Personal Computer Proficiency

The following training modules can be used to help train staff to the California State Personal Computer Proficiency and Instructional Integration proficiency. Although the basic concepts apply to several software packages and operating systems, the modules are based on Windows 95/98 and Microsoft Office Pro 97.
 

1. INTRODUCTION

1-1 Workshop description, goals, and context
1-2 Technology and Learning
1-3 Assessment: Teacher Portfolio

2. OPERATING SYSTEM

2-1. Computer Operating System (OS) Skills: Mac, Windows 3.11, Windows 95/98, DOS

2-1-1: Parts of a computer
2-1-2: Determine specifications of computer (OS, RAM, HD, etc)
2-1-3: Memory vs. storage
2-1-4: Start menu
2-1-5: Help

2-1-6: Find
2-1-7: Settings
2-1-8: Documents
2-1-9: Programs
2-1-10: Task Bar

2-1-Organizing the desktop and windows
2-1-file and disk information
2-1-find files and programs
2-1-Windows Explorer

2-1-right click for properties
2-1-: format a disk
2-1-: copy a disk
2-1-: copy a file, also to and from FDD and HDD.
2-1-: save a file
2-1-: save as...
2-1-software hierarchies, strategies, and file formats
2-1-keyboard vs. mouse commands
2-1-OK vs. Cancel

2-1-: Launch software
2-1-: quit software
2-1-restating the computer
2-1-shuting down the computer

2-2. Manage the Hard Drive

2-2-1: Organize software and files on a hard drive
2-2-2: name a file
2-2-3: name a disk
2-2-4: install software
2-2-5: locate files on HDD
2-2-6: backup files
2-2-7: write protect disks

3. MAINTENANCE SKILLS

3-1: Cleaning the computer
3-1: archive manuals, software and documentation
3-1: create computer "first-aid" resources
3-1: create a system boot disk
3-1: create an anti-virus boot disk
3-1: install printer software. Configure software
3-1: troubleshoot printer
3-1: manage memory, change memory allocation
3-1: recover files with repair utilities (i.e. Norton Utilities)
3-1: install, manage, update virus software.

4. WORD PROCESSING

• 4-1: formatting
• 4-1: mixing fonts
• 4-1: draw tools
• 4-1: creating tables
• 4-1: using templates
• 4-1: creating templates
• 4-1: outlines
• 4-1: save text as RTF
• 4-1: spell and grammar check
• 4-1: copy, paste, cut
• 4-1: mail merge
• 4-1: save and save as...

5. SPREADSHEET

• 5-1: plan the spreadsheet
• 5-1: entering text
• 5-1: entering data
• 5-1: entering formulas
• 5-1: using formulas
• 5-1: graphing

6. DATABASE

• 6-1: plan database
• 6-1: relational vs. flat
• 6-1: create categories
• 6-1: entering data
• 6-1: using pull downs
• 6-1: filters
• 6-1: reports
• 6-1: importing data
• 6-1: exporting data

7. PRESENTATIONS

• 7-1: planning presentation
• 7-1: creating a story board
• 7-1: using a wizard
• 7-1: using templates
• 7-1: creating slide show from scratch
• 7-1: importing graphs
• 7-1: importing images
• 7-1: using Pack 'n Go

8. E-MAIL

• 8-1: anatomy of an e-mail address
• 8-1: configuring software
• 8-1: sending
• 8-1: checking e-mail
• 8-1: replies
• 8-1: forwarding
• 8-1: using folders and organizing messages
• 8-1: mulitple addresses
• 8-1: address book
• 8-1: copy and paste text
• 8-1: attachments
• 8-1: listservs
• 8-1: Citing Internet resources

9. WORLD WIDE WEB (WWW)

• 9-1: how www works
• 9-1: basic navigation
• 9-1: understanding URLs
• 9-1: entering a URL
• 9-1: using a directory
• 9-1: using a search engine
• 9-1: fixing aged URLs
• 9-1: saving as text
• 9-1: saving images
• 9-1: Citing Internet resources

10. NETIQUETTE

• 10-1: e-mail addresses and lists
• 10-1: e-mail attachments
• 10-1: use of humor
• 10-1: LAUSDnet AUP

11. GLOSSARY