Y5 How do I analyse data with Google Sheets?

May 192017

Go to Classroom and open the document to work on
Rainfall in Wiltshire
1. Create a line graph from the rainfall data
2. Underneath the graph write three sentences about what the graph shows
Shoe sizes
1. Create a table to record shoe sizes in your class
2. Create a bar graph from the data
3. Write two sentences about what the graph shows.
Boy/girl preferences
1. Create a table with three columns: Favourite thing, Boys, Girls,
2. Enter the data from the class survey
3. Create a double bar chart of the data
4. Write two sentence about what the graph shows.
** Do big countries have more people?
1. Create a table with columns: country, population, area
2. Visit this website to collect the data from some countries
3. http://www.worldometers.info/world-population/population-by-country/
4. Create a scatter graph from the data
5. How can you tell if it shows you the answer to the question?

	T1	T2	T3	T4	T5	T6
Y3	Y3T1	Y3T2	Y3T3	Y3T4	Y3T5	Y3T6
Y4	Y4T1	Y4T2	Y4T3	Y4T4	Y4T5	Y4T6
Y5	Y5T1	Y5T2	Y5T3	Y5T4	Y5T5	Y5T6
Y6	Y6T1	Y6T2	Y6T3	Y6T4	Y6T5	Y6T6

MrW's Computing Blog