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 same time as Tutorial | 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 05/25/2022 11 PM