USING A GRAPHICAL USER INTERFACE (GUI)-BASED SPREADSHEET APPLICATION, ENHANCE THE FUNCTIONALITY AND APPLY GRAPH / CHARTS TO A SPREADSHEET
UNIT STANDARD ID: 116943
NQF LEVEL: 4, CREDITS: 3
NOTIONAL HOURS: 30
SAQA UNIT STANDARD ALIGNMENT
SPECIFIC OUTCOMES (SO)
Level 4 | Credit 3
UNIT STANDARD 116943 :
Using a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graph / charts to a spreadsheet
SPECIFIC OUTCOME 1
Create and edit a graph.
OUTCOME RANGE
Graph refers to all types of graphs and/or charts.
ASSESSMENT CRITERION 1
The major graph types are defined in terms of their purpose.
ASSESSMENT CRITERION RANGE
At least 3 of: Pie, Bar, Column, Line, Scatter, Area.
ASSESSMENT CRITERION 2
A graph is created from a given data source.
ASSESSMENT CRITERION RANGE
At least 2 of: Pie, Bar, Column, Line, Scatter, Area.
ASSESSMENT CRITERION 3
A graph is edited.
ASSESSMENT CRITERION RANGE
At least 3 of: Graph title, axis titles, data labels, background colour, line or bar colour.
ASSESSMENT CRITERION 4
The graph type is changed.
ASSESSMENT CRITERION 5
A graph is copied and moved based on given specifications.
ASSESSMENT CRITERION RANGE
Within a worksheet, to a different worksheet, to a different spreadsheet file.
ASSESSMENT CRITERION 6
A graph is resized.
ASSESSMENT CRITERION 7
A graph is deleted from a spreadsheet.
SPECIFIC OUTCOME 2
Load data from an external data source to produce a given spreadsheet result.
ASSESSMENT CRITERION 1
The external data file is checked to ensure that the input into a spreadsheet will achieve the required results.
ASSESSMENT CRITERION 2
The format of the input file is determined to ensure correct input into a spreadsheet.
ASSESSMENT CRITERION RANGE
Tables from another source.
ASSESSMENT CRITERION 3
The data is copied into the spreadsheet.
ASSESSMENT CRITERION 4
The resulting spreadsheet is in accordance with the given spreadsheet result.
SPECIFIC OUTCOME 3
Insert and edit objects into a spreadsheet.
OUTCOME RANGE
Any 2 of the following objects: pictures, images, charts, auto-shapes.
ASSESSMENT CRITERION 1
An object is inserted into a spreadsheet.
ASSESSMENT CRITERION RANGE
At least 2 of the following: picture, image, chart, autoshape.
ASSESSMENT CRITERION 2
A selected object is manipulated in a spreadsheet.
ASSESSMENT CRITERION RANGE
At least 2 of the following: move, copy, resize.
ASSESSMENT CRITERION 3
Use a drawing tool to draw an object in the spreadsheet.
Table of Contents
Introduction to graphs and charts
Lesson 1 – Types of graphs
Activity 1
Lesson 2 – Working with Charts
Identifying the Parts of a Chart
Creating a Chart
Chart Tools
To Change the Chart Style
Moving a chart
Resize a chart
Deleting a graph
Activity 2
Lesson 3 – Importing data from an external source
Activity 3
Lesson 4 – Insert and edit objects
Inserting an object
To copy and paste an object
To Cut and Paste an object
To resize an object
Drawing an object in a spreadsheet
Activity 4
Introduction to graphs and charts
Excel 2010 allows users to create and edit graphs. In computer science, a graph is an abstract data type that is meant to implement the graph and hypergraph concepts from mathematics. (Wikipedia)
A graph data structure consists of a finite (and possibly mutable) set of ordered pairs, called edges or arcs, of certain entities called nodes or vertices. As in mathematics, an edge (x, y) is said to point or go from x to y. The nodes may be part of the graph structure, or may be external entities represented by integer indices or references.
A graph data structure may also associate to each edge some edge value, such as a symbolic label or a numeric attribute (cost, capacity, length, etc.).
