CTL3071

1
CTL3071

• Griffith University
• Introduction to Spreadsheets
• USING EXCEL

2
Introduction

• Spreadsheets are useful for
• rapid calculation of repetitive material
• converting data to graph formats
• use as mini-databases for record keeping

3
Tasks Today -)

• Start Excel and create a spreadsheet
• Enter data
• apply simple formula
• Apply font formatting and colour
• Convert to graph

4
Task Example

• MACDONALDS FARM
• ANIMALS QTY PRICE TOTAL
• KANGAROOS 54 155.6 8,402.40
• RABBITS 67 17.8 1,192.60
• HORSES 83 350.0 29,050.00
• EMUS 29 650.0 18,850.00

5
Completed Task Example

• MACDONALDS FARM
• ANIMALS QTY PRICE TOTAL
• KANGAROOS 54 155.6 8,402.40
• RABBITS 67 17.8 1,192.60
• HORSES 83 350.0 29,050.00
• EMUS 29 650.0 18,850.00
• TOTAL 233 1173.4 57,495.00

6
Uses and Abuses

• Discuss Uses of spreadsheet
• How might spreadsheet training be abused?
• How do spreadsheets relate to teaching?