Topic outline

  • Record Keeping (Spreadsheets)

    Record Keeping

      • By the end of this unit you should be able to use ICT to support class administration through the keeping of a digital class record system using a spreadsheet package.

                     Learning Objective:

        1. Identify and understand different ICT tools used in school and class administration

            4 hours

          This unit will be facilitated during the workshop. However, the resources you require for the unit will be made available here on the LMS. You will also be required to upload your class markbook here too, using the assignment submission tool.

          Announcements Forum

          Introduction


          Click on the link below to watch a quick introduction to Unit 05: Record Keeping


           As Rwandan schools adopt new digital technologies it makes sense to also automate much of the school administration. Some school administrators are using school management packages but you can start right here and now and learn to keep your class marks using a spreadsheet. The skills you learn here will help you support digital administration in the future. 

          The Importance of School Records

            60 Minutes

          In this digital age we now have access to data which was not possible before. This includes data about students and their learning habits, performance and test scores. One of the best way to process all this data about individuals and their educational progress is to use a school management system. This is a software platform that captures the data and provides us with tools to analyze the data. It also provides a number of services such as reporting and timetable making. There are a few that are open source that means have no direct costs, they are free. If your school does not already have one then it’s worth evaluating the two we have here and considering if there is a place in school for such a platform.

          You are encouraged to access and do some readings on different school administration packages that outline the merits of such systems. You are encouraged to investigate a few open source platforms that can be used free of charge. In your groups discuss the merits of such software in a forum. You will need to moderate the discussion.

          Now let us discuss the importance of ICT in school and demonstration on various ICT tools used for school and class administration in the following areas:

          1. Recording and processing data
          2. Storing and sharing information with others
          3. Capture and store data for informing data-driven decision making
          4. Improve methods of accountability and reporting.
          Here are some resources to help you investigate different software packages:
          The SchoolTool BookURL

          Class Records Using Spreadsheets

           180 Minutes




          Excel is a spreadsheet program that allows you to store, organize, and analyze information. While you may think that Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of Excel's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different kinds of data.


          This activity is a portfolio assignment. Read the instructions below in order to create your own spreadsheet markbook. Make sure it reflects a real class and a real set of term marks.

          Step 1

          Access the tutorial below.

          Spreadsheet Class Mark Book Video Tutorials Page

          Step 2

          Using the steps outlined in the tutorial, create a class markbook using information from one of your real classes. 

          Step 3
          Use the assignment tool below to submit the document.

          • Still not happy? Try out these GCF Learn Free Excel 2016 Tutorials below to get another perspective on how to use a spreadsheet package.

          GCFLearnFree. (2017). Excel 2016 Tutorials URL

          Attribution

              The following Open Education Resources (OER) were consulted and/or adapted to create this unit

              1. COL/Guyana. (2012). ICT in Education for Teachers: Classroom Records. (CC BY) Available online at http://colccti.colfinder.org/sites/default/files/guyana/pages/TL/Module02/Unit04/01.html
              2. COL/Guyana. (2012). ICT in Education for Teachers: School Records. (CC BY) Available online at http://colccti.colfinder.org/sites/default/files/guyana/pages/TL/Module02/Unit05/01.html
              3. Matthew Goniwe School of Leadership and Governance. (2017). Create a Spreadsheet Markbook. (CC BY SA). Available online at http://mg.nbatesting.co.za/course/view.php?id=9 
              4. MoEST Kenya. (2015). KICTCFT: ICT to Keep School Records. Available online at http://kictcft.nba.co.za/course/view.php?id=11

              1. GFC LearnFree. (2017). Excel 2016 Tutorials. Available online at https://www.gcflearnfree.org/excel2016/ 
              2. GFC LearnFree (2017). Excel Formulas. Available online at https://www.gcflearnfree.org/excel2016/intro-to-formulas/1/
              Open License

              All material in this ICT Essentials for Teachers Course unit is licensed by the Ministry of Education, Rwanda under a Creative Commons Attribution-ShareAlike 4.0 International License with the exception of the resources listed below:

              GCF Learn Free: Excel Tutorials and Excel Formulas

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