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 outcomes | Discipline-level learning outcomes | Assessment 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.
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