Computer Science 

Unit 1 and Unit 2

Semester 1  - Unit 1

Week 1 - Managing data - Word Processing

Introduction to course


Learning Objectives


Systems analysis and development 


Resources

Managing Data presentation

Word processing  task  - Convert the attached PDF to a well formatted  Word document.

Word processing theory questions here


Extension

Python bitesize tutorials

or

W3Schools Python tutorials

or

Snakify Python tutorials 

Week  2 + 3 + 4 + 5 -  Systems Analysis and Development - Computer Systems

Learning Objectives

 


Resources

Task 1 - Managing Data presentation, including theory questions to be answered.

Task 2 - Practice task

Task 3 -  CPU presentation and video and notes and notes 2 and practice questions here

Task 4 - Khan academy Unit - How computers work the link is here

Exemplar report format from a B grade student here

Useful websites here and here

Extension

Python bitesize tutorials

or

W3Schools Python tutorials

or

Snakify Python tutorials 

Week 6 + 7 + 8 - Systems Analysis and Development - Computer Systems

Learning Objectives

Resources

Systems Analysis and Development presentation

Boot process note

Theory questions 

Systems Analysis Revision Sheet Click here 

Khan Academy login 

Week 9 + 10 + 11 - Managing Data - Spreadsheets

Learning Objectives


Resources

Spreadsheet level 2 for those who have not used them for a while here

Spreadsheet level 3 for those more confident here

Excel resource poster here

Excel revision to advanced resource here


Week 12 +13 +14 + 15 - Managing Data - Databases

Learning Objectives


Resources

Managing Data Database presentation here

SQL presentation here

Database web resource here

Database practice here

Database extension here

Database Video club practice instructions here and data here

Week 16 + 17 + 18 + 19 + 20 - Programming in Python

Learning Objectives

Learn to code in Python

Resources

Python bitesize tutorials

or

W3Schools Python tutorials

or

Snakify Python tutorials

or

Edabit Python tutorials

or

Grok Learning tutorials

or 

Codeacademy  here

or

Python Data Science here





Semester 2 -  Unit 2

Week 1 + 2 - Developing Software

Introduction

Learning Objectives


Resources

Presentation can be found here

Task: log into Khan Academy and complete the work assigned.

Beginner Python tutorial here

Intermediate Python tutorial here

Week 3 + 4 + 5 - Developing Software

Learning Objectives


Resources

Developing software 2 presentation here

Developing Software worksheet here 

Programming Challenges here

Week 6 + 7 + 8 + 9 + 10 + 11 - Programming 

Learning Objectives

Resources 

Programming presentation here

Work through this online tutorial to create your first game in python here

Week 12 +13 +14 - Networks and Communications 

Learning Objectives



Skills 


Resources

Networks presentation here

Networks presentation workbook here

Week 1 practice questions here

Watch Warriors on the net here

Cisco cyber security page here

Cisco Packet Tracer Labs

Lab 1:   Click here
Lab 2:   Click here
Lab 3:  Click here