CMIS 175 - Microcomputer Applications

4 Credit (4 lecture, 0 lab) 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. Develop mailings (form letter, envelopes, mailing labels) using secondary data sources.
3. Create documents which include data elements such as tables and charts.
4. Apply formatting techniques (character and paragraph) to enhance document appearance.
5. Develop a professional newsletter.
   1. Apply multiple column techniques.
   2. Utilize multiple sections.
   3. Create graphics using the Diagram function.
   4. Apply appropriate breaks (section, page, column, continuous).

Goal 2:  Excel

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.

Goal 3:  Integration

1. Start two applications.
2. Explain source document, destination document, and object.
3. Select a range to copy in the source document.
4. Copy the selected range in the source document to the Clipboard.
5. Switch from the source document application to the destination document application.
6. Paste the object on the Clipboard in the destination document.
7. Embed the object on the Clipboard in the destination document.
8. Link the object on the Clipboard to the destination document.
9. Tile two application windows on the screen to view both at the same time.
10. Drag and drop an object between tiled applications.
11. Embed an existing file or create and embed an object without leaving an application.

Goal 4:  Microsoft Access

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 links to the Web.
   5. Create calculated controls.
   6. Design forms which include linked subforms.
3. Create macros to automate basic processes.
4. Design a customized menu system using the switchboard system.
5. Implement multiple table relations.
   1. Incorporate rules for referential integrity.
6. Create pivot tables.

Goal 5:  PowerPoint

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
5. Develop presentations based on Word generated outline.