USE A GRAPHICAL USER INTERFACE (GUI)-BASED SPREADSHEET APPLICATION TO CREATE AND EDIT SPREADSHEETS
US 116937
NQF LEVEL: 2
CREDITS: 4
NOTIONAL HOURS: 40
SAQA UNIT STANDARD ALIGNMENT
SPECIFIC OUTCOMES (SO)
Level 4 | Credit 2
UNIT STANDARD 116937 :
Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets.
SPECIFIC OUTCOME 1
Demonstrate an understanding of the principles of spreadsheets
ASSESSMENT CRITERION 1
Spreadsheet is defined in terms of its purpose and use.
ASSESSMENT CRITERION RANGE
Uses include but is not limited to:
• Automation of repetitive calculation tasks, organisation of data into rows and columns.
ASSESSMENT CRITERION 2
Examples of spreadsheet that can be produced using a spreadsheet application are provided.
ASSESSMENT CRITERION RANGE
At least three examples.
ASSESSMENT CRITERION 3
The benefits of using a spreadsheet application for producing and working with spreadsheets are explained.
ASSESSMENT CRITERION RANGE
At least three benefits.
ASSESSMENT CRITERION 4
Examples of spreadsheet programs are named.
ASSESSMENT CRITERION 5
Properties of a spreadsheet are identified and described in terms of its purpose and use.
ASSESSMENT CRITERION RANGE
Properties include but is not limited to:
• Rows, columns, cells, cell cursor.
SPECIFIC OUTCOME 2
Create, open and save spreadsheets.
OUTCOME RANGE
When creating new spreadsheets, the na e of the new spreadsheet must allow the spreadsheet to be easily identified in terms of its purpose and content.
ASSESSMENT CRITERION 1
The spreadsheet application program is opened.
ASSESSMENT CRITERION 2
A new spreadsheet is created.
ASSESSMENT CRITERION RANGE
At least 4 columns and 4 rows of data are entered, no calculations.
ASSESSMENT CRITERION 3
Methods of moving the cell cursor are demonstrated in order to move about the spreadsheet.
ASSESSMENT CRITERION RANGE
At least 2 methods are demonstrated.
ASSESSMENT CRITERION 4
Saving spreadsheets is explained in terms of its purpose and the destination of the saved filed.
ASSESSMENT CRITERION 5
The spreadsheet is saved with a specific name in a specific folder.
ASSESSMENT CRITERION RANGE
At least two different methods of saving a spreadsheet.
ASSESSMENT CRITERION 6
The spreadsheet is closed.
ASSESSMENT CRITERION 7
An existing spreadsheet is opened and closed.
ASSESSMENT CRITERION 8
The spreadsheet application program is closed.
SPECIFIC OUTCOME 3
Produce a spreadsheet from a given specification.
OUTCOME RANGE
At least 8 rows and 5 columns should be contained in the spreadsheet produced.
ASSESSMENT CRITERION 1
A spreadsheet is produced with the required data from given specification.
ASSESSMENT CRITERION RANGE
Text, numbers, dates.
ASSESSMENT CRITERION 2
Formula are entered to achieve the given specification.
ASSESSMENT CRITERION RANGE
Formulae: addition, subtraction, division, multiplication, sum.
ASSESSMENT CRITERION 3
The differences between data cells, label cells, and formula cells are explained.
ASSESSMENT CRITERION 4
The spreadsheet is in accordance with the given specifications.
ASSESSMENT CRITERION 5
Practices are demonstrated to ensure the integrity of the data.
ASSESSMENT CRITERION RANGE
Check against data source, check-totals, audit formulae.
ASSESSMENT CRITERION 6
The benefits of saving a file in different formats is explained.
ASSESSMENT CRITERION RANGE
Formats: Text, CSV, HTML, other software versions, other software types.
ASSESSMENT CRITERION 7
A spreadsheet is saved in a different format.
ASSESSMENT CRITERION RANGE
At least two of: Text, CSV, HTML, other software versions, other software types.
SPECIFIC OUTCOME 4
Edit a spreadsheet.
ASSESSMENT CRITERION 1
An existing spreadsheet is opened.
ASSESSMENT CRITERION 2
Cells are selected for manipulation and de-selected.
ASSESSMENT CRITERION RANGE
Cell, cell range, entire column, entire row, entire spreadsheet.
ASSESSMENT CRITERION 3
Cells are manipulated.
ASSESSMENT CRITERION RANGE
Move, copy, delete.
ASSESSMENT CRITERION 4
Use the automatic fill feature to automatically enter data in cells.
ASSESSMENT CRITERION RANGE
At least two of: Year, Quarter, Month, Week, Day.
ASSESSMENT CRITERION 5
Text is located and replaced in a spreadsheet by using features of the application.
SPECIFIC OUTCOME 5
Format a spreadsheet.
ASSESSMENT CRITERION 1
Cells are formatted using formatting features of the spreadsheet application.
ASSESSMENT CRITERION RANGE
Formatting features include the following: Style, Alignment, Font, Background colourAt least one option listed out of each formatting feature must be performed: Style (Text, number, date, currency, percentage), Alignment (left, center, right, justified, text direction), Font (type, size, style – italic, bold, underlined, colour, strike-through, superscript, subscript), Background colour.
ASSESSMENT CRITERION 2
Rows are formatted.
ASSESSMENT CRITERION RANGE
Height, automatic fit.
ASSESSMENT CRITERION 3
Columns are formatted.
ASSESSMENT CRITERION RANGE
Width, automatic fit.
SPECIFIC OUTCOME 6
Check spelling and grammar in a spreadsheet.
ASSESSMENT CRITERION 1
The dictionary to be used for spelling and word usage is set up.
ASSESSMENT CRITERION 2
Text is entered and corrected automatically while entering.
ASSESSMENT CRITERION 3
Text is checked for spelling and grammar and corrections made based on judgement.
ASSESSMENT CRITERION RANGE
Cell, range of cells.
ASSESSMENT CRITERION 4
Words are added to the custom dictionary.
SPECIFIC OUTCOME 7
Print a spreadsheet using features specific to spreadsheets.
ASSESSMENT CRITERION 1
The printing of gridlines is altered.
ASSESSMENT CRITERION RANGE
Printing of gridlines on or off.
ASSESSMENT CRITERION 2
A row is selected to print on each page of the printed spreadsheet.
ASSESSMENT CRITERION 3
Different ways of printing sheets within a spreadsheet are demonstrated, according to given specifications.
ASSESSMENT CRITERION RANGE
Different ways include but are not limited to:
• Entire workbook, active sheets.
Table of Contents
Introduction to Excel 2010
Lesson 1 – Setting Up Your Excel Environment
Spreadsheet programs
Examples of spreadsheets that can be produced using a spreadsheet application
Benefits of spreadsheet application
Properties of a spreadsheet
Activity 1
Lesson 2 – Starting a Workbook
To Create a New, Blank Workbook
To Select a Cell
To Insert Text
To Edit or Delete Text
To Move Through a Worksheet Using the Keyboard
To Save the Workbook
Close the active workbook window
Close a workbook
To Open an Existing Workbook
Exiting Spreadsheet
Activity 2
Lesson 3 – Producing a spreadsheet
Cell Content
To Insert Rows
To Insert Columns
To Delete Rows and Columns
To Insert Text
To Edit or Delete Text
Simple Formulas
Checking the integrity of data
The benefits of saving a file in different formats
Saving a spreadsheet with a different file format
Activity 3
Lesson 4 – Editing a spreadsheet
To Open an Existing Workbook
1. To edit text
Using automatic fill feature
2. Formatting dates and times
Find or replace text and numbers in a worksheet
Activity 4
Lesson 5 – Formatting a spreadsheet
1. Formatting font
To Change the Font Style
2. Text alignment
3. Formatting Numbers and Dates
To Modify Column Width
To Modify the Row Height
Activity 5
Lesson 6 – Checking spelling and grammar in a spreadsheet
To set up dictionary
AutoCorrect spelling, and insert text and symbols
Spelling and grammar check and corrections
Add words to your spell check dictionary
Activity 6
Lesson 7 – Printing Workbooks
To View the Spreadsheet in Print Preview
Print gridlines in a worksheet
To Print Active Sheets
To Print the Entire Workbook
To Print a Selection, or Set the Print Area
To Change Page Orientation
To Use Print Titles
Activity 7
Introduction to Excel 2010
Excel 2010 is the spreadsheet software in the Microsoft 2010 Office Suite. It allows you to store, organize, and analyze numerical and text data.
The main uses of spreadsheets include;
• Automation of repetitive calculation tasks
• Organisation of data into roles and columns
• Create consolidating results
• Manage data lists
