The aim of the S1 to S3 BGE ICT/Computing Science course is to help students enjoy developing their skills and understanding as they experience the computing science and digital literacy concepts contained in the technologies area of the Curriculum of Excellence. This course will not only help students excel at applying their computing science knowledge and digital literacy skills, but will also assist in their progress in literacy, numeracy career education and health and wellbeing outcomes as well as developing those much needed soft skills in areas such as, presentation, graphics and searching the WWW.

 

S1

Introductory unit

• Introduction to school network
• Using Windows Operating System
• Email
• Keyboarding

Computer Systems Unit

1. Binary
2. CPU and Main Memory
3. Backing Storage Devices
4. Input and Output Devices
5. Networks
6. Computer Systems assessment

Staying Safe Online

1. Personal Data and Privacy
2. The Internet of Things
3. Hacking and DoS attacks
4. Malware and Phishing
5. Protecting Computer Systems
6. Real-World examples of Cybercrime
7. Searching the Web
8. SSO assessment

 

S2

Game creation using Scratch

1. Introduction to Scratch
2. Events in Scratch
3. Using Variables
4. Using Constructs
5. Parallel Processes
6. Parameters
7. Practical challenges

Databases

1. What is a Database?
2. Real-World case study
3. Designing a Database
4. Creating a Database in MS-Access
5. Adding images to a Database
6. Validation
7. Database creation challenges
8. Searching a Database
9. Sorting Database
10. Complex queries
11. Practical challenges
12. Practice questions

Spreadsheets

1. What is a Spreadsheet?
2. Real-World case study
3. Designing a Spreadsheet
4. Creating a Spreadsheet in MS-Excel
5. Creating simple formula
6. Using Absolute and Relative cell references
7. Spreadsheet challenges
8. Using functions
9. Function challenges
10. Practical challenges

 

S3

Coding basics using Scratch

1. Calculations
2. Solving problems with fixed loops
3. Solving problems with conditional statements
4. Solving problems with conditional loops
5. Practical challenges
6. Practical questions

Text-based coding using Python 1

1. Input and Output
2. Conditional statements
3. Fixed loops
4. Conditional loops
5. The software development process
6. Design techniques
7. Practical challenges
8. Practical questions

Web design

1. Introduction to Web Design
2. Designing a Website
3. Basic Structure of a Web Page
4. Hyperlinks and the Anchor Tag
5. Embedding Media
6. CSS: styling other elements
7. CSS: styling text
8. JavaScript events
9. Practical challenges
10. Practical questions

Text-based coding using Python 2

1. Simple calculations
2. Simple string functions
3. Simple mathematical functions
4. Programming challenges