Reusing a Grading Rubric in Numbers for iOS

Last fall, I wrote about using Numbers on my iPad to create a rubric for grading lab reports. This semester, I wanted to use the same rubric with some minor modifications to score the same kind of report. Not much has changed in Numbers since then, but I wanted to jot down what I did so I remember for next time.

The first step was to duplicate the spreadsheet on the iPad, so that I wasn’t overwriting last year’s grades. I actually like to keep these around for when students ask me for recommendation letters, as they provide a record of details about a student’s work habits that I’ve long since forgotten. I think it can help a letter immensely to be able to say, “I knew this student when she was a freshman, and she was already a shining star on her first scientific report.”

After making a new copy of the spreadsheet, I deleted all rows except the first and copy/pasted this year’s roster into it. I slightly altered the requirements for the report, so I (luckily) remembered to modify the items and point values to reflect my expectations. After that, I was off to the grading races, this time using a form to do data entry rather than entering values directly on the table. I’ve commented on this view before, but this turns Numbers into a little bit of a database-flavored tool, giving just a bit more focus on an individual student’s ‘record’ than a spreadsheet allows.

NumbersFormwatch full xXx: Return of Xander Cage 2017 film online

The major change this year is that Numbers on both iOS and the Mac are both connected to iCloud, making it completely seamless to access the grade sheet back on my Mac. Like last time, I set up a ‘mail merge’ (outdated name) to generate a one-page report for each student, which required that I save a copy of the spreadsheet to my Mac from iCloud. I guess the mail merge feature isn’t iCloud-aware just yet. This year, rather than creating a separate PDF for each student, I just copy/pasted the output in Pages into the body of an email, which was cleaner than last year’s PDF attachment. 

Grading with a rubric in Numbers for iOS

One of the best ways I’ve found to keep my sanity with grading is to use a rubric whenever possible. This means that, for each student, I would print a rubric and fill it in with comments and notes, and that is not in keeping with my desire to move away from paper as much as possible. Besides, this information is so ephemeral that it hardly rises to the importance of archiving on paper. No, this is definitely a job for electrons, and that puts it in the realm of the iPad.

I started by looking for grading rubric apps in the App Store, but didn’t find anything that struck me as useful for my particular purposes. I thought about making a PDF of the rubric and annotating it for each student on the iPad, but I would end up with a file to manage on the iPad for each student and would still have to enter scores into my grade sheet. So I decided to use Numbers to create a simple rubric. I made each column a different criterion, and entered student names in rows by copy/paste from my grade sheet.

Magic Stepper

After I entered a few scores this way, I didn’t like how I had to enter a number for each criterion — I just wanted to select a number that fit the student’s performance on that criterion. That’s when I noticed the cell format called ‘Stepper’:

The stepper format allows you to define a minimum and maximum value and an increment. Once set up, you can just tap an ‘up’ or ‘down’ arrow next to the cell to assign points, and you don’t fill half the screen with the on-screen keyboard. Nice.

After I scored all the lab reports, I needed a way to distribute them electronically to the students. I decided to merge the students’ scores onto a copy of the rubric, so I set up a Pages document on my Mac with the Numbers spreadsheet linked as the merge source and ran the Mail Merge. Then I sent each student a PDF of their scoresheet.

Conclusions

This has become my primary system for scoring papers with a rubric. I really like the ease with which I can enter a score for each category with a few taps, it allows me to keep focus on the paper. For a large rubric, it’s essential to freeze the header row and column so I can continue to see the criteria and student name, but this introduced a gotcha when I tried to configure merge fields, because a header column cannot be a data source. I got around this easily by copying the names into a non-header column, but it was one more step than I expected. While grading one student’s work, I recognized I had been recording the scores in another student’s row, but a couple taps on the ‘Undo’ button recovered the lost values. The last comment is that it was a real pain to send each student a PDF attachment, manually, by email. For now though, the alternative of using our LMS is an even worse prospect!