| Week | Date | Work | Recordings |
|---|---|---|---|
| 1.1 | Tue, 8/26/25 |
Attendance HPIA Class Introduction Books and chatbot Project01-Website Project02-Database Connections Project03-Business Database Project04-IoT Databases Core Website Files Formative00_Part1-course tech |
class01 - intro, hpia, f00Pt1 * Course Introduction * Core Website Files * Formative00-Part1 |
| 1.2 | Th, 8/28/25 | Attendance Formative00_Part2-course tech Formative00_Part3-course tech Website URL Submission URL Check- Review URL submission(s) |
class02 -website url, foopt1,2 * Formative00-Part2 * Formative00-Part3 * Website URL Submission |
| 2.1 | Tue, 9/2/25 | Attendance Start Project01 Part 1-website |
class03
* Project01-website |
| 2.2 | Th, 9/4/25 | Attendance Finish Project01 Part 1-website Formative01-Flat File problems |
class04
- |
| 3.1 | Tue, 9/9/25 | Project 1 Part 2-Retrieving Assignments
A&P-suggested-LinkedIn Learning-Access 2019 Essential Training Presentation01-Access Database Introduction Summative01-Database Objects-pull from GitHub repo |
class05- no recording * Project01-Part 2 Summative01 |
| 3.2 | Th, 9/11/25 | finish Summative01, start Summative02 Project04-IOT00-Raspberry Pi overview LinkedIn Learning01-Access Essential Training |
class06- website problems IOT00 |
| 4.1 | Tue, 9/16/25 |
Presentation02-Building a Database
Summative02-Creating Tables and Relationships |
class07-
Summative02 |
| 4.2 | Th, 9/18/25 |
Presentation03-Query Basics Query Tips Query Exercises GenerativeAI Project04-IOT01-Raspberry Pi setup |
class08- Summative02, IOT01 IOT01 |
| 5.1 | Tue, 9/23/25 |
Formative03-Query Basics Summative03-Queries |
class09- Summative03 |
| 5.2 | Th, 9/25/25 | Project04-IOT02-VNC LinkedIn Learning02-Queries Raspberry Pi and WiFi |
class10-
Summative03, Formative03- |
| 6.1 | Tue, 9/30/25 |
Presentation04-Form and Report Basics Form and report tips Formative04-form and reports Summative04-Forms and Reports |
class11 - Formative04 |
| 6.2 | Th, 10/2/25 |
Review for Midterm Midterm01 available in D2L Project04-IOT03-ssh remote connections |
class12- Sum04 IOT03- Summative04-Exercises 5,6 |
| 7.1 | Tue, 10/7/25 | Presentation05-Advanced Queries and Tables Formative05-Advanced Queries Summative05-Queries, Enhanced Tables Queries and tables Lookup Exercise |
class13 - Summ05-Adv queries |
| 7.2 | Th, 10/9/25 | Project02-preparation-Install Hyper-V Review LinkedIn Learning videos | class 14- |
| Week | Date | Work | Recordings |
| 8.1 | Tue, 10/14/25 | Project02-Database Connections Project02-Part 1-Access and MySQL |
class15- Project02 Part 1 |
| 8.2 | Th, 10/16/25 | Project02-Part 2-Access and SQL Server Project04-IOT10-MySQL on RPi |
class16- Proj 2 P2, IOT1,2,3,10 |
| 9.1 | Tue, 10/21/25 | Presentation06-Advanced Forms Formative06-Advanced Forms For fun, try to solve Formative06 using Excel Pivot Table |
class17 -Formative06 |
| 9.2 | Th, 10/23/25 | Summative06-Custom Forms Form tips |
Summative06 class18- Formative06 |
| 10.1 | Tue, 10/28/25 |
Presentation07-Advanced Reports Advanced Report Tips Formative07-Advanced Reports |
class19 - Sum05, Sum06 |
| 10.2 | Th, 10/30/25 | Summative07-Custom Reports LinkedIn Learning03-Forms and Reports Project04-IOT19-sensor data to cloud |
class20- Sum06-forms |
| 11.1 | Tue, 11/4/25 |
Presentation08-Sharing Data Data Integration Tips Formative08-Linked Tables Linked Table Madness! |
class21- IOT19, Form07 |
| 11.2 | Th, 11/6/25 | Summative08-Sharing Data Pivot Table Example Midterm02 available in D2L |
class22- Sum07 |
| 12.1 | Tue, 11/11/25 | Veteran's Day-No Class | |
| 12.2 | Th, 11/13/25 |
discuss and work on Project 2 Presentation09-Action Queries Action Query Tips Formative09-Specialty Queries Summative09-Action Queries and Advanced Table Relationships Project04-IOT20 -MySQL and ODBC |
class23-IOT20, Sum09 |
| 13.1 | Tue, 11/18/25 |
Presentation10-Macros Presentation11-Visual Basic for Applications-coding Formative10-VBA Presentation12-Database Management |
class24 -Sum09, start s10 Summative10 -VBA, forms |
| 13.2 | Th, 11/20/25 |
Summative10-Managing Databases Project04-IOT21- sensor data to MySQL |
class25 - IOT20,21 Summative10 |
| 14.1 | Tue, 11/25/25 | Access Macros and VBA for Project03 Project04-IOT21-sensor data to MySQL LinkedIn Learning04-Database Foundations |
class26- IOT25, Form10, P3-start |
| 14.2 | Th, 11/27/25 | Thanksgiving-No Class | |
| 15.1 | Tue, 12/2/25 | work on Project03 Grading Issues LinkedIn Learning05-IoT Fundamentals |
class27-fall 24-Project3, Form10 class27-fall 22-S10, start Project3 |
| 15.2 | Th, 12/4/25 | finish Project03 Course Review and Feedback Grading Issues Addressed in class |
class28 -Project03 |
| Final Exam | |||
| Week | Date | Work | Recordings |