280 hour Computer Applications Course

 

 


LOCATION

TIME

COST

French River Education Center

672 Main Street

North Oxford, MA 01537

8:00 a.m. to 12:30 p.m.

Monday-Friday

$4,000 per person

 

 

Course Outline

 

Description...

 

This 280 hour, instructor-lead course is designed to provide trainees with instruction in the use of several industry-standard software packages including Microsoft Office 2007 (Word, Excel, PowerPoint, Access, and Outlook), QuickBooks Pro 2006 and the Internet for business applications. The featured operating system is Windows XP. The Center’s computer lab is equipped with Pentium IV PCs, color ink-jet printers, laser printers, digital cameras, scanners, full time/full access internet, and connections to a Windows 2003 network. The computer:student ratio is 1:1 and class size is limited to 18. Recognizing today’s business environment, successful program completers enhance their employability profile, a result of newly acquired knowledge of PCs and networked computers and demonstrated software proficiency. Six (6) texts are provided.

 

Computer experience is not a requirement for this program although keyboard familiarity is helpful. 

 

Course Breakdown

 

Segment 1:            Computer Concepts / Using Windows XP

Segment 2:            Microsoft Internet Explorer 8.0

Segment 3:            Microsoft Outlook 2007

Segment 4:            Microsoft Excel 2007

Segment 5:            Microsoft Word 2007

Segment 6:            Microsoft Word 2007: Mail Merge

Segment 7:            Microsoft Access 2007

Segment 8:            QuickBooks Pro 2006

Segment 9:            Microsoft PowerPoint 2007

 

 

 

Segment 1: Computer Concepts / Using Windows XP

 

Participants:

            This overview has been designed for students who have no previous experience with personal computers (PCs).

 

Prerequisites:

            There are no prerequisites for this segment.

 

Objective:

            Participants will develop an understanding of the basic hardware components of computers and how these components interact to produce the primary functions of everyday computer operations. In addition, students will receive an overview of basic software and how software and hardware interact with each other. This overview will include an examination of Microsoft operating systems and office applications. Students will also receive hands-on training in the basic procedures and skills necessary for using the Windows operating environment.

 

Structure:

            Course structure is a combination of lectures and hands-on exercises.

 

Outline:

 

Elements of a Personal Computer                   

 

 

Using the Windows Op System

 

 

Segment Lab:

 

Checking system resources

Basic computer maintenance

 

Segment 2: Microsoft Internet Explorer 8.0

 

Participants:

            This overview has been designed for students who have no previous experience with the Internet.

 

Prerequisites:

            Segment 1: Computer Concepts / Using Windows XP.

 

Objective:

Students will learn how the Internet works, what is needed to connect in a business and home environment, and how to use Microsoft Internet Explorer 8.0 (and other Browser software programs) to browse and search the Web. They will develop an understanding of the Internet and the World Wide Web, their terminology, ISPs, and new connection options.

 

Structure:

            Course structure is a combination of lectures and hands-on exercises.

 

 

Outline:

 

 

 

Segment Lab:  

 

Searching for Internet content

Organizing Favorites/Bookmarks into folders

Finding Internet Connection options

 

Segment 3: Microsoft Outlook 2007

 

Participants:

            This overview has been designed for students who have no previous experience with Microsoft Outlook.

 

Prerequisites:

            Segment 1: Computer Concepts / Using Windows XP

 

Objective:

Students will learn the basics of Microsoft Outlook: e-mail, scheduling, calendar appointments, contact lists, tasks, and notes.

 

Structure:

            Course structure is a combination of lectures and hands-on exercises,

 

Outline:

 

 

Typing Tutor

 

All students will spend 15 minutes per day working on a automated typing tutor program. This program is designed to teach touch typing to those students who do not type or those students who search the keyboard for letters.

 

For those students who do type, the program will help build additional accuracy and speed.

 

Segment 4: Microsoft Excel 2007

 

Participants:

            This overview has been designed for students who have no previous experience with Microsoft Excel.

 

Prerequisites:

            Segment 1: Computer Concepts / Using Windows XP.

 

Objective:

Students will develop an understanding of the Excel environment and spreadsheet concepts such as: entering data; formatting data; editing data; working with formulas; changing the page setup; printing; using the spell check; freezing windows; using Excel Database features; creating Template Documents; and creating pie, bar, and line charts.

 

Structure:

            Course structure is a combination of lectures and hands-on exercises.

 

Outline:

 

 

Segment 5: Microsoft Word 2007

 

Participants:

            This overview has been designed for students who have no previous experience with Microsoft Word.

 

Prerequisites:

            Segment 1: Computer Concepts / Using Windows XP.

 

Objective:

Students will develop an understanding of word processing, document preparation, and basic desktop publishing features.

 

Structure:

            Course structure is a combination of lectures and hands-on exercises,

 

Outline:

 

·         Creating Headers and Footers

·         Creating a Table

 

Segment 6: Microsoft Word 2007 - Mail Merge

 

Participants:

            This overview has been designed for students who have mastered Word’s basics and would like to use its more advanced features such as mail merge and other tools.

 

Prerequisites:

            Segment 5: Microsoft Word 2007

 

Objective:

Students will move onto more advanced portions of the Microsoft Word program - learning to create Form Letters, Mailing Labels, and Envelopes using the Microsoft Word Mail Merge Wizard.

 

Structure:

            Course structure is a combination of lectures and hands-on exercises.

 

Outline:

 

·         What is Mail Merge?

·         The Data Source

·         The Main Document

·         Merging the Documents                                                                                                                               

·         Creating Mailing Labels

 

 

Segment 7: Microsoft Access 2007

 

Participants:

            This overview has been designed for students who have no previous experience with Microsoft Access.

 

Prerequisites:

            Segment 1: Computer Concepts / Using Window XP

            Segment 4: Microsoft Excel 2007

            Segment 6: Microsoft Word 2007 - Mail Merge

 

Objective:

Students will learn the basics of the Access interface. This introductory course will deal with single-table example only. The course teaches sorting, filtering, and querying, along with customizing forms and reports.

 

Structure:

            Course structure is a combination of lectures and hands-on exercises.

 

Outline:

 

·         What is a Query?

·         Creating a Simple Query

·         Creating a Query using the Wizard

·         Creating a Query from Scratch

·         Saving Queries

·         Selecting Specific Fields

·         Selecting Records

·         Using Simple Criteria

·         Using Comparison Operators

·         Using Wildcard Characters

·         Excluding Fields from a Dynaset

·         Using Multiple Selection Criteria

·         Using the AND Operator

·         Using the OR Operator

·         What is a Form or Report?

·         Creating a Form

·         Creating an AutoForm

·         Using the Form Wizard

·         Switching Views

·         Moving Around in Forms

·         Moving Within Records

·         Moving Between Records

·         Creating a Report

·         Creating an AutoReport

·         Using the Report Wizard

·         Editing Reports

·         Printing Forms and Reports

 

 

 

Segment 8: QuickBooks Pro 2006

 

Participants:

            This segment has been designed for students who have no previous experience with QuickBooks Pro and who are interested in learning to post Accounts Payables, Account Receivables, and Payroll information. Students will learn to print necessary accounting reports and process payroll checks.

 

Prerequisites:

            Segment 4: Microsoft Excel 2007

 

Objective:

Students will develop an understanding of QuickBooks Pro 2006, learn how to create weekly and monthly accounting reports, and learn how to utilize program features to post information.

 

Structure:

            Course structure is a combination of lectures and hands-on exercises, aided by an exercise disk with sample files.

 

Outline:

 

Introduction to QuickBooks Pro 2006

Understanding Basic Accounting

Working with the QuickBooks Window

Backing up Your Company File

 

Creating a Company

Planning & Creating a Company

Customizing a Company File

Editing Your QuickBooks Preferences

Working with the Balance Sheet Reports

 

Customer Transactions

Working with the Customer: Job List

Understanding and Creating Service Items

Creating Invoices

Receiving Payments

Entering Sales Receipts

Making Deposits

 

Vendor Transactions

Entering Bills

Paying Bills

Writing Checks

Paying a Vendor with a Credit Card

Producing Vendor and P&L Reports

 

Banking with QuickBooks

Creating Bank Accounts

Transferring Funds

Credit Card Transactions

Reconciling Accounts

Viewing Banking Reports

 

Payroll

Managing the Employee List

Creating Paychecks

Processing Payroll Forms

 

Segment 9: Microsoft PowerPoint 2007

 

Participants:

            This segment has been designed for students who have no previous experience with Microsoft PowerPoint and who are interested in creating slide shows, charts, and other types of textual and graphical presentation.

 

Prerequisites:

            Segment 1: Computer Concepts / Using Windows XP

 

Objective:

Students will develop an understanding of PowerPoint 2007, learn how to create presentations, and learn how to utilize program features to create professional quality graphics and slides.

 

Structure:

            Course structure is a combination of lectures and hands-on exercises.

 

Outline:

 

·         Creating a Presentation

·         Adding and Editing Text

·         Adding & Deleting Slides

·         Selecting Objects

·         Entering Bulleted Information

·         Using the Bulleted List Slide

·         Using the Bullets and Numbering Command

·         Changing Slide Order                                                                                                                                  

·         Changing Slide Layout and Design

·         Adding Graphics

·         Inserting Graphics from Other Sources

·         Using WordArt

·         Animate Objects

·         Customizing the Animation

·         Rearranging the Slides

·         Printing the Presentation

·         Special Printing Options

·         Printing in Color

·         Viewing the Slide Show

·         Setting Up the Slide Show

·         Viewing the Slide Show

·         Adding Sounds

·         Controlling Sound Effects                                                                                                                           

·         Playing an Audio CD

 

 

Computer Applications Training Program

 

General Information

 

Instructor:                    Paul Neslusan

                                    Computer Systems Manager

                                    French River Education Center, Inc.

 

Class Times:                8:00 a.m. to 12:30 p.m.

                                    Monday thru Friday

 

Breaks:                         One 15-minute break

 

Topical Outline:           Segment 1:       Computer Concepts / Using Windows XP

                                    Segment 2:       Microsoft Internet Explorer 7.0

                                    Segment 3:       Microsoft Outlook 2007

                                    Segment 4:       Microsoft Excel 2007

                                    Segment 5:       Microsoft Word 2007

                                    Segment 6:       Microsoft Word 2007: Mail Merge

                                    Segment 7:       Microsoft Access 2007

                                    Segment 8:       QuickBooks Pro 2006

                                    Segment 9:       Microsoft PowerPoint 2007

 

 

Daily Schedule:            8:00—8:15        Typing Tutor

                                    8:15—8:45        Review of Previous Class

                                    8:45—9:45        Session A: Lecture and Exercises

                                    9:45—10:00       Session A Lab

                                    10:00 – 10:15    BREAK

                                    10:15—11:15     Session B: Lecture and Exercises

                                    11:15—11:30     Session B Lab

                                    11:30—12:25     Hands-on Exercises

                                    12:25—12:30     Review of Skill Mastery