Page 1000 - SUBSEC October 2017_Neat

SECTION 5: SPREADSHEETS (cont’d)

SPECIFIC OBJECTIVES CONTENT

Students should be able to:

8. perform charting operations; and, Select appropriate chart types: Column charts,
Bar charts, line graphs, pie charts.

Labelling charts: graph titles, labels on axes,
data labels.

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

Suggested Teaching and Learning Activities

To facilitate students’ attainment of the objectives of this Section, teachers/facilitators are encouraged
to engage students in the teaching and learning activities below.

1. Teachers should engage students in using feedback on class activities towards completing their
SBA.

2. Encourage students to complete exercises that use functions and formulas to effect a more
efficient and effective solution.

3. Demonstrate examples of locating text and data on a spreadsheet so that data is not lost if
rows or columns are inserted or deleted.

4. Encourage students to practise pasting versus moving various types of charts to a new sheet;
inserting titles and axes labels. Students should also practise pasting charts to a word-
processed document and adjusting the chart on the page.

5. Encourage students to practise entering test data for their programs to see the results and
reinforce these concepts from Sections 7 and 8.

CXC 30/G/SYLL 17 23