Skip to main content

"Mr. A is always on his phone in class..."


So,, the above quote is true... I'm always on my phone in class.  For one, I take a lot of pictures (see the previous post, for example) - my students treat every surface like a whiteboard, and I like keeping track of what students are doing.

I also created a Microsoft Form (http://forms.microsoft.com) to track learning skills and other observations of learning.  What's nice is that everything gets pushed into an Excel Spreadsheet and I can pull out by day, by section, by student, by learning skill -- and because it's automatically date/time stamped I can also match pictures to anecdotes.

When I first opened the form on my phone in the browser, I made sure to click on ADD TO HOME SCREEN in the browser menu so that I could get a button I can easily tap each time I want to make an entry.

I teach three sections of Grade 10 Math, so my first question is which section I am adding a note to.  Now, I could have made three different forms but then I would have had three different spreadsheets and three different buttons on my phone.   It's worked out easier to just choose which section... because...

Forms does Branching ... 

...depending on which Section I pick in the first question, the next question displays which group of student(s) I am assessing.  And yes, I set up the "which student" so that I can make an observation on one or several students all at once.

It does take a couple of minutes setting up the form when I first started and I do have to go back in when there is a change of students but the time-saving on the other end makes up for it.

After I choose the student(s) I then added a series of ranking questions - in this case, I used the Ontario Learning Skills:

  • Responsibility
  • Organization
  • Independent Work
  • Collaboration
  • Initiative
  • SelfRegulation


Now, I don't necessarily use each rating for each observation - but if it's appropriate it's good feedback to capture.  I didn't make them required questions so I can skip what I don't need.

Then, I have an open text box in which to write a comment.

And lastly, I have a check box to indicate whether or not there is a photo associated with the entry.  Since Microsoft Forms puts a time/date stamp in the Excel spreadsheet, I can match the picture to the entry.



I also recommend using a swipe keyboard; I use Swiftkey (Android) - by swiping to get your words down, it can greatly increase your speed of entry and allows you to write using only one hand.  In fact, only one thumb with enough practice.

(The idea to develop a form like this came from an old app on my iPod Touch that I used to use called GradePad.  But then Apple removed the ability to update my iPod so I use my phone now).

Post a Comment

Popular posts from this blog

Teacher Professional Development and Microsoft OneNote

During the first three weeks of July, I have the amazing opportunity to work at the Park City Mathematics Institute.  It is, without exaggeration, the best professional development opportunity for teachers of mathematics.  Participants spend three weeks thinking deeply about mathematics and mathematics education.

There are three main aspects of PCMI:

learning mathematicsreflection on practice (RoP)becoming a resource to others.I'm part of the team for RoP and in charge of the third aspect, in which participants consider a gap in professional development back at their home districts and work in small groups to help fill that hole by developing a rich PD seminar on that topic.

It is not easy to develop professional development.  Teachers who haven't written PD have to patiently learn how to write (essentially) lesson plans for someone else.

This year, I used Microsoft OneNote to facilitate the process.  We have a central OneNote Notebook through which I lay out the daily schedule…

Five reasons to learn Math with OneNote

So, Alice Keeler - @alicekeeler- who is an amazing blogger and an incredible resource for those using Google products, posted 60 Ways Math Teachers can use Google Classroom last April.  It came across my desk the other day and, since school hadn't started yet, I thought it might be a good reflection for me on how one could do similar tasks with OneNote Class Notebook.

I went through the list and checked that I could accomplish them all with OneNote and re-wrote her post with those modifications ... but it was looking a little "plagiarism-y" so, just to check, I emailed Alice to see if she was okay with it.  She was not, but encouraged me to do my own brainstorming.
So... Math Teachers & OneNote (including OneNote Class Notebook).  My top five... 
1) The Under-valued value of scribbles & notation
If you really want to be "paperless" (and that should never be a goal - you want to be digital so that content is no-cost) in a mathematics classroom, it's n…

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 grading but rather a situation in our Psychology course.  The teachers were doing a study with their students and wanted to collect the data easily and run a T-Test with as little work as possible.  (A t-test, roughly speaking, determines whether two groups are different from each other.)

We set up an Excel Survey for the students to enter their results and then in a second sheet in the spreadsheet containing the Survey, we laid out the T-Test.  As the results came in, the T-Test continually re-evaluated.  Success!

I figured if it can work for a T-Test, it can work for a simple multiple-choice, True/False or simple word response. So I head over to my O…