Apr 19, 2024  
2020-2021 Catalog 
    
Catalog Navigation
  Publication Home
  President’s Welcome

  Programs of Study (A to Z)
  Programs of Study by Degree
  Programs of Study by Division
  Online Degrees
  Course Descriptions

  Admissions Policies
  College Costs
  Financial Aid

  Academic Policies
  Academic Calendar
  General Education
  Transfer Information

  About the College
  SCC Quick Links
  Services for Students
  Disclaimers & Notifications
HELP
2020-2021 Catalog Archived

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:
  1. Maintain and query a relational database.
  2. Create forms and reports from a relational database. 
  3. Enhance a workbook with charts and graphs.
  4. Manage multiple worksheets and workbooks. 
  5. Demonstrate usage of advanced spreadsheet functions such as Pivot Tables, What-if Analysis and macros. 
  6. 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
Face Covering Requirements:
All faculty, staff and students must wear a face mask/covering at all times (absent a medical condition) on all SCC campuses when safe social distancing measures are not possible or difficult to follow. For further details, refer to the Student Guidelines for Face Coverings and Social Distancing on the SCC Coronavirus COVID-19 Information page.
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


SCC Logo
Official Course Syllabus
2020-2021