ICT

GCSE ICT (AQA B)

Overview

Course overview

Literacy

ICT Keywords - spelling

Transfer resources

Transfer activities   ICT Rules Computer Checker - Level 3 Computer Checker - Level 2 Level 2 data sheet (password - see teacher) Computer Checker - Level 1 Level 1 spreadsheet Computer Checker - Teacher demo (password) Transfer unit mark sheet Transfer unit objectives and outcomes Transfer unit formulae VBA extension work

Essential skills and consolidation of learning from Key Stage 3 Social effects of ICT presentation Word skills test Health and safety Health and safety - Agony aunt Spreadsheets Spreadsheet formulae Good practice guide Readability statistics Poor presentation Practical skills analysis activity Think Pair Share activity True or False?

Case studies

Using ICT for payroll in a small business Payroll task assessment sheet Payroll task Wages template Formulae help sheet Hardware

ICT in a supermarket Supermarket assessment sheet Tesco case study Tesco case study (Short version) Database extension task Databases concept map Stock control database project Access - Help on types of queries

ICT in a library Library assessment sheet Library assessment sheet (updated version) Library terminology activity Data Flow Diagrams 1 Data Flow Diagrams 2  (Answer) Data Flow Diagrams 3   (Answer) Data Flow Diagrams 4 (Sorting exercise) Networks and the Internet 1 Networks and the Internet 2  (Answer) Networks and the Internet 3 Networks terminology activity ICT in Education

ICT in E-Commerce Amazon case study Amazon case study - Updated version Security of data / Computers and the Law

ICT in weather forecasting Data logging and control assessment sheet Weather forecasting activities Base camp weather station activities

ICT in traffic management Control systems and data logging Flowchart - possible solution ICT and Traffic management Programming in VBA Programming in VBA - Assessment

Further applications of ICT Further applications of ICT template Systems software ICT and the law activity Downloads list

Coursework resources

Communication and data handling Coursework guide - New version Coursework guide - New version (Basic tasks) Assessment sheet Coursework report College Library research sheet Document analysis template Analysis help Specification help Implementation help Validation help Coursework prompts Checklist

Modelling, measurement and control Coursework guide - New version Assessment sheet Coursework report Spreadsheet formulae to learn Example of a modelling spreadsheet Analysing functions of the modelling spreadsheet Document analysis template

Extra help Analysis - Writing about processes Specification 1 Coursework target sheet

Design sheets to printout Database Database design (Table design) Forms - Ideas Forms - Final Queries Reports   Spreadsheet Spreadsheet design   Presentation / Website Presentation - Thumbnail sketches Presentation / Website - Final   Word processing / DTP Designing leaflets etc Page design - Ideas (A4, A5 etc) Page design - Final Business card With Compliments slip Traceable leaflet templates

Revision

Revision resources Yr10 revision list Yr11 revision list Test Revision quizzes Revision starter Warm up session activity sheet

 

Websites

AQA (exam board)

BBC education

Becta ICT in education

Computeractive magazine

ICT GCSE

Puma glossary

Puma ICT in society

Revision notes

Revision quizzes

Webopedia (Online dictionary)