Gcse Ict Coursework Access

ICT


Welcome

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.


Equipment

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)

KS3

 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:
https://www.dominicancollege.org.uk/departments/ict#sigFreeId9781d8a26d

KS4

 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


KS5

+-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

CAD/CAM
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

Entertainment
Home on-line banking


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


Modelling

Spreadsheet features and functions
Methodology and Practice
Simulation modelling

 Solution to a problem involving three separate tasks

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

 A2 IT1/3 - Theory  IT2/4 - Coursework 

 IT3: 60% exam

 IT4: 40% CW

Networks

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

Telecommuting
Codes of conduct

 ICT Security Policies


Database systems

Databases
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
Implementation
Testing
User documentation
Evaluation
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:
https://www.dominicancollege.org.uk/departments/ict#sigFreeId737ae24f01


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 *