CMIS 175 - Microcomputer Applications

4 Credit: (2 lecture, 2 lab, 0 clinical) 4 Contact Hours: [CMIS 115 ]

This continuation of CMIS 115 further develops word processing, spreadsheet, database and presentation software techniques using Microsoft Office. Intermediate skills using these applications are developed through applied projects within a business context.
Semesters Offered: fall semesters

Course Goals/ Objectives/ Competencies:
Goal 1: Construct comprehensive documents using advanced features in Microsoft Word.

Modify templates, themes, and styles
Manage quick parts
Create form letters, mailing labels, and a directory using mail merge
Optimize a document for online viewing and collaboration

Goal 2: Develop Microsoft Excel spreadsheets to solve financial and data-based problems.

Manage data using Excel’s data tools
Generate reports from multiple worksheets and workbooks
Summarize data with PivotTables
Perform what-if analyses

Goal 3: Create Microsoft Access databases to generate custom reports, forms, and tables.

Create advanced queries
Enhance table design
Use form tools
Create custom forms
Create custom reports
Share, integrate, and analyze data

Goal 4: Create advanced electronic presentation using Microsoft PowerPoint.

Apply advanced formatting to objects
Apply advanced animations
Distribute presentations

Goal 5: Integrate data between Word, Excel, Access, and PowerPoint.

Paste the object on the Clipboard in the destination document
Embed the object on the Clipboard in the destination document
Link the object on the Clipboard to the destination document