ICT Skills for Teachers (Office 2016 / Office 365)

Assessment - Create a interactive mark book (Advanced level)

You can use this as a checklist for your computer skills development:

	Description	Successful	Done with support	Learning	To learn
1	Start Microsoft Excel
2	Create a basic markbook
3	Calculate percentage
4	Save your worksheet
5	Copy the formula
6	Automatically assign a grade based on a mark
7	Conditional formatting
8	Insert a combo box
9	Use the VLOOKUP function