More than just =sum()

Standard

Last week the game website was blocked…  It just shows how we try and keep you safe in school by restricting websites, however now it should be unblocked so we will have another go at a new Spreadsheet skill.  But first we need to generate some data!

Have a play on the Starry Night Game – How about we say best of three goes remember to record your scores.  Enter your scores onto the online form.

I have been really smart and the data is easily collected into a Google Spreadsheet so you can look at all the results!

Using what you learned about =sum() last week I want you to create a Spreadsheet in Excel that totals your score and that of five of your friends.  Can you make it clear and easy to read?

Starry Nights Score Sheet1a

If I wanted to I could sort my data so it is like a league table – the best score at the top, counting down!  Remember you can let the computer do the work with the sort function.

Sort Make sure the tab is set to Data, and select the sort function.

The icons with AZ, ZA and an arrow just sort the first column alphabetically – which is useful but not today.

Pressing on the sort function a dialogue box pops up.

Fill in sort

Pressing OK sorts your data out in an instant!  A great way to quickly and easily sort data.  You can even sort by more than one column – Surname, First name – which is incredibly useful but that is for the future!

Sorted

That is all very useful but sometime I might need more information – like what was the lowest score in any game, what was the top score?  With only 25 bits of data to scan over all with scores only in the hundreds it won’t take a year 6 mathematician long.  But the numbers could be much bigger, be decimals or even scores for the whole year group so no longer 25 bits of data but…  180!

Again let the computer take the strain!  It has a function built in to work out the smallest – minimum =min() score in a range or even the biggest – maximum =max()

In side the brackets you but the cell references for all the cells you want to sort – remember it won’t be the total column!

Finish

Who could think of uses for this sort of function in school?

Advertisements

One response »

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