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.