,
Message sent from:
North Lane, West Hoathly, West Sussex, RH19 4QG
Tel: 01342 810302 | Email: office@westhoathlyschool.co.uk
Headteacher: Annabelle Fox

KEY STAGE 2 - SPRING SYLLABUS

DATABASES & DATA

In the Autumn Term we will also be starting our Databases & Data strand.  There are 2 strands to this subject area, which are listed below. 

COMPUTING TOPICS

  1. Flatfile Databases - Airtable
  2. Branching Databases – FlexiTree
     

AIRTABLE

In this strand we use child-friendly, online database software, to introduce the children to flatfile databases and data handling.  Year-on-year we revisit the strand, in order to develop the related knowledge and skills.

Year Group Focus

  • Y3 Creating Databases - Covers setting up simple databases, understanding that there are different field types, i.e. text, number, date, etc.  Entering a data set, correcting errors, and analysing information, and answering questions.
  • Y4 Database evolution - Covers developing the databases from the previous year, and adding new fields and field types. Idenfifying dynamic/static data, and updating dynamic data, i.e. your date of birth would be static data, your age dynamic data.
  • Y5 Database Interrogation - Covers further developing existing databases.  Identifying the impact incorrect information would have when analysing data, i.e. it would scew your figures.  Using filters, sorting and searching in order to answer questions.
  • Y6 Databases Exports - Covers further developing existing databases.  Importing/exporting Comma Separated Values (CSV) files, & analysing data using Charts and Graphs in Excel.  Recognising implausible data, i.e. an individual's hobby was playing Quidditich.

FLEXITREE
In this strand we will be learning about Branching Databases (aka Binary Databases), and binary searches.  Branching Databases are used to carry out  Binary Searches.  These are searches that use a series of YES/NO questions in order to arrive at the answer.  If you have ever played Twenty Questions, you have done a Binary Search!

Year Group Focus

  • Y3 Creating Databases - Covers setting up simple identification databases, using a series of prepared YES/NO questions. 
  • Y4 Designing Databases - Covers setting up simple identification databases, and devising a series of YES/NO questions. 
  • Y5 Database Development - Covers setting up multi-level identification databases, and devising a series of YES/NO questions. 
  • Y6 Database Evolution - Covers setting up more complex multi-level identification databases, and devising a series of YES/NO questions.  Adding images and sounds.

DIGITAL LIFE

In the second half of the Spring Term we will be learning about Digital Life.  With more and more of our lives being spent online; having a good understanding of the importance of E-Safety & Online Security, has become imperative.  Consequently, we revisit the topic each year; adding new elements in order to develop the breadth and depth of the children’s knowledge.  By the time they leave us, they have a good all round understanding of the subject.   

Recently, the topic has evolved to incorporate a wider range of elements.  Now known as ‘Digital Life’, the strand focuses on eight different aspects of online education:

  1. Self-Image and Identity
  2. Online Relationships
  3. Online Reputation
  4. Online Bullying
  5. Managing Online Information
  6. Health, Wellbeing and Lifestyle
  7. Privacy and Security
  8. Copyright and Ownership

The new framework, produced by the UK Council for Child Internet Safety (UKCCIS) in Partnership with the Department of Education and other relavent parties, “…aims to support and broaden the provision of online safety education, so that it is empowering, builds resilience and effects positive culture change.  The objectives promote the development of safe and appropriate long term behaviours, and support educators in shaping the culture within their setting and beyond.” 

The PSHE Association was one of the partners involved in developing the Digital Life curriculum.  Consequently, much of the content falls under both Computing and PSHE (Personal, Social and Health Education).   Therefore, the technical aspects of the topic will be covered in Computing and the emotional aspects in PSHE sessions.  In computing there are 2 strands to this subject area, which are listed below. 

COMPUTING TOPICS

  1. Digital Literacy - Google Chrome
  2. Digital Citizenship – Google Chrome
     

DIGITAL LITERACY

In this strand we will be focusing on digital/web skills.  This will include learning how to move around the World Wide Web effectively, using Web Browsers and understanding the search results returned, and much more. 

Year Group Focus  -  Under Revision TBA

  • Y3 Key Word Searches - Identifying and using Keywords, the most important words in a sentence, when carrying out searches, i.e. What is the population of Malta?  I need a map of London.
  • Y4 Password Protection - Creating strong passwords, and understanding the purpose of Anti-Virus, Anti Spyware & Fire Wall software.
  • Y5 Secure Websites - Identifyings secure sites by checking for Security padlocks & https.  Evaluting websites and their content.
  • Y6 Online Ownership - Undering what Intellectual Property, Plagiarism and Copyright mean on a basic level.  Copying and downloading content and citing sources.

DIGITAL CITIZENSHIP

In this strand we will be focusing on digital interaction.  This will include esafety and security, how to treat others, and much more.

Year Group Focus -  Under Revision TBA

  • Y3 to Y6 E-safety & Security - Covers age appropriate aspects of Digital Life; focusing on the dangers that can be encountered online and how the children can protect themselves.  We also look at being a good on Digital Citizen.

COMPUTING HOME PAGE TOP

West Hoathly Church of England Primary School | Hosted by New Era Technology | DB Primary | DB Learning Library

X
Hit enter to search