TERM 1: AUTUMN TERM

TERM 2: SPRING TERM

TERM 3: SUMMER TERM

YEAR GROUP

T1a

T1b

T2a

T2b

T3a

T3b

Year 5

Google Drive/Google Classroom

-How to login to the google drive

-How to access from home

-How to work collaboratively using the google drive

-How to access google classroom in different subjects

Hardware and Software/Artificial Intelligence

-What is Hardware?

-The categories of Hardware

-Input, Output and Storage devices

-The CPU, the computer brain

-What is AI?

-What is Software?

-The categories of Software

-Design a use for AI

-Oracy Skills

Algorithms and Flow Diagrams

-What is an algorithm?

-How do we create them?

-What makes a good algorithm?

- The computer brain v the human brain

-Using a flow diagram to represent an algorithm

-Decomposition

-Flow chart symbols

-Creating our own Flow Diagrams

-How do computers work?

Scratch Level 1: Disney Pseudocode

- Introducing block based programming

-How to insert original images into scratch

-Selecting and saving images

-Creating an algorithm fit for purpose

- Writing pseudocode

-Programming original images to perform an algorithm

Lego Wedo Project

-To work in a pair to follow instructions

-Problem solve and evaluate

-Use software to programme a lego model to perform different tasks

-Collaborate with others

- Debug and problem solve

-Oracy Skills

E Safety

Google’s-  Be Internet Legends

- Be Internet Secure Protect Your Stuff

- Think Before You Share

Animation Project

-Be able to use different software packages to create a character

-To develop a storyboard based around a character

-Use editing tools within different software i.e. paint and Microsoft Publisher

-Animate an original story using tools within Microsoft Powerpoint

-Presentation/Oracy skills development

An Introduction to Spreadsheets

-What is a spreadsheet

-Who would use a spreadsheet?

-What software would we use to create a spreadsheet?

-Setting out a spreadsheet in excel

-Creating basic formulas

E Safety

Google’s-  Be Internet Legends

- Be Internet Brave, When in doubt discuss

Year 6

Google Drive/Google Classroom

-Refresher on how to login to the google drive

-Refresh on how to access from home

-Refresh on how to work collaboratively using the google drive

-Refresh on how to access google classroom in different subjects

Data and Data Representation

-Top Trumps Project

-What is a Database and why do we use them?

-The difference between data and information

-Creating a data capture sheet

-Populating a data capture sheet/data entry

-Searching the Internet Safely

-Desk top publishing skill development

- Graphic Design

-How to Mail Merge

- Evaluating our designs

Scratch Level 2

-Skill Building

-Following instructions

-Independent learning

-Developing independent learning skills

-Problem solving and debugging

-Creating loops

-Using variables within a programme

Python Basics

-Introduction to text based programming

-Using the idle

-Using an online editor

-Creating a basic programme

-Running a programme in Python

-Debugging a basic programme in Python

Kodu Project

-Game creation in Kodu, Collaborative working

-Explore software independently

-Story mapping

-Oracy Skills

-Creating pseudocode

-Creating and testing their game

-Debugging and decomposition

-Game evaluation

E Safety

Google’s-  Be Internet Legends

- Be Internet Alert Check it’s For Real

Spreadsheets - Further Skills

- Creating formulas recap

-More complex formulas

-Formatting cells

-Naming workbooks within a spreadsheet

-Making spreadsheets look professional

Year 7

Google Drive/Google Classroom

- Refresher on how to access and use the google drive and google classroom

- How to use email

- Email etiquette

- How to use email for school work

- E safety and email

Database Development

- A practical unit covering the basic theory, creation and use of a single-table database and a simple relational database involving two tables in a one-to-many relationship.

- Creating Queries in Microsoft Access

- Using relational operators

- Careers and real life uses of Databases  eg in the police force

HTML & CSS

- What is HTML and CSS?

-Where is it used and how?

- Basic HTML code

- Inserting headings in HTML

- Changing the look of the web page using basic CSS

- Debugging HTML code

- Creating a web page

Python Level 2

- Developing useful programmes in this text based programming language

- Debugging programmes

- Refining and developing programmes

BBC Micro Bit

- Hardware components

- Following instructions

- Using different software to programme the microbit

- Running a programme on the Microbit

- Debugging a programme

Design Thinking

- TED Talks

- What is design thinking?

-”The Sixth Sense”

- Using Computers to solve problems

- Collaborative project

- Google drive

- Careers and pathways

- Presentation skills and oracy

Spreadsheets in Business

- Recapping previous spreadsheet skills

- Developing further skills in spreadsheets

- Using spreadsheets in business, why do we need to know how to use a spreadsheet?

- Careers

- Entrepreneurial skills, small business concept creation

Hardware and Software

- Hardware and software refresher

-What is a network?

- Binary overview

- The CPU and binary

Using Computers to Communicate

- How to email

- What is CC, BCC?

- How to attach docs

- Email Etiquette

- E safety issues

Year 8

Google Drive/Google Classroom

- Refresher on how to access and use the google drive and google classroom

- How to use email

- Email etiquette

- How to use email for school work

- E safety and email

The Origins of Code

- Create an extended piece of writing on how Alan Turing helped to win WW2 by cracking the Enigma Code and creating one of the first computers

- Using the internet to independently research

Spreadsheet Analysis

- Developing more complex spreadsheets

- Creating Graphs and charts in excel

- Designing spreadsheets for a purpose

-Using Graphical Spreadsheets to analyse data

Python Level 3:

- Continue to develop text based programming skills

- Develop more complex programmes using python

- Use of variables in programmes

- Loops

HTML & CSS - Level 2

- What is HTML and CSS?

- Where is it used and how?

- Basic HTML code

- Inserting headings in HTML

- Changing the look of the web page using basic CSS

- Debugging HTML code

- Creating a web page

Game Creation

- Systems Life Cycle

- To design a game concept

- Create characters

- Research what makes a good game

- Use a variety of software to create a prototype for the game

- Game creation and testing

- Debugging and evaluating

- Careers in the Gaming Industry

- E Safety related to Gaming and online safety