Key Stage Three - Control Technology and Data Logging

Handling Data


Checking Data Files for mistakes L3

PLTS- Independent Enquirers-identifying questions to answers and problems to resolve

PHSEE/Every Child Matters- Enjoy and achieve, E-safety

Load the data file "Cool Leisure Centre" from the sample files 

Lesson objectives -Checking Data Files for mistakes

Worksheet 1- Cool Leisure Centre L3

 


Amending Mistakes L4

Load the data file "Cool Leisure Centre" from the sample files 

PLTS- Independent Enquirers-identifying questions to answers and problems to resolve. 

PHSEE/Every Child Matters- Enjoy and achieve, E-safety

Lesson objectives - Amending Mistakes

Worksheet 2-Cool Leisure Centre L4
 


Creating Queries L4

Load the data file "Cool Leisure Centre" from the sample files 

PLTS- Independent Enquirers-identifying questions to answers and problems to resolve.  Planning and carrying out research, appreciating the consequences of decisions.  Exploring issues, events or problems from different perspectives.

         -Reflective learners-Reviewing progress and acting on the outcomes.

PHSEE/Every Child Matters- Enjoy and achieve, E-safety

Lesson objectives - Creating Queries, Interpreting Queries

Worksheet 3 Creating Queries-Cool Leisure Centre

Worksheet 4  Interpreting Queries- Cool Leisure Centre

Load the data file "Bookings" from the sample files 

Worksheet 5 Creating Queries-Bookings


Sorting Data L5

Load the data file "Accidents" from the sample files 

PLTS- Independent Enquirers-Planning and carrying out research, appreciating the consequences of decisions.

PHSEE/Every Child Matters- Enjoy and achieve, E-safety

Lesson objectives -  Sorting Data

Worksheet 6 Sorting Data-Accidents
 


Presenting Data L5

Load the data file "Accidents" from the sample files 

PLTS-Independent Enquirers-Planning and carrying out research, appreciating the consequences of decisions.

          -Reflective learners-Reviewing progress and acting on the outcomes

Lesson objectives - Presenting Data

Worksheet 7 presenting Data-Accidents


 

Complex queries L6

Load the data file "Cottages" from the sample files 

PLTS- Independent Enquirers-identifying questions to answers and problems to resolve.  Planning and carrying out research, appreciating the consequences of decisions.  Exploring issues, events or problems from different perspectives.

         -Reflective learners-Reviewing progress and acting on the outcomes.

PHSEE/Every Child Matters- Enjoy and achieve, E-safety

 

Lesson objectives - Complex queries

Worksheet 8 Complex queries-Cottages


Testing Hypothesis L6

Load the data file "World" from the sample files 

PLTS- Independent Enquirers-identifying questions to answers and problems to resolve.  Planning and carrying out research, appreciating the consequences of decisions.  Exploring issues, events or problems from different perspectives.

         -Creative Thinkers-Questioning their own and others assumptions

         -Reflective learners-Reviewing progress and acting on the outcomes.

PHSEE/Every Child Matters- Enjoy and achieve, E-safety, Health and well being

 

Lesson objectives - Testing Hypothesis

Worksheet 9 Testing Hypothesis - World


Creating a new Data file

Lesson objectives - Creating a Data file

Worksheet 10 Creating a Data File

Worksheet 11 Entering Data

Worksheet 12 Queries


Creating your own Data File L7

PLTS- Independent Enquirers-identifying questions to answers and problems to resolve.  Planning and carrying out research, appreciating the consequences of decisions.  Exploring issues, events or problems from different perspectives.

         -Reflective learners-Reviewing progress and acting on the outcomes.

         -Self Managers-Working towards goals, showing initiative commitment and perserverance.

PHSEE/Every Child Matters- Enjoy and achieve, E-safety, Health and well being

Lesson Objectives - Creating your own Data File

Worksheet 13 - Creating your own Data File


Create successful ways to collect and prepare information for processing L8

PLTS- Independent Enquirers-identifying questions to answers and problems to resolve.  Planning and carrying out research, appreciating the consequences of decisions.  Exploring issues, events or problems from different perspectives.

         -Reflective learners-Reviewing progress and acting on the outcomes.

PHSEE/Every Child Matters- Enjoy and achieve, E-safety, Health and well being

Lesson objectives - Create successful ways to collect and prepare information for processing

Worksheet 14 - Questionnaire


Evaluating the advantages and limitations of the Data handling software L7

PLTS- Independent Enquirers-identifying questions to answers and problems to resolve.  Planning and carrying out research, appreciating the consequences of decisions.  Exploring issues, events or problems from different perspectives.

         -Creative Thinkers-Questioning their own and others assumptions

         -Reflective learners-Reviewing progress and acting on the outcomes.

PHSEE/Every Child Matters- Enjoy and achieve, E-safety, Health and well being

Lesson objectives - Evaluating the advantages and limitations of the Data handling software

Worksheet 15 - Advantages and limitations


Pupil Self Assessment Tick Sheet

 


Database Revision

Databases Penalty Shootout