Computer Course Syllabi
Course Content
Click on the links below to view course content. If you have additional questions, please call (863) 499-2717 and ask for Heather Perkins or Tracy Michaels.
You can also send an email to Heather Perkins.
Introduction to Personal Computers
Prerequisites: None
This hands-on course is designed for the novice. The topics include
hardware and software; an introduction to the Windows operating
system; primary and secondary memory including RAM, ROM, the hard
disk and USB drives; shopping for computers; computer protection and
security; using the mouse and keyboard; booting a computer; creating
and saving files; and an overview of the Internet and software
applications.
Introduction to Microsoft Windows XP
Prerequisite: Introduction to Personal Computers
This hands-on course is an introduction to the Windows operating
system. The topics that will be discussed include starting Windows;
the program manager; using the mouse; the Help feature; desktop
shortcuts; the control panel; multitasking; creating and deleting
folders; working with the Windows menu system; the desktop; working
in dialog boxes; using My Computer and the Windows Explorer; and
using the clipboard to copy and paste files.
Introduction to Microsoft Word
Prerequisites: Basic Windows skills.
This hands-on course is an introduction to Microsoft’s
word-processing application, Word. Course content includes menus and
toolbars; keyboard shortcuts; entering and editing text; naming and
saving documents; opening existing Word documents; selecting text;
moving, copying, pasting and deleting text; using the Help feature;
formatting text; working with AutoCorrect; inserting special
characters; page setup and printing; using proofing tools; working
with paragraph settings; working with columns; setting tab stops;
headers and footers; sectioning documents; and bulleted and numbered
lists.
Intermediate Microsoft Word
Prerequisites: Basic Windows and Microsoft Word skills.
This hands-on course builds upon the Introduction to Microsoft Word
topics. Course content includes managing files; working with tables
and columns; working with AutoFormat and styles; working with
AutoText and macros; working with graphics and clipart; using Mail
Merge; working with envelopes and labels and using the Drawing
toolbar.
Advanced Microsoft Word
Prerequisites: Basic Windows and Microsoft Word skills.
This hands-on course offers advanced Microsoft Word topics including
sharing information with other programs such as Excel, PowerPoint,
and Access; working in Outline view; inserting footnotes and
endnotes; creating a table of contents or index; working with master
documents; inserting comments; creating bookmarks and
cross-referencing; creating and modifying a chart; creating and
using forms and templates; and creating HTML documents in Microsoft
Word.
Introduction to QuickBooks Pro
Prerequisites: Basic Windows skills.
This hands-on course offers introductory skills for the novice.
Learn how your company’s finances flow through QuickBooks software.
Course content includes entering and processing checks, bills, and
payments. Set up accounts, customers, vendors, items, and jobs. Work
with inventory and invoices. Create company books from scratch.
Microsoft PowerPoint
Prerequisites: Basic Windows skills.
This hands-on course offers a working overview of Microsoft’s
presentation application, PowerPoint. Course content includes using
the AutoContent Wizard; PowerPoint default settings; menus and
toolbars; creating and saving files; using the Help feature; working
with existing PowerPoint files; working with slide layouts; adding
text and graphic placeholders.
Topics in this course also include working in outline view; using notes pages; working with slide masters; using cut, copy, paste, and the clipboard; using proofing tools; working with backgrounds and design templates; adding tables, charts, graphics and clipart; annotating slides; working with timings, animations, sounds and effects; printing slides; and hyperlinks.
Introduction to Microsoft Excel
Prerequisites: Basic Windows skills.
This hands-on course is an introduction to Microsoft’s spreadsheet
application, Excel. Course content includes menus and toolbars;
Excel default settings; keyboard shortcuts; entering and editing
data; naming and saving documents; opening existing Excel documents;
selecting data; moving, copying, pasting and deleting data; creating
custom lists; using the Help feature; formatting labels and values;
creating and using range names; working with Excel features such as
AutoSum, Paste Function, and AutoFill; relative and absolute
references; adjusting column widths and row heights; formatting cell
contents; basic formulas and functions; comments; working with page
setup; and printing.
Intermediate Microsoft Excel
Prerequisites: Basic Windows and Microsoft Excel skills.
This hands-on course builds upon the Introduction to Microsoft Excel
topics. Course content includes managing workbooks and worksheets;
charts; freezing columns and rows; hiding data; simple macros;
working with lists; linking; sorting and filtering data; using Excel
features such as Subtotals, Consolidating and the Scenario Manager,
one- and two-input Data Tables; and data validation
Advanced Microsoft Excel
Prerequisites: Basic Windows and Microsoft Excel skills.
This 12-hour, hands-on course offers advanced Microsoft Excel topics
that includes a sampling of the many function categories available;
the conditional format feature; using range names; importing data
into Excel; using Excel data in other Microsoft applications; and a
basic overview of Pivot Tables.
Introduction to Microsoft Access
Prerequisites: Basic Windows skills.
This hands-on course introduces Microsoft’s powerful database
application, Access. Course content includes an overview of
databases; the relational database concept; creating and saving an
Access database file, working with in the Access window; menus and
toolbars; default Access settings; using the Help feature; working
in design view and saving Access objects; creating tables; using a
table wizard; field properties; primary key fields; input masks;
table relationships; creating and editing select and union queries;
using a query wizard; querying and sorting data; creating forms
using a wizard; adding form controls and working with their
properties; form headers and footers; setting the tab order; and
working with form designs.
Intermediate Microsoft Access
Prerequisites: Basic Windows and Microsoft Access skills.
This course builds on the Introduction to Microsoft Access topics.
Course content includes creating and working with reports; adding
report objects and working with their properties; working with
report layouts and grouping options; creating calculated fields;
report headers and footers; page setup and printing; using a report
wizard; creating and saving macros; creating command buttons on
Access objects; finding, sorting and filtering data; importing and
exporting Access data from other applications such as Excel, Word,
txt files, and DBase; subforms; and hyperlinks
Introduction to Microsoft Outlook
Prerequisites: Basic Windows skills.
This hands-on course offers a working overview of Microsoft’s mail
program, Outlook. Course content includes exploring the Outlook
window and viewing options; working with menus and toolbars; the
Outlook Bar; creating and deleting folders; the Help feature;
e-mail; default settings; working with contacts, the inbox, the
calendar, notes, task lists and the journal; deleting and archiving
messages; creating distribution lists; the Meeting Planner; and
working with scheduling and reminders.
Working with the Internet
Prerequisites: Introduction to Personal Computers; Introduction
to MS Windows.
This hands-on course is designed as an overview of working with the
Internet. The topics include working with browsers; setting up an
e-mail account; downloading files; surfing the web; netiquette;
copying and pasting internet information; setting a default web
site; working with history lists; and more.
Microsoft Word
- Introduction to MS Word 2007
- Introduction to MS Word 2003
- Intermediate MS Word 2003
- Advanced MS Word 2003
Microsoft Excel
- Introduction to MS Excel 2007
- Introduction to MS Excel 2003
- Intermediate MS Excel 2003
- Advanced MS Excel 2003