Please note: the material on this site is not endorsed by OCR.

Please refer to the syllabus to ensure that you are covering all of the necessary theory.

AS Unit G061: Information, Systems and Applications











Data, information and knowledge










data, information and knowledge

methods used to convey information

types of data

sources of data

static and dynamic data

quality of information

coding data

validation and verification

back-up and archive

cost of information

input-process-output-feedback loop







Software and hardware components of an information system






a. difference between hardware and software

b. input devices

b. output devices

b. storage devices

c. specialist hardware devices

d. specialist software devices

e. types of software

f. user interfaces








Characteristics of standard applications software and application areas







types of software used for basic tasks

characteristics of applications

wizards, style, templates and macros

design considerations for tailored data entry screens

buttons, form controls, menus, templates

house style

master documents, slides, styles for house style

transfer of data between applications

needs of different users





Spreadsheet concepts




financial modelling

object modelling

variables, formulae, functions and rules

worksheets, workbooks, rows, columns, cells, ranges

absolute and relative referencing









Relational database concepts







database terminology

database notation

attributes, entites and E-R diagrams

advantages and disadvantages of normalisation

characteristics of first, second and third normal form

data dictionary

select data types


setting up a database - practical task








Applications software used for presentation and communication of data







characteristics of documents

mail merge

reformatting documents to meet the needs of an application

clip art and thumbnail images

vector and bitmap graphics

graphic libraries

features of presentation software

OHPs vs electronic presentations

Modes of navigation

Linear, non-linear and hierarchical presentations








The role and impact of ICT







impact of ICT

Capabilities and limitations of ICT

future developments of ICT

legal aspects of ICT - Data Protection Act (1998)

legal aspects of ICT - Computer Misuse Act (1990)

legal aspects of ICT - Copyright, Designs and Patents Act (1988)

legal aspects of ICT - Regulation of Investigatory Powers Act (2000)

legal aspects of ICT - Electronic Communications Act (2000)

legal aspects of ICT - Freedom of Information Act (2000)

combating ICT crime and protecting ICT systems

networking computers

standards in ICT

health and safety