Computer Science
Unit 1 and Unit 2
Semester 1 - Unit 1
Week 1 - Managing data - Word Processing
Introduction to course
Learning expectations
Course outline
Assessment Outline
Classroom rules
Set up computers
Learning Objectives
data management techniques for personal computer use, including hierarchical storage of data using files and folders
issues related to ethics in the storage of personal data
features of word processing software, including common formatting functions
Systems analysis and development
types of computer systems, including:
mobile
desktop
server
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
functions of computer hardware components, including:
input
keyboard
mouse
microphone
digital camera/web cam
scanner
processing
central processing unit (CPU)
control unit (CU)
arithmetic logic unit (ALU)
registers
primary storage
random access memory (RAM)
read only memory (ROM)
secondary storage
mechanical drive
solid state drive
online
output
monitor
printer
speaker/headphones
how user wants influence the choice, use and creation of personal computer systems
connect peripheral devices to a computer system using:
ports
universal serial bus (USB)
Firewire
PS2
ethernet
serial
install simple software
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
Extension
Python bitesize tutorials
or
W3Schools Python tutorials
or
Snakify Python tutorials
Week 6 + 7 + 8 - Systems Analysis and Development - Computer Systems
Learning Objectives
the role of an operating system
types of hardware booting processes
cold
warm
types of basic maintenance strategies and computer protection software, including:
defragmentation
error check
disk clean
back up
anti-malware
basic maintenance strategies and techniques to rectify simple computer difficulties, including:
diagnosis of fault
implementation of a solution
description of process
purpose of the systems development life cycle (SDLC)
flow of data through an information system
input
processing
storage
output
stages of the SDLC
preliminary analysis
analysis
design
development
implementation
evaluation and maintenance
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
features of spreadsheet software, including:
simple functions (sum, average, min
and max)
simple formulae (addition, subtraction,
multiplication and division
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
features of database software, including:
components of a single table database (field, record, file)
data entry forms
simple search techniques
create a simple query
simple data types (number, text, Boolean, date, currency)
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
Semester 2 - Unit 2
Week 1 + 2 - Developing Software
Introduction
overview of Unit 2
review of Unit 1
Learning Objectives
hardware and software systems used in personal computing (applications, operating systems)
the roles of hardware, software and the user in a computer system
interrelationship between users, hardware and software in a personal computer system
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
the purpose of the software development cycle (SDC)
stages of the SDC
state the problem
plan and design
develop the solution
test the solution
evaluate the solution
requirements for software licensing, including:
single user
site licence
ethical and legal issues associated with software, including:
copyright
piracy
comparison of website construction tools
Resources
Developing software 2 presentation here
Developing Software worksheet here
Programming Challenges here
Week 6 + 7 + 8 + 9 + 10 + 11 - Programming
Learning Objectives
the components of a computer program
inputs
processing
outputs
control structures
sequence
selection
iteration
the concepts of variables and data types, including:
integer
real
character
string
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
key concepts, terminology and functions of common network components
data transmission rates
megabits per second (Mbps)
gigabits per second (Gbps)
wired data transmission media
twisted pair
fibre optic
wireless transmission
hardware components required for a personal area network (PAN) or home network, including:
modem
router
wireless access point
firewall
types of communication software, including:
browser
email
web authoring
scripting
software requirements for a PAN or home network, including:
browser
plugin
internet connectivity software
effect of bandwidth availability on network functionality
features of a network, including the ability to share:
files
peripheral devices
an internet connection
storage devices
the role of an internet service provider in a PAN or home network
concept of internet protocols, including:
hypertext transfer protocol (HTTP)
hypertext transfer protocol secure (HTTPS)
file transfer protocol (FTP)
methods to ensure reliability of internet data for personal use
measures an individual can take to help maintain data privacy and security
the role of users in maintaining the security of information transmitted through communication systems
Skills
connect common peripheral devices
create and administer a simple peer-to-peer network to:
share files
share peripheral devices (printer, scanner)
share internet connection
use Bluetooth to create a simple personal network
use communication software to upload files to a web server
analyse the suitability of a PAN or a home network solution
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