Computer Science 

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 

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

Useful websites here and here

Extension

Python bitesize tutorials

or

W3Schools Python tutorials

or

Snakify Python tutorials 

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 

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

Week 9
Spreadsheet level 3 for those more confident here

Conditional Formatting - Here is a brief overview: Click here
Here are two tasks that include downloadable links: Click here
Activities 1-5 Creating Formulas Activities 

Week 10

Activities 6-10 Creating Formulas Activities 

Excel resource poster here

Excel revision to advanced resource here

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

Book Borrowing Database. Instructions:  Here   dataset:  Here 

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

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

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

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

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