How Active Am I? Unit 1, Lesson 4

L/Os:

To develop a spreadsheet for a specific purpose 

Outcome: You will develop your skills in Microsoft Excel and have started developing a spreadsheet for the unit

Starter - 5 minutes

Reflect on your work from last lesson.... Which was the easiest??

A Adding up these numbers in your head?

1
2
5
7
10

B Or in a spreadsheet?

Main Task - 45 minutes

1. Open Microsoft Excel
2. Create your Active spreadsheet from last lesson (look in your Year 7 ICT folder)
3. Ensure that you have at least FOUR lots of data in your spreadsheet as below:

1. Make your spreadsheet look aesthetically pleasing! Add colours and outlines to your table!

1. Can you now add these up using the AutoSum formula?
2. What other formulae could you use?

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