Create a class mark book using a spreadsheet

Conclusion

• 
  

  Have you seen this spreadsheet at school? It’s a mark analysis tool that uses a spreadsheet software

  [Picture]

  The spreadsheet is better than a calculator when it comes to working out term and year marks. Instead of working out grades for each individual you can generate the marks for a whole class! The trick, however, is to keep the mark book running throughout the year so that when it comes to reporting time most of the data has already been captured. 

• 
  
  

  The following OER were adapted to create this unit of study:
  

• MGSLG ICT CFT. (2018). Create a spreadsheet mark book (CC BY-SA) URL
• MGSLG ICT CFT. (2018). Integrating spreadsheets into student learning (CC BY-SA) URL
• 
  
  

  The following resources were consulted in this study unit. Full copyright but free to use:
  

• GCF LearnFree. (nd). Excel URL
• 
  
  
  

  
  

  Zambia ICT CFT Teachers Course by Zambia MoE is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

  All content not licensed under a Creative Commons licence is all rights reserved, and you must request permission from the copyright owner to use this material.