Tip Sheets | Home   

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        

Back to Activities