MGT 206 - Management Spreadsheets

Class: 3 Credits: 3
This course emphasizes the use of spreadsheet software to support managerial decision-making through the analysis of data.

Prerequisite(s): Take ENG 032 and RDG 032 with a minimum grade of C and take CPT 101 and ACC 101 or ACC 111.

Course Topics:

Spreadsheet formulas and functions.
Spreadsheet charts and graphs.
Financial formulas and functions.
Multiple worksheets and workbooks.
Advanced fuctions 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 Web site

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 Policies that include:

Required materials for all online courses
Mandatory Attendance Requirement
Proctored Exams

Standard SCC Course Policies:
Please review the Standard SCC Course Polices on the following topics:

Academic Integrity
Academic Misconduct
Add/Drop period
Appeals Process
Class Attendance
Classroom Behavior (traditional and online)
Classroom Conduct/Expectations
Lab Procedures (general SCC policy regarding this)
Online Confidentiality
Services For Students with Disabilities
Withdrawal Policy

Official Course Syllabus
2021-2022