SPREADSHEETS: Graphical Aspects of Spreadsheets

GRAPHICAL ASPECTS OF SPREADSHEETS

1. Creation of simple spreadsheets to explore numeracy
Layout
Selecting Cells
Selecting Columns & Rows
Entering Data
Basic Formatting
Entering Formulas
Autosum
2. Graphical aspects of spreadsheets
Introduction to Graphs
Creating a Graph
Pasting a Graph into a Word document
Pasting a Table into a Word document
Task
3. Functions
Inserting Functions
4. Exploring Mathematical Ideas
Visual Representation
Scatter diagrams
Clock faces & fancy fonts
Formatting Numbers
Number Patterns
Number Grids

Introduction to Graphs

A spreadsheet also has the capability to produce visual representations of data. There are various types of graphs to choose from.

Types of Graphs

Be sure to select the graph that is appropriate for the information that you are representing.

Titles, labels and scales are important.

Next: Creating a Graph