Syllabus
Introduction to Spreadsheets

Introduction to Spreadsheets

ITSW-1304

Credit Summer 2020
06/01/2020 - 08/02/2020

Course Information

Section 001
Distance Learning
ONL DIL
Ralph Hooper

Office Hours

  • M T W Th
    7 pm - 8 pm
    Online
    By Appointment -- please email me at ralph.hooper@austincc.edu to make arrangements to meet via Blackboard Collaborate Ultra

Course Requirements

Grade Policy: Grade based on SAM Trainings, Exams, and Projects (70%), and Blackboard Tests (30%)

90%-100% A 80%- 89% B 70%-79% C 60%-69% D 0%-59% F 

 

This class runs from June 1 through Aug 2. All work must be completed by Sunday, August 2@ 8pm.
 

All SAM work for Modules 1-12 (including Trainings, Exams and Projects) is already posted and ready for you.
 

Test 1 should be taken after you have completed all work for Modules 1-4 with passing grades on each assignment ( >= 60%), but not before June 15. 

Test 2 should be taken after you have completed all work for Modules 5-8 with passing grades on each assignment ( >= 60%), but not before July 6.

 

Test 3 should be taken after you have completed all work for Modules 9-12 with passing grades on each assignment ( >= 60%), but not before July 27.
 

 

Readings

Approved Course Text: MicroSoft OFFICE 365 EXCEL 2016:Comprehensive (LooseLeaf)-W/ACCESS CODE for MindTap, Parsons, Course Technology CENGAGE Learning.

 

Materials are included with tuition as a part of First day Access

 

 

 

Course Subjects

1. Getting Started with Excel

2. Formatting

3. Formulas and Functions

4. Charts

5. Tables

6. Multiple Worksheets

7. Excel Applications

8. Advanced Functions

9. Financial Tools and Functions

10. What-if Analyses

11. Business Intelligence

12. Collaborating

 

Student Learning Outcomes/Learning Objectives

Course Objectives/ Learning Outcomes: 

1.Use spreadsheet software to manage financial data.

2.Work with formulas and functions.

3.Develop professional-looking worksheets.

4.Create charts and graphs.

5.Create and use spreadsheet lists (basic database management).

6.Use spreadsheet's editing and web tools.

7.Develop a spreadsheet application.

8.Use data tables and scenario managers.

9.Use spreadsheet's solver for complex problems.

10.Import data into the spreadsheet from other programs.

 

 

 

Schedule

 Week of Monday

       Assignments            Exams
June 1 Module 1-2 SAM Training & Projects Module 1-2 SAM Exams
June 8 Module 3-4 SAM Training & Projects Module 3-4 SAM Exams
June 15    Taken in Blackboard Test 1 Modules 1-4
June 22 Module 5-6 SAM Training & Projects Module 5-6 SAM Exams
June 29 Module 7-8 SAM Training & Projects Module 7-8 SAM Exams
July 6    Taken in Blackboard Test 2 Modules 5-8
July 13 Module 9-10 SAM Training & Projects Module 9-10 SAM Exams
July 20 Module 11-12 SAM Training & Projects Module 11-12 SAM Exams
July 27    Taken in Blackboard Test 3 Modules 9-12