Week
|
Lecture/Notes
|
Assignments
|
|
#1
Jan 13-17
|
Chapter 1
Appendix A - Text
Appendix A - Slides
|
Read: Chapter 1 & Appendix A
Install: Microsoft Office (Access)
|
|
#2
Jan 20-24
|
NO CLASS ON MONDAY JANUARY 20TH
Chapter 1
Appendix A - Text
Appendix A - Slides
|
Homework 1 - Appendix A:
Exercise A.12
Steps A - U
pg. A-44 - A-47
*Upload your Cape_Codd.accdb database to D2L drop box Homework 1*
Recursive Relationships
Due: January 31st @ 11:30PM
Read: Chapter 2
|
|
#3
Jan 27-31
|
Chapter 2 - Part 1
Chapter 2 - Part 2
|
Homework 2 - Chapter 2:
Review Questions
2.17 - 2.54
pg. 121 - 123
*Upload a Word document with each SQL query or question response to D2L drop box Homework 2*
Cape Codd Access Database
Smart Quotes to Straight Quotes in Word
Due: February 10th @ 11:30PM
Read: Chapter 2
|
|
#4
Feb 3-7
|
Chapter 2 - Part 1
Chapter 2 - Part 2
|
Read: Chapter 3
|
|
#5
Feb 10-14
|
Chapter 3
Feb 14 Notes
ACM - A Relational Model of Data for Large Shared Data Banks
Full Paper - A Relational Model of Data for Large Shared Data Banks
|
Exam #1 ⟹ Friday February 21st
Homework 3 - Chapter 3:
Case Questions Regional Labs
Questions A - J
pg. 186 - 187
*Upload a Word document with each question response to D2L drop box Homework 3*
Due: February 19th @ 11:30PM
Group Assignment 1 - Chapter 2:
The Queen Anne Curiosity Shop Project
Questions A - U
pg. 133 - 140
*Use Microsoft Access for these questions*
*Upload a Word document with each SQL query or question response to D2L drop box Group Assignment 1*
*Upload a separate statement explaining how your group distributed the work and what each group member was assigned*
*Designate a Group Leader who will upload the answers for the entire group*
Due: February 24th @ 11:30PM
Read: Chapter 3
|
|
#6
Feb 17-21
|
EXAM #1
Chapter 3
Feb 17 Notes
Feb 19 Notes
|
Read: Chapter 4
|
|
#7
Feb 24-28
|
Chapter 4
|
Homework 4 - Chapter 4:
Review Questions
4.2, 4.3, 4.4, 4.6, 4.9, 4.10, 4.18, 4.19, 4.22, 4.34
pg. 206 - 208
*Upload a Word document with each question response to D2L drop box Homework 4*
Due: March 7th @ 11:30PM
Group Assignment 2 - Chapter 3:
The Queen Anne Curiosity Shop Project
Questions A - G
pg. 187 - 189
*Upload a Word document with each question response to D2L drop box Group Assignment 2*
*Upload a separate statement explaining how your group distributed the work and what each group member was assigned*
Group Assignment 3 - Chapter 4:
The Queen Anne Curiosity Shop Project
Questions A - G
pg. 209 - 210
*Upload a Word document with each question response to D2L drop box Group Assignment 3*
*Upload a separate statement explaining how your group distributed the work and what each group member was assigned*
Due: March 7th @ 11:30PM
Read: Chapter 5, Appendix B & Appendix C
|
|
#8
Mar 2-6
|
Chapter 5
Appendix B - Text
Appendix B - Slides
Appendix C - Text
Appendix C - Slides
|
Read: Chapter 5 & 6
|
|
#9
Mar 9-13
|
SPRING BREAK - NO CLASSES
|
|
#10
Mar 16-20
|
EXTENDED SPRING BREAK - NO CLASSES
|
|
#11
Mar 23-27
|
READING/ASSIGNMENTS POSTED TO CONTENT SECTION OF D2L
|
|
#12
Mar 30-Apr 3
|
READING/ASSIGNMENTS POSTED TO CONTENT SECTION OF D2L
|
|
#13
Apr 6-10
|
READING/ASSIGNMENTS POSTED TO CONTENT SECTION OF D2L
|
|
#14
Apr 13-17
|
READING/ASSIGNMENTS POSTED TO CONTENT SECTION OF D2L
|
|
#15
Apr 20-24
|
READING/ASSIGNMENTS POSTED TO CONTENT SECTION OF D2L
|
|
#16
Apr 27-May 1
|
Final Exam Review
|
FINALS WEEK
CSCI313-001: FRIDAY MAY 1ST
10:15AM-12:15PM
ROSS 136
|
