CGS 1515 - Spreadsheet Techniques and Programming

College of Computer & Information Technology

Credit(s): 3
Contact Hours: 47
Effective Term Fall 2018 (550)

Requisites

Prerequisite COP 1000 with a minimum grade of C or
Prerequisite CGS 1100 with a minimum grade of C

Course Description

Program strongly recommends completion of General Education Math requirement prior to taking CGS 1515. This course will provide students with hands-on experience and skills with a spreadsheet. Students will learn the various functions and commands of the spreadsheet as well as how to plan, create, and program spreadsheets for common business applications. It is appropriate for accounting and business majors, programmers and spreadsheet application developers.

Learning Outcomes and Objectives

  1. The student will create a complex spreadsheet to achieve business standards by:
    1. Planning the structure and format
    2. Applying financial, lookup, statistical and logical functions
    3. Constructing formulas using absolute, relative and mixed cell referencing
  2. The student will analyze data by:
    1. Designing graphs and charts to compare and contrast data
    2. Applying advanced functions, formulas and rules
    3. Solving “what if”, “goal-seek” and other problems
    4. Creating pivot tables and pivot charts
  3. The student will use tools to eliminate detailed, repetitive routines by:
    1. Creating/writing macros
    2. Editing/deleting macros using Visual Basic for Applications (VBA) programming language

Criteria Performance Standard

Upon successful completion of the course the student will, with a minimum of 70% accuracy, demonstrate mastery of each of the above stated objectives through classroom measures developed by individual course instructors.

History of Changes

DBT 11/21/89 Online, effective 20001 DBT 5/17/94 Eff 20011 (I, 2001). Effective Session 19941 3 Year Review 2004. C&I 6/5/96, DBT 6/18/96 3 Year Review 2008. Effective Session 19961 C&I Approval: 11/28/2000, BOT Approval: 01/16/2001, Effective Term: Spring 2013 (465). C&I Approval: , BOT Approval: , Effective Term: Spring 2017 (525).
C&I Approval: , BOT Approval: , Effective Term: Fall 2018 (550)

Related Programs

  1. Business Administration (BUS-AS) (670) (Active)
  2. Computer Information Technology (CIT-AS) (640) (Active)
  3. Data Science (DATSCI-AS) (640) (Active)
  4. Health Sciences (HSA-TR) (670) (Active)
  5. Health Sciences: Dental Hygiene Focus (HSA-DENHY-AS) (640) (Active)
  6. Health Sciences: Emergency Medical Services Focus (HSA-EMS-AS) (640) (Active)
  7. Health Sciences: General Health Sciences Focus (HSA-GEN-AS) (640) (Active)
  8. Health Sciences: Health Information Technology Focus (HSA-HIT-AS) (640) (Active)
  9. Health Sciences: Nursing Focus (HSA-NURSE-AS) (640) (Active)
  10. Health Sciences: Physical Therapist Assistant Focus (HSA-PTA-AS) (640) (Active)
  11. Health Sciences: Radiography Focus (HSA-RAD-AS) (640) (Active)
  12. Health Sciences: Respiratory Care Focus (HSA-RESC-AS) (640) (Active)
  13. Health Sciences: Surgical Services Focus (HSA-SURG-AS) (640) (Active)
  14. Health Sciences: Veterinary Technology Focus (HSA-VETTC-AS) (640) (Active)
  15. Health Services Administration (HSA-BAS) (655) (Active)
  16. Help Desk Support Specialist (HDSK-CT) (530) (Active)
  17. Microsoft Office Specialist - Microsoft Excel Expert (2016 or later) (to BUS-AS) (MOSE2IC-AR) (600) (Active)
  18. Microsoft Office Specialist - Microsoft Excel Expert (2016 or later) (to CIT-AS) (MOSE3IC-AR) (600) (Active)
  19. Microsoft Office Specialist - Microsoft Excel Expert (2016 or later) (to DATSCI-AS) (MOSE4IC-AR) (600) (Active)
  20. Microsoft Office Specialist - Microsoft Excel Expert (2016 or later) (to HDSK-CT) (MOSE6IC-AR) (600) (Active)
  21. Microsoft Office Specialist - Microsoft Excel Expert (2016 or later) (to HSA-AS) (MOSE5IC-AR) (600) (Active)
  22. Microsoft Office Specialist - Microsoft Excel Expert (2016 or later) (to PROSYS-AS) (MOSEIC-AR) (600) (Active)
  23. Production Systems Management (PROSYS-AS) (645) (Active)
  24. Technology Development & Management (TMGT-TR) (670) (Active)