Sort it out Year 6!

Standard

Last time we tried this the game was blocked!  But now we can play Starry Night to get some data.  I want you to play the game 3 times – each time record the score onto my online form.

From the online data – pick five people and create a spreadsheet that will record their scores.  I have put together an example below:-

Starry Nights Score Sheet

How can you find other people’s results?  Well that is easy – RESULTS – this is the real time results for the form!  How clever.

If you have time you can make it look very pretty.

Record the scores and then use what you learned last term – =sum(…) to work out a total.

Starry Nights Score Sheet1a

It would be really useful to sort the table data into order!  The computer can do this for you automatically.

First select all the cells in the table! – include the headings for the table!

Sort Fill in sort

Sorted

Sometimes in a set of data it is useful to find out what the largest – Max or smallest – min score is.

To do this you use two functions =min(..) and =max(..) – I have added these in boxes at the bottom of the table.

Finish

Challenge.

Swap a person on your table of result for someone else.  Can you reorder it?  What happens to the Min / Max?

Real Life Challenge.

When might it be useful to use these functions in school?  If you have an idea comment on the post.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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