CIS 112 Spreadsheets/Graphics Processing

Campus Location:
Georgetown, Dover, Stanton, Wilmington
Effective Date:
CIS 107, SSC 100 or concurrent


Course Credits and Hours:
3.00 credits
2.00 lecture hours/week
2.00 lab hours/week
Course Description:

This course covers advanced spreadsheet concepts and skills using spreadsheet graphics tools to create charts, graphs, and external applications. Additional topics include advanced formatting and macro creation.

Required Text(s):


Additional Materials:


Schedule Type:
Classroom Course
Hybrid Course
Online Course


Core Course Performance Objectives (CCPOs):
  1. Design a spreadsheet using advanced formatting, formulas, and data management. (CCC 6)
  2. Create an automated spreadsheet using macros. (CCC 6)
  3. Generate graphics based on spreadsheet data. (CCC 6)
  4. Use the data analysis features of spreadsheets to solve common business problems. (CCC 2, 6)


Measurable Performance Objectives (MPOs):

Upon completion of this course, the student will:

    1. Create a spreadsheet using advanced formatting techniques.
    2. Use pre-defined functions and formulas to calculate values.
    3. Identify and describe specific functions.
    4. Use correct cell address reference to enter formulas and functions.
    5. Apply conditional formatting to enhance the display of the spreadsheet.
    6. Create and use pivot tables, charts, and spark lines to summarize and consolidate data.
    7. Manipulate multiple worksheets and workbooks.
    8. Protect a workbook and multiple worksheets.
    9. Create a spreadsheet using templates.
  2. Create an automated spreadsheet using macros.
    1. Explain the concept and purpose of macros.
    2. Demonstrate proper use of macros.
    3. Use macros to automate a spreadsheet.
    4. Troubleshoot and debug macros.
    5. Create and use lists of data.
    6. Create worksheet templates using macros.
  3. Generate graphics based on spreadsheet data.
    1. Create a visual representation of a spreadsheet.
    2. Interpret trends based on spreadsheet data and graphics.
    3. Compare and contrast different graphics using the same set of data.
    4. Select the appropriate graphic(s) for a specific set of data.
    1. Use a spreadsheet to perform what-if analysis.
    2. Integrate spreadsheets with other applications such as the World Wide Web, Microsoft Word, and Microsoft PowerPoint.
    3. Import and export data from and to external sources.
    4. Publish spreadsheets to external applications, such as Portable Document Folder (PDF) or webpage.
    5. Use the analysis feature of a spreadsheet to recommend a solution to a given business problem.
Evaluation Criteria/Policies:


92 100 = A
83 91 = B
75 82 = C
0 74 = F


  1. Apply clear and effective communication skills.
  2. Use critical thinking to solve problems.
  3. Collaborate to achieve a common goal.
  4. Demonstrate professional and ethical conduct.
  1. Install, configure, and secure computer applications and operating systems.
  2. Design, write, and debug computer programs.
  3. Design and integrate databases in computer programs
  4. Analyze and design complex computer applications to solve business problems.
  5. Integrate the principles of the Internet into web development.
  6. Incorporate the principles of networking and information security in computer application development.
Disabilities Support Statement:


Minimum Technology Requirements: