CPSC 343 | Database Theory and Practice | Fall 2022 |
You are expected to be familiar with the course policies stated below. Ignorance of a policy is not an excuse for violating a policy or being surprised when it is applied to you, and will not exempt you from its penalties.
On this page:
Communication |
All course information, materials, and announcements will be posted on the course webpage and/or Canvas. You are expected to check Canvas and the schedule page regularly. Individual communication will take place via email. You are expected to check your HWS email account regularly. |
---|---|
Conduct |
As with any course, you are expected to be on time and prepared to engage in the day's activities. Class sessions will often involve group activities, and being late or unprepared impacts others as well as yourself. During class, you are expected to be present and on task for the whole period - web surfing, texting, playing games, doing assignments for other courses, etc are not acceptable, nor is leaving during the session (absent an emergency). (Take care of any necessary business before or after class!) You are encouraged to bring a laptop for use during in-class exercises if you can. However, many distractions are present on a computer and it is recommended that you turn off email and other notifications and close applications that are not needed for the current task in order to reduce the temptation of those distractions. |
Technology Failures |
This course makes use of database and web servers set up specifically for this course, as well as the math/CS department webserver (math.hws.edu) and campus resources including Canvas and the Rosenberg 009 and Lansing 310 labs. If you run into a problem with a system that doesn't seem to be working as it should, please let me know. You should regularly back up your work to protect against computer failures. This is automatically done nightly for the department's Linux filesystem; see the "Emergencies" section of Using Linux at HWS for more information. For course-related files on a personal computer, you can back them up by periodically copying them to your CS account. See the "SSH, SCP, SFTP" section of Using Linux at HWS for more information. Note that you should only do this for course-related work! |
Assignments and Evaluation |
This course introduces many new terms and concepts, including multiple languages and sets of notation. This means that it is important to do the readings, to prepare for class and actively practice the material, and to keep up rather than letting things slide. Daily Lessons: For most class sessions you will be expected to complete a lesson beforehand involving readings and/or videos and some questions about the material to help you self-assess what concepts you understand, learn what you don't, and identify where you have further questions. As the goal of these "quizzes" is self-assessment, grading is based on completeness (did you answer the questions?) rather than correctness. Practice Problems: Trying to solve problems and applying concepts for yourself is essential for mastery. In most cases the Canvas discussion boards will be used for practice problems in order to facilitate peer feedback and encourage deeper engagement with the problems. You must post your answer before you can see others' responses, and you can earn up to three points for each problem: one point for posting an answer, an additional point if your answer is correct or you follow up with a correct answer and an explanation of what was wrong with the original answer, and one point for a correct and substantive comment on an answer different from your own (e.g. reflecting on the differences in approach if the answer is correct or explaining what the problem is if the answer is incorrect). Project: A substantial course project involving the design and development of a database and application utilizing that database will provide a practical application for the course material. Work on the project will begin early in the semester; the timeline can be found on the schedule page. Exams: There will be five in-class hour exams and a two-hour in-class cumulative final exam. Dates are on the schedule page. More about the topics covered and the format of the exams will be announced closer to the exam dates. Grades: Grades in this course will be computed as follows:
Note that there is a lot of weight on the exams! The final exam will provide a limited second chance to make up for difficulties on earlier hour exams, but your best strategy is to take the daily lesson self-assessments and especially the practice problems seriously so that you are prepared for the exams. You are strongly encouraged to do more than the minimum number of practice problems and should come to office hours early and often if you are struggling with a particular topic. |
Attendance |
You are expected to be on time for all class sessions, and to be present and engaged in the course for the full period. Any absence, whatever the reason, means that you miss out on discussions and activities that take place in class. This puts a greater burden on you to catch up, and students who regularly miss class often end up not doing as well in the course. In addition, announcements are made at the beginning of class, and late arrivals may miss important information. However, while you should make every effort to attend class, it is understood that there may be extenuating circumstances which make attending every class difficult. It is especially important that you follow current guidelines with respect to COVID, including quarantining if you test positive and/or have symptoms. If you cannot attend class, please let me know as soon as possible and make sure that you check the schedule page for new assignments and materials from class, complete any missed readings or other tasks, and come to office hours if you have any questions or need help with any aspect of the material. This should be done promptly to avoid falling behind. If you miss more than three classes during the semester or if you miss several classes in a row, you are at greater risk for falling behind. In that case, please see me as soon as possible to discuss options for helping you stay on track. |
Making Up Work, Late Policy, Extensions, and Missing/Rescheduling Exams |
Any handouts, examples, slides, and other materials from class will be posted on the course website (on the schedule page) and/or on Canvas. If you miss class, you should review this material as soon as possible and seek help at office hours as needed. Late handins refer to assignments being accepted for grading after the due date. In the case of a last-minute emergency that prevents an on-time handin of already-completed work, notify me as soon as possible and make arrangements to complete the handin promptly. This is not an extension of time to complete the assignment.
Extensions allow handins after the due date without penalty, whether or not late handins are allowed for the assignment. Extensions are expected to be rare, as taking more time for one thing cuts into the time available for the next, and are primarily intended for when there is an extended absence or issue that affects a significant amount of the time for an assignment. In such a case, contact me as soon as possible to discuss a timeline for completing the missing work.
All exams are in class. Every effort should be made to attend class and take the exams at the scheduled times. If you have an unavoidable conflict and are unable to attend class on an exam date due to scheduled things such as sports competitions, official Colleges activities such as musical performances or debate competitions, academically-related events such as attending a conference, job interviews, or religious observances, you must make arrangements in advance for rescheduling the exam (typically as soon as possible after the scheduled date). In the case of a last-minute illness or a personal or family emergency that causes you to miss class on an exam date, you must contact me as soon as possible to arrange a make-up time. In all cases, you may not discuss anything related to the exam until you have completed it. Note that leaving early for a vacation, being busy, needing more time to study, or having a bunch of assignments or exams due at the same time are not considered reasons for rescheduling an exam. However, if you have three final exams on the same day, you may request that one of them be moved to a different time period. No work will be accepted after the end of the Registrar-scheduled final exam time slot except in the case of an incomplete. The final exam cannot be rescheduled without the authorization of your dean. |
Working Together and Academic Integrity |
The HWS Principle of Academic Integrity governs all of the work completed in this course. Students should read the full policy. For this course:
Violations can result in anything from a warning to point deductions or a 0 on the assignment for the first offense. A second such offense is grounds for failure in the course. Cases may also be referred to the Committee on Standards. Note that the HWS Principle of Academic Integrity states:
There are no exceptions to this policy; ignorance of the policy and desperation ("It was the night before it was due and there wasn't anyone else to ask!") are specifically not excuses for violating the policy. If you are having trouble with the course material, come to the instructor! - it is never advantageous to "borrow" someone else's solution, and the time spent trying to disguise this "borrowing" is far better spent getting help. |
Being Successful |
There is a lot of new material in this course, and at any point you will likely have several active assignments: daily lessons, practice problems, the project, and possibly an exam. Don't fall behind! It is important that you budget your time so that you can fit all of these things in and get them in on time. Dates for major assignments and exams are on the schedule page. Topics introduced earlier are used and built on later in the course. Review each day's material soon after class and start on practice problems early, and seek help promptly if you are stuck on something or want to discuss ideas. Letting a point of confusion slide often snowballs, and it is easy to find yourself falling behind if that happens. It is also important that you take responsibility for your own learning and do enough problems to master the material, seeking out help as needed. Do the practice problems provided (even more than the minimum requirement) and pay attention to the feedback! Note taking on paper is encouraged as it avoids the distraction of electronic devices and the act of handwriting helps with retention of information. (Anything that appears on the projector screen - slides, examples, or code - will be posted on the schedule page soon after class, so you don't need to copy down all of that material in your notes.) If you do use a laptop or other device to take notes, you are encouraged to turn off notifications and close other applications to reduce the temptation of those distractions. A useful strategy for note-taking is to (only) make note of key ideas and examples during class and then rewrite your notes, filling in other details and relevant information, soon after class. This allows you to pay more attention during class, increases your engagement with the material, and helps you identify what you need to ask questions about. If there is something related to the course format or materials that would help you be more successful in the course, please come discuss it with me. |
Resources and Accommodations |
Your primary resource if you need help with any aspect of the course material is the instructor - ask questions during class, stop by office hours, send email, or drop by or schedule a meeting. For more general help, such as with writing, study skills, or time management, you are encouraged to check out the Center for Teaching and Learning (CTL):
Disability accommodations:
|