Resources (strongly recommended)

Course ELMS Website

Textbook: Murach’s MySQL, 4th Edition (2019), Murach, J. ISBN: 9781943873104

Or any copy of the 2nd  or 3rd  edition; the data in the examples will differ slightly, but chapters with major differences are available in course reserves.

eBook| Physical copies are available via the campus bookstore.

Additional readings and resources will be assigned via ELMS.

Computer Use:

We will work through SQL examples during lectures and discussions. Please have a computer available for coursework during class sessions to ensure a full learning experience. There are Recommended Computer Specifications for the College of Information that will support the software used in this course.

Software:

• MySQL Community Server & Workbench versions 8.0 or later

-   Mac: MySQL Community Server&MySQL Workbench. NOTE: Specific MySQL sub-versions are compatible with specific macOS versions.

-   Windows: MySQL Installer.

Check ELMS for download and installation instructions, videos, and other resources. Feel free to seek help from the instruction team.

Campus Policies

It is our shared responsibility to know and abide by the University of Maryland’s policies that relate to all courses, which include topics such as:

□   Academic integrity

□   Student and instructor conduct

□ Accessibility and accommodations

□   Attendance and excused absences

□   Grades and appeals

□ Copyright and intellectual property

Please visit Course-Related Policies and Resources for Undergraduate Students for the Office of

Undergraduate Studies’ full list of campus-wide policies, and follow up with me if you have questions.

Course Policies

□    Stay engaged with the course and participate.

□    There are many ways you can participate, including completing asynchronous work, attending lecture and discussion sessions, discussions, and project teamwork.

□    Have a computer available for course-related work and bring it to class (make sure it’s fully charged).

□    Monitor ELMS daily; adjust settings as needed to ensure receipt of all notifications.

□    Follow the course calendar activities:

o  Watch the week’s assigned videos, keep up with readings, and execute examples before the lecture.

o  Review practice problems before discussion/lab sessions.

o  Complete worksheets, homework, and quizzes as assigned.

o  Complete lab quizzes during discussion sessions (or soon after) and submit via ELMS.

o  Submit all individual and team assignments via ELMS on time. Some assignments cannot be submitted late, and others have late penalties.

o  Do not wait until the deadline to make your ELMS submission! ELMS will mark submissions as "late" even if they are only a few minutes late. Technical issues at 10 pm on the due date are NOT our emergency! So, begin assignments early and attend office hours for assistance.

o No submissions are accepted outside of the ELMS course site!

□    All team members must participate actively in the team project.

□    If you are struggling with the course content or schedule, please reach out to the instructors and TAs.

□ If you have an excuse for an absence or a deadline extension request, submit the Absences/Extensions Request form either before the absence or within 2 weeks after the absence or deadline in question!

Additional University Resources

You are expected to take personal responsibility for your own learning. This includes acknowledging when your performance does not align with your goals and taking action. Everyone can benefit from expert guidance on time management, note-taking, and exam preparation; I encourage you to schedule an appointment with an Academic Coach. Sharpen your communication skills by visiting the Writing Center. Finally, if you just need someone to talk to, visit the Counseling Center.

Notice of Mandatory Reporting

Notice of mandatory reporting of sexual assault, sexual harassment, interpersonal violence, and stalking: As faculty members, we are designated as “Responsible University Employees,” and we must report all disclosures of sexual assault, sexual harassment, interpersonal violence, and stalking to UMD’s Title IX Coordinator per University Policy on Sexual Harassment and Other Sexual Misconduct. If you wish to speak with someone confidentially, please contact one of UMD’s confidential resources, such as CARE to Stop Violence (located on the Ground Floor of the Health Center) at 301-741-3442 or the Counseling Center (located at the Shoemaker Building) at 301-314-7651. You may also seek assistance or supportive measures from UMD’s Title IX Coordinator, by calling 301-405-1142, or emailing. To view further information on the above, please visit the Office of Civil Rights and Sexual Misconduct's website.

Names/Pronouns and Self-Identifications

The University of Maryland recognizes the importance of a diverse student body and is committed to fostering equitable classroom environments. We invite you, if you wish, to tell us how you want to be referred to both in terms of your name and your pronouns (he/him, she/her, they/them, etc.). The pronouns someone indicates are not necessarily indicative of their gender identity. Visit the LGBTQ+ Equity Center to learn more.

Additionally, how you identify in terms of your gender, race, class, sexuality, religion, and dis/ability, among all aspects of your identity, is your choice whether to disclose (e.g., should it come up in classroom conversation about our experiences and perspectives) and should be self-identified, not presumed or imposed.

We will do our best to address and refer to all students accordingly, and we ask you to do the same for all your fellow Terps.

Office Hours and Group Project Support

For extra clarification on a lecture topic, a lab exercise, a quiz, or assistance with a homework assignment, please attend online or in-person office hours. The office hour schedule is on the ELMS home page.

Course Structure

The course is delivered in a hybrid learning format structured around weekly modules. As such, there are asynchronous elements and synchronous classes.

• Self-study Preparation (Asynchronous Materials): This includes readings, slides, videos, and weekly quizzes.

Students are expected to complete the assigned readings, videos, and quizzes before their weekly lecture.

• Lecture and Discussion Classes (Synchronous Sessions): Lectures and discussion/lab classes will be interactive and based on the material covered in the Self-Study Preparation. Participation is necessary to excel at this course. If you anticipate missing a session, email the instructors and TAs ahead of time, or contact us as soon afterwards as possible and submit an Absences/Extensions Request form within 2 weeks of the absence.

•    At least three "participation instances" (e.g., lecture + lab + one office-hour visit, or lecture + lab + project team meeting) per week are advised and encouraged.

Excused Absences and Assignment Extensions

If you have an excused absence or deadline extension request, submit the Absences / Extension Request form either before the absence or within 2 weeks after the absence or impacted assignment deadline. UMD policies require students to “notify the instructor in a timely manner” in case of an absence or missed submission.

Hence, assignment extension requests more than 2 weeks beyond the close date will not be granted. According to UMD policies, absences stemming from work duties other than military obligations (e.g., unexpected changes in shift assignments) and traffic/transit problems do not typically qualify as excused absences. NOTE:

All missed assignments, discussions, quizzes, and labs that you want to submit require an extension request.

Only university-sanctioned absences (religious observance, unforeseen life circumstances out of your control with documentation, or illnesses with appropriate documentation) will be accepted. If documentation related to an illness is not available, you may use a once-per-semester self-signed excuse.The complete university policy on absences can be found here.

All team assignments must be completed on time since available team members are expected to complete deliverables even ifa team member is unavailable, regardless of the absent individual’s reason. When a team member is unable to actively participate in a project deliverable, they are expected to put in extra effort on subsequent deliverables.

Grades

Your course grade is determined by your performance on the learning assessments in the course. Assessment scores will be posted on ELMS. If you would like to discuss your grade or have questions about how something was scored, please schedule a time with the course TA. Grade disputes must be submitted in writing within one week of receiving the grade.

A few assignments will allow a slightly late submission for a percentage deduction on the score. In such cases, the cut-off times and associated penalties will be indicated in the assignment. Assignments submitted beyond  the final due date will not be accepted, and you will receive a zero. Not all assignments will allow for late submission. Please read all submission instructions carefully!

This table illustrates the percentage weight of each assessment towards your final grade.

Letter grades will be assigned using the following scale. There is no rounding of numeric grades up to the next letter grade.

Requests for Reference Letters and Other Kinds of Recommendations

Prof. Duffy and Mr. DeWitt are currently unable to accommodate requests for letters of reference. They may be able to support phone or email inquiries from employers regarding job applications and internships.