Create a class mark book using a spreadsheet

Creating a spreadsheet mark book

• 

  The following steps to create a spreadsheet mark book will be:

  1. An explanation of cells, sheets, labels and values
  2. How to create a mark book
  3. How to format columns and cells
  4. Adding columns / rows
  5. How to average column and / or row values
  6. How to create and apply formulas.

  
  Before we start with creating your mark book, have a quick look at the introductory video on 'Getting started with Excel'. A Google Sheets link is included below should that be the spreadsheet application of your choice. However, this unit will provide instructions for the Excel software.

• GCF LearnFree. (nd). Getting started with Excel URL

  View
• Google for Education. (2020). How to use Google Sheets URL

  View
• 
  

  Watch the video below to find out more about step 1. Remember, follow on your own spreadsheet as the facilitator takes you through the necessary steps.

• MGSLG ICTCFT. (2017). Introduction of cells, sheets, labels and values (CC BY-SA) Page

  View
• 
  

  We recommend that you set up your own mark book with a 'live class scenario' which has actual test results which you can upload. Work through these steps using this 'live data'!

• MGSLG ICTCFT. (2017). How to create a class mark book (CC BY-SA) Page

  View
• 
  

  Once you have created your spreadsheet (and don't forget to save it) let's give you a few tips on how to format columns and cells.

• MGSLG ICTCFT. (2017). Formatting columns and cells (CC BY-SA) Page

  View