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
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
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
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
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
Communication systems
Revision tasks
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
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
Network tasks
Network design task
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
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
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)
A2 handbook
A2 weekly plan
ICT4
13.1 - Organisational structure
Organisational structure Diagram Card sort
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
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
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
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
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
Network security
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
Access coursework
Database design sheets
Macro design sheet (Database)
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
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