Notes to Facilitator

This session’s aim is to introduce students 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.