Information Technology Exam guide Unit 7: Spreadsheets


CXC Information Technology Guide: Unit 7

INFORMATION TECHNOLOGY EXAM GUIDE

UNIT 7: SPREADSHEETS

GENERAL OBJECTIVE:

On completion of this Section, students should develop expertise in the use of a spreadsheet package in the development of computer applications.

SPECIFIC OBJECTIVES:

The student should be able to:

CONTENT
1.

Explain the purpose of a spreadsheet;

Definition of spreadsheet: a spreadsheet is a table consisting of cells (rows, column locations) that hold accounting or financial
data and simulates the traditional physical spreadsheet;

it captures displays and manipulates data.

2.

Use appropriate terminology and notions commonly associated with spreadsheets;

Row, column, cell, cell address, label, value, formula, function,
worksheet, template, range, title, window, record.

3.

Select basic pre-defined systems functions;

Including sum, average, date, maximum, minimum, count, if, vlookup, rank
4. Create advanced arithmetic formulae;

Formulae involving addition, subtraction; multiplication;
division; powers; square roots, the use of brackets.

5.

Explain the use of common features of spreadsheet software;

Row/column title locking,

relative addressing,

absolute addressing.

6.

Invoke row and column title locking;

Horizontal, vertical, both.

7.

Replicate (copy) formulae into other cells;

Relative versus absolute addressing.

8.

Manipulate data on a spreadsheet;

Effects of move, copy, delete operations on formulae.
9.

Manipulate columns and rows;

Insert and delete columns and rows.

10.

Format a spreadsheet;

Numeric data formatting,

text formatting,

alignment, borders.

11.

Sort a spreadsheet;

Primary field,

secondary field,

ascending vs. descending order.

12.

Find a record matching a given criterion;

Simple criterion, complex criterion, record - find command.
13. Perform charting operations; Bar charts, line graphs, pie charts, graph titles, labels on axes.
14.

Select appropriate graphical representation of data;

15. Manipulate multiple worksheets;

Use of two or more worksheets to solve problems involving some
or all of the functions and operations listed above.

16. Import files. Graphics, tables.


Fivestar

guest-m young (not verified) 8 June 2009 - 10:32pm

I'm the parent of a 3rd former who has to do Information Technology-technical (Computer Studies CVQ) in the grouping he's chosen. After getting this wealth of information my son and I will be better prepared for the two years ahead.

PS I've been looking for Computer Studies (CVQ). I did'nt know there was two types of Info Tech.

Hi,

Yes, there are two types. This exam guide is specifically for the CXC CSEC Information Technology exam. I am not sure if the CVQ Information Technology exam has the same requirements. Your local MOE mignt be able to give you more information on that or the www.cxc.org website.

I am glad that the help here is useful to you and your son.

Add new comment

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.

Image CAPTCHA
Enter the characters shown in the image.