Year 7

Term 1

Lesson 1 – Welcome to the computing lab

Create a memorable and secure password for an account on the school network & Remember the rules of the computing lab

Lesson 2 – Welcome to your workstation

Find personal documents and common applications, recognise a respectful email & construct an effective email and send it to the correct recipients.

Lesson 3 – Respectful online communication

Describe how to communicate with peers online.

Lesson 4 – Presenting to an audience part 1

Plan effective presentations for a given audience; Describe cyberbullying; Explain the effects of cyberbullying

Lesson 5 – Presenting to an audience part 2

Plan effective presentations for a given audience; Describe cyberbullying; Explain the effects of cyberbullying

Lesson 6 – Who are you talking to

Check who you are talking to online.

Lesson 1 – Getting to know a spreadsheet

Identify columns, rows, cells, and cell references in spreadsheet software; Use formatting techniques in a spreadsheet

Lesson 2 – Quick calculations

Use basic formulas with cell references for calculations in a spreadsheet (+, -, *, /) ; Use the autofill tool to replicate cell data

Lesson 3 – Collecting Data

Explain the difference between data and information; Explain the difference between primary and secondary sources of data; Collect data

Lesson 4 – Become a data master!

Analyse data; Create appropriate charts in a spreadsheet; Use the functions SUM, COUNTA, MAX, and MIN in a spreadsheet.

Lesson 5 – Level up your data skills!

Analyse data; Use a spreadsheet to sort and filter data; Use the functions AVERAGE, COUNTIF, and IF in a spreadsheet.

Lesson 6 – Assessment

Use conditional formatting in a spreadsheet; Apply all of the spreadsheet skills covered in this unit

Term 2

Lesson 1 – Computer networks and protocols

Define what a computer network is and explain how data is transmitted between computers across networks; Define ‘protocol’ and provide examples of non-networking protocols.

Lesson 2 – Networking Hardware

List examples of the hardware necessary for connecting devices to networks.

Lesson 3 – Wired and Wireless Network

Compare wired to wireless connections and list examples of specific technologies currently used to implement such connections; Define ‘bandwidth’, using the appropriate units for measuring the rate at which data is transmitted, and discuss familiar examples where bandwidth is important

Lesson 4 – The Internet

Define what the internet is; Explain how data travels between computers across the internet; Describe key words such as ‘protocols’, ‘packets’, and ‘addressing’.

Lesson 5 – Internet Services

Explain the difference between the internet, its services, and the World Wide Web; Describe how services are provided over the internet; List some of these services and the context in which they are used; Explain the term ‘connectivity’ as the capacity for connected devices (‘Internet of Things’) to collect and share information about me with or without my knowledge (including microphones, cameras, and geolocation); Describe how internet-connected devices can affect me

Lesson 6 – The World Wide Web

Describe components (servers, browsers, pages, HTTP and HTTPS protocols, etc.) and how they work together.

Lesson 1 – Introduction to programming and sequencing

Compare how humans and computers understand instructions (understand and carry out); Define a sequence as instructions performed in order, with each executed in turn; Predict the outcome of a simple sequence; Modify a sequence

Lesson 2 – Sequence and variables

Define a variable as a name that refers to data being stored by the computer; Recognise that computers follow the control flow of input/process/output; Predict the outcome of a simple sequence that includes variables; Trace the values of variables within a sequence; Make a sequence that includes a variable

Lesson 3 – Selection

Define a condition as an expression that will be evaluated as either ‘true’ or ‘false’; Identify that selection uses conditions to control the flow of a sequence; Identify where selection statements can be used in a program;  Modify a program to include selection

Lesson 4 – Operators

Create conditions that use comparison operators (>,<,=); Create conditions that use logic operators (and/or/not); Identify where selection statements — that include comparison and logical operators — can be used in a program.

Lesson 5 – Count-controlled iteration

Define iteration as the process of repeatedly executing instructions; Describe the need for iteration; Identify where count-controlled iteration can be used in a program; Implement count-controlled iteration in a program; Detect and correct errors in a program (debugging).

Lesson 6 – Problem-Solving

Independently use programming constructs to solve a problem (subroutine, selection, count-controlled iteration, operators, and variables).

Term 3

Lesson 7 – Introduction to programming and sequencing

Define a subroutine as a group of instructions that will run when called by the main program or other subroutines; Define decomposition as breaking a problem into smaller, more manageable subproblems; Identify how subroutines can be used for decomposition

Lesson 8 – Fly cat, Fly!

Identify where condition-controlled iteration can be used in a program; Implement condition-controlled iteration in a program

Lesson 9 – Loop the loop!

Evaluate which type of iteration is required in a program

Lesson 10 – Treasure those lists!

Define a list as a collection of related elements that are referred to by a single name; Describe the need for lists; Identify when lists can be used in a program; Use a list

Lesson 11 – Translate this! Part 1

To decompose a larger problem into smaller subproblems; To apply appropriate constructs to solve a problem

Lesson 12 – Translate this! Part 2

To decompose a larger problem into smaller subproblems; To apply appropriate constructs to solve a problem

Lesson 1 – Features of a word processor

Select the most appropriate software to use to complete a task; Identify the key features of a word processor; Apply the key features of a word processor to format a document; Evaluate formatting techniques to understand why we format documents.

Lesson 2 – Licensing appropriate images

Select appropriate images for a given context; Apply appropriate formatting techniques; Demonstrate an understanding of licensing issues involving online content by applying appropriate Creative Commons licences; Demonstrate the ability to credit the original source of an image.

Lesson 3 – The credibility of sources

Critique digital content for credibility; Apply techniques to identify whether or not a source is credible.

Lesson 4 – Research and plan your blog

Apply referencing techniques and understand the concept of plagiarism; Evaluate online sources for use in own work.

Lesson 5 – Promoting your cause

Construct a blog using appropriate software; Create content for a blog based on credible sources; Apply referencing techniques that credit authors appropriately; Design the layout of the content to make it suitable for the audience.

Lesson 6 – Project completion and assessment

Construct a blog using appropriate software; Create content for a blog based on credible sources; Apply referencing techniques that credit authors appropriately; Design the layout of the content to make it suitable for the audience.