Notes to Facilitator

This session’s aim is to introduce participants to the use of a spreadsheet for record-keeping purposes, namely a class mark book. There are two tutorials offered here, both aimed at achieving the creation of a mark book in Excel. The first is for new users (beginners) and will guide them through the steps required to develop a simple mark book. Skills that will be taught include basic formatting, creating totals and averages, and creating formulas. The second is for intermediate users that have already had some experience using Excel.

The skills covered include Autofill, AutoFilters, Conditional Formatting, Customising Toolbars and the VLOOKUP function. The facilitator will need to support the student teachers on both sets of tutorials.

It should also be noted that this activity is a recommended Portflio Task and if you are following the assessment strategy you have the option of collecting in the completed spreadsheets for marking.