Year 07 Computer Science
Curriculum:
Click to Expand Autumn Content:
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
Click to Expand Spring Content:
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)
Click to Expand Summer Content:
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
Subject Overview:
Students in Year 7 have 1 Computer Science lesson each week.
In Year 7, students have 1 piece of homework set every 2 weeks.
This homework is usually set on Epraise.
Assessments:
Students in Year 7 sit a baseline assessment at the the start of the Autumn Term.
Students sit a summative assessment at the end of each unit.
