Skip to main content
Side panel
UNESCO ICT CFT Based Courses
English (en)
English (en)
العربية (ar)
You are currently using guest access (
Log in
)
Spreadsheet
Module 2 Unit 4
Introduction
Creating a spreadsheet mark book
What is next?
And now?
Global Education Coalition (GEC)
Teach using a spreadsheet
Assignment
Conclusion
Home
Calendar
Create a class mark book using a spreadsheet
Home
Courses
Zambia (MoE)
Module 2 - Basic ICT skills for teaching and learning
Spreadsheet
Conclusion
MGSLG ICT CFT. (2018). Create a spreadsheet mark book (CC BY-SA)
MGSLG ICT CFT. (2018). Create a spreadsheet mark book (CC BY-SA)
Click
https://mgonline.mgslg.co.za/course/view.php?id=9
link to open resource.
◄ Assignment submission tool
Jump to...
Jump to...
Announcements
GCF LearnFree. (nd). Getting started with Excel
Google for Education. (2020). How to use Google Sheets
MGSLG ICTCFT. (2017). Introduction of cells, sheets, labels and values (CC BY-SA)
MGSLG ICTCFT. (2017). How to create a class mark book (CC BY-SA)
MGSLG ICTCFT. (2017). Formatting columns and cells (CC BY-SA)
MGSLG ICTCFT. (2017). Adding column totals (CC BY-SA)
MGSLG ICTCFT. (2017). Averaging column values (CC BY-SA)
MGSLG ICTCFT. (2017). Creating formulas (CC BY-SA)
GCF LearnFree. (nd). Excel: page layout and printing
GCF LearnFree. (nd). Excel: creating more complex formulas
GCF LearnFree. (nd). Excel: sorting data
GCF LearnFree. (nd). Excel: filtering data
GCF LearnFree. (nd). Excel: Groups and subtotals
GCF LearnFree. (nd). Excel: Charts
Google for Education. (2020). Get started with Google Sheets
Microsoft Support Centre. (2020). Excel help & learning
MGSLG ICT CFT. (2018). Lesson plan: using spreadsheets to teach planets relative gravity
Forum discussion: Using spreadsheets as part of my lesson plan
Assignment marking criteria
Assignment submission tool
MGSLG ICT CFT. (2018). Integrating spreadsheets into student learning (CC BY-SA)
GCF LearnFree. (nd). Excel
MGSLG ICT CFT. (2018). Integrating spreadsheets into student learning (CC BY-SA) ►