Assignments

There are three major types of assignments for DATA 514. These include homeworks (50% of your grade), lecture activities (40% of your grade), and a final team project (10% of your grade).

Academic Integrity

Your integrity is everything. You are expected to hold yourself to the highest standards of personal and academic integrity while participating in this course.

Any attempt to misrepresent the work you submit will be dealt with via the appropriate University mechanisms, and your instructor will make every attempt to ensure the harshest allowable penalty. The guidelines for this course and more information about academic integrity are in a separate document (including, but not limited to, the Allen School’s Academic Misconduct page and the College of Engineering’s Academic Misconduct Process). You are responsible for knowing the information in these documents.

All material you submit in the homeworks and quizzes must be written by you. Copying the work of another student or external documents is a violation of the above integrity policy. In summary:

Collaboration

Data scientists adhering to the highest standards of integrity will still collaborate with fellow data scientists. In this course collaboration is encouraged and expected. You may discuss and share the contents of this course as you wish, so long as you do not share specific solutions and code. You may work with other students and discuss solutions to problems, but you should not copy answers or code directly. You may use internet resources to look up references, but you may not copy any answers directly.

One way to determine whether you are collaborating, versus cheating, is to test how well you have learned material. If you are able to take a break, and then recreate solutions or generalize solutions (solve similar but slightly different problems) that is a good indication that you are truly learning the material.

There will be some opportunities to work on solutions together. These include in-class activities and the final project. During these times you should ensure that each member of the group is treated with respect and can make a contribution to the final solution.

Late Days

In recognition of the vagaries of life, students are permitted up to 6 late days during the quarter. Using a late day permits a student to submit an assignment up to 24 hours past the due date (two late days permits 48 hours). Students may use up to two late days per assignment. (There will be no late days allowed for the final project presentation.) Late day tallies will be maintained on Canvas.

If you need further accommodation, or have truly exceptional circumstances, please contact Megan to arrange an appropriate strategy for completing your work.

Lecture Activities

Lecture activities will be provided during each lecture. These activities will be due at the beginning of the following lecture.

  1. Week 1 Worksheet
  2. Week 2 Worksheet, Employee pay, Employee titles
  3. Week 3 Worksheet
  4. Week 4 Worksheet

Homeworks

Homeworks are more involved and practical exercises, which are due weekly on Thursday evenings.

  1. Intro to SQL/sqlite
  2. Basic SQL Queries
  3. Advanced SQL/Postgres, and Postgres Setup
  4. Database Design

Project

The project culminates in a team presentation, which will take place during our regular class meeting time, during finals week.