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 

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 

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

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

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 

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 

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

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 

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

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

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

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 

  1. • use pseudocode to represent a programming solution  

     • create flow charts to represent a programming solution 

Resources

Google online course here

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

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

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