Mastering Spreadsheet Skills: An Introductory Training Program

1. An Introduction To Creating Spreadsheets Trainer: Sam Capurso

2. 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

3. Assessment methods • Short assessment task at the end of the whole training, whichwill test skills acquired in Session 1. • Direct observation of how you complete the training exercise will test skills acquired in Session 2.

4. Session 1

5. Assessment criteria • Open and view different toolbars • Use workplace ergonomic work practices and strategies • Open spreadsheet application, create spreadsheet files and enter numbers, text and symbols into cells according to information requirements • Enter simple formulas and functions using cell referencing where required • Save spreadsheet to directory or folder

6. Why are spreadsheet packages used? • 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

7. Some more theory... OHS: Ergonomic practice Pause Exercises Link

8. 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!

9. 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 Keys

10. The outcome of Exercise 1 should look like this:

11. 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: $, %, ( )

12. Session 2

13. Assessment criteria • Create a chart using selected data in the spreadsheet

14. 3. Create a chart – skill demo Now try generating a chart with the data in Exercise 3 of your Trainee Workbook. Extra

15. Summary of training 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

16. Performance criteria for 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

17. Assessment - test • Open workbook labelled Assessment. • Complete assessment tasks. • Save workbook for marking.

18. 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)