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.


3
Average: 3 (3 votes)
Your rating: None
guest-m young's picture
guest-m young (not verified)
Information Techology-technical aka Computer Studies (CVQ)

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.

Kathy-ann Daniel's picture
Kathy-ann Daniel
Offline
Joined: 24 Aug 2007
Re: 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.

Kathy-ann Daniel-Gittens

guest-m young's picture
Shanika (not verified)
Information Technology

Information
Technology lookin easy

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
4 + 14 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.