CGS2518

Spreadsheets for Business Environments

Course Code:
CGS 2518

Credit Hours:
3

Effective beginning:
2023-24

Sections:
000

 

Course Description:
This course provides an in-depth study of spreadsheets utilizing a problem-solving approach. Spreadsheet-based solutions are explored for common business tasks and problems. The course presents a thorough coverage of spreadsheet functions and tools, along with a deep understanding of their purpose in a business environment. The course is ideal for students with professional interests related to business and economics, as well as for students wishing to obtain a deeper understanding of spreadsheets in general.

 

Course Details

Prerequisites:

CGS 1100 with a C or better or consent of department

 

Instructors:

Glenda Bethel

 

Required textbooks/ course materials:

Succeeding in Business with Microsoft® Excel® 2013: A Problem-Solving Approach (1st Edition), 2014, Gross, Akaiwa, & Nordquist, ISBN-13: 9781285099149

 

Assignment/course outline:

See your Instructor First Day Handout for individual instructor assignment schedule.

 

Discipline-level learning outcomes:

CGS 2518 is not a General Education Core course.  However, it does address several discipline-specific competencies in the Technology Area.

T-1 Apply appropriate technologies to a range of tasks.

T-2 Communicate, collaborate, and create content effectively, using state-of-the-art information technologies.

T-3 Locate, access, evaluate, and use information from digital/electronic sources.

T-4 Identify ethical, social, and legal issues related to information technology.

T-5 Identify essential issues related to information security.

 

Associate in Science degree in Business Administration Learning Outcomes:

B-1 Demonstrate knowledge of the principles, practices and supervisory responsibilities of management, and ethical and legal issues in a business environment.

B-2 Apply general business work place competencies, including employability skills and office computer skills.

B-3 Perform accounting tasks and understands business accounting concepts. 

B-4 Communicate effectively in oral and written form, exhibit college level computation and problem-solving skills, and interact appropriately with people of other cultures or backgrounds. [Gen. Ed.]

 

Associate in Science degree in Computer Information Technology Learning Outcomes:

CIT-1 Understand, install, configure, monitor, use, and troubleshoot computer hardware and software. [1.0, 2.0, 3.0, 4.0, 6.0, IT Support 12.0, 13.0]

CIT-2 Understand, install, configure, monitor, use, and troubleshoot network hardware and software. [8.0, 9.0]

CIT-3 Demonstrate general computing workplace competencies, including employability skills, interpersonal & customer service skills, and user support skills. [11.0, IT Support 12.0, 13.0, 14.0, 15.0]

CIT-4 Demonstrate project management skills. [10.0]

CIT-5 Perform database management and design tasks. [7.0]

 

Associate in Science degree in Network Systems Technology Learning Outcomes:

NST-1 Understand, install, configure, monitor, use, and/or troubleshoot computer hardware and software. [1.0, 3.0]

NST-2 Understand, install, configure, monitor, use, and troubleshoot network hardware and software. [2.0, 4.0]

NST-3 Demonstrate general computing workplace competencies, including employability skills, interpersonal & customer service skills, and user support skills. [5.0, Server Admin 18.0]

NST-4 Demonstrate project management skills. [6.0]

NST-5 Depends on Specialization:

  • Server Administration (Program Code 2181): Demonstrate advanced understanding of networked environments and perform network administration activities. [Server Admin Specialization 7.0-8.0]
  • Network/Cybersecurity (Program Code 2182): Demonstrate proficiency in securing networks and data, including performing penetration testing and responding to cybersecurity incidents. [Network/Cybersecurity Specialization 7.0-9.0]
  • Digital Forensics (Program Code 2183): Demonstrate understanding of forensic casework procedures and perform computer and mobile device forensic investigations. [Digital Forensics Specialization 7.0-14.0]

 

Course-level learning outcomes:

Course-level student learning outcomesDiscipline-level learning outcomesAssessment methods
Appraise and describe the purpose of spreadsheet software

T-1, T-2, T-3, B-2, B-3 

Homework, tests, quizzes
Synthesize and apply the appropriate software features to accomplish tasks within their discipline

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes
Formulate data for computation, analysis, and reference

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes
Formulate data for effective analysis using PivotTables and PivotCharts

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes
Contrast formulas and functions

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes
Appraise “what-if” analysis

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes
Synthesize and use multiple worksheets within a workbook

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes
Evaluate auditing capabilities to locate and correct errors

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes
Appraise principles of effective layouts to build templates

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes
Propose fundamental spreadsheet skills and tools in problem-solving

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes
Evaluate problems with statistical analysis tools

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes
Formulate visualization and charting skills

T-1, T-2, T-3, B-2, B-3

Homework, tests, quizzes

 

Means of accomplishing learning outcomes:

In-Person

The instructor will:

  • Lecture and lead class discussions.
  • Assign readings from textbooks and/or other sources to supplement lectures.
  • Provide supplemental materials that align with the material presented in the textbook as appropriate.
  • Design assignments, quizzes, discussions, etc., to help students engage with the course material.
  • Use other teaching strategies to assist students in examining and understanding course materials as needed.
  • Provide timely feedback on assignments.
  • Hold weekly office hours to address questions and student needs outside of class time.

The students will:

  • Attend class regularly and be attentive to lectures.
  • Engage with class discussion.
  • Participate in student discussion groups.
  • Read assigned readings.
  • Complete assignments, quizzes, discussion boards, etc., as assigned by the instructor.

Online

The instructor will:

  • Lead class discussions.
  • Assign textbook and/or other readings.
  • Provide supplemental materials that align with the material presented in the textbook as appropriate.
  • Design assignments, quizzes, discussions, etc., to help students engage with the course material.
  • Use other teaching strategies to assist students in examining and understanding course materials as needed.
  • Provide timely feedback on assignments.
  • Hold weekly virtual office hours to address questions and student needs.

The students will:

  • Engage with the course regularly.
  • Engage with class discussions.
  • Participate in student discussion groups.
  • Read assigned readings.
  • Complete assignments, quizzes, discussion boards, etc. as assigned by instructor.

 

Printer-friendly Version:

Download Syllabus

 

College-wide policies and resources

For more specific information on Chipola's college-wide academic policies and resources available to students, visit the link below.

Policies & Resources