Homework Assignments and Exams


Overview

The information on this page is tentative.

Grading

We grade the class on a point system. Exams and homework assignments are worth various points. The points for the individual homework assignments are below. The midterm exam is work 20 points and the final exam is work 30 points.

The mapping of points earned to grades is:

Homework Assigned Due Points
0 TBD TBD 0
1 TBD TBD 10
2 TBD TBD 15
3 TBD TBD 15
4 TBD TBD 10

Exams

Midterm Exam

The midterm exam is a take home exam. The exam is a set of practical exercises. The practical exercises involve using database systems to solve problems, e.g. writing queries, defining schema, etc. We expect to assign the midterm on 22-Oct-21 and you have one week to complete it.

Additionally, there will be a short, in person quiz on the day we release the take home midterm.

Our goal with the quiz is to test you on the type of questions and topics that often occur during job interviews. This helps you prepare.

Final Exam

The final exam follows the same format as the midterm. There is a take home exam and a short, in-class quiz. We expect to release the final 10-Dec-2021, and you have approximately one week for the take home section. The in-class quiz will occur when the registrar assigns a final exam date and time.

Homework Assignments

There will be four homework assignments, and a HW 0 that you complete to set up your environment. You will find information on HW 0 on CourseWorks and below when we publish. Homework assignments are a combination of written questions reinforcing critical concepts and practical exercises. The practical exercises requires using databases, e.g. database queries, designing schema, etc.

Students have a total of 5 late submission grace days:


Homework Specific Information

Homework 0: Environment


The instructions and material for HW 0 are in the GitHub repository for the course.

  • If you clone the repo, the material is in the relative folder HomeworkAssignments/W4111_HW0 F21.
  • If you do not want to clone the repo, you can download a zip file and uncompress.
  • There are two relevant files:
    • W4111_HW0.ipynb: This is a Jupyter notebook that you need to complete and submit.
    • HW0_Environment Setup.pdf: Instructions on how to accomplish the task.