Timing and resources
Time: 3 weeks
Syllabus: pages 18–25 Section 8.2
Software/course specifications: pages 12–13, 15
Texts: Heinemann IPT Prelim—G. K. Powers (chapter 7)
P1.1Describes the nature of information processes and information technology
P5.1Selects and ethically uses computer based and non-computer based resources and tools to process information
P6.1Analyses and describes an identified need
P6.2Generates ideas, considers alternatives and develops solutions for a defined need
Students learn to:
(a)Define a spreadsheet and describe its uses.
(b)Describe the advantages of electronic spreadsheets over manual methods.
(c)Organise data into rows and columns for entry into a spreadsheet.
(d)Explain the meaning of cell, cell reference and selected cell.
(e)Understand and distinguish between the three main types of data—label, value and formula.
(f)Recognise features of the spreadsheet program—formula bar, status bar, scrolling.
(g)Create a spreadsheet by entering labels, values and formulas into a cell.
(h)Edit data in a cell by inserting and deleting.
(i)Move data from a cell using cut and paste.
(j)Copy data from a cell using copy and paste.
(k)Move and copy data using drag and drop.
(l)Copy the contents of a cell into adjacent cells using the ‘Fill’ command.
(m)Search for specific text that is part of a label, value or formula using find and replace.
(n)Design a spreadsheet using good design principles with four identifiable areas—instruction, input, calculation and output.
(o)Open a completed spreadsheet from a storage medium.
(a)Create formulas that contain numbers, cell references, operators and functions.
(b)Explain the meaning of a range of cells.
(c)Use a name to replace a cell reference or a range in a
(d)Describe a circular reference.
(e)Use arithmetic operators (+, -, *, /, and ^).
(f)Use relational operators (=, <>, <, >, <=, >=).
(g)Use arithmetic functions (SUM, MAX, MIN, COUNT, ABS, SQRT and INT).
(h)Use statistical functions (AVERAGE and STDEV).
(i)Use logical functions (IF).
(j)Use other functions (LOOKUP).
(k)Explain the difference between absolute and relative referencing.
(l)Copy formulas using absolute and relative referencing and the ‘Fill’ command.
(m)Recalculate a formula if the values in a cell reference are changed.
(n)Make ‘what if’ predictions using a spreadsheet.
(o)Explain the advantages of a template.
(p)Create a template to solve a simple problem.
3.Formatting a spreadsheet
(a)Change the row height and column width—drag the border, redefine the default, and the minimum necessary to display the contents of a cell.
(b)Insert and delete rows and columns.
(c)Format cells with numbers to the following styles—general, fixed, comma, currency, per cent, scientific, date, time, fraction and special.
(d)Align the contents of a cell vertically—top, centre and bottom.
(e)Align the contents of a cell horizontally—align left, align right, centre, centre across selection, wrap text and shrink to fit.
(f)Format text using a range of fonts and styles.
(g)Use borders and shading to improve the appearance of the spreadsheet.
(h)Run and record a macro for a repetitive task.
(a)Explain the advantages of presenting data as a chart.
(b)Describe and understand the purpose of each chart type—bar, column, line and pie chart.
(c)Create a chart by selecting data and choosing a chart type.
(d)Create and edit the features of a chart—chart title, axes, axis title, data labels and legend.
(e)Import a chart into a word processing document.
Comment on topic: _______________________________________________________________________________________
Other resources used: _____________________________________________________________________________________
Date completed_________________________ Time taken_____________________ Teacher’s signature: _________________
Copyright © Pearson Australia (a division of Pearson Australia Group Pty Ltd)
Sample Teaching Program