Whitby Community College
Whitby Community College Faculties

ICT

AS/A2 ICT

Resources for AS and A2 ICT, including useful websites.

Exams

Past papers - Link to AQA past papers and mark schemes (Click here).

 

AS ICT

AS handbook

AS weekly plan

Essential websites

AS Intro activity

ICT Rules

Revision sessions

ICT1

10.1 - Knowledge, information & data

Knowledge, information & data

Police and accuracy of data

10.2 - Value & importance of information

Value and importance of information

10.3 - Control of information

Control of information

10.4 - Capabilities & limitations of ICT

10.5 - The social impact of ICT

The Digital Divide

Student presentations

Business 1

Business 2

Crime 1

Education 1

Education 2

Medicine 1

Medicine 2

Teleworking 1

Teleworking 2

10.6 - Role of communication systems

Communication systems

Revision tasks

Student presentations

Communication systems 1

10.7 - Information & the professional

10.8 - Information systems, malpractice & crime

10.9 - The legal framework

10.10 - Health & safety

Health & safety

ICT2

11.1 - Data capture

11.2 - Verification & validation

11.3 - Organisation of data for effective retrieval

11.4 - Software: Nature, capabilities & limitations

Data portability etc

Standards and protocols

11.5 - Manipulation and/or processing

11.6 - Dissemination/distribution

11.7 - Hardware: Nature, capabilities & limitations

Current hardware standards

11.8 - Security of data

11.9 - Network environments

Network tasks

Network design task

Student presentations

Network environments 1

Network environments 2

11.10 - Human/Computer interface

User interfaces

ICT3

AS project resources

Excel coursework

Excel practical skills checklist

Excel project checklist

General advice

Document analysis

Input, processing & output

Objectives & performance indicators

Spreadsheet design sheet

Macro design sheet (Spreadsheet / Word processing)

Word processing design sheet

User interface design sheet

Testing strategy

Case study template

Client satisfaction survey

Demonstration spreadsheets

Excel demo 1

Excel demo 2

Excel demo 3

 

A2 ICT

A2 handbook

A2 weekly plan

Essential websites

ICT4

13.1 - Organisational structure

Organisational structure

Diagram

Card sort

13.2 - Information systems & organisations

Information systems

Data mining

Systems Analysis Investigation
Agenda for initial meeting
Minutes sheet for team meetings
Summary of Registration methods
Electronic Attendance, Swipe cards

13.3 - Corporate information systems strategy

Corporate IS strategy 1

Corporate IS strategy 2

13.4 - Information & data

13.5 - The management of change

Management of change

13.6 - Legal aspects

13.7 - User support

Training

Training task

User support

13.8 - Project management & effective ICT teams

13.9 - Information & the professional

 

ICT5

14.1 - Policy and strategy issues

14.2 - Software

Software evaluation

14.3 - Database management concepts

Entity-Relationship diagrams

Features of Access

Features of Access - Test

Access - Switchboard references

Normalisation task

Activities

14.4 - Communication & information systems

14.5 - Networks

Network security

Standards and protocols

14.6 - Human/Computer interaction
14.7 - Human/Computer interface

14.8 - Software development

14.9 - Software reliability

14.10 - Portability of data

 

ICT6

A2 coursework resources

Access coursework

Document analysis

Objectives & performance indicators

Testing strategy

Database design sheets

Macro design sheet (Database)

Word processing design sheet

Case study template

Client satisfaction survey

Access skills test

Access skills test - Teacher mark sheet

Exemplar material

Data Flow Diagrams Example  (Answer)

 

Websites

AQA (exam board)

BBC education

Becta ICT in education

King James School revision notes

Puma glossary

Puma ICT in society

The British Computer Society

Fatmax revision

HCI resource