Using Spreadsheets to investigate problems.


Last week we looked at referencing cells and entering simple formulae, so this week we are going to build on these skills.  For the start of the lesson I want you to copy my spreadsheet shown, but complete it.

L2 1

Sometimes you need to make a spreadsheet more attractive for the user, so you can use colours and different fonts.  Remember… It needs to be readable!

L2 2

The tool bar on Excel is very similar to Word and PowerPoint, so you don’t need any help with this.

Now you know how useful Spreadsheets are get ready for the next challenge!

Sweet Problem

Now you have tackled the problems can you comment on our blog and tell me what are the advantages of a spreadsheet over a pencil and paper with this type of problem solving.




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s