- View more resources from this publisher
Digital Schoolhouse
Tooltip
These resources have been reviewed and selected by STEM Learning’s team of education specialists for factual accuracy and relevance to teaching STEM subjects in UK schools.
Databases Unplugged
This series of activities is aimed at upper-primary school children and above, and is intended as an introduction to organising and storing data.
Kinaesthetic activities, paper-based and online tasks are used to support teaching of:
*Branching databases
*Fields and records
*Searching including the use of wildcards
*Structured queries including Boolean operators and Venn diagrams are used to aid understanding
*Range searches using comparison operators
*Sorting Key vocabulary is reinforced in each lesson.
The lessons progress from first principles of databases, moving to the use of online ‘cloud database’ tools, after the fundamentals have been firmly established.
Older children are subsequently introduced to relational databases using online and unplugged approaches. They learn about:
*Data validation
*Lookup tables and keys
*Referential integrity
*Relationship types and models
A short philosophical activity then focuses on the ethics of storing some data in databases using news articles as a stimulus. This is, again, intended for children at the upper-end of primary school.
Digital School House is associated and fully supported by Ukie
Show health and safety information
Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.
Downloads
-
Databases unplugged 4.78 MB
Show downloads
-
Databases unplugged 4.78 MB
Information on the permitted use of this resource is covered by the Category Three Content section in STEM Learning’s Terms and conditions.
