Topic - Computing
L.O. I can collate data about my classmates using an excel program and generate tables from this. (eg. number of pupils who are wearing a jumper, male and female, eye colour – pupil choice).
|
Basic |
Advancing |
Deep |
|
I can use an excel program to arrange some data. |
I can categorise data using excel and present it using tables. |
I can design and create a range of charts using computer software and organise/present this effectively. |
Use the ‘excel’ prompt sheet below. This will help you with creating charts on excel. Follow the crib sheet step by step to ensure you are able to create a chart accurately.
As you are at home and won't have access to our classes to collate data, you can use the following data to put into a chart:
|
Eye colour |
Blue |
Brown |
Hazel |
Green |
Grey |
Other |
|
No. of pupils |
7 |
11 |
3 |
1 |
4 |
1 |