Kellogg Community College is offering 11 online courses as part of the Office Information Technology (OIT) Program this fall, which are listed below.
Whether you’re interested in advancing in your OIT associate or certificate program this fall or simply want to pick up a new skill by becoming an expert in information processing software like Microsoft Word, Excel or PowerPoint, the courses listed below will provide you with the instruction you need while allowing you to absorb it all from anywhere you have access to the Internet.
All of the below classes run from Aug. 27 to Dec. 14, 2015, and each class is limited to just 24 students – so act fast if you want a place in a specific class.
The course descriptions listed below are from the Office Information Technology (OIT) section of KCC’s latest Academic Catalog. View the OIT catalog section through the link for information about the required prerequisites for each course.
For more information about the OIT Program, visit www.kellogg.edu/office-information-technology-oit. For information about registering for fall classes, visit www.kellogg.edu/registration.
Fall 2015 Online OIT Courses at KCC
OIT-100-90: Introduction to Computer Information Systems
3 credits
Fees: $50
The principles of information technology relating to business are covered (including hardware, software, communications, networks, the Internet and information systems). Programming concepts, Web page creation, navigation of the World Wide Web, and use of application software are introduced to assist the student in developing a technology learning plan. This course presents strategies for purchasing, installing and maintaining a computer system. Students will be exposed to career planning and industry standard certifications to help achieve personal and professional goals involving information technology. Students are expected to spend time working online with a computer beyond the assigned activities. Discussions and class activities are designed to assist students with no prior information technology experience to be successful.
OIT-160-90: Applications Software
3 credits
Fees: $53
An introductory course surveying popular microcomputer software using hands-on instruction. Topics will include Windows, word processing, spreadsheets and databases.
OIT-176-90: Beginning Word
2 credits
Fees: $42
This individualized instruction course introduces students to the basic features of Microsoft Word. Major topics will include creating and editing a document, creating a research paper, using a wizard to create a resume, creating a cover letter with a table and creating Web pages.
OIT-177-90: Intermediate Word
2 credits
Fees: $40
This individualized instruction course introduces students to the intermediate features of Microsoft Word and prepares them for the Microsoft Office Specialist (MOS) Core Certification exam. Major topics will include creating a document with a table, chart and watermark; generating form letters, mailing labels and envelopes; creating a professional newsletter; and integrating merged form letters to email addresses using an Access table.
OIT-178-90: Advanced Word
2 credits
Fees: $40
This individualized instruction course introduces students to the advanced features of Microsoft Word and prepares them for the Microsoft Office Specialist (MOS) Expert Certification exam. Major topics will include working with a master document, an index and a table of contents; creating an online form; using Visual Basic for applications with Word; and linking an Excel worksheet and charting its data in Word.
OIT-181-90: Beginning Excel
2 credits
Fees: $42
This individualized instruction course introduces students to the basic features of Microsoft Excel. Major topics will include creating a worksheet and embedded chart; formulas, functions, formatting and Web queries; what-if analysis, charting and working with large worksheets; and creating static and dynamic Web pages using Excel.
OIT-182-90: Intermediate Excel
2 credits
Fees: $40
This individualized instruction course introduces students to the intermediate features of Microsoft Excel and prepares students to take the Microsoft Office Specialist (MOS) Core Certification exam. Major topics will include financial functions, data tables, amortization schedules and hyperlinks; creating, sorting and querying a worksheet database; creating templates and working with multiple worksheets and workbooks; and linking an Excel worksheet to a Word document.
OIT-183-90: Advanced Excel
2 credits
Fees: $40
This individualized instruction course introduces students to the advanced features of Microsoft Excel and prepares students to take the Microsoft Office Specialist (MOS) Expert Certification exam. Major topics will include the creation and manipulation of business-formatted worksheets and charts using appropriate functions and formulas in Excel; creation of worksheets utilizing data tables, hyperlinks, databases, templates and consolidated capabilities; integration of graphics, Word, Access and Excel data into appropriate business reports, etc.; using Visual Basic for Applications code to create procedures for specific worksheets; using advanced techniques to audit and validate data, solve problems using Excel’s Solver, Scenario Manager and Pivot Table, Pivot Chart and Data Map utilities; importing and exporting data and collaborating on worksheets tracking data changes; and Microsoft Office Specialist (MOS) Expert Certificate exam objectives.
OIT-184-90: Beginning PowerPoint
2 credits
Fees: $42
This individualized instruction course introduces students to the basic levels of Microsoft PowerPoint. Students will be introduced to selecting a template; starting and customizing a new slideshow from an outline; saving and reviewing a presentation; viewing a Web page using a browser; and publishing a presentation as a Web page. Introductory information about the Microsoft Office Specialist (MOS) Certification exam program will be presented.
OIT-187-90: Beginning Access
2 credits
Fees: $42
This individualized instruction course introduces students to the basics of Microsoft Access. Students will be introduced to creating a database using design and datasheet views; creating queries, forms, reports, labels and relationships; and using conditional formatting, aggregate functions and filters/sorts within Microsoft Access. Introductory information about the Microsoft Office Specialist (MOS) Certification exam program will be presented.
OIT-227-90: Medical Terminology
2 credits
Fees: $42
This individualized instruction course introduces students to basic medical terminology. Prefixes, suffixes, word roots, combining forms, special endings, plural forms, abbreviations and symbols are included in the content. This course uses computer software to assist students in studying the terminology and in assessing their mastery of the material. Exams are also taken via the computer. Emphasis is placed on spelling, definition, usage and pronunciation.
OIT Degrees & Certificates
KCC offers several OIT Program associate of applied science degrees and certificates, which are listed below.
Associate of Applied Science Degrees
- Administrative Assistant
- Medical Administrative Assistant
- Microcomputer Applications Specialist
- Legal Administrative Assistant
- Word/Information Processing
Certificate Programs
- Administrative Assistant
- Legal Administrative Assistant
- Medical Administrative Assistant
- Microcomputer Applications
- MOS Master Preparation
- Word/Information Processing
For more information about the OIT Program, visit www.kellogg.edu/office-information-technology-oit. For information about registering for fall classes, visit www.kellogg.edu/registration. Fall classes begin Aug. 27.