MTC Logo

Home Calendar MailcanvasCareerCoach | IT Help mymtc | blog  Facebook  YouTube  LinkedIn  Instagram  Twitter 


Future Students

MTC Course Credit-by-Exam
OIS 1240 Computer Applications

Course Description:

This integrated, project-based course will help students use the software applications Microsoft® Word, Excel, PowerPoint, and Access to solve business problems. Students will use the Internet and e-mail as they research topics and prepare documents using the appropriate software applications. Course topics include technology history, future trends in technology, and the role of technology in a professional environment.

Scheduling the Credit by Exam:

The student must complete the credit-by-exam form and pay the fee ($45) for the exam in the MTC Business Office prior to taking the exam. The student must contact Kristy Taylor in Room 161C,, or telephone at 740-389-4636 Ext. 273 to schedule an appointment to take the credit by exam. The student must bring his or her receipt to the scheduled testing appointment.


The OIS 1240 CBE test your Microsoft Word, Excel, Access, and PowerPoint skills for a PC. The following MTC IT College Graduate Competency will be assessed as well:

  1. Use basic operating system functions including file management
  2. Connect to the Internet and use a Web browser to research and obtain information
  3. Create, send, and receive e-mail and attachments
  4. Create, edit, and print a professional document using a word processing application
  5. Create, edit, and print a professional document using a spreadsheet application

Students should be very familiar with the following features:


  • Headers/footers
  • Margins
  • Font selection and manipulation
  • Line Spacing
  • Formatting Numbers and Bullets
  • Columns
  • Find and Replace
  • Printing options
  • Naming conventions
  • Paste Functions including OLE
  • Citations and Bibliography
  • Mail Merge


  • Headers/footers
  • Margins
  • Font selection and manipulation
  • Formatting cells, columns, and rows
  • Calculations
  • Formulas
  • Labeling tabs
  • Charts
  • Naming conventions
  • Paste Functions including OLE


  • Create, modify, and navigate tables
  • Build and modify a basic query
  • Export data


  • Creating Slides
  • Templates
  • Headers/Footers
  • Speaker Notes
  • Paste Functions including OLE

File Management:

  • Creating folders and subfolders
  • Renaming items
  • Copying, moving, and deleting items


  • Sending, retrieving, and composing email through MTC student email accounts
  • Attachments


  • Effective search techniques
  • Citing URLs correctly
  • Multitasking





Connect with us

Contact us

Marion Technical College
1467 Mt. Vernon Ave.
Marion, Oh. 43302


College Hours

Get a personalized e-brochure

Did You Know?
Click here for MTC facts