Databases
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
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 web, Building 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
Suggested Software
- 2Investigate (from Purple Mash or the 2Simple Collection)
- Google Forms - From Google's G-Suite, or Microsoft Forms from Microsoft 365
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…