Note: I have written a second post on using Microsoft Excel templates with Numbers.
How Numbers for iPad can save you time and make life easier during report card time!
Numbers (itunes link) spreadsheet app directly from Apple, is a worthy Microsoft Excel-like competitor for the iPad. It is a powerful tool for teachers who own an iPad, and can be used for assessment, especially during report card season. It is a $9.99 app that is part of Apple’s iWork suite which also includes Pages and Keynote.
For those of you who calculate their marks with Microsoft Excel, and have become comfortable using your PC, fear not. You are able to open all your excel files within Numbers and all your formulas and formatting will transfer over to the iPad. Last term, I did ALL my report card work within Numbers on iPad. First, I found and downloaded an Excel grading template, opened it in Numbers, then
- I crunched all my assignments, quizzes, tests, and performance tasks
- I calculated my percentages for my students grades for their report cards
- I entered in their comment numbers (my school uses a comment bank system)
- I divided the classes into individual files and sent them via email to the corresponding teachers to enter into their own report card programs
- I was able to, at the end, revert my Numbers document back into an Excel file, and save it to Dropbox for backup for future reference
Check out a screenshot of one of my files, containing very easy access to my 14 classes:
See the tabs near the top? I simply can tap those to access any of my 14 classes.
Here is a screenshot of how Numbers organizes my files. As you can see in the bottom left ofnit, I am able to create folders by dragging files into the box, not unlike dragging your apps into folders.
Here is a screenshot of my Term report card marks, organized in columns by Effort grade, term %, letter grade, and two comments from the bank that I create separately:
Two distinctive advantages of Numbers over Excel:
Numbers is a universal app, meaning that you only have to purchase it once and you can sync all documents between all your iOS devices. Since I have an iPhone as well, I have instant access to everything within Numbers, including my students’ marks, grades, effort marks. If I need to quickly refer to something, I can access it within a few taps on the phone. I can make changes directly on the iPhone as well. as soon as I close the app on there, it will save automatically to the cloud, meaning that when I open up the document on my iPad, all changes are there. There is no need to press “save” or “save as…” and send it between devices. Everything is literally done for you once you close the app.
How have I taken advantage of the iCloud feature? While I was out of the house one day last term, I received an email from one of my classroom teachers. She was wondering if I could verify a few marks and effort grades that I had sent her. I opened the file on my phone and made the necessary changes. All this was done while “on the road”.
Also, when a student needs to be reminded of their mark, say on a recent quiz, it again only takes a few taps on either the iPad or iPhone to retrieve it. Just the fact that I am able to do my work whenever and wherever I want makes my transition from PC to iPad a no-brainer. For years, I dreaded sitting at the computer to input all my marks. It was something I put off until the last minute. Although in the end I was always happy to be completed, I just didn’t enjoy procrastinating. iCloud has made life much easier in this respect.
Another great feature of Numbers is the drop-down menu. If I know I have a few options for the specific column, I can easily create them. Once I create it for one cell, I can copy the entire column, and repeat for each class.
These drop-down menus also came in handy during a recent oral evaluation. Students were assessed on their reading ability and given two marks out of three. It took me just a minute or two to set up the menus, and from then on I called out a students name, they read, and I chose their mark on the spot, tapping the number instead of typing it in:
This feature will come in super handy for teachers who assess with clear cut numbers (Is that all teachers?)
Although most of you reading this probably won’t transition to this method this school year, I would definitely suggest exploring it for next year, especially if you already own an iPad. Remember that you can import all your previous Excel files and formulas! Bring your marking to the park, the beach, or just on your couch!
Finally, I am assuming that some of you may not necessarily enjoy typing on the iPad itself. When I have a lot of numbers to enter, I use the older iPad keyboard dock from 2010 that I bought on Ebay for $15. It is very responsive, and feels like an actual iMac keyboard:
(Let me know if you are interested in my grading template. I can send it to you!)
Have any of you already tried using Numbers to do your report card marks? Let us know what you think of the process in the comments!
9 Comments Add yours
I am interested in your gradebook! Would I be able to get a template?