| First Week of Class Begins: | Monday, 8/21/2023 |
| Add without Instructor Permission by: | Sunday, 8/20/2023 |
| Last Day to Add with APC*: | Tuesday, 8/29/2023 |
| Drop with Refund by: | Friday, 8/25/2023 |
| Elect Pass/No Pass by: | Saturday, 10/14/2023 |
| Drop without "W" Grade by: | Tuesday, 8/29/2023 |
| Drop with "W" Grade by: | Monday, 9/25/2023 |
| Last Class is Monday | Monday 10/16/2023 |
| Last Week of Class Ends: | Saturday, 10/14/2023 |
CIMW 105 SQL/MySQL/CIS 405 NC - Assignment/Quiz Due Dates
|
|||
| Week | |||
|---|---|---|---|
| To Begin Module |
Canvas Quizzes | Due Date Quizzes are Due Monday expire Wednesday |
Assignments** are Due Monday |
| 1st | orientation/intro quiz | Due Monday 4 days before tutorial.sql | Course Orientation |
| 1st | Quiz 1 tutorial (10pts) | submit tutorial.sql (10pts) |
|
| 2nd | Quiz 2 select.sql (10pts) | submit select.sql (10pts) | |
| 3rd | Quiz 3 intermediate (10pts) | submit intermediate.sql (20pts) | |
| 4 | Quiz 4 pmaIntro (10pts) |
submit pmaIntro.sql+ (11pts) | |
| 4 | Quiz 5 pmaView 1st 2 Video (10Pts) Crunch time begins next week, so do Chapter1 and pmaReset now. |
submit pmaView.sql, (15 pts) | |
| 5 | Chap 1 Quiz (20 pts) |
due same time as PMAReset, but A&B get it done sooner | Read Chapter 1 |
| 5 | Quiz 7 pmaReset (10 pts) DB Restore, and Intro Cloud (relatively easy assignment) |
submit - pmaReset.sql (12 pts) | |
| 6 | Quiz 8 pmaTrigger (20pts) | submit pmaTrigger.sql (15pts) | |
| 7 | Quiz 9 pmaRoutine (20Pts) Quiz10 pmaTransaction (20Pts) |
submit pmaRoutine.sql (12pts) and email - pmaReport (15pts) |
|
| C Grade Totals | 160 Pts *0.92 = 147 | 120 Pts *0.92 = 105 | |
| Table Below is Assignments/Quizzes A & B Student Must Complete | |||
| A | Quiz | Due Date/Quiz Expiration | You should complete up to and including pmaView.sql before starting the assignments and quizzes in this table. |
| 5 | Assignment Quiz One (20 pts) | submit p21.sql (10 pts) | |
| 5 | Chapter 2 (20 pts) | submit p58.sql (7 pts) | |
| 6 | Chapter 3 (20 pts) | submit p87.sql (10 pts) | |
| 6 | Chapter 4 (20 pts) | submit p125.sql (21 pts ) | |
| 7 | Chapter 5 (20 pts) | submit p157.sql (20 pts) | |
| 7 | Chapter 6 (20 pts) | submit p177.sql (15 pts ) | |
| 7 | Chapter 7 Extra Credit (10 bonus pts) | submit casinoNoJoin.sql (10 bonus points) | |
** For assignments, you may submit them late but they will be penalized. After due date you can complete the assignment in the next 7 days at a 25% penalty, after that the penalty is 50%. However last day of class is last day of class; For a logic oriented course you must complete work in order and at a steady pace. Both the material and assignments build on themselves. For on line courses if you snooze you loose.
+ pma is short for phpMyAdmin
++ Class officially ends Monday 10/16/2023 11 PM