CGS2518

Spreadsheets for Business Environments

Course Code: CGS 2518

Credit Hours: 3

Effective beginning: 2020-21

 

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:

The following topics will be covered in this course at the discretion of the instructor:

  • Introduction to Problem Solving & Decision making with Microsoft Excel 2013
  • Applying Fundamental Excel Skills & Tools in Problem Solving
  • Solving Problems with Statistical Analysis Tools
  • Determining Effective Data Display with Charts
  • Applying Logic in Decision Making
  • Retrieving Data for Computation, analysis, & Reference
  • Evaluating the Financial Impact of Loans & Investments
  • Organizing Data for Effective Analysis
  • Using Data Tables & Excel Scenarios for What-if Analysis
  • Enhancing Decision Making with Solver
  • Troubleshooting Workbooks & Creating Excel Applications

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

 

 

  1. Attend and participate in class regularly.
  2. Read all assigned material before class.
  3. Study in-class notes and online (Canvas) materials.
  4. Complete assigned projects in a timely manner to enable reflections and revisions on the final product.
  5. Participate in discussions.
  6. Demonstrate your mastery of the required skills on quizzes, exams, etc.
  7. Complete all assignments with promptness and accuracy.
  8. All written documents as well as online assignments must be completed using correct grammar, spelling, and structure.

 

The grading breakdown is subject to change at the discretion of the instructor.

Quizzes                                                            

up to 40%

Test (which includes Midterm and Final) 

up to 60%

Assignments, Projects and/or Labs     

up to 40%

Participation                                       

up to 20%

 

Please see your first day handout for individual instructor grading schemes.

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.