Computer Science
Unit 3 and Unit 4
Semester 1 - Unit 3
Week 1 - Systems Analysis and Development - Project Management
Introduction to course
Learning expectations
Course outline
Assessment Outline
Classroom rules
Set up computers
Topic - Systems Analysis and Development
Learning Objectives
The concept of project management
Planning
Scheduling
Budgeting
Tracking
Types of system development methodologies
Prototyping
Systems development life cycle (SDLC)
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)
preliminary analysis
analysis
design
development
implementation
evaluation and maintenance
Systems development documentation as a part of the SDLC
context diagrams using Yourdon/Demarco notation
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
computer system hardware and software
the concept of boot process
storage capacities, including:
bit
byte
kilobyte
megabyte
gigabyte
terabyte
appropriate hardware components for a computer system designed for a specific purpose, including:
input
output
processing
storage (primary and secondary)
the role of the standard operating environment (SOE)
functions of the components of the central processing unit (CPU)
arithmetic logic unit (ALU)
control unit (CU)
registers
program counter
system clock
the concept of the fetch-execute cycle
troubleshooting strategies, including:
diagnosis of fault
implement a solution
document troubleshoot procedure
appropriate physical preventative maintenance measures
the purpose of an ICT code of conduct
ethics in the development and use of ICT systems
privacy considerations in the development and use of ICT systems
digital communications etiquette when using ICT system
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
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
spreadsheet terms, including:
cell
formula
function (sum, average, max, min, count, countif)
label
worksheet
lookup tables (hlookup, vlookup)
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
hierarchical structure of data
character/byte
field
record
table/relation
data protection methods, including:
encryption
authentication
passwords
biometric
digital signature
data types, including:
number
date/time
currency
text (string)
Boolean (true/false)
database terms, including:
data, field and record
data integrity
data redundancy
ethical and legal issues relating to the personal use and storage of data
legal requirements and implication of information kept by various organisations about individuals
issues related to use of online databases
design considerations for visual interfaces and navigation systems within database systems
the purpose of database documentation for the user
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
create a working single table database which includes:
data types
primary keys
forms
reports
queries
create a visual interface for users of a database
create database documentation
Resources
Practice Database practical task here video club excel here
Task 4 and exam break are included
Week 16 + 17 - Developing Software
Learning Objectives
purpose and function of software to operate a computer system
operating systems
utility software, including:
file compression
defragmenter
anti-virus
anti-malware
application software
requirements for software licensing, including:
freeware
open source
shareware
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
stages of the software development cycle (SDC)
state the problem
plan and design
develop the solution
test the solution
evaluate the solution
factors affecting the development of software, including:
user needs
user interface
apply software development requirements, including:
user needs
user interface
apply the SDC to create a digital solution
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
Semester 2 - Unit 4
Week 1 + 2 - Programming Theory
Course review
review of Semester 1
assessment requirements
overview of Semester 2
Learning Objectives
characteristics of data types, including:
integer
real (floating point number)
Boolean
character
naming conventions for variables
types of code, including:
source
executable
types of control structures, including:
sequence
selection
one-way (if then)
two-way (if then else)
multi-way (nested if)
iteration
test first (while)
test last (repeat until)
fixed (for)
types of program or code errors, including:
syntax errors
run-time errors
logical errors
the concept of data validation, including:
test data
trace table
modelling of an algorithm to test for logic using flow charts
use pseudocode to represent a programming solution
create flow charts to represent a programming solution
Resources
Google online course here
Week 3 + 4 + 5 + 6 - Programming Practical
Learning Objectives
apply, using pseudocode and a programming language, the following programming concepts:
constants
variables
apply, using pseudocode and a programming language, the following control structures:
sequence
selection
iteration
apply, using pseudocode and a programming language, the following techniques:
develop internal and external documentation
select and apply suitable test data for checking the solution
use trace tables to test for and debug logic errors
apply the SDC to create a digital solution
Resources
Create Python games here
Week 7 - Networks and Communications
Topic - Networks and communications
Learning Objectives
functions of the following computer hardware components required for networks
router
switch
firewall
modem
network interface card (NIC)
wireless access point
bridge
communication terms, including:
protocols
digital
analogue
Ethernet
types of communication networks
personal area network (PAN)
local area network (LAN)
wide area network (WAN)
technologies appropriate for the implementation of a client/server and peer-to-peer network
star network topology
diagrammatic representation of network topologies for PAN, LAN and WAN
characteristics of transmission media, including:
twisted pair
fibre optic
satellite
cellular
wireless
create network diagrams using CISCO network diagram conventions to represent network topologies for PAN and LAN
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
types of communication protocols, including:
post office protocol 3 (POP3)
internet message access protocol (IMAP)
simple mail transfer protocol (SMTP)
wireless access protocol (WAP)
methods used to ensure security of information over the internet, including:
authentication
encryption
firewalls
types of malware, including:
viruses
worms
trojans
spyware
Resources
CISCO packet tracing course here
Networking Presentation part 3 here