Topic outline

  • Unit 8: Create a Spreadsheet Mark Book


  • Unit Introduction

    • In this tutorial we will use a spreadsheet package, MS Excel, to generate a class mark book to track student test performance throughout the year. The mark book should also calculate class average per test and derive a symbol per student based on their final year mark. Access the instructions below by working through the pages in sequence. Have both the tutorial and your spreadsheet program open and recreate the steps yourself. Once you have experienced the power of a spreadsheet program you will never keep a paper version again. Let’s get started.

      By the end of the lesson you should be able to the following:


    • Click on the link below to begin your lesson: 

    • Lesson: Create a Spreadsheet Markbook
      Opened: Tuesday, 12 April 2022, 9:19 PM
      Closed: Thursday, 30 June 2022, 11:59 PM
      View Go through the activity to the end

  • Assessment instructions

    • Use the assignment submission tool below to upload the spreadsheet class mark book you created as part of the lesson.

    • Assignment for Unit 08 - Class Mark Book
      Opened: Tuesday, 12 April 2022, 9:19 PM
      Due: Friday, 27 May 2022, 9:18 PM
      View Make a submission

    • Badges & Points

      There is a badge available on completion of the unit's lesson and  assignment worth one (1) SACE professional development point.

  • Attribution & References

    • Attribution (Open Educational Resources)

      • Moore, A. (2011). How to make a Class Mark Book in Excel.Available online here
      • Thielan, A. (2007). Spreadsheet (Photo). Flickr.Available online here

      References

      • Microsoft. (2017). Excel Help - (C) - Available online here

  • License