Skip to main content
Side panel
ICT Essentials for Teachers
You are currently using guest access (
Log in
)
Spreadsheets
General
Welcome
Creating a mark book using MS Excel
So you've created a mark book, what's next?
And now?
Global Education Coalition (GEC)
Teaching learners using a spreadsheet
Assignment
Conclusion, attribution and licence
Home
Calendar
13: Basic ICT skills: Use a spreadsheet for marks
Home
Courses
Spreadsheets
Creating a mark book using MS Excel
GCF LearnFree. (nd). Getting started with Excel
GCF LearnFree. (nd). Getting started with Excel
Click
https://edu.gcfglobal.org/en/excel/getting-started-with-excel/1/
link to open resource.
◄ Announcements
Jump to...
Jump to...
Announcements
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). Create a spreadsheet mark book (CC BY-SA)
MGSLG ICT CFT. (2018). Integrating spreadsheets into student learning (CC BY-SA)
GCF LearnFree. (nd). Excel
Google for Education. (2020). How to use Google Sheets ►