Computer Science 

Unit 3 and Unit 4

Semester 1 - Unit 3

Week 1 - Systems Analysis and Development - Project Management

Introduction to course


Topic  - Systems Analysis and Development

Learning Objectives

The concept of project management 

Types of system development methodologies

Resources

Systems Analysis and Development presentation 

Systems Analysis and Development notes_1 and notes_2  

Systems Analysis and Development  Questions 1  and  Questions 2 


Revision

Watch this first video https://www.youtube.com/watch?v=FlfChYGv3Z4&feature=emb_logo 

Watch the second video https://www.youtube.com/watch?v=fjMU-km-Cso&feature=emb_logo 


Extension

Python bitesize tutorials

or

W3Schools Python tutorials

or

Snakify Python tutorials 

Week 2 + 3 - Systems Analysis and Development - SDLC

Learning Objectives

Stages of systems development life cycle (SDLC)

Systems development documentation as a part of the SDLC

Resources

Systems Analysis and Development presentation 

Yourdon website link 

Yourdon website notes 

Computing Teacher website link 

Systems Analysis and Development -  context diagram notes

Systems Analysis and Development - context diagram practice questions with answers  Practice questions 


Extension

Python bitesize tutorials

or

W3Schools Python tutorials

or

Snakify Python tutorials 

Week 4 + 5 - Systems Analysis and Development - Hardware/Software

Learning Objectives


Resources

Storage and Storage Capacities Click here  worksheet: Storage worksheet 

Input Process Output and Storage Presentation worksheet: questions 

Systems Analysis and Development part 2 presentation 

Systems Analysis and Development part 2 notes and questions

Useful websites here and here

Create your own presentation highlighting the latest in computing technology, i.e compare the latest cpu , the fastest SDD and the coolest motherboard. 


Extension

Python bitesize tutorials

or

W3Schools Python tutorials

or

Snakify Python tutorials 

Exemplar report format from a B grade student here

Week 5 + 6 + 7 - Managing Data - Spreadsheet

Learning Objectives



Resources

Worksheets for practising the topics above can be found below

CountIF practice tasks here

Lookup practice tasks here

Additional excel activities here


Extension

Python bitesize tutorials

or

W3Schools Python tutorials

or

Snakify Python tutorials 

Week 8 +9 + 10  - Managing Data - Database

Learning Objectives


Resources

Presentation for Managing data can be found here

Tutorial website Quackit here

Additional Task Resources here 

SQL tasks here and questions here

Extension

Python bitesize tutorials

or

W3Schools Python tutorials

or

Snakify Python tutorials 

Week 11- 13 - External Set Task Prep and Task

Assessment -Task - External Set Task or EST

EST Prep
Storage and Storage Capacities Click here  worksheet: Storage worksheet 


2023 EST can be found here

2022 EST can be found here

2021 EST can be found here     

2020 EST can be found here

2019 EST can be found here

2018 EST can be found here

2017 EST can be found here

2016 EST can be found here

Week 14 + 15  - Managing Data - Database

Learning Objectives


Resources 


Practice Database practical task here video club excel here


Task 4  and exam break are included 

Week 16 + 17 - Developing Software

Learning Objectives 

Resources 


Developing software presentation here

Notes and Questions here


Extension - Cybersecurity


Follow the link to complete the Saburra capture the flag website here


Week 18 - Developing Software

Learning Objectives 




Resources

Developing software presentation here

Visit BBC Bitesize to learn more here

Design a GUI in Python here


Extension -  Cybersecurity 

Visit the CyberStart website, create an account here

Week 19 + 20 - Programming Practice

Use this time to catch up on any missed assessments, then practice your programming in Python.


Resources

Python bitesize tutorials

or

W3Schools Python tutorials

or

Snakify Python tutorials

or

Edabit Python tutorials

or

Grass hopper here

Semester 2 - Unit 4

Week 1 + 2 - Programming Theory

Course review 


Learning Objectives

 


Resources

Google online course here


Week 3 + 4 + 5 + 6 - Programming Practical

Learning Objectives

Resources

Create Python games here


Week 7 - Networks and Communications

Topic - Networks and communications

Learning Objectives

Resources

Networking Presentation part 1 here

Networking Presentation part 2 here 

Networking  worksheet here

CISCO packet tracing course here


Week 8 - Networks and Communications

Topic  - Networks and communications 

Learning Objectives


Resources

CISCO packet tracing course here

Networking Presentation part 3 here