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
Add to Portfolio (opens a new window)
|