Syllabus Sections
Publish Date
05/29/2020 17:19:28
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 |