Year 10

Computer Science

Semester One

Week 1 + 2 + 3 - Digital Systems

Introduction to course

Welcome to year 10 Computing Studies

Learning Objectives


Resources 


What is a computer? Presentation here

Digital Systems worksheet here

CPU worksheet here

Revision PowerPoint here  and worksheet here 


Extension 

Visit Silent teacher and practice your maths and programming skills here


Digital systems end of topic test

Week 4 + 5 + 6 - Spreadsheets

Learning Objectives


Resources

GFCGlobal online learning Excel tutorials here

or 

Excel practical refresher workbook here 

Orb worksheets here

Spreadsheet practice test tasks instructions here the Excel worksheet here

Extension

Python

Week 7 + 8 + 9 + 10 - Databases

Learning Objectives


Resources

Database intro presentation here

Create a simple database here

A more complex database here

Quackit database tutorial here 

Week 11 - Computational thinking

Learning Objectives

Resources

Watch the Google video here

Visit the Bebars computational challenges here, or more challenges can be found here

Week 12 + 13 + 14 - LEGO Mindstorms

Learning Objectives

Resources 

LEGO Mindstorms rescue challenge video here

Week 15 - Algorithms, Flowcharts and Pseudocode

Learning Objectives

Resources

View the algorithms presentation here

The worksheet to go with the presentation is here

Week 16 + 17 + 18 +19 - Python

Learning Objectives

Resources

View the programming presentation here

Python programming challenges here


Semester Two

Week 1 + 2 + 3 + 4 - Python Game 

Learning Objectives


Python programming websites

Edabit, learn Python tutorial here 

Program a game in Python with Ray Wenderlich here

Pygame tutorial here

Pygame tutorial 2 here

She codes turtle here

Week 5 + 6 + 7 + 8 + 9 +10 - Computer Game 

Learning Objectives

Resources

101 Computer challenges in Python here

Week 11 + 12  - Networks

Learning Objectives

Resources

Networks presentation here

Networks notes here

Networks worksheet here

Khan Academy course on networking here please use school email to log in.

Week 13 + 14 + 15 + 16 - Cybersecurity

Learning Objectives

Resources

Cybersecurity with Nova Labs here