2023-2024 Catalog 
    May 28, 2024  
2023-2024 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CMIS 175 - Microcomputer Applications

4 Credit: (4 lecture, 0 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.
OFFERED: fall semesters

Course Goals/ Objectives/ Competencies:
Goal 1:  Demonstrate comprehensive document development and editing skills using Microsoft Word.

  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)
  1. Develop spreadsheet templates
  2. Acquire data from other spreadsheets through the use of 3-D formulas.
  3. Consolidate data from multiple workbooks
  4. 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
  1. 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
  1. Implement multiple table relations
  1. Incorporate rules for referential integrity
  1. 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

Add to Portfolio (opens a new window)