Tip Sheets | Home   

ICT Skills for Teachers (Office 2016 / Office 365)

Assessment - Create a marksheet (Beginner 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 Type in the headings and learners' names        
3 Sort the names alphabetically        
4 Resize the column widths        
5 Save the mark sheet        
6 Type the learners' marks        
7 Calculate the total for each learner        
8 Calculate the test average        
9 Calculate each learners' percentage        
10 Insert borders around the information        
11 Format the text        
12 Preview the print version        
13 Close Microsoft Excel        

Back to Activities