From Training

Contents 1 Basic Adult Digital Literacy 1.1 Description 1.2 Available Programs 1.3 Why IC3? 1.4 Practice Tests 1.5 Prerequisites 1.6 Pricing 1.7 Exams 1.8 Assessments 1.9 Customization 1.10 Course Outline 1.10.1 Module 1: Computing Fundamentals 1.10.2 Module 2: Key Applications 1.10.3 Module 3: Living Online

Basic Adult Digital Literacy

Description

The days are gone when the entry-level employee could remain unaffected by computers in any industry. Truck drivers, electrical linemen, factory workers are all required now to possess at least basic skill on the computer.

Available Programs

There are two large and widely used programs for digital literacy in the world. ECDL/ICDL and IC3.

The European Computer Driving License/International Computer Driving License is widely used in much if the world and is part of a wider portfolio of standardized certifications. The ICDL program has not been used extensively in the US so far and does not look to be a serious competitor with IC3 any time soon.

Internet Computing and Core Certification (IC3) is another world-wide certification and is sponsored by Certiport. IC3 is used extensively in American workforce retraining and Displaced Worker programs. IC3 also meets the eighth-grade No Child Left Behind standards and is used in many school programs. SawyerTraining, Inc. has adopted the IC3 as our literacy standard and we are promoting it's adoption in the workplace and community.

• See how IC3 and ICDL fit into a certification roadmap.
• See a PowerPoint presentation explaining IC3.
• See an IDC white paper entitled "Preventing Bad Hires: The Value of Objective PreHire Assessment".
• See Microsoft's Research Report "Microsoft Office Specialist: Improving the Workplace" (dated but still valid).

Why IC3?

N.B. Some of these videos must be downloaded. Some will play in your browser. The ones that play in your browser may take a bit of time to load depending on your connection. You can also right click and download them for later.

• 30 second commercial (.mpg)
• The Digital Divide (.wmv)
• Cleveland Adopts IC3 for Digital Literacy (.wmv)
• Lee Iacocca on why we need Digital Literacy (.wmv)

Practice Tests

Practice tests are critical to helping the student succeed on the exams. IC3 exams are often the first time students have taken a computer-based exam. Many students have very high anxiety about taking any type of test. Practice tests help acclimate students to the test environment and give them confidence in their skills.

Certiport has just recently rolled out new practice exams to support the IC3 GS3 standards and exams. We will post examples and information on these as soon as they become available.

Prerequisites

None. The point of the Digital Literacy program is to bring you up-to-speed and make you comfortable and marketable in a computer-based world.

Pricing

IC3 certification training is priced differently than other programs. The cost is typically all inclusive and covers the textbook, training, and three exam vouchers (one for each segment).

SawyerTraining, Inc. is an authorized Certiport testing center for IC3 and uses only authorized IC3 instructors. We can also provide on-site testing for groups.

Contact SawyerTraining, Inc. directly for pricing information (tel: 612.234.1298 or email: Sales@sawyerTraining.com)

Exams

There are three exams associated with the IC3 program. Don't worry. These are not high-pressure exams and the training we provide will help you succeed at test time. We recommend you take your exams shortly after training while your knowledge and skills are still fresh.

For those taking the exams, be prepared to spend several hours reading and reviewing outside of class to sufficiently prepare for the exams.

Assessments

Assessments are an ideal way for Human Resource departments to assure applicants have the necessary skills for their jobs before hiring. Assessments are less pressure for a candidate and less expensive for the organization while still giving an very accurate measure of the candidate's skill. Using assessments allows organizations to be fair and consistent in their evaluation of applicants and reduce training and support costs post-hire. Organizations can also use assessments in place of exams either before or after training (or both) to evaluate employee skills and training effectiveness.

Customization

Digital Literacy programs can be standardized using the curriculum mapped to IC3 or ICDL. Training can also be highly customized to fit the specific need of an organization. Customized modules on security and use policies, for example, can be added to build comprehensive programs. An extensive needs analysis and plan for implementation and outcomes will be part of any digital literacy program. SawyerTraining can provide customized materials in line with your custom program.

Course Outline

Module 1: Computing Fundamentals

1. Introducing Computers
   1. What makes a computer a computer
   2. How computers are used today
   3. Types of computers
   4. Computer systems
   5. Computer networks
2. Computer Hardware
   1. System components
   2. Types of computer memory
   3. Input devices
   4. Output devices
   5. Storage devices
3. Maintaining and Protecting Hardware
   1. Evaluating hardware components and upgrades
   2. Connecting devices to the computer
   3. routine maintenance
   4. Troubleshooting
   5. Protecting computer systems from theft and damage
4. Computer Software
   1. Hardware vs. software
   2. Types of software
   3. Microcomputer operating systems
   4. User interfaces
5. Essential Computer Skills
   1. Starting and shutting down the computer
   2. Working with storage media
   3. Opening and closing a window
   4. Working with files and folders
   5. Starting and exiting a program
   6. Installing new software
6. Using Technology to Solve Problems
   1. Problem solving
   2. Steps in the problem-solving process
   3. Technological tools can help solve problems
7. The Windows Operating System
   1. The Windows world
   2. Windows updates
   3. Starting Windows
   4. Moving around the desktop
   5. Identifying the parts of a window
   6. Navigating through Windows
   7. The Windows Help feature
   8. Shutting down Windows
8. Changing Settings and Customizing the Desktop
   1. The control panel
   2. Changing control panel settings
   3. The Desktop
   4. Customizing the desktop
   5. Using shortcuts
9. Using Windows Explorer
   1. The Explorer window
   2. Setting Explorer options
   3. Viewing the contents of a drive or folder
   4. Displaying file properties
   5. Finding files and folders
10. File Management with Windows Explorer
    1. Creating folders
    2. Naming folders and files
    3. Selecting files
    4. Copying, moving, and deleting files
    5. Managing a hard drive

Module 2: Key Applications

1. Using Microsoft Office 2003
   1. Starting an Office 2003 application
   2. Navigating the Windows application screens
   3. Understanding the information in the application window
   4. Customizing the document window
   5. Opening, saving, and printing documents
   6. Closing documents and applications
   7. Getting help
2. Word Essentials
   1. Creating a new document
   2. Entering text in a document
   3. Selecting text
   4. Displaying nonprinting characters
   5. Changing vies
   6. Using the track changes and comments features
3. Editing and Formatting Documents
   1. Deleting and inserting characters
   2. Undo, redo, and repeat
   3. Copying and moving text
   4. Inserting special text: date, time, and special characters
   5. Using find and replace
   6. Formatting text
   7. Using format painter
   8. Using the document statistics tools
   9. Checking spelling and grammar
   10. Formatting a document for printing
4. Working with Tables
   1. Creating a table
   2. Inserting and deleting rows and columns
   3. Formatting tables
   4. Inserting and editing text in a table
   5. Modifying the table structure
   6. Sorting data in a table
   7. Converting text to a table and a table to text
5. Enhancing Documents
   1. Using Columns, borders, and shading
   2. Page numbers, headers, and footers
   3. Footnotes and endnotes
   4. Inserting graphics
   5. Using drawing tools
   6. Templates and styles
   7. Enhancing your document with text tools
6. Excel Essentials
   1. Identifying the parts of the Excel screen
   2. Navigating through a worksheet
   3. Inserting and deleting rows and columns
   4. Changing column width and row height
   5. Working with data in worksheet cells
   6. Formatting the contents of a cell
   7. The undo and redo features
7. Organizing Worksheets
   1. Merging cells
   2. Entering data with the autofill command
   3. Applying autoformats
   4. Creating multiple worksheets
   5. Sorting data
   6. Printing a worksheet
8. Creating Formulas and Charting Data
   1. Formulas
   2. Relative and absolute cell references
   3. Using autosum
   4. Function formulas
   5. Create a chart
   6. Edit chart data
   7. Editing chart formats and options
   8. Interpreting worksheet and chart data
9. PowerPoint Essentials
   1. Opening and saving an existing presentation
   2. Identifying the parts of the PowerPoint screen
   3. Navigating through a presentation
   4. Changing the slide view
   5. Creating a new presentation
   6. Applying a design template
   7. Adding, deleting, and duplicating slides
   8. Previewing a presentation
10. Enhancing Presentations with Multimedia Effects
    1. Adding information to a slide
    2. Formatting text
    3. Inserting graphics
    4. Changing slide layout
    5. Transitions
    6. Changing the order of slides in a presentation
    7. Printing handouts and speaker notes
11. Access Essentials
    1. Identifying the parts of the Access screen
    2. Creating a database table
    3. Modifying a database table
    4. Editing database records
    5. Adding and deleting records
12. Managing and Reporting Database Information
    1. Changing the datasheet layout
    2. Creating a form
    3. Sorting data in datasheet view
    4. Finding and replacing data
    5. Creating queries and reports
    6. Mailing labels

Module 3: Living Online

1. Networks and Telecommunication
   1. Networks
   2. Communications media
   3. Network hardware
   4. Types of networks
   5. Network operating systems software
2. E-mail and Effective Electronic Communication
   1. Electronic mail
   2. Sending and receiving e-mail
   3. Organizing and managing e-mail
   4. Professional and effective electronic communication
   5. Special e-mail features
   6. Managing an address book
   7. Other forms of electronic communication
3. Internet Essentials
   1. How the internet works
   2. Accessing the internet
   3. Browser basics
   4. Customizing browser settings
   5. Communicating on the internet
   6. Working with web pages
4. Researching on the Internet
   1. Searching online
   2. Search engines
   3. Techniques for searching
   4. Saving, copying, and printing information from websites
   5. Bookmarking and downloading web sites
5. Evaluating Online Information
   1. Types of internet resources
   2. Criteria for evaluating electronic resources
   3. Assessing information on web sites
   4. Web sites and copyright rules
6. Technology and Society
   1. E-commerce
   2. Technology and education
   3. Science and technological innovation
   4. The wired workplace
7. Security, Privacy, and Ethics Online
   1. Safeguarding software and data
   2. Computer crime
   3. Security issues
   4. Preserving privacy
   5. Other legal and ethical issues
   6. Responsibilities of technology users
   7. Maintaining a safe working environment