Databases and Websites Syllabus

BSAD 3341 Spring 2017

Instructor Information

Name : Terry Sergeant   Office Hours
E-Mail : MW 8:30-10:00; 2:00-3:00  
Office : JB 322 TTh 8:30-9:30; 2:00-3:00  
Phone : 670-1292 Fri 9:00-10:00  
Web Site :      


Description : Students will learn how to apply theories of database design to create and use databases in more than one relational database management system. Student will learn how to create and manage websites using a content management system. Students will also learn how to choose a web hosting company, how to purchase a domain name, and how to modify layouts.
Prerequisites : None
Textbook : None

Course Objectives

Students who satisfactorily complete this course will (hopefully) be able to:


Your grade in the course will be earned / calculated as follows:
lab days   10%
homework   30%
midterm exam   30%
final exam   30%
A $\rightarrow$ 90 - 100
B $\rightarrow$ 80 - 89
C $\rightarrow$ 70 - 79
D $\rightarrow$ 60 - 69
F $\rightarrow$ 0 - 59

Lab Days

Most Thursday's will be designated as a ``lab day'' in which we will spend some time working on exercises or homework during the class period. Attendance is mandatory and you will receive a grade out 10 possible points for each lab day evaluated as follows:

3 points preparation did you prepare for the lab day in advance?
2 points attendance did you show up on time and stay for the entire lab session?
5 points participation were you actively engaged in the session without distraction?

Days which are designated as lab days will appear as an assignment in Canvas and will include ``pre-lab'' instructions that are to be completed prior to lab day. If you know in advance you will have to be absent on a lab day you can receive credit by doing the following:

  1. Prior to the start of the lab day on Thursday send email to announcing you will be absent and attaching files you have been working on (or whatever makes sense) as evidence of your preparation for the lab period. If your preparation has been inline with the pre-lab assignment you will receive 3 points.
  2. Prior to the start of class on the following Tuesday send email to explaining your progress since the first email. Also attach files or provide URLs (or whatever makes sense) as evidence of your completed work. You can receive up to 7 points based on your continued progress.

Homework Assignments

Homework will be assigned and graded on a regular basis. Point values (and lead time) will vary in accordance with the difficulty of the assignment.

A homework assignment is considered late if it is not submitted at or before the beginning of the class period on the day it is due. Late homework assignments will receive a 20% point penalty and must be completed within a week or the original due date. Assignments that miss the one week deadline will receive a grade of 0 (unless there are extenuating circumstances).

In order to do well on the exams it will be necessary for each student to work homework assignments independently. There are times, however, when you may become stuck and require assistance. For this reason, the standard regarding independent homework is quite loose:

When working a homework assignment you must not make any sort of electronic copy of work that is not your own. Also, you must type assignments yourself. Failure to abide by these rules is a violation of the academic integrity standards for this course.


Exams are comprehensive. The final exam will take place at the scheduled time during finals week. Exams will never be collaborative in nature so receiving any form of assistance from anyone other than the instructor is a violation of the academic integrity policy. You may only use study aids during the exam if they are expressly allowed by the instructor for that particular exam.

Students with Disabilities

Any student with a professionally diagnosed learning disability and/or other professionally diagnosed disability that may affect course performance may choose to seek accommodation. Eligible students seeking accommodation should contact the Office of the Director of Undergraduate Advising and Disabilities of such as soon as possible in the academic term (preferably during the first two weeks of a long semester) for which they are seeking accommodations. The director will prepare letters to appropriate faculty members concerning specific, reasonable academic adjustments for the student. The student is responsible for delivering accommodation letters and conferring with faculty members. Please refer to the most recent version of the Undergraduate Catalog for the complete policy. (Lindsay Boynton, Director of Undergraduate Advising and Disabilities, Office: SM-209, Phone: 670-5842, Email:

Academic Integrity

Violations of academic integrity have been described to some degree in other sections of this syllabus.

Cases of suspected academic dishonesty will be handled in accordance with university policies outlined in Undergraduate Catalog and in the Student Handbook. The current catalog prescribes that ``no student who has violated the Academic Integrity Policy will be allowed to graduate from Hardin-Simmons University with honors.'' Penalties will be assigned at the discretion of the instructor and typically range from failure on the assignment to failure of the course. A general rule-of-thumb is that a first offense (if not too major) will result in a zero on the assignment and a second offense will result in an F for the course. The current catalog states that an F earned in this way cannot be replaced by retaking the course.

Computer Account Use

The instructor may occasionally use email to communicate with the class as a whole or with individuals. When contacting you for this course the instructor will use your HSU email account. You are expected to check your HSU email account at least once per day and you will be held responsible for any content distributed in this way.


Regarding class attendance, the Undergraduate Catalog states:
Accordingly, absence from more than 25 percent of class meetings and/or laboratory sessions scheduled for a course (including absences because of athletic participation) is regarded as excessive, and a grade of F may be assigned as deemed appropriate by the professor.

Course Calendar and Class Structure

We may vary from this outline somewhat but the exam dates are fairly firm. Note that the day of the week on which an exam is scheduled is specified in parenthesis.

Week Date Topic / Schedules
Week 1 16 Jan Intro to Website Hosting
Week 2 23 Jan Website Design
Week 3 30 Jan Intro to Wordpress
Week 4 06 Feb Wordpress
Week 5 13 Feb Graphics
Week 6 20 Feb SEO
Week 7 27 Feb Managing Backups
Week 8 06 Mar Thu: Midterm Exam
Week X 13 Mar Spring Break!
Week 9 20 Mar HTML & CSS
Week 10 27 Mar Database Concepts
Week 11 03 Apr MS Access
Week 12 10 Apr Normalization and Design
Week 13 17 Apr MySQL
Week 14 24 Apr SQL
Week 15 01 May Misc. Database Skills
  09 May Final Exam (Tue) at 10:30am

Quick Links