an introduction to creating spreadsheets trainer: sam capurso
TRANSCRIPT
An Introduction To Creating Spreadsheets
Trainer: Sam Capurso
Introduction to today’s training
• Two sessions
• Purpose
• Structure
• OHS requirements and facilities
• Questions are welcome at any time!
• Thank-you gift at the end
Assessment methods
1. Short assessment task at the end of the whole training, which will test skills acquired in Session 1.
2. Direct observation of how you complete the training exercise will test skills acquired in Session 2.
Session 1
Assessment criteria
1. Open and view different toolbars 2. Use workplace ergonomic work practices and
strategies3. Open spreadsheet application, create spreadsheet
files and enter numbers, text and symbols into cells according to information requirements
4. Enter simple formulas and functions using cell referencing where required
5. Save spreadsheet to directory or folder
• Spreadsheets and workbooks• Business and mathematical applications• Storing data and performing calculations• Collating, manipulation and presenting data – e.g.
charts / graphs
• Can proceed from this training program to Certificate I in Information, Digital Media and Technology
Why are spreadsheet packages used?
Some more theory... OHS: Ergonomic practice
Pause Exercises Link
Introduction to Excel (2007)
• Microsoft Office button• Ribbon and Groups• Worksheet tabs• Horizontal scrolling bar• Formula bar
• Experiment with these – they look a bit different for other versions of the Excel!
Keys
1. Opening spreadsheets and entering data
• Cell reference terminology• Navigation
• Entering and editing data• Entering numbers as text
• Trainer demonstration• Complete Exercise 1 in your Trainee Workbook
The outcome of Exercise 1 should look like this:
2. Using formulas and functions
• All formulas start with equals (=) sign
• Add (+), subtract (-), multiply (*) and...
• divide (/)
• Sum function: =sum(cell range)
• Using cell references
• Trainer demonstration• Complete Exercise 2 in your Trainee Workbook
Other useful keys: $, %, ( )
Session 2
Assessment criteria
6. Create a chart using selected data in the spreadsheet
3. Create a chart – skill demo
Now try generating a
chart with the data
in Exercise 3 of your
Trainee Workbook.
Client A
Client B
Client C
Client D
Client E
Client F
Client G
Client H
Client I
Client J
Client K
Client L
Client M
0
200000
400000
600000
800000
1000000
1200000
Revenue by Client
Client bar
$
2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 20120
20
40
60
80
100
120
Monthly rainfall (mm) in January and June over the last ten years
Jan Rainfall June Rainfall
Extra
Theory:• Identifying reasons for using spreadsheet packages• Identifying ergonomic considerations when using a computer
Practical:• Navigating through spreadsheets• Entering data• Using formulas: +-X/, sum• Using relative cell references in formulas• Generating graphs: column and line
Summary of training
Training Package:ICA11 Information and Communications Technology
1.1.• Element: OHS practices• Unit: Operate word-processing applications
1.1, 1.2, 1.7, 2.2., 4.3.• Element: Create spreadsheets, Customise Basic Settings, and
Incorporate object and chart in spreadsheet• Unit: Operate spreadsheet applications
Performance criteria for training
Assessment - test
• Open workbook labelled Assessment.
• Complete assessment tasks.
• Save workbook for marking.
Well done!
• Thank-you for your participation and cooperation.
• Please complete the evaluation form. Your feedback is very much appreciated.
• Next session: using formatting and common tools in spreadsheet development (i.e., continuing on with this unit)