Databases

About this unit:

Explore different ways to collect, interrogate and present data collaboratively using a range of programs. What is a database? Why and how are they used in real life?

National Curriculum Links - Computing KS2

The content of this plan cover the following National Curriculum strands: 

  • understand computer networks, including the internet; how they can provide multiple services, such as the World Wide Web, and the opportunities they offer for communication and collaboration
  • select, use and combine a variety of software (including internet services) on a range of digital devices to design and create a range of programs, systems and content that accomplish given goals, including collecting, analysing, evaluating and presenting data and information

 

Curriculum Mapping

Why this? What does it build on?

This unit builds on some of the content in the Year 2 unit Finding and Presenting Information, where students look at gathering and presenting data in graphs and charts. It also utilises skills learned in the Year 3 unit Communication and collaboration, such as using collaborative tools to gather, analyse, and present information.

What comes next?

After this unit, the students will continue their use of online collaborative tools in Key Stage 2 units Searching the webBuilding Collaborative websites and Spreadsheet masters. In Spreadsheet masters they will also deepen their knowledge and understanding of working with data in spreadsheet databases; creating charts and graphs, using formulas, sorting and adding conditional formatting to data.

View our full curriculum map

Take a look at our full curriculum map to see how units across all year groups, from Year 1 to Year 6 link.

Unit Resources

Lesson Slides

Detailed lesson slides for you to use when delivering this unit of work with your class

Unit Assessment Sheet

Use our simple assessment system to measure your students' success in this unit of work.

Lessons

Lesson

  • To understand and explain what a database is
  • To identify records and fields of a database.
  • To identify advantages and disadvantages of using databases.

Lesson 2

  • To select appropriate data to add to a database
  • To create a collaborative class database
  • To search and sort a database

Lesson 3

  • To insert records into a database.
  • To insert information into fields of a database.
  • To look through a database to find information. Think, discuss and try different searching methods.

Lesson 4

  • To make a chart from information in a database.
  • To be able to read and compare information on a chart.
  • To interpret a chart and report findings.

Lesson 5

  • To compare different methods of collecting data
  • To understand and explain the difference between open and closed questioning
  • To create and use an online questionnaire for data collection

Lesson 6

  • To accurately analyse and interpret database information .
  • To make charts from the database information. 
  • To present information from a database.

Suggested Software

Full Computing Glossary

Take a look at our full computing glossary, plus key vocabulary for each age group.

Key computing vocabulary for this unit

Cloud storage -  Services such as Google Drive, OneDrive and iCloud allow users to store their files and data on internet servers, rather than on their local computers. Advantages of this are that files are safer and can be accessed anywhere with an internet connected device. Storage can also be effectively infinite as you can buy more storage if needed.

Collaboration - To work together with others. Many digital tools now allow easy collaboration as users can work remotely on the same document or system at the same time. Tools like Google G-Suite and Microsoft Office 365 offer a variety of collaborative documents and apps.

Data - A structured set of numbers, representing digitised text, images, sound or video, which can be processed or transmitted by a computer.

Database - A database is an organised collection of data, generally stored and accessed electronically from a computer system.

Edit - To change, add or remove elements in a piece of work (usually to improve it).

Evaluation - Making judgements (a computational thinking concept)

Export - The opposite of importing and a computing command that usually means saving or sending a file, or part of a file, to a specific new location. It also often allows changing the file format as it’s saved. For example, a Photoshop image could be exported as a PDF document or different images types (PNG, JPEG etc). You might also export content between apps on an iPad. A piece of music could be exported to iMovie to use as a soundtrack for a video.

Field - Columns of a table in a database, or categories. For example in a database of people in an organisation you might have fields for 'name', 'address', 'phone number', 'job title' etc.

Import - A computing command that usually means allowing a user to bring in a file, or part of a file into another application so they can be combined. For example, an image could be imported into presentation slides, or art software to use as a background.

Rank - A number that shows the position of something in a numerically ordered sequence.

Record - Every item in a database is called a 'record'. Each record will have information saved for a number of categories or 'fields'. For example, in a database about countries 'Spain' might be a record that is kept. Information on population, land area, and capitol city may be part saved as fields for that record.

Save - To store a piece of work in a computer’s memory so that it can be recalled at a later time.

Search - To identify data that satisfies one or more conditions, such as web pages or records in a database containing keywords, or files on a computer with certain properties.

Sort - To arrange a set of data into a prescribed sequence.

Related units

Building Collaborative Websites

About this unit: Use Google apps for collaborative research as well as planning and creation of a group website, considering…

Communication and Collaboration

About this unit: Introduce students to email and online collaborative tools. Learn how to safely and appropriately make use of these…

Finding and Presenting Information

About this unit: Introduce students to this great block-based programming language to create animations and games perfect for KS1. Write…

Inside the internet

About this unit: Get under the skin of the Internet to investigate what the internet is, how the web works,…

Searching the Web

About this unit: Take a detailed look at all elements of searching the web with care and consideration, covering: searching…

Spreadsheet Masters

About this unit: Hone your spreadsheet skills to become a spreadsheet master! Learn about the basics of spreadsheets with a…

What is a computer?

About this unit: Delve into what really makes a computer a computer. Is a TV a computer? Is a fridge…