Microsoft ExcelTag Archive

So last post I went over how I used PowerAutomate (Flow) to push stuff form Forms to Excel. But a colleague had a different question so I thought I’d go over that scenario here. I have two grade 10 math sections, and I used the Microsoft SEL Form (from here)… Continue Reading PowerAutomate, Forms->Excel Part 2

So during RemoteLearning in order to be able to manage things, we combine our Grade 9 classes across three teachers into one class. Now, before everyone panics, that meant a total of 30 students in one “class” -= our sections are small and at least two of the three teachers… Continue Reading PowerAutomate, Forms->Excel

So one of the challenges folks have is that there isn’t yet an easy way to assign students to breakout rooms so that they can work on a problem together. Each breakout room is a mini-Team with a shared chat space, a Microsoft Whiteboard, audio/video conferencing and a file space.… Continue Reading Breakout Rooms in Microsoft Teams

One of the handy things about having infinite storage in Office365 is that there are versions of every bit of your work stored continually.  So, when I worked on the Word document in my previous blog post on Restricting Editing (here) the Word Document had several Previous Versions, snapshots of… Continue Reading I’ve seen this before — Previous Versions in Word (& Excel & PowerPoint)

Teacher content displayed on projector So it was optimistic of me to say I’d be able to post twice in the same day… so here I continue from #My24Hrs Part 1. So as it turned out, I didn’t have a lot of time to run around to classes.  I managed… Continue Reading #My24Hrs Part 2

It often surprises me when folks don’t know about Office365 and/or don’t know how Microsoft has changed its educational offerings in the past few years.  Although Google definitely had the lead up to say 2011, Microsoft has quickly come up from behind and re-invented the educational space for teaching, learning,… Continue Reading 5 Reasons Schools should run with Office365

So it’s pretty common that folks use Google Forms to create an automatically graded assessment.  Now, I have to admit, as a mathematics teacher I don’t do a lot of fixed-response assessments like this that need automatic grading.  But that doesn’t mean it isn’t a useful option. In fact this… Continue Reading Auto-Grading an Office365 Excel Survey Assessment

One of the activities in Reflecting on Practice today involved developing question stems that would promote math talk.  We wanted a quick and easy way of collecting the sample question stems each participant had created — a survey lets us distribute the typing and simplifies the redistribution for tomorrow’s task.… Continue Reading Excel Surveys