From the online data – pick five people and create a spreadsheet that will record their scores. I have put together an example below:-
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.
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!
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.
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.