Course Outline

 

Home Up General Services Bookkeeping Other Resources

 

 

Each of the following courses is a total of 15 hours, divided into five 1 ˝ hour instructor-led sessions, followed by a 1 ˝ hour open minimum supervised lab. MCS offers individual as well as group training. In order to create an effective learning environment, we limit our groups to four attendees. Group training is $275.00 per student--per course and our Individual course is $375.00 --per course.

The above charges include all courseware, however if books are lost or damaged replacement books are available at an additional charge of $15.00.

We like the idea of "tell you what we are teaching you, teach you, tell you what we taught you". Meaning that we will show you what to expect by you viewing a small demonstration at your computer workstation and on your own monitor, then we give the control of the computer back to you and walk you through the exercise. Last we discuss what we did and why we would do it. Lastly, you do at least three repetitions of the same exercise. It is very quality learning!

Please note the following course descriptions:

                    Course Name:                     Course Outline:

MCS-101.1

Microsoft Windows

 

Includes computer terms, working with the Windows environment. Using the mouse, icons, menus, and dialog boxes. Running multiple application, and switching between them and more.

MCS-101.2

Microsoft Windows

 

Learn to organize files and folders, copy, move and delete files. Find lost files, restarting, troubleshooting and shortcut tips.

 

MCS-102.1

Microsoft Word

Access and identify the parts of the screen. Navigate and explore different viewing options and use Help. Create basic documents and envelopes using basic editing features. Save, preview and print.

MCS-102.2

Microsoft Word

Apply formatting using the keyboard, menu, shortcut menus and toolbars. Work with attributes, justification, indenting and line spacing, set tabs and tab alignment. Adjust the page layout. Control pagination and create headers and footers.

MCS-102.3

Microsoft Word

 

Copy/cut and paste text and formats. Understand section breaks. Create numbered and bulleted lists. Create and format a table. Use multiple documents, copy information from one document to another.

MCS-102.4

Microsoft Word

Find and replace text and formatting, spell and grammar checkers, and use the thesaurus. Use and create templates and managing your files.

 

MCS-103.1

Microsoft Excel:

Access the program, identify the parts of the screen. Using the mouse, keyboard, menus, icons to navigate around the worksheet and use Help. Data entry techniques, editing and deleting, basic formulas, formatting, saving, previewing and printing.

MCS-103.2

Microsoft Excel:

Range names, copy and move data and formulas. Insert/delete rows and columns, AutoFill, copy absolute reference formulas, calculate statistical functions, let the computer help you enter formulas.

MCS-103.3

Microsoft Excel:

Navigating between several worksheets, copying data and formulas. Edit data and formulas, rename worksheets. Calculate several sheets into one sheet. Working with financial functions, calculate the payment of a loan, calculate the amount of a loan based on a given payment. Spell check and replace text.

MCS-103.4

Microsoft Excel:

Copy and format multiple sheets simultaneously. Create charts, text box, use drawing tools and exiting Excel.

 

MCS-104.1

Microsoft

Power Point:

Access the program, identify the parts of the screen, using the menu system with and without the mouse, navigating through the document, and explore different view options. Create and format text charts.

MCS-104.2

Microsoft

Power Point:

Design pie charts and XY charts. Use Auto-content to help you create a presentation. Create column charts. Learn to import data from your spreadsheet. Learn to create line graphs.

MCS-104.3

Microsoft

Power Point:

Design Organizational Charts. Insert linked text. Preview and print presentations. Create a slide show presentation

MCS-105.1

Internet using Netscape Communicator or Windows Explorer:

Internet fundamentals which include; What is the Internet, What resources are on the Internet, and what is a browser? We experiment with starting and customizing your browser and navigating and searching the Internet. Marking locations and electronic mail.

 

MCS-106.1

Microsoft Access:

Explore an existing database, create a new database, modify a database & define table relationships.

MCS-106.2

Microsoft Access:

Edit and format the appearance of your data, find records, using a form, filtering and sorting your data.

MCS-106.3

Microsoft Access:

Querying to select records, use multiple criteria, use queries to perform calculations and save queries for repeated use.

MCS-106.4

Microsoft Access:

Join several related tables, customize a basic report, perform calculations and exit MS Access.

 

MCS-107

Court Documents Made Easy

Setup templates for file folder labels, form letters & envelopes; Setup section sign macro and setup court documents templates for: • Easy-to-use caption •Table of Contents •Table of Authorities • Setup page numbering

 

MCS-108.1

QuickBooks Pro:

Access the program and company file, create a company file, and access help.  Understand and access the Navigator, add & modify the Chart of Accounts. Create & modify the Item list, Customer list, Employee list and Vendor list.

MCS-108.2

QuickBooks Pro:

Create & modify invoices, sales receipts, and credit memos. Write checks, use the check register, setup and enter credit card transactions. Record & pay bills, receive & record payments and deposits, use the accounts payable register, pay sales tax, pay credit card statements.

MCS-108.3

QuickBooks Pro:

Reconcile checking and credit card accounts. Setup payroll information and pay employees. Display quick reports, modify/customize and print reports. Back-up and restore a company file.

 

MCS-109.1

ACT!

Access the program and database, window elements, using menus, toolbar, status bar, alert boxes, and keyboard shortcuts. Displaying specific contacts and changing contact screens. Use Lookup to locate contact, customize contact list and use Help. Create a new database, enter your company information and set/change password. Add new contacts, set default values and duplicate records for different contacts. Inert and delete text, delete contact records and print records. Change field names, use drop-down boxes and customize contact screen.

MCS-109.2

ACT!

Schedule phone call, meetings, alarms, and other activities. Modify and clear activities. Create a note. Create and remove recurring activities. Create a task list, display and modify task lists. Display, modify, move and print calendars. View contacts, specific contacts, use filter to list sets of contacts. Setup and print calendars.

MCS-109.3

ACT!

Using look-ups and groups. Querying, using wildcards Create, display and modify a group. Modify data for a group of contacts. Generate and print reports, standard reports, task list reports, contact reports. Create a contact letter, edit, save, print letters and a fax cover page. Modify, save, printing and generating form letters.

 

MCS-110

Situational:

For the person who has had training already, situational lab only of Word, Excel and/or Power Point Excel including copy & linking between Word and Excel. Includes instructor led training on faxing the finished document right from the computer and Windows’ messaging, send, receive, reply, forward, print and save.

 

Our keyboarding course is a total of 15 hours of a computer-based self running tutorial, The keyboarding course is $150.00.

MCS-111

Keyboarding

The student will learn touch typing using a computer. Students progress at their own speed, within a given time frame, through the alphabet and then the numeric keyboard. Emphasis is placed upon proper typing techniques, and parts of the keyboard.

 

 

 

Send mail to Micky@gr8teachers.com with questions or comments about this web site.
Copyright © 2006 Micky's Computer Services
Last modified: October 31, 2006