مخطط الموضوع

  • 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 درس
      مفتوح: Tuesday، 12 April 2022، 9:19 PM
      مغلق: Thursday، 30 June 2022، 11:59 PM
      معاينة متابعة النشاط حتى النهاية

  • 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 واجب
      فتحت: Tuesday، 12 April 2022، 9:19 PM
      تستحق: Friday، 27 May 2022، 9:18 PM
      معاينة القيام بالتسليم

    • 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