Technology Literacy Collaborative

Created: February 2011       Last Updated: --

Overview: This course allows participants to gain knowledge of the most common Microsoft Office programs as they prepare for the workplace. This course goes beyond the basics of Level I and Level II Basic Computer Class to provide a broader understanding of the Microsoft Office Suite.

Typical Schedule: 4 Sessions – 2 Hours Each

Operating System: N/A

Software Requirements: Microsoft Office 2007

Session topics include:

• Microsoft Word
• Microsoft Excel
• Microsoft PowerPoint
• Microsoft Publisher

Created: July 2009       Last Updated: June 2010

Overview: This course continues to build and expand upon basic knowledge of computers through exploring different software. Participants are introduced to many of the Google features, job searching online, more of Microsoft Word (advanced use) and Microsoft Excel.

Typical Schedule: 4 Sessions – 2 Hours Each

Operating System: N/A

Software Requirements: Microsoft Office 2007

Session topics include:

• Online Job Search and Applications
• Beyond the Basics of Microsoft Word - Creating a professional document
• Introduction to Microsoft Excel
• iGoogle

The PTE Technology Workshops were created to teach students the tools needed to properly find a job using available technology tools. This workshop coveres how to use the basics of Word 2007 to make a resume, how to use various job search sites successfully and how to use Email properly in a job search setting.

This workshop is taught twice a week, 90 minutes per class, for four weeks. The topics include:

Week 1: Using word for Resumes

Week 2: Using the Internet for Job Search 1

• Indeed.com and Search Engines
• Craigslist.org and Internet Safety

Week 3: Email and Email Correspondence

• Email Correspondence
• Email Etiquette and Email Attachments

Week 4: Using the Internet for Job Search 2

• Job Connect and National vs. Local Job Search Sites
• Non-Profit Job Board and using specific job search sites

Full Microsoft Word Curriculum with step-by-step activities.

Included is PPL's curriculum and instructor manuals for the Computer Basics series. The series runs for 4 days every two weeks. Each day is devoted to a different lessons and they are as follows:

This 4 session class covers vocabulary, navigation, and basic functions of Microsoft Word. You will learn to: copy and paste, add bulleted and numbered lists, use spell check, and do basic formatting.

Required Experience: Students must have basic typing skills and be comfortable using the mouse.

Notes: (1) This class is part of a suite of computer courses created at the Saint Paul Public Library. The goal is to prepare learners in basic computer competencies as outlined in the Northstar Digital Literacy Standards. Please visit www.digitalliteracyassessment.org/ for more information.

(2) This class is designed for a computer lab environment where the instructor can project an image of their computer for the class to see. However, you may also substitute a computer-projector set-up with solely lecturing, using printouts of the slideshows as vocabulary cards, etc. Similarly, you can teach to a group of students who are using desktop computers, laptop computers, etc.

This is a handout used to help students remember useful buttons on the Microsoft Word Ribbon. This is best used in an open lab setting as a resource for students that have already been introduced to the concept of the Ribbon.

List of all useful Microsoft Word shortcuts (should work for 2003, 2007, and 2010)