Sectieoverzicht


    • The steps that you will be taken through in the process of creating 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. 

    • GCF LearnFree. (nd). Getting started with Excel URL
      Leerlingen moeten
      Bekijken
    • Google for Education. (2020). How to use Google Sheets URL
      Leerlingen moeten
      Bekijken


    • 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) Pagina
      Leerlingen moeten
      Bekijken


    • 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) Pagina
      Leerlingen moeten
      Bekijken


    • 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) Pagina
      Leerlingen moeten
      Bekijken