CCEA EXEMPLIFYING EXAMINATION PERFORMANCE

A computer system stores data in:

• Analogue format

• Digital format

• Information format

• Doubled format

MPEG stands for:

• A. Moving Photographic Experts Group

• B. Moving Picture Experts Group

• C. Moving Pixel Experts Group

• D. Moving Portable Experts Group

Select the list which contains only image file formats: [1]

• A. PNG, GIF, MIDI, PDF

• B. TIFF, PNG, GIF, JPEG

• C. GIF, PNG, PDF, CSV

• D. JPEG, TIFF, PNG, PDF

Select the correct name of the legislation which protects the rights of customers when shopping online.

• Customer Card Regulations

• Consumer Card Regulations

• Customer Contracts Regulations

• Consumer Contracts Regulations

Select the statement which is correct about the Data Protection Act.

• The Data Protection Act protects the rights of individuals whose data is being stored and their data can be shared with any organisation who requests it.

• The Data Protection Act protects the rights of organisations storing data so that they can make full use of the data.

• The Data Protection Act protects the rights of organisations storing data and prevents them from sharing data with other organisations who request it.

• The Data Protection Act protects the rights of individuals whose data is being stored and ensures their data is accurate and up to date.

Select the list which correctly details only methods which will help reduce eye strain in computer users.

• Anti-glare screens, regular breaks, ergonomic mice and keyboards

• Ergonomic mice and keyboards, regular free eye tests, screens with adjustable brightness and contrast

• Appropriate lighting, swivel screens, regular free eye tests

• Appropriate lighting, anti-glare screens, screens with adjustable brightness and contrast

Many electronic devices now use GPS. What do the letters GPS stand for?

• Global Placement System

• Geographical Positioning System

• Global Positioning System

• Geographical Placement System

Select the correct meaning for the term VLookup, which is used with spreadsheet applications.

• Value Lookup

• Vertical Lookup

• Variable Lookup

• Valid Lookup

Conditional formatting can be used in spreadsheets. Identify the statement that is not true about conditional formatting when it is applied within a spreadsheet.

• It can be used to change the cell colour if a specified condition is met.

• If a condition is not met nothing will happen to the appearance of the cell.

• It can be used to change the formula in a cell if a condition is met.

• It can be applied to more than one cell at a time.

Select the statement which correctly describes bit rate when representing sounds.

• A. The bit rate is the number of bits used to store each sound sample.

• B. The bit rate is the speed at which the sound has been recorded.

• C. The bit rate is the amount of data, measured in bits, that is processed in a given amount of time.

• D. The bit rate is the number of audio sound samples captured every second.