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) during Remote Learning for them, […]
Tag: Microsoft Excel
PowerAutomate, Forms->Excel
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 were always in the class […]
Breakout Rooms in Microsoft Teams
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. If your school allows students […]
I’ve seen this before — Previous Versions in Word (& Excel & PowerPoint)
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 my work in progress, stored […]
#My24Hrs Part 2
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 to pop into one geography […]
5 Reasons Schools should run with Office365
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, collaboration and creativity. So, briefly, […]
Auto-Grading an Office365 Excel Survey Assessment
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 post arises not from automatic […]
Excel Surveys
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. In the past we would […]