 |
|
|
|
|
|
 |
|
||||
 |
 |
 |
|
||
 |
|
||||
 |
|
||||
 |
|
||||
 |
|
||||
 |
|
||||
 |
|
||||
 |
|
||||
 |
|
||||
 |
|
||||
 |
|
||||
 |
|
||||
 |
|
||||
 |
|
||||
 |
 |
 |
|
||
 |
|
||||
Introduction
In this unit you will consider how to collect relevant data to answer a question. You will design a file to handle the data and will check your entries for accuracy. Finally, you will use the database functions in a spreadsheet package, such as Microsoft Excel, to interrogate your data and consider the plausibility of the conclusions you have drawn.
Lesson outlines
LESSON 1
Evaluating and interrogating an existing data set
1 Starter: Checking pupils’ knowledge and understanding
2 Considering critically the information in an existing data set
3 Interrogating an existing data set
4 Generating graphs
5 Plenary: Considering everyday uses of graphical data
Homework: Considering the clarity of information represented graphically
LESSON 2
Presenting information in different formats to test hypotheses
1 Starter: Review of previous learning
2 Proposing and testing hypotheses
3 Using percentages to derive new information
4 Plenary: Presenting conclusions
Homework: Collecting data
LESSON 3
Designing a questionnaire to collect data
1 Starter: Introducing questions to be answered
2 Considering what data are required
3 Framing the questions for a questionnaire
4 Considering answers to questions on a questionnaire
5 Plenary: Comparing local and national data
Homework: Collecting data
LESSON 4
Creating a questionnaire and designing a data handling file structure
to answer a key question
1 Starter: Designing a questionnaire
2 Completing a questionnaire
3 Plenary: Designing and creating a data handling file structure
Homework: Evaluating individual database designs
LESSON 5
Entering, checking and testing data
1 Starter: Checking data for errors
2 Entering and testing data
3 Creating graphs and charts for initial data analysis
4 Sorting data and using selective searching
5 Plenary: Recognising the need to collect extra data to draw conclusions
Homework: Improving data collection to avoid pitfalls
LESSON 6
Drawing conclusions and selecting data to support them
1 Starter: Ways of checking the plausibility of conclusions
2 Drawing conclusions
3 Providing evidence to support conclusions and checking for plausibility
4 Plenary: Relating conclusions to original questions
Homework: Extending the investigation or preparing for the next unit
