| Week | Date | Work | Recordings |
|---|---|---|---|
| 1.1 | Tue, 8/23/22 |
Attendance Class Introduction Book and MindTap Project01-Website Project02-Database Connections Project03-Business Database Project04-IoT Databases Core Website Files Formative00_Part1-course tech |
* Course Introduction * Core Website Files * Formative00-Part1 class01 |
| 1.2 | Th, 8/25/22 | Attendance Formative00_Part2-course tech Formative00_Part3-course tech Website URL Submission URL Check- Review URL submission(s) |
* Formative00-Part2 * Formative00-Part3 * Website URL Submission class02 |
| 2.1 | Tue, 8/30/22 | Attendance Start Project01 Part 1-website |
* Project01-website
class03 |
| 2.2 | Th, 9/1/22 | Finish Project01 Part 1-website Formative01-Flat File problems |
class04
- |
| 3.1 | Tue, 9/6/22 | 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 |
* Project01-Part 2 class05- no recording Summative01 |
| 3.2 | Th, 9/8/22 | finish Summative01, start Summative02 Project04-u01-Arduino setup LinkedIn Learning01-Access Essential Training |
class06- website problems |
| 4.1 | Tue, 9/13/22 |
Presentation02-Building a Database
Summative02-Creating Tables and Relationships Project04-IOT01-Raspberry Pi setup |
class07-
IOT01 |
| 4.2 | Th, 9/15/22 |
Presentation03-Query Basics Query Tips Query Exercises |
class08- Formative03 |
| 5.1 | Tue, 9/20/22 |
Formative03-Query Basics Summative03-Queries |
class09- Summative03 |
| 5.2 | Th, 9/22/22 |
Project04-IOT02-VNC LinkedIn Learning02-Queries Raspberry Pi and WiFi |
IoT WiFi class10- No recording 9/22 |
| 6.1 | Tue, 9/27/22 |
Presentation04-Form and Report Basics Form and report tips Formative04-form and reports Summative04-Forms and Reports |
class11 -u01, IoT01,02 Formative04 |
| 6.2 | Th, 9/29/22 |
Review for Midterm Midterm01 available in D2L Project04-IOT03-ssh remote connections |
class12- Sum04,Form03
Summative04-Exercises 5,6 |
| 7.1 | Tue, 10/4/22 | University Improvement Day-No Class |
No Recording |
| 7.2 | Th, 10/6/22 | Presentation05-Advanced Queries and Tables Formative05-Advanced Queries Summative05-Queries, Enhanced Tables Queries and tables Lookup Exercise Project02-preparation-Install Hyper-V Review LinkedIn Learning videos |
class13 - Sum04 |
| Week | Date | Work | Recordings |
| 8.1 | Tue, 10/11/22 | Project02-Database Connections Project02-Part 1-Access and MySQL |
class14
- Project02 Part 1 |
| 8.2 | Th, 10/13/22 | Project02-Part 2-Access and SQL Server Project04-IOT10-MySQL on RPi |
class15- Proj 2 P2 |
| 9.1 | Tue, 10/18/22 | Presentation06-Advanced Forms Formative06-Advanced Forms For fun, try to solve Formative06 using Excel Pivot Table |
Formative06 class16-(fall2021) |
| 9.2 | Th, 10/20/22 | COB Alumni Visit Summative06-Custom Forms Form tips |
Summative06 class17-fall 21-Summative06 |
| 10.1 | Tue, 10/25/22 |
Presentation07-Advanced Reports Advanced Report Tips Formative07-Advanced Reports |
class18 - Form07 |
| 10.2 | Th, 10/27/22 | Summative07-Custom Reports LinkedIn Learning03-Forms and Reports |
class19-fall 21-sum07 class19-fall22-Sum07, AdvReports |
| 11.1 | Tue, 11/1/22 |
Presentation08-Sharing Data Data Integration Tips Formative08-Linked Tables Linked Table Madness! |
class20- Form08, Sum08 |
| 11.2 | Th, 11/3/22 | Summative08-Sharing Data Pivot Table Example Midterm02 available in D2L |
class21- Sum08 |
| 12.1 | Tue, 11/8/22 | discuss and work on Project 2 Presentation09-Action Queries Action Query Tips Formative09-Specialty Queries |
class22
-Form9, Sum9 classxx -Sum09q3+ |
| 12.2 | Th, 11/10/22 |
Summative09-Action Queries and Advanced Table Relationships Project04-IOT19 -sensor data to cloud |
class23-Sum09 |
| 13.1 | Tue, 11/15/22 |
Presentation10-Macros Presentation11-Visual Basic for Applications-coding Formative10-VBA Presentation12-Database Management |
class24 P4-IOT19, Sum10 Summative10 Summative10-VBA, forms |
| 13.2 | Th, 11/17/22 |
Summative10-Managing Databases Project04-IOT20- MySQL and ODBC |
class25 - IOT20, Formative10 |
| 14.1 | Tue, 11/22/22 | Access Macros and VBA for Project03 Project04-IOT21-sensor data to MySQL LinkedIn Learning04-Database Foundations |
class26- IOT21, Sum10 Part 1 |
| 14.2 | Th, 11/24/22 | Thanksgiving | No Class |
| 15.1 | Tue, 11/29/22 | work on Project03 Grading Issues LinkedIn Learning05-IoT Fundamentals |
class27-fall 21-Project3 class27-fall 22-S10, start Project3 |
| 15.2 | Th, 12/1/22 | finish Project03 Course Review and Feedback Grading Issues Addressed in class |
class28 -Project03 |
| Final Exam | |||
| Week | Date | Work | Recordings |