CIS 112 Spreadsheets/Graphics Processing


Campus Location:
Georgetown, Dover, Stanton, Wilmington
Effective Date:
2018-51
Prerequisite:
CIS 107, SSC 100 or concurrent
Co-Requisites:

none

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):

Obtain current textbook information by viewing the campus bookstore online or visit a campus bookstore. Check your course schedule for the course number and section.

Additional Materials:

None

Schedule Type:
Classroom Course
Hybrid Course
Online Course
Disclaimer:

None

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)

See Core Curriculum Competencies and Program Graduate Competencies at the end of the syllabus. CCPOs are linked to every competency they develop.

Measurable Performance Objectives (MPOs):

Upon completion of this course, the student will:

  1. Design a spreadsheet using advanced formatting, formulas, and data management.
    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.
  4. Use the data analysis features of spreadsheets to solve common business problems.
    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:

Students must demonstrate proficiency on all CCPOs at a minimal 75 percent level to successfully complete the course. The grade will be determined using the Delaware Tech grading system:

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

Students should refer to the Student Handbook for information on the Academic Standing Policy, the Academic Integrity Policy, Student Rights and Responsibilities, and other policies relevant to their academic progress.

 
Core Curriculum Competencies (CCCs are the competencies every graduate will develop):
  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.
  5. Use information literacy for effective vocational and/or academic research.
  6. Apply quantitative reasoning and/or scientific inquiry to solve practical problems.
Program Graduate Competencies (PGCs are the competencies every graduate will develop specific to his or her major):
  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:

The College is committed to providing reasonable accommodations for students with disabilities. Students are encouraged to schedule an appointment with the campus Disabilities Support Counselor to request an accommodation needed due to a disability. A listing of campus Disabilities Support Counselors and contact information can be found at the disabilities services web page or visit the campus Advising Center.

Minimum Technology Requirements:
Minimum technology requirements for online, hybrid, video conferencing and web conferencing courses.