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 ACC 101 or ACC 111, CPT 170, ENG 032 and RDG 100 with a minimum grade of C.

Course Topics:

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:

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

Official Course Syllabus
2023-2024