This is lesson six of the Spreadsheet basics series of lessons. This gets students to understand how to use functions in order to do simple calculations (SUM, AVERAGE, MAX, MIN) for a class of students with a mark-sheet for a fictional class. There is an advanced version of the mark-sheet for those super fast students which also needs them to work out how to calculate ranges and relies on earlier taught content on this course which required them to convert scores to percentages.
The lesson comes with teacher exemplars to use with students and a step by step presentation
Learning Objectives:
• Know how to use the SUM, AVERAGE, MIN and MAX functions
• Understand how to speed up setting up spreadsheets with Copy and Paste
This Download includes:
Presentation
Two practical tasks allowing for differentiation
Teacher model answers for both tasks
This resource has enough for 2 lessons X 50 minutes with extension tasks for those students that get through their tasks quicker than all the rest
The lesson comes with teacher exemplars to use with students and a step by step presentation
Learning Objectives:
• Know how to use the SUM, AVERAGE, MIN and MAX functions
• Understand how to speed up setting up spreadsheets with Copy and Paste
This Download includes:
Presentation
Two practical tasks allowing for differentiation
Teacher model answers for both tasks
This resource has enough for 2 lessons X 50 minutes with extension tasks for those students that get through their tasks quicker than all the rest
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£3.29