Year 10
Computer Science
Semester One
Week 1 + 2 + 3 - Digital Systems
Introduction to course
Welcome to year 10 Computing Studies
Introduction to course
Overview of cover page
Overview of assessments
Student expectations
Learning Objectives
Role of hardware and software in managing, controlling and securing the movement of data in a digital system
Different methods of manipulation, storage and transmission of data
Define a digital system
List hardware
List software
Define sensors
Understand types of storage
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
Design possible solutions, analysing designs against criteria, including functionality, accessibility, usability and aesthetics using appropriate technical terms and technology
Select, justify, and safely implement and test appropriate technologies and processes, to make solutions.
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
Define a database
List uses for a database
State the functions used in a database
Understand the keywords used in a database
Create a basic database
Use a basic database
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
Design algorithms represented diagrammatically and in structured English, including iteration
Validate algorithms and programs using common acceptable methods
Implement data storage and organisation techniques within a programming environment
Investigate components/resources to develop increasingly sophisticated solutions, identifying and considering associated constraints
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
Design algorithms represented diagrammatically and in structured English, including iteration
Validate algorithms and programs using common acceptable methods
Implement data storage and organisation techniques within a programming environment
Investigate components/resources to develop increasingly sophisticated solutions, identifying and considering associated constraints
Resources
LEGO Mindstorms rescue challenge video here
Week 15 - Algorithms, Flowcharts and Pseudocode
Learning Objectives
Design algorithms represented diagrammatically and in structured English, including iteration.
Validate algorithms and programs using common acceptable methods.
Implement data storage and organisation techniques within a programming environment.
Resources
View the algorithms presentation here
The worksheet to go with the presentation is here
Week 16 + 17 + 18 +19 - Python
Learning Objectives
Design algorithms represented diagrammatically and in structured English, including iteration.
Validate algorithms and programs using common acceptable methods.
Implement data storage and organisation techniques within a programming environment.
Resources
View the programming presentation here
Python programming challenges here
Semester Two
Week 1 + 2 + 3 + 4 - Python Game
Learning Objectives
Design algorithms represented diagrammatically and in structured English, including iteration.
Validate algorithms and programs using common acceptable methods.
Implement data storage and organisation techniques within a programming environment.
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
Design algorithms represented diagrammatically and in structured English, including iteration.
Validate algorithms and programs using common acceptable methods.
Implement data storage and organisation techniques within a programming environment.
Resources
101 Computer challenges in Python here
Week 11 + 12 - Networks
Week 13 + 14 + 15 + 16 - Cybersecurity
Learning Objectives
Role of hardware and software in managing, controlling and securing access to data, in networked digital systems
Simple compression of data and how content data is separated from presentation data
Apply techniques for acquiring, storing and validating quantitative and qualitative data from a range of sources, considering privacy and security requirements
Resources
Cybersecurity with Nova Labs here