|
LEARNING OBJECTIVE
|
Success Criteria
|
|
To understand how to produce a fully labelled bar
chart.
LEARNING OUTCOME
To produce a fully labelled bar chart.
|
SHOULD:
- I can produce a bar chart to show the following data.
- I can give my bar chart a title.
- I can label both of the axis.
COULD:
- I can interpret the graph accurately.
|
1. Parts of a Spreadsheet
CELL, COLUMN, ROW
2. Creating Graphs
Watch your teacher creating a Graph with Title and Axis Titles
How many children eat fruit once a week?
| How often? |
Number of Children? |
| More than once a day |
6 |
| Once a day |
9 |
| Once a week |
11 |
| Less than once a week |
3 |
| Never |
1 |
Now teacher will create a Bar Chart
3. Create your own Graphs
You need to produce graphs for both sets of data.
There is a help sheet you will need to read with your partner before you start to create the graphs so you know what each graph is for.
Both graphs can be produced on the same spreadsheet.
4. Plenary
Who has successfully been able to create a bar chart using Excel?
- Do A Self assessment.
- What difficulties did you encounter?
Go through the science based questions on the sheet:
Graph 1:
- Put the results into a graph. The graph must have a title and must be fully labeled.
- What does the graph show?
- What is the name of the force, which is acting on the toy car?
Graph 2:
- Put the results into a graph. The graph must have a title and must be fully labeled.
- What does the graph show?
- What is the name of the process when ice changes to water?
- In what location did the ice stick stay most frozen?
- What was the warmest location used in the investigation? How do you know this was the warmest place?
| 