S3 Computing Science
Course Overview
Our S3 course follows the level 4 Experiences and Outcomes outlined in A Curriculum for Excellence – Technologies Curriculum Area.
Computers play an important part in today’s society. It is important to be aware of their effects at work, in the home and in our leisure time and to be able to adapt to the inevitable new developments in technology.
The course aims to develop skills and confidence in a range of software which will be beneficial to pupils now and on leaving school.
The course contains 4 main units:
Databases
This unit allows pupils to develop knowledge and an understanding of how a database can be used to solve problems.
Pupils will create databases using the software FileMaker Pro. They will learn how to
- create fields of the correct data type and populate these fields with data.
- search a database file given search criteria and sort records given the desired order.
- create reports so that the layout of the resulting records are shown in an attractive format.
p
Web Design
This unit allows pupils to develop knowledge and an understanding of the components needed to create a web page.
Pupils will create their own web pages using the programming languages HTML and Javascript.
Pupils will learn to
- write in programming code to place text, audio and graphics onto a web page.
- created coded hyperlinks to link the pages together.
p
Software Development and Design
This unit allows pupils to develop knowledge and an understanding of the programming concepts needed to create effective programs.
Pupils will create their own code using a programming languages called Livecode.
Pupils will learn
- to create their own programs using the software Livecode.
- the difference between variables and values.
- how to code decision making conditions and use repetition code to create useful programs.
p
Computer Systems
This unit covers:
- the choices of hardware and software that is now available and how it can be used in a range of commercial situations and in the home.
- The legal social and environmental issues of using computers
- The security issues that computer users need to be aware of to keep themselves and their information safe.
- networks, looking at the uses of networks within a business and the wider uses of the internet
p
Methodology
Teacher-led discussion, cooperative group work and formative assessment strategies are used to give pupils the opportunity to demonstrate and improve their knowledge, practical skills and skills for learning, life and work.
Assessment
Pupils undertake an online test at the end of the following topics/units:
Unit 2 –Types of Computer & Data representation WB 30th Sept
Unit 3 – Databases WB 18th Nov
Unit 4 – Networks and Security WB 20th Jan
Unit 5 – Web Design WB 30th March
Unit 6 – Software Development and Design WB 11th May
There will be a written Mid Term Test in December and a written S3 Full Test in May.
Practical work will be assessed throughout the year by the class teacher.
Recording & Reporting
The written tests and practical assessments form the basis for the comments in the pupil report issued to parents in January. These results are also used to inform decisions about likely progression in S4, when pupils who choose to remain in the Computing Department will study Computing Science at either National 4 or National 5 Levels.
Miss Stalker CL .. Mr Lodge
June – Sept
- Types of Computers
- Data representation
- Test WB 30th Sept
September – November
- Operating Systems and Applications
- Database
- The General Data Protection Regulation
- Test WB 18th Nov
Jan
- Networks
- Security risks
- Security precautions
- S3 Mid Term Test
January – March
- Websites
- Media Types
- Copyright, Design and Patents Act
- HTML and JavaScript
- Test WB 30TH March
April
- Environmental impact
April – May
- The Software Development Process
- Programming
- S3 Full Test WB 11th May
Resources
Useful websites
Computing Systems
Security risks and precautions
Legal implications
Copyright, Design and Patents Act
Practical Revision:
Software Design and Development
Download Python for free
Python programming booklet – helpful to work on if you want to take National 5 Computing
HTML
Extra Curricular : IDEA Award – we are encouraging all students to get their bronze award – click this link to get logged in.