How Active Am I? Unit 1: Lesson 5

L/Os:

To develop a spreadsheet for a specific purpose 

Outcome: You will develop your skills in Microsoft Excel and your spreadsheet for the unit

Starter - 10 minutes

1. You have been given a post-it with A, B or C - sit at the correct table
2. As a TEAM and using the cards in front of you, put them into the correct order
3. Extension: What does a formula ALWAYS start with???

Main Task - 40 minutes

Open Microsoft Excel and your Active spreadsheet from your Year 7 ICT folder
Ensure that you have completed at least FOUR lots of data in your spreadsheet and formatted it as below:

Add formulae for the following:
SUM
AVERAGE
MIN
MAX

Try creating a chart!
Add your data to my spreadsheet 

Mini-Plenary - 5 minutes

Which colour are you working on? How can you progress to the next colour?
Showcase + 2 stars and a wish

Plenary - 5 minutes

Think, Pair... Share! 

Think: What have you learnt today?

Pair: Turn to the person next to you and discuss

Share: Share with the rest of the class