CMIS 175 - Microcomputer Applications

4 Credit: (4 lecture, 0 lab, 0 clinical) 4 Contact Hours: [CMIS 115  or (CMIS 256 , CMIS 257 , CMIS 258 , and CMIS 259 )]

1. Modify graphical elements using layering, grouping, and watermark techniques.
2. Create documents which include data elements such as tables and charts.
3. Apply formatting techniques (character and paragraph) to enhance document appearance.
4. Develop a professional newsletter.

1. Apply multiple column techniques.
2. Utilize multiple sections.
3. Create graphics using the SmartArt function.
4. Apply appropriate document breaks (section, page, column, continuous.)

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

1. Develop spreadsheets using various financial functions (e. g. PMT, FV, PV).
2. Implement data tables (one and two input) to display financial data
3. Apply formatting techniques (e. g. borders, background colors, shading) to enhance spreadsheets
4. Illustrate data using various chart types
5. Use data mining methods to generate reports

1. Create data lists/tables
2. Apply filters
3. Derive database statistics from d-functions (e. g. dcount, daverage, dsum)

6. Develop spreadsheet templates
7. Acquire data from other spreadsheets through the use of 3-D formulas.
8. Consolidate data from multiple workbooks
9. Incorporate the use of Pivot Tables and Pivot Charts

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

1. Create custom reports

1. Develop summary reports with calculated controls
2. Design reports where multiple tables are used
3. Modify format characteristics to enhance appearance

2. Develop custom forms

1. Apply lookup controls linked to other tables
2. Integrate data from multiple tables
3. Rearrange controls
4. Create calculated controls
5. Design forms which include linked subforms

3. Implement multiple table relations

1. Incorporate rules for referential integrity

4. Create pivot tables

Goal 4:  Develop Microsoft PowerPoint presentations using templates and runtime presentation settings.

1. Apply custom backgrounds to presentations
2. Modify clipart using ungroup/group techniques
3. Change the master slide to create unique slide designs
4. Apply runtime presentation settings

1. Transitions
2. Slide timings
3. Builds
4. Animation schemes
5. Animated graphics

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

1. Paste the object on the Clipboard in the destination document
2. Embed the object on the Clipboard in the destination document
3. Link the object on the Clipboard to the destination document