10 Sept 2011

Spreadsheets for administrative purposes

If the spreadsheet can be useful to accountants and number crunchers then it is useful to an educator. How many times have we recorded marks in mark books only to have to change a mark for one reason or another, recalculate average, percentage, re-sort placings... - We have all been there before. Welcome to Excel! OK, it's got these weird boxes.. hmm what to do?

Let me give you some ideas. Use it as your digital record of marks book. Once you get the hang of rows, columns and some basic formulae, you will wonder how you ever survived without it. Add a graph or chart using the wizard and you will be surprised how easily you will begin to appreciate how effective your lessons have been after you evaluate them. You can even use it for taking roll. And if you've got to juggle weightings on multiple criteria let Excel handle all the laborious calculations.

Excel has some powerful functions built in that makes the assessor role of an educator easier.

Oops. Did I mention preparing your annual budgets for the classroom or managing your personal finances.

If you're a Mac user say hi to Numbers :)