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
Google for Education. (2020). How to use Google Sheets
Google for Education. (2020). How to use Google Sheets
Click
https://edu.google.com/teacher-center/products/sheets/?modal%20active=none&modal_active=none
link to open resource.
◄ GCF LearnFree. (nd). Getting started with Excel
Jump to...
Jump to...
Announcements
GCF LearnFree. (nd). Getting started with Excel
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
MGSLG ICTCFT. (2017). Introduction of cells, sheets, labels and values (CC BY-SA) ►