This is a full list of all the sections you will need to cover for the exam.  I am adding explanations over the next week but you will find more information in your books as well as BBC Bite size website.  Please refer to this website whilst I am updating this page http://www.bbc.co.uk/education/subjects/zqmtsbk

 

Hardware


– Input, output, processing & storage

Most common manual input devices are the keyboard and mouse.
Automatic input devices include sensors, bar code reader & optical mark reader
Most important piece of hardware is The CPU (Central Processing Unit) is the part of a computer system that is commonly referred to as the “brains” of a computer. The CPU is also known as the processor or microprocessor.

Common output formats are printed paper, sound, video and on-screen documents.
Other output devices include speakers, projectors, buzzers, switched outputs & lights

– Types of a computer
Supercomputers (powerful mainframe computer)
Mainframes (large high-speed computer, especially one supporting numerous workstations or peripherals.)
PCs, Laptops, Notebooks, Tablets, Embedded computers

– Processors
A microchip  that has memory and other components built in.   It accepts input data.  Important feature is speed.

Backing up storage
– Storage devices & media
You need to store data even after the computer is switched off.  Whilst it is running data is kept in the memory but when off you need backage storage.

Memory

RAM – Can be written to a to, read from and edited. Volatile
ROM – Data can not be changed. Necessary for the operation of the computer. Non volatile

Software

Software refers to the programs that we run on our computer systems.
Types of software (There are 2 types: Systems software & Application software)

Systems Software (Operating system, user interface, utility programs, drivers)
Application Software (Microsoft office, Photoshop)

Data input & output

Garbage In, Garbage Out (GIGO)
– Inputs
Data capture is colllecting data for input to a computer i.e Forms
– Outputs
Output depends on how accurate the input is.

Applications & effects
– A typical day
Think about electronics now available in a household, traveling, work, school, banking, hospital equipment…..
– Payrolls  (Payrolls are used to manage wages and salaries of the
employees.) Now the most common commercial application of ICT is payroll processing. Employees data, clock in and out times all stored digitally.
– Online booking systems
– Banking (ATMs – online banking)
– Engineering & Manufacturing (CAD – computer aided design.  CAM – Computer aided manufacture)
– Logistics (Used to plan, implement and control the effective delivery and storage of goods and services.)
– Education (Help students learn & management of the institution. VLE – Virtual learning environments)
– The Law (ICT systems are an important tool for law enforcement.  National databases to hold info on criminals.)
– Healthcare & medicine
– Libraries
– Entertainment & Leisure activities
– Security

Data Protection Act

It first became a law in 1984 but was then updated in 1988.

It sets out the rules for collecting, storing and dealing with personal information.


Communications, networks & internet
– LANS
– WANs
– The Internet
– Connecting to the Internet
– World Wide Web
– VPNs

Word processing & desktop publishing
– Word Processing
– General formating
– Page setup
– Columns / Templates
– Mail merge
– Graphics
– Drawing tools
– DTP

 

Spreadsheet & modelling
– Spreadsheet software
– Concepts
– Merging
– Formulae
– Cells
– Formating
– Graphs & charts
– IF Function
– Macros


Databases
– Database software
– Creating database
– Tables
– Primary keys
– Data entry
– Queries
– Reports

Graphics, video & audio editing software
– Graphics software
– Video editing software
– Audio editing software

 

Presentation software
– Slides
– Animation
– Charts
– Themes
– Links

Web authoring
– Publishing a website
– Web authoring software
– Images/ text/ links
– Styles (CSS)