Gcse Ict Coursework Access



Information Communication Technology (ICT) is a core aspect of modern life. It underpins the way we work, keep in touch and relax. In addition, the digital technology industry sector now represents a significant sector of the local economy. The ICT department of Dominican College aims to provide pupils with the core competencies that are now essential to making your way in the modern world. At Key Stage 3 the pupils are allocated one period per week of ICT in Year 8 and two periods per week in Years 9 & 10. The aim of these lessons is to allow all pupils to learn the main skills that they will need to be able to use computer software effectively. At Key Stage 4 we follow CCEA’s full course GCSE in ICT and at Key Stage 5 we follow WJEC’s specification for GCE ICT. Every year some of our students embark on degree programmes in the increasingly popular areas of Computing and ICT.


Dominican College has 3 dedicated ICT rooms, each equipped with approximately 27 multimedia PCs which work as part of the C2K network. Every classroom in the school has an interactive whiteboard and staff and pupils also have access to a range of printers, scanners and assorted hardware and software. The school also has a dedicated Apple Mac network which comprises a Mac Server and 2 Apple Mac computer suites which are largely used by the Moving Image Arts, Media Studies and Music departments.

Departmental Staff

Mr Ciaran Lyons – Head of ICT
Ms Claire Culshaw – ICT Teacher

Celebrating Achievement

GCSE results: The following pupils achieved maximum uniform marks in the CCEA GCSE ICT examination in 2014: Sophie Hughes, Leah Taylor, Chloe Fitzgerald.
In the summer 2013 examination series, Emer Doherty achieved the highest mark recorded in CCEA’s A2 ICT exam

Examination Performance

GCSE - percentage & (pupils)

 Year A* A  B C D
 2014 24% (10) 54% (22) 12% (5) 10% (4) 0 (0)
 2013 13% (3) 35% (8) 39% (9) 13% (3) 0 (0)
 2012 0 (0) 76% (22) 17% (5) 7% (2) 0 (0)

A Level - percentage & (pupils)

 Year A* A  B C D E
 2014 43% (6) 29% (4) 29% (4)
 2013 11% (1) 22% (2) 33% (3) 22% (2) 11% (1)
 2012 7% (1) 29% (4) 21% (3) 29% (4) 7% (1) 7% (1)


 Year Topic 1 Topic 2 Topic 3 Topic 4 Topic 5 Topic 6
 8  MS Word (Word Processing)   MS PowerPoint  MS Excel (Basic Spreadsheets) The Internet Basic Programming
 9  MS Word MS Excel (Intermediate Spreadsheets)  Photoshop (Basic Image Manipulation)  Web Design MS Access (Basic Databases) HTML
 10  ICT Theory   MS Access (Intermediate Databases)  Photoshop (Intermediate Image Manipulation) MS Excel (Advanced Spreadsheets) Scratch Programming


View the embedded image gallery online at:


 Assessed by 3 Continuous Assessment Tasks in Year 11

(Databases, Spreadsheets & PowerPoints)

 Unit 1: Tools and Applications 

 Communications Software
Presentation Package
Information Handling Package
Spreadsheet Package

 Assessed by 2 Continuous Assessment Tasks in Year 12

(Web Design and Game Design)

 Unit 2: Using Multimedia and Games Technology

 Using Graphics
Using Digital Video and Sound
Games Technology
Using Multimedia Assets

 Studied in Year 11 & Year 12.

Assessed by examination at the end of Year 12

 Unit 3: Understanding ICT Systems…

 Knowledge of ICT Components
Data and Information
Digital Communication Methods
Applications of ICT


+-ASClick to collapse

+-A2Click to collapse

 AS IT1/3 - Theory  IT2/4 - Coursework 

 IT1: 60% exam

 IT2: 40% CW

 Data , information and knowledge

 The value and importance of information
 Quality of information
 Validation and verification
 Capabilities and limitations of ICT

Uses of ICT - Business

Computer based shopping systems

Uses of ICT - Education

Uses of computers for teaching and learning
School / college administration

Uses of ICT - Health

Scanning, life support
Medical databases
Expert systems

Uses of ICT - Home

Home on-line banking

 Presenting Information
 Human Computer Interface (HCI)
 Social Issues
 Database Systems


Spreadsheet features and functions
Methodology and Practice
Simulation modelling

 Solution to a problem involving three separate tasks

 Analysis of existing data processing activities
Desk top publishing
Automated documents
 Compression and storage techniques

 A2 IT1/3 - Theory  IT2/4 - Coursework 

 IT3: 60% exam

 IT4: 40% CW


Choosing a network for a company

Types of network available
Software components

The Internet

The impact of the Internet upon business
Connecting to the Internet
Moral, Social and Ethical Issues

 Human Computer Interface (HCI)

Working with ICT

Codes of conduct

 ICT Security Policies

Database systems

Distributed databases

 Management of change

 Management Information Systems

 System Development Life Cycle (SDLC)

 A database project based in an actual commercial context

User Requirements
Design specification
User documentation
Project planning

Extra-curricular Activities

The ICT Department runs an after school club which is open to all pupils studying ICT in the senior school. The ICT club is intended to introduce pupils to the more demanding aspects (yet fun!) aspects of computer programming which are not covered in normal ICT lessons. For this we are fortunate to have the use of 5 Raspberry Pi computers generously donated by iTeach. One of the main reasons for running the club is so that pupils who are considering a degree programme in Computing will have had the opportunity to investigate this area.


View the embedded image gallery online at:

What is a Database?

In this unit you will be using a piece of software called Access to create a database on your DVD collection. Students studying their GCSE ICT have to create a similar project using Access so you will be learning some advanced skills.

A database is a way of storing information about a specific topic on a computer. This means that all this information is very organised and can be searched through (or queried) very quickly.

Databases are everywhere, in shops, schools, businesses, governments. Somewhere there is a database with details about you stored on it. One of the biggest Databases in the country is held by the DVLA (Driver Vehicle License Agency) which stores the details of every car and person with a driving licence in the country. There are over 30 million cars in the UK, so this database needs to pretty big!

Click here for a PowerPoint explaining more about how Databases work.

Remember this key diagram. This is very important for any type of computer system.

Data and Information

One of the keys about databases is the difference between Data and Information. Information is data when has been Processed. So the diagram above would change to this

Click here for a PowerPoint on understanding the difference between Data and Information.

0 thoughts on “Gcse Ict Coursework Access”


Leave a Comment

Your email address will not be published. Required fields are marked *