ITSW-1304 Introduction to Spreadsheets
Ralph Hooper
Credit Summer 2024
Section(s)
ITSW-1304-001 (80751)
LEC DIL ONL DIL
LAB DIL ONL DIL
ITSW-1304-002 (80752)
LEC DIL ONL DIL
LAB DIL ONL DIL
Course Requirements
12 MindTap/SAM module-level Training assignments; average will be 12.5% of your grade
12 MindTap/SAM module-level Exam assignments; average will be 12.5% of your grade
12 MindTap/SAM module-level Critical Thinking Projects; average will be 25% of your grade
3 MindTap/SAM Capstone Projects; average will be 25% of your grade
3 Blackboard Concepts Tests - average will be 25% of your grade
An overall grade will be assigned based on the following scale:
90% - 100% A 89% - 80% B 79% - 70% C 69% - 60% D 0% - 59% F
Student Learning Outcomes/Learning Objectives
Use spreadsheet software to manage financial data.
Work with formulas and functions.
Develop professional-looking worksheets.
Create charts and graphs.
Create and use spreadsheet lists (basic database management).
Use spreadsheet's editing and web tools.
Develop a spreadsheet application.
Use data tables and scenario managers.
Use Solver for complex problems.
Import data into the spreadsheet from other programs.
Enhance spreadsheet with internal programming language (Visual BASIC).
Schedule
| Week of | Readings | Assignments | Tests |
| May 28 | Modules 1 & 2 | Modules 1 & 2 SAM trainings and projects | Modules 1 & 2 SAM exams |
| June 3 | Modules 3 & 4 | Modules 3 & 4 SAM trainings and projects | Modules 3 & 4 SAM exams |
| June 10 | Catch up | Modules 1-4 Capstone Project | Blackboard Test 1 |
| June 17 | Modules 5 & 6 | Modules 5 & 6 SAM trainings and projects | Modules 5 & 6 SAM exams |
| June 24 | Modules 7 & 8 | Modules 7 & 8 SAM trainings and projects | Modules 7 & 8 SAM exams |
| July 1 | Catch up | Modules 5-8 Capstone Project | Blackboard Test 2 |
| July 8 | Modules 9 & 10 | Modules 9 & 10 SAM trainings and projects | Modules 9 & 10 SAM exams |
| July 15 | Modules 11 & 12 | Modules 11 & 12 SAM trainings and projects | Modules 11 & 12 SAM exams |
| July 22 | Catch up | Modules 9-12 Capstone Project | Blackboard Test 3 |
Instructor Information
Professor Ralph E. Hooper
Office Phone: 512-223-2599 (forwards to my cell phone when out of the office)
Office Location: Room 1300.25 San Gabriel Campus (not on campus for Spring 2023)
Virtual Office Hours: Mon & Wed 1 pm -- 3pm via Zoom (email for appt.)
ACC email: ralph.hooper@austincc.edu Blackboard Collaborate will be available for meetings
Instructor Website: https://hooper.accprofessors.com/
Instructor Bio: I have been teaching at the college level for over 35 years in both mathematics and computer science. My research interests are computational thinking and educational technology. I enjoy travel and baseball.
Office Hours
M W 1:00 PM - 3:00 PM virtual -- online via Zoom
NOTEPublished: 05/26/2024 00:24:36