revised and updated Tuesday April 13, 2004
Some of the files in the second and third tables are out of date; check with Doug first. If you use them, download and save the files to disk. Right click the file name then:
|
Handouts |
|||
| File | Format | Description | Size (KB) |
| excel_handout12.16.rtf | RTF | The Excel window | 1060 |
| excel_handout12.17.rtf | RTF | Excel toolbars | 205 |
| excel_handout12.18.rtf | RTF | How to do things in Excel | 18 |
|
In class activities and practice |
|||
| File | Format | Description | Size (KB) |
| Excelskills2.xls | Excel 2000 | Skills required for Excel Challenge | 18 |
| excel_starting1.doc | Word doc | Introduction and overview of Excel | 30 |
| enroll_ex.doc | Word doc | Exercises with a small data table | 27 |
| enroll.xls | Excel 2000 | Workbook to accompany enroll_ex | 14 |
| pay_ex.rtf | RTF | College pay statement | 14 |
| pay.xls | Excel 2000 | Workbook to accompany pay_ex | 14 |
| sandwich.doc | Word doc | Sandwich exercise | 27 |
| excel_sporting.rtf | RTF | Sporting goods exercise | 19 |
| running.xls | Excel 2000 | Workbook to accompany excel_sporting | 33 |
| excel_pex9a.rtf | RTF | Practice Exercise 9A | 28 |
| Rusty's_business_instructions.doc | Word doc | Exercise on sorting, filtering, functions | 24 |
| Rusty's_business.xls | Excel 2002 | Workbook to accompany Rusty's | 17 |
|
Old exercises |
|||
| File | Format | Description | Size (KB) |
| excel_ex8.rtf | RTF | Exercise 8B | 48 |
| excel_ex9.rtf | RTF | Exercise 9 | 33 |
| budget1.xls | Excel 2000 | Workbook for Exercise 9 | 14 |
| The bird feeder | |||||||||
| Bird | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Total | % of total |
| blue jay | 20 | 25 | 17 | 17 | 21 | 31 | 19 | 150 | 29% |
| chickadee | 16 | 12 | 17 | 19 | 4 | 18 | 23 | 109 | 21% |
| goldfinch | 28 | 33 | 11 | 24 | 17 | 19 | 29 | 161 | 32% |
| junco | 4 | 2 | 2 | 2 | 5 | 3 | 1 | 19 | 4% |
| nuthatch | 2 | 0 | 4 | 2 | 6 | 1 | 5 | 20 | 4% |
| purple finch | 8 | 11 | 3 | 3 | 11 | 2 | 14 | 52 | 10% |
| Total | 78 | 83 | 54 | 67 | 64 | 74 | 91 | 511 | 100% |
| % of total | 15% | 16% | 11% | 13% | 13% | 14% | 18% | 100% | |
| Daily average | 13 | 14 | 9 | 11 | 11 | 12 | 15 | ||
| Daily maximum | 28 | 33 | 17 | 24 | 21 | 31 | 29 | ||
| Daily minimum | 2 | 0 | 2 | 2 | 4 | 1 | 1 | ||
| Week total | 511 | ||||||||