MTC Logo


MyCourses/Canvas     MyMTC    IT Help    Mail    Calendar        






 

 

 

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, taylork@mtc.edu, or telephone at 740-389-4636 Ext. 4115 to schedule an appointment to take the credit by exam. The student must bring his or her receipt to the scheduled testing appointment.

Objectives:

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:

Use basic operating system functions including file management

Connect to the Internet and use a Web browser to research and obtain information

Create, send, and receive e-mail and attachments

Create, edit, and print a professional document using a word processing application

Create, edit, and print a professional document using a spreadsheet application


Students should be very familiar with the following features:

Word:

  • 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

Excel:

  • Headers/footers

  • Margins

  • Font selection and manipulation

  • Formatting cells, columns, and rows

  • Calculations

  • Formulas

  • Labeling tabs

  • Charts

  • Naming conventions

  • Paste Functions including OLE

Access:

  • Create, modify, and navigate tables

  • Build and modify a basic query

  • Export data

PowerPoint:

  • Creating Slides

  • Templates

  • Headers/Footers

  • Speaker Notes

  • Paste Functions including OLE

File Management:

  • Creating folders and subfolders

  • Renaming items

  • Copying, moving, and deleting items

Email:

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

  • Attachments

Internet:

  • Effective search techniques

  • Citing URLs correctly

  • Multitasking

 

Contact us

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

740.389.4636
enroll@mtc.edu

College Hours

Did You Know?
Click here for MTC facts