ITSW-1307 Introduction to Database: Access

Ralph Hooper

Credit Fall 2023

Section(s)

ITSW-1307-003 (69012)
LEC DIL ONL DIL

LAB DIL ONL DIL

ITSW-1307-004 (69013)
LEC DIL ONL DIL

LAB DIL ONL DIL

Course Requirements

Grading System and Policy

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 Project assignments – average will be 25% of your grade  

3 MindTap/SAM Concept 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 

Readings

Do NOT buy the textbook materials. Access is already included in your ACC tuition!

MindTap The New Perspectives Collection, Office 2019, 1st Edition, Cengage Learning.

Course Subjects

1. Creating a Database

2. Defining Table Relationships

3. Querying a Database

4. Forms and Reports

5. Advanced Queries

6. Custom Forms

7. Custom Reports

8. Analyzing Data

9. Action Queries 

10. Macros

11.Visual Basic

12. Managing and Securing a Database

Student Learning Outcomes/Learning Objectives

Use a database management system (DBMS) to solve business problems.

Study and practice data design theory.

Create Entity Relationship diagrams

Design and modify tables, queries, forms and reports.

Normalize tables to 3rd normal form.

Create primary keys for each table.

Define and understand entity integrity and referential integrity in relational databases

Schedule for 16 week section

Week of

Readings

Assignments

Exams/Tests

August 21

Onboarding

Orientation Assignment

-----------

August 28

Module 1

Module 1 SAM Training & Project

Module 1 SAM Exam

September 4

Module 2

Module 2 SAM Training & Project

Module 2 SAM Exam

September 11

Module 3

Module 3 SAM Training & Project

Module 3 SAM Exam

September 18

Module 4

Module 4 SAM Training & Project

Module 4 SAM Exam

September 25

Test 1

Capstone Project

Test 1

October 2

Module 5

Module 5 SAM Training & Project

Module 5 SAM Exam

October 9

Module 6

Module 6 SAM Training & Project

Module 6 SAM Exam

October 16

Module 7

Module 7 SAM Training & Project

Module 7 SAM Exam

October 23

Module 8

Module 8 SAM Training & Project

Module 8 SAM Exam

October 30

Test 2

 Capstone Project

Test 2

November 6

Module 9

Module 9 SAM Training & Project

Module 9 SAM Exam

November 13

Module 10

Module 10 SAM Training & Project

Module 10 SAM Exam

November 20

Module 11

Module 11 SAM Training & Project

Module 11 SAM Exam

November 27

Module 12

Module 12 SAM Training & Project

Module 12 SAM Exam

December 4

Test 3

Capstone Project

Test 3

 

Schedule for 12 week section

Week of

Readings

Assignments

Exams/Tests

September 18

Onboarding, Module 1

Orientation Assignment, Module 1 SAM Training & Project

Module 1 SAM Exam

September 25

 Module 2

Module 2 SAM Training & Project

Module 2 SAM Exam

October 2

Module 3

Module 3 SAM Training & Project

Module 3 SAM Exam

October 9

Module 4

Module 4 SAM Training & Project, Capstone Project

Module 4 SAM Exam, Test 1

October 16

Module 5

Module 5 SAM Training & Project

Module 5 SAM Exam

October 23

Module 6

Module 6 SAM Training & Project

Module 6 SAM Exam

October 30

 Module 7

Module 7 SAM Training & Project

Module 7 SAM Exam

November 6

Module 8

Module 8 SAM Training & Project, Capstone Project

Module 8 SAM Exam, Test 2

November 13

Module 9

Module 9 SAM Training & Project

Module 9 SAM Exam

November 20

Module 10

Module 10 SAM Training & Project

Module 10 SAM Exam

November 27

Module 11

Module 11 SAM Training & Project

Module 11 SAM Exam

December 4

Module 12

Module 12 SAM Training & Project, Capstone Project

Module 12 SAM Exam, Test 3

 

Instructor Information

Professor Ralph E. Hooper

Office Phone: 512-223-2599 

Office Location: Room 1300.25 San Gabriel Campus  

Virtual Office Hours: Tue & Thurs 10:30 am -- 1 pm via Zoom (email for appt.)

ACC email: ralph.hooper@austincc.edu -- Zoom 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

T Th 10:30 AM - 1:00 PM online via Zoom (email for appt)

NOTE

Office Hours

T Th 10:30 AM - 1:00 PM online via Zoom (email for appt)

NOTE

Published: 08/20/2023 18:21:56