I have always graded student presentations on my computer using Excel. I have four categories, enter the grade and comments for each category on the computer during the presentation, and Excel does the math for the final grade.

Recently, though, I’ve been using my computer to project the presentations; I seemed to have some trouble with the frequent swapping in and out of multiple (student) computers. But if I use my computer to project, I can’t use it to grade.

This year I figured I would be able to use the iPadPro to grade. So I opened the spreadsheet via Dropbox in Excel and off I went. Except…the iPad told me that it was read-only (in Excel) and I had to convert it to be able to edit it, and the convert button didn’t seem to want to convert.

2017-03-28 12.29.42

So I took a screen shot of the spreadsheet and made it my default page in Noteshelf (see here for Noteshelf and other notetaking apps) and used the ApplePen to grade it.

Screen Shot 2017-03-29 at 9.59.17 PMScreen Shot 2017-03-29 at 10.00.12 PMScreen Shot 2017-03-29 at 10.02.18 PM

I screenshot the completed sheet for each student, uploaded it to Dropbox, and uploaded it to ItsLearning. As usual, the ApplePen made it worthwhile; I wouldn’t have wanted to do that with a regular stylus.

Screen Shot 2017-03-29 at 8.59.11 AM