MGT 206 - Management Spreadsheets
Lecture Hours: 3 Lab Hours: 0 Credits: 3
Description: This course emphasizes the use of spreadsheet software to support managerial decision-making through the analysis of data.
Prerequisite(s): Take CPT 170 , ENG 032 and RDG 100 with a minimum grade of a C or higher.
Course Topics:
- Spreadsheet formulas and functions.
- Spreadsheet charts and graphs.
- Financial formulas and functions.
- Multiple worksheets and workbooks.
- Advanced functions such as Pivot Tables, What-if Analysis and macros.
- Connect external data to a spreadsheet.
Textbooks:
Textbook information can be found on the Book Inn website
Required Materials:
- Microsoft Excel 2013
- Skills Assessment Manager Office 2013 (SAM2013)_Assessment, Projects, and Training
- One USB/jump disk or sky drive onto which all typed assignments will be saved.
Grading System:
An overall grade of C or higher is required for transferability.
A = 90 - 100
B = 80 - 89
C = 70 - 79
D = 60 - 69
F = 0 - 59
Student Learning Outcomes:
- Maintain and query a relational database.
- Create forms and reports from a relational database.
- Enhance a workbook with charts and graphs.
- Manage multiple worksheets and workbooks.
- Demonstrate usage of advanced spreadsheet functions such as Pivot Tables, What-if Analysis and macros.
- Connect external data to a spreadsheet.
For SCC Online Courses:
If the course you are taking is online, please review the SCC Online Course Policies that include:
- Identity Verification
- Required materials for all online courses
- Mandatory Attendance Requirement
- Orientation and Support
- Proctored Exams
Standard SCC Course Policies:
Please review the Standard Course Policies on the following topics:
- Academic Integrity
- Add/Drop period
- Attendance
- Classroom Conduct
- Equal Access
- IT Access
- Online Behavior
- Online Confidentiality
- Services For Students with Disabilities
- Student Concerns
- Student Help Services
- Withdrawals
Official Course Syllabus
2024-2025
|
