KELLOGG COMMUNITY COLLEGE
450 North Avenue • Battle Creek, MI. 49017 • 269.965.3931
Office Information Technology
Descriptions and Prerequisites
OIT 100 Introduction to Computer Information Systems 3 CR
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. Lab Fee
OIT 109 Keyboarding I 2 CR
Development of basic keyboarding skills for processing information. This course is designed to give students in a minimum amount of time the basic keyboarding number pad skills to input information into computers. Credit is not applicable toward the Office Information Technology certificate/degree program. Lab Fee
OIT 110 Keyboarding II 2 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99. This open entry course is designed to teach mastery of the keyboard, mechanics of the computer, accuracy and speed in typing, practice of basic office keyboarding skills, and production of office materials. Students will be introduced to basic document processing using Microsoft Word. Students will learn to create memorandums, modified block and block letters with envelopes, unbound and left-bound reports, and tables. Minimum speed attainment of 33 words per minute on a three-minute timing with five or less errors is necessary for the grade of “C.” Students enrolling in this course must know how to type using the touch method and be able to key for two minutes at 20 words per minutes with five or less errors. [0-32-32] Lab Fee
OIT 111 Keyboarding III 2 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99; and OIT 110. This open entry course is designed to teach continued emphasis on keyboarding techniques and development of speed and accuracy. Students will review and build mastery in the creation of memorandums, letters, reports, and tables. Students will be introduced to creating documents with graphics, as well as advanced Microsoft Word techniques used to enhance keyboarding. Minimum speed attainment of 48 words per minutes on a three-minute timing with five or less errors is necessary for a “C.” [0-32-32] Lab Fee
OIT 112 Keyboarding IV 2 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99; and OIT 111. This open entry course is designed for advanced keyboarding students. Students will be introduced to international keyboarding. They will learn to work with documents going to Canada, Mexico, France, Germany, and Japan. Students will also be introduced to typing both medical and legal documents. Emphasis will be placed on building keyboarding speed and accuracy. Students in this course will be simulating actual business-world activities with the creation and editing of their documents. Minimum speed attainment of 50 words per minute on a five-minutes timing with five or less errors is necessary for a “C.” [0-32-32] Lab Fee
OIT 116 Office Procedures 3 CR
A lecture course designed to prepare the learner for working in the changing office of the twenty-first century. Office and clerical responsibilities will be studied and practiced that will emphasize technology; communication skills needed for working in today's office; the changing nature of work; and the changing organizational structures, as well as critical thinking skills. The learner will also obtain hands-on exposure to the Internet and an electronic calendar program. The learner should plan on spending time on the computer outside of class to complete the hands-on portion of the class. [24-24-48]
OIT 160 Applications Software 3 CR
An introductory course surveying popular microcomputer software using hands-on instruction. Topics will include windows, word processing, spreadsheets, and databases. [16-32-48] Lab Fee
OIT 176 Beginning Word 2 CR
This open entry course introduces students to the basic features of Word. Major topics will include creating and editing a document, creating a research paper, using a wizard to create a résumé, creating a cover letter with a table, and creating web pages. [0-32-32] Lab Fee
OIT 177 Intermediate Word 2 CR
Prerequisite: OIT 176. This open entry course introduces students to the intermediate features of Word and prepares them for the Microsoft Office Specialist Core examination. 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 e-mail addresses using an Access table. [0-32-32] Lab Fee
OIT 178 Advanced Word 2 CR
Prerequisites: OIT 176, 177, or earned Microsoft MOS certification at the core level. This open entry course introduces students to the advanced features of Word and prepares them for the Microsoft Office Specialist Expert examination. 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. [0-32-32] Lab Fee
OIT 181 Beginning Excel 2 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99. This open entry course introduces students to the basic features of 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. [0-32-32] Lab Fee
OIT 182 Intermediate Excel 2 CR
Prerequisite: OIT 181. This open entry course introduces students to the intermediate features of 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. [0-32-32] Lab Fee
OIT 183 Advanced Excel 2 CR
Prerequisite: OIT 182. This open entry course introduces students to the advanced features of Excel and prepares students to take the Microsoft Office Specialist (MOS) Expert Certification exam. Major topics will include: 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. [0-32-32] Lab Fee
OIT 184 Beginning PowerPoint 2 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99. This open entry course introduces students to the basic levels of Microsoft PowerPoint. Students will be introduced to selecting a template, starting and customizing a new slide show 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 Microsoft Office Specialist (MOS) will be presented. [0-32-32] Lab Fee
OIT 185 Intermediate PowerPoint 2 CR
Prerequisite: OIT 184. This open entry course introduces students to the intermediate levels of Microsoft PowerPoint. Students will be introduced to adding sound effects and hyperlinks to slides, printing speaker notes, and using the macro recorder to create a macro. Upon completion of this course, students will be ready to take the Microsoft Office Specialist (MOS) Certification exam. [0-32-32] Lab Fee
OIT 187 Beginning Access 2 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99. This open entry lab course introduces students to the basics of Microsoft Access. Students will be introduced to creating a database using design and datasheet views, querying a database using the select query window, and maintaining a database using the design and update features of Access. Introductory information about the Microsoft Office Specialist (MOS) certification exam program will be presented. [0-32-32] Lab Fee
OIT 188 Intermediate Access 2 CR
Prerequisite: OIT 187. This open entry lab course introduces students to the intermediate features of Microsoft Access. Students will be introduced to creating reports, forms, and combo boxes; enhancing forms with OLE fields, hyperlinks, and subforms; and creating an application system using macros, wizards, and the switchboard manager. Upon completion of this course students will be ready to take the Microsoft Office Specialist (MOS) Certification exam. [0-32-32] Lab Fee
OIT 189 Advanced Access 2 CR
Prerequisite: OIT 188. This open entry lab course introduces students to the advanced features of Microsoft Access. Students will be introduced to advanced report techniques, advanced form techniques, advanced applications development techniques, integrating an Excel worksheet to an Access database, and Microsoft Office Specialist Expert examination requirements. Upon completion of this course students will be ready to take the Microsoft Office Specialist (MOS) Certification exam. [0-32-32] Lab Fee
OIT 190 Microsoft Outlook 3 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99. This open entry course introduces students to the basic and intermediate levels of Microsoft Outlook. Students will learn the capabilities of Outlook (such as attaching a file to a message, replying to and forwarding messages, organizing tasks by using folders, printing a task list, and using advanced calendar features). Upon completion of this course, students will be ready to take the Microsoft Office Specialist (MOS) Certification exam. [0-48-48] Lab Fee
OIT 192 Beginning Publisher 2 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99. This open entry course introduces students to the basics of Microsoft Publisher. This software is part of the highly successful Microsoft Office Suite. Publisher provides the basics for Desktop Publishing. Students will learn to create and edit a publication, design a newsletter, prepare a tri-fold brochure, create business forms and tables, and integrate Publisher with other Office applications. Students will work with customizing content, graphics, design sets, and color schemes. [0-32-32] Lab Fee
OIT 193 Beginning Project 2 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99. This open entry course is designed to introduce students to planning a project. The Microsoft Project Program enables you to define the steps that are needed to complete your end-of-project goal. You will learn to use the software to help calculate dates, responsibilities, and costs plus clearly communicate the project information to all those involved. Students will learn to complete basic project management, which includes defining, organizing, tracking, and communicating information about a project in order to meet a project goal. [0-32-32] Lab Fee
OIT 195 Introduction to the Internet 2 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99. This is open entry lab course. Little known a few years ago, the Internet is one of the more popular and fastest growing areas in computing. Today the Internet can be used to carry out research, shop, converse with people around the world, and in many other ways. In this course students will learn basics of using the Internet. Students will be able to move around, find, and retrieve information. Students will become familiar with search engines and master the art of communication using the Internet. [0-32-32] Lab Fee
OIT 196 Introduction to Windows 2 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99. This open entry lab course introduces students to the latest Windows operating system. Students will be introduced to the Windows Desktop, learn to use menus and toolbars, and learn to manage files in a Windows environment. [0-32-32] Lab Fee
OIT 197 Proofreading 2 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99. This open entry course is designed to teach students how to find and correct errors in written communication. Students will learn to concentrate, have patience, and pay attention to detail. Basic proofreading symbols will be introduced. Students will review formatting, spelling, and writing mechanics. Students will learn to use their proofreading skills on simulated real-world business documents. Lab Fee
OIT 200 Independent Study 1-3 CR
Prerequisite: departmental approval. Course may be repeated for additional credit. An opportunity for the interested student with a good scholastic record to pursue independently the study of some subject under the direction of a member(s) of the faculty. Subjects are chosen and arrangements made to suit the needs of individual students.
OIT 226 Legal Terminology 2 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99. This open entry lab course introduces students to basic legal terminology. Students will be learning the meanings of over 1200 words and phrases. Paralegals, legal administrative assistants, court reporters, law students, and others in the legal field will become more comfortable with their work after taking this course. Students will be using a self-directed CD which accompanies the book to help reinforce the terminology learned. [0-32-32] Lab Fee
OIT 227 Medical Terminology 2 CR
Prerequisite: COMPASS reading score of 70, or a “C” in STSK 98 or 99. This open entry lab 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. A self-paced computerized program allows the students to progress at their own rate. Emphasis is placed on spelling, definition, usage, and pronunciation. [0-32-32] Lab Fee
OIT 228 Medical Office Scheduling and Billing 3 CR
Prerequisite: OIT 227. This course introduces students to the basic features of using computers in the medical office. Students will learn to input patient information, schedule appointments, enter transactions, file insurance claims and bill patients, review and record payments, and balance accounts. The HIPAA Privacy and Security Rules will be presented. Students will learn how to use NDCMedisoft Advanced, widely-used medical administrative software. This software is only available in the KCC Open Entry labs. Students should be able to type 30 wpm before taking this course. Lab Fee
OIT 229 Medical Coding 2 CR
Prerequisites: OIT 227 and 228. This open entry course introduces students to the skills needed to be a successful physician practice medical coder. Students will learn to review patients' medical records and assign diagnosis and procedure codes. Proofreading skills and accuracy will be stressed because accurate coding is a critical part of ensuring that claims follow the legal and ethical requirements of government programs and other payers, as well as the federal HIPAA laws. Medical Coder Certification will be discussed. Lab Fee
OIT 241 General Machine Transcription 3 CR
Prerequisites: COMPASS reading score of 70, or a “C” in STSK 98 or 99; and a "C" in OIT 111. This open entry course is designed to provide an introduction to the operation of the machine transcriber, a review of basic English, spelling and transcription skills, and provide practice in applying the cognitive skills of spelling, punctuation, and grammar to the transcription of letters and memos. Machine transcription is a fusion of skills that combines the sub skills of keyboarding, oral and written communication, listening, and decision making. Lab Fee
OIT 243 Legal Machine Transcription I 2 CR
Prerequisites: OIT 241 or departmental approval, PARA 110 or a legal terminology background, ENGL 120 or 151, keyboarding skills of at least 45 wpm, and familiarity with Microsoft Word or WordPerfect. This open entry course will provide a basic study of legal transcription techniques; the formatting of legal documents; and the sub-skills of keyboarding, oral and written communications, listening, and decision making, which are necessary to work in a legal environment. Lab Fee
OIT 244 Legal Machine Transcription II 2 CR
Prerequisites: OIT 241 and 243, PARA 110 or legal terminology background, ENGL 120 or 151, keyboarding skills of at least 45 wpm, familiarity with Microsoft Word or WordPerfect. This open entry course will build on the legal transcription skills learned in OIT 243 and introduce students to intermediate transcription skills needed in working in different legal specialty environments. Lab Fee
OIT 245 Medical Machine Transcription I 2 CR
Prerequisites: OIT 241, 227 or medical terminology background, ENGL 120 or 151, keyboarding skills of at least 45 wpm, familiarity with Microsoft Word or WordPerfect. This open entry course will provide a basic study of medical transcription techniques; the formatting of medical documents; and the sub-skills of keyboarding, oral and written communication, listening, and decision making, which are necessary to work in a medical environment as a transcriptionist. Lab Fe
NOTE: The course descriptions for the Cooperative Education course electives within the Office Technology Program (OIT) can be found under the Information Technology (IT) course descriptions within this section of the catalog.