Computer Science

Coronavirus Closure

Following on from the updated Government directive on school closures in the Leicester and Leicestershire area, The Cedars Academy is now closed from Tuesday 30th June to all students except children of key workers who have registered for a place.

Autumn Term

Topic

Overview

Hardware and Software
  • Input, output and storage devices
  • Internal complements of a computer system
  • Types of software including utility, application, system and operating system software 
  • Database management and manipulation 
Text Based Programming
  • An introduction to Small Basic
  • Statements, Properties and Operators
  • Variables
  • Conditions and Loops
  • Branching and sub-routines

  

Social, Moral, Spiritual & Cultural and British Values Links

    • SMSC – Code of ethics when writing computer programs
    • SMSC – Self-reflection in programming 
    • SMSC:  respect the law and consequences of actions
    • SMSC – self discipline 
    • BV: respect of others view and opinions 

 

Careers, Advice, Information & Guidance Links

Coding solutions for end users  

 

Home Learning this Term

    • Literacy for learning – spellings
    • Research into the history of Computer Systems (timeline)
    • Home items with a microprocessor
    • Algorithms

 

Spring Term

Topic

Overview

Logic
  • Data Representation
  • Binary to denary 
  • Denary to binary
  • Truth tables
  • Logic gates 

  

 

Social, Moral, Spiritual & Cultural and British Values Links

    • SMSC – self discipline

 

Careers, Advice, Information & Guidance Links

Producing a logical set of instructions to problem solve 

 

Home Learning this Term

    • Literacy for learning - spellings
    • The new computer language
    • Coded messages
    • Binary to denary conversion
    • Denary to binary conversion  

 

 

Summer Term

Topic

Overview

My SQL
  • Using SQL as a database management tool
  • Creating a table
  • Populating a table
  • Manipulating data in a table
  • Deleting data 
  • Creating relationships between data 

 

Social, Moral, Spiritual & Cultural and British Values Links

    • SMSC: Keeping data secure
    • BV: The rule of law 

 

Careers, Advice, Information & Guidance Links

Students get the opportunity to experience a command driven database system that is used outside of schools and colleges 

 

Home Learning this Term

    • Literacy for learning – spellings
    • Database key terms
    • The use of MySQL in the real world
    • Recall key terms

 

 

Year 8 Computer Science Summary

The year 8 Computer Science curriculum builds a firm foundation of computer science principals including knowledge of computer systems, computational thinking and programming.  Student start to understand how the internal components of a computer feed into a complete computer systems and how the different types of software work alongside the hardware to make a computer system do what we need.   

Students are introduced to binary and learn how units of data are stored in a computer system.  

Programming concepts in year 8 move away from block based programming and focus more on students learning commands in preparation for GCSE Computer Science.