NORTH CENTRAL TEXAS COLLEGE
COURSE SYLLABUS
COURSE AND INSTRUCTOR INFORMATION
Course title: Intro to MySQL
Course prefix, number, and section number: ITSE 1303 0340
Semester/Year of course: Fall 2023
Semester start and end dates: August 28 – December 16
Modality (Face to face/Synchronous or Asynchronous online/Hybrid): Online
Class meeting location, days, and times: Online
Lab meeting location, days, and times: Online
Semester credit hours: 3
Course description: Introduction to the analysis and utilization of data requirements and organization into normalized tables using the four normal forms of database design.
Course prerequisites: None
Required course materials:
Book: Murach, Joel, Murach’s MYSQL 3rd Edition, ISBN: 978-1-943872-36-7
Software: MySQL Community Server 8.0 & MySQL Workbench 8.0
Computer: Running minimum Windows 8 Operating System, with Administrative rights to install software.
Name of instructor: Rebekah Sanchez
Office location: Corinth Campus, Suite 170, Room 173
Telephone number: 940.498.6480
E-mail address: rsanchez@nctc.edu
Office hours for students: By appointment
SYLLABUS CHANGE DISCLAIMER
The faculty member reserves the right to make changes to this published syllabus if it is in the best interest of the educational development of this class. Any such changes will be announced as soon as possible in person and/or writing.
SUMMARY OF COURSE ASSIGNMENTS
List of graded assignments:
19 Labs – 20 pts. each = 340 total pts. with after lowest two dropped
19 Quizzes – 10 pts. each = 170 total pts. after lowest two dropped
4 Exams – 50 pts. each = 200 total pts.
2 Discussion Posts – 30 pts. for Introduction Post; 100 pts. for Collaboration Post = 130 total pts.
16 Weekly Videos – 10 pts. each = 160 total pts.
Final grade scale:
900-1000 points = A
800-899 points = B
700-799 points = C
600-699 points = D
0-599 points = F
Late work policy:
Assignments are due on the date and time indicated on the assignment. These dates/times are listed on the course calendar and will appear on your Canvas calendar and ‘to do list’. Assignments include everything that receives a grade. Your lowest two labs and two quizzes will be dropped. All assignments are due by the due date. If you have extenuating circumstances, I encourage you to reach out to me and we can discuss your individual situation. That does not mean that communicating with me will automatically extend your deadlines. It does mean that I will take it into consideration for extending the assignment. Although it is not always possible, communication is best when it happens prior to deadlines.
SEE CANVAS FOR THE COMPLETE COURSE CALENDAR, OUTLINE, DETAILED DESCRIPTION OF GRADED WORK, AND OTHER RELATED MATERIAL.
COURSE POLICIES
Academic Integrity Policy: Scholastic dishonesty shall include, but is not limited to cheating, plagiarism, academic falsification, intellectual property dishonesty, academic dishonesty facilitation and collusion. Faculty members may document and bring charges against a student who is engaged in or is suspected to be engaged in academic dishonesty. See Student Handbook, “Student Rights & Responsibilities: Student Conduct ([FLB(LOCAL)]”.
AI/Natural Language Programs (NLPs)/Large Language Models (LLMs) Usage Policy: This information is used with permission and citation with gratitude to Princeton University: The McGraw Center for Teaching and Learning. Intellectual honesty is vital to an academic community and for my fair evaluation of your work. All work submitted in this course must be your own, completed in accordance with the College's academic regulations. You may not engage in unauthorized collaboration or make use of ChatGPT or other AI composition software/NLPs/LLMs. Students must obtain permission from me before using AI composition software (like ChatGPT) for any assignments in this course. Using these tools without my permission puts your academic integrity at risk. This course does make use of AI/NLPs/LLMs plagiarism checker software as such as “Turnitin” developed for the purpose of detecting the use of AI programs. Any violation of this policy will be considered academic dishonesty and will be documented and filed as such. See Student Handbook, “Student Rights and Responsibilities: Student Conduct ([FLB(LOCAL])”.
Attendance Policy: Regular and punctual attendance is expected of all students in all classes for which they have registered. All absences are considered to be unauthorized unless the student is absent due to illness or emergencies as determined by the instructor. It is the student responsibility to provide documentation as to the emergency for approval and judgement by the faculty member. Approved college sponsored activities are the only absences for which a student should not be held liable and only when provided by a college official ahead of the absence. Valid reasons for absence, however, do not relieve the student of the responsibility for making up required work. Students will not be allowed to make up an examination missed due to absence unless they have reasons acceptable to the instructor. A student who is compelled to be absent when a test is given should petition the instructor, in advance if possible, for permission to postpone the exam. Student will be dropped from a class by the Registrar upon recommendation of the instructor who feels the student has been justifiably absent or tardy a sufficient number of times to preclude meeting the course’s objectives. Persistent, unjustified absences from classes or laboratories will be considered sufficient cause for College officials to drop a student from the rolls of the College. From Board Policy FC (LOCAL)
Withdrawal Policy
A student may withdraw from a course on or after the official date of record. It is the student’s responsibility to initiate and complete a Withdrawal Request Form.
Last day to withdraw from the course with a “W” is: November 6, 2023
Student Learning Outcomes:
Upon successful completion, students will be able to:
Identify database terminology and concepts
Plan, define, and design a database
Design and generate tables
Devise and process queries
Install, configure, and run the MySQL server
COLLEGE POLICIES