Overview:

Students in Year 7 have one Computer Science lesson each week.

Year 7 Computer Science students have one piece of homework set every two weeks.
This homework is usually set on Epraise.

Curriculum:

In Autumn we study:
Collaborating Online Respectfully
Spreadsheets
Welcome To The Computing Lab
Welcome To Your Workstation
Respectful Online Communication
Presenting To An Audience: Part 1
Presenting To An Audience: Part 2
Who Are You Talking To?
  • Create A Memorable And Secure Password For An Account On The School Network
  • Remember The Rules Of The Computing Lab
  • Find Personal Documents And Common Applications
  • Recognise A Respectful Email
  • Construct An Effective Email And Send It To The Correct Recipients
  • Describe How To Communicate With Peers Online
  • Plan Effective Presentations For A Given Audience
  • Describe Cyberbullying
  • Explain The Effects Of Cyberbullying
  • Plan Effective Presentations For A Given Audience
  • Describe Cyberbullying
  • Explain The Effects Of Cyberbullying
  • Check Who You Are Talking To Online
Getting To Know A Spreadsheet
Quick Calculations
Collecting Data
Become A Data Master!
Level Up Your Data Skills!
Assessment
  • Identify Columns, Rows, Cells, And Cell References In Spreadsheet Software
  • Use Formatting Techniques In A Spreadsheet
  • Use Basic Formulas With Cell References To Perform Calculations In A Spreadsheet (+, -, *, /)
  • Use The Autofill Tool To Replicate Cell Data
  • Explain The Difference Between Data And Information
  • Explain The Difference Between Primary And Secondary Sources Of Data
  • Collect Data
  • Analyse Data
  • Create Appropriate Charts In A Spreadsheet
  • Use The Functions SUM, COUNTA, MAX, And MIN In A Spreadsheet
  • Analyse Data
  • Use A Spreadsheet To Sort And Filter Data
  • Use The Functions Average, Countif, And If In A Spreadsheet
  • Use Conditional Formatting In A Spreadsheet
  • Apply All Of The Spreadsheet Skills Covered In This Unit
In Spring we study:
Networks: From Semaphores To The Internet
Programming
Computer Networks And Protocols
Networking Hardware
Wired And Wireless Networks
The Internet
Internet Services
The World Wide Web
  • 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
  • List Examples Of The Hardware Necessary For Connecting Devices To Networks
  • 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
  • Define What The Internet Is
  • Explain How Data Travels Between Computers Across The Internet
  • Describe Key Words Such As ‘protocols’, ‘packets’, And ‘addressing’
  • 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
  • Describe Components (Servers, Browsers, Pages, HTTP And HTTPS Protocols, etc.) And How They Work Together
Introduction To Programming And Sequencing
Sequence And Variables
Selection
Operators
Count-Controlled Iteration
Problem-Solving
  • 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
  • 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
  • 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
  • Create Conditions That Use Comparison Operators (=, <, >)
  • Create Conditions That Use Logic Operators (and/or/not)
  • Identify Where Selection Statements Can Be Used In A Program That Include Comparison And Logical Operators
  • Define Iteration As A Group Of Instructions That Are Repeatedly Executed
  • 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)
  • Independently Design And Apply Programming Constructs To Solve A Problem (Subroutine, Selection, Count-controlled Iteration, Operators, And Variables)
In Summer we study:
Programming
Gaining Support For A Cause
You’ve Got The Moves!
Fly Cat Fly!
Loop The Loop!
Treasure Those Lists!
Translate This! (Part 1)
Translate This! (Part 2)
  • 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 Down Into Smaller, More Manageable Subproblems
  • Identify How Subroutines Can Be Used For Decomposition
  • Identify Where Condition-controlled Iteration Can Be Used In A Program
  • Implement Condition-controlled Iteration In A Program
  • Evaluate Which Type Of Iteration Is Required In A Program
  • 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
  • Decompose A Larger Problem Into Smaller Subproblems
  • Apply Appropriate Constructs To Solve A Problem
  • Decompose A Larger Problem Into Smaller Subproblems
  • Apply Appropriate Constructs To Solve A Problem
Features Of A Word Processor
Licensing Appropriate Images
The Credibility Of Sources
Research And Plan Your Blog
Promoting Your Cause
Project Completion And Assessment
  • 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
  • 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
  • Critique Digital Content For Credibility
  • Apply Techniques To Identify Whether Or Not A Source Is Credible
  • Apply Referencing Techniques And Recognise The Concept Of Plagiarism
  • Evaluate Online Sources For Use In Own Work
  • 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
  • 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

Assessments:

Students in Year 7 are assessed through end of unit assessments and an end of year assessment.

Resources:

Students have a variety of resources available to them:

  • Teacher Slides
  • Activity Sheets/Tasks
  • Support Documents
  • Key Terminology Sheets
All of these resources can be found on Microsoft Teams.