Course #: | COMP 353-001 3397 (in-person with
several online meetings) There is no online section, but I am fully supporting online students |
Day/Time: | Thursday, 4:15 - 6:45 |
Classroom: | Cuneo Hall , Room 203 |
Prerequisites: | COMP 271 or COMP 251 |
Instructor: | Dr. Channah Naiman |
email: | cnaiman@luc.edu |
web page: | http://webpages.cs.luc.edu/~cnaiman |
office hours: |
Thursday, 2:45 -
3:45, or by appointment Doyle Center 205 x. 88113 (email preferred!!) Also, shortly before and after class in or near our classroom. |
TA: |
no such luck--it's
all me, all the time.... |
Course
Description: This
course covers the fundamentals of database design and application
development by accessing a transaction-oriented database server. Emphasis on SQL. An open-source database is
used. Additional
topics include enabling access to
the database via the web.
Outcome:
Students
will learn SQL,
database design and application development using the latest software
tools.
Students will also learn techniques for web based data retrieval and
manipulation.
Software:
Sakai:
As of this writing, Sakai will be used for course
announcements,
homework submissions, and grade postings. While the raw
scores
posted on Sakai should be correct (although I have encountered some
problems with that too!), please do not rely upon Sakai's Course Total
calculations. Usually, they are okay, but there have been
problems. I check the total grade postings periodically, to
check up on Sakai's calculations. Certainly, before the
mid-term grade posting on Locus, and before the drop deadlines, check
your grades (and I will too!) Grades are calculated as
specified in this
syllabus. If Sakai presents too many problems, we will switch
to
CourseSites.
Class
Format:
The
class sessions will be a mixture of lecture and lab. The
proportion of each will vary by the topic being covered. If
you
have a laptop, you will want to bring it to class starting with the third wek of class, unless I let you
know in advance. Some of the labs are worth points, and some
of them cannot be made up outside of class.
Labs 4, 5 and 6 have assignments associated with them.
Nearly all of the lectures and labs
will be
videoed,
and links provided on Sakai. Reading materials, lab
assignments
and homeworks are all posted, either on Sakai or linked to on this
syllabus.
I will be presenting examples and demonstrating code that are not in your text. You are responsible for what is presented in class, even if some of the activity may not be covered in the class notes. If you choose not to attend, that is your prerogative; however, make sure that you find out what you missed.
The
last third of the class will focus on the project. We will
have two guest lectures from Mr. Elliott Post, one of our adjuncts, a
professional full-stack web developer, who specializes in PHP. We
will also have several "flipped" classes, where you may review the
videos of several short topics (such as transactions, cookies,
sessions) on your own time, and I will work with teams during "project
walkarounds" during class time.
Cell Phones: Only
you know
the relative importance of any particular
cell phone call, and whether it is important for you to answer a call
immediately rather than later. I do want you to be respectful of your
classmates and disrupt the class as little as is practical.
If you get cell phone
calls with fair frequency, be sure to have the ring muted before coming
to class. If you rarely get calls, you might not mute it ahead, and
your cell phone may happen to ring. Get rid of the noise as soon as
possible, and do not get flustered. I assume you will move outside the
classroom for a conversation. If you get fairly frequent calls that you
are likely to consider important answering, sit in a place where your
exit and re-entrance are as unobtrusive as possible.
*No second try*: If you have an excuse for not being prepared to take the exam, but decide to take it anyway, you don't get to change your mind after you see a poor grade. Being sick is not a way to get one more chance than everyone else. I may allow you to delay an exam due to illness, but I will not let you be reexamined due to a poor grade.
Religious Holidays: Students with religious holiday conflicts: Please let me know within the first two weeks of class if you have a religious holiday conflict with any exam or homework due date, so that we can plan on an accommodation.Students with Disabilities: If you have a documented disability and wish to discuss academic accommodations, please contact the Services for Students with Disabilities Office (773-508-3700 and SSWD@luc.edu) as soon as possible. Students with documented disabilities who provide me with a letter from the SSWD office will be fully accommodated as per the terms of the letter. Students who are allowed to take their exams in the SSWD office are encouraged to do so. Should you choose to take the exam in the classroom, I cannot guarantee that the classroom environment will be quiet enough to provide you with the environment that your disability may require. If you choose to take the exam in the classroom, you are taking that risk.
Students with Sponsorships and Scholarships: If you require a certain grade in order to satisfy a sponsor or a scholarship requirement, please be sure to monitor your grade on Sakai. I will consider only your performance in this course in calculating grades, using the grading rubric posted in this syllabus. If you cannot achieve a minimum grade that is required by a sponsor or a scholarship, I will not change your grade to help you meet that requirement. This would be unfair to other students, and not reflecive of your performance in this course. You are reponsible to monitor your grade and to keep apprised of the withdrawal dates posted by the registrar.
|
A |
93 |
A- |
90 |
B+ |
87 |
B |
83 |
B- |
80 |
C+ |
77 |
C |
73 |
C- |
70 |
D+ |
67 |
D |
63 |
The dates below give the sequence and a general idea of the time spent, though we may get ahead or behind this time schedule at different points, depending on the needs of the class. Be sure to keep up with where we really are in class.
Labs (except for Lab 0, which isn't really a lab) are listed for the class when we will work on them together. The TA or I should check off your completion or at least your participation during the same class. Labs 1, 2 and 3 cannot be made up outside of class. Sometimes, we can't finish the labs in class. In that case, I will check that work was done during class and allow a submission later, usually that night or the next day. Labs 4 - 7 have assignments associated with them. Due dates are listed on this syllabus and on Sakai.
Assignments are to be turned in on the date where they are listed below as due, generally by 11:55PM.
In general, read the assigned chapters before coming to
class.
Most
lectures
will not follow the book exactly. Very few will use
the text's PowerPoints. However you are responsible for the
chapter anyway, even if I focus on certain examples and not others from
the text. It's the best of both worlds!
The first few weeks look like we are covering a lot of
chapters.
This is because the chapater topics are interrelated, and there is a
lot of overlap. The data modeling examples given in class
will include a discussion of the functional dependencies
inherent
in the applications, and the ER diagrams will reflect the normalized
relations for that model. Do not get overwhelmed with the
reading
(although the book is very clear). Rather, I will walk you
through the important topics. You will have time to catch up
on
the reading by the midterm.
Date |
Activities |
Assignments |
1/18 |
|
Install
XAMPP
on your laptops, if you are using a laptop. Configure
PHPMyAdmin, (possible
issues),
(You can
use any WAMP, MAMP or LAMP stack, or you can use a VM on Guacamole if
you request one. But I have
supplied
instructions to XAMPP, which works on Windows and Mac. Check
the
orientation assignments on Sakai.) Test your installation as
per
instructions on Sakai. You may also want to install SublimeText, atom, TextWrangler (or any good text editor) on the mac, or Notepad++ on Windows Assign: Homework #1 Orientation: Available on Sakai. Best to complete before the course begins. |
1/25 |
|
Due: Homework #1 Assign: Homework #2 (use EER case) resolve any installation issues on stack |
2/01 |
|
Due: Orientatinon Tasks Due: Homework #2 Assign: Homework #3 Lab #1: show me or TA at end of class |
2/08 |
DUE : Homework #3 Lab #2: show me or TA at end of class Assign: Homework #4 |
|
2/15 |
|
Lab
#3: due at the end of class Hard deadline for Homeworks 1-3 |
2/22 |
|
DUE: Homework
#4 |
3/01 | Midterm Exam (Review
for midterm) |
|
3/07 | Spring Break, no classes | |
3/15 |
|
Assign: Homework
#5 DUE: Lab 4 assignment |
3/22 |
Possibly a "flipped" class. Watch these videos on your own time,
and we'll finish work from the previous lecture, and spend time
clarifying project requirements with teams. Depends on how far we
are in the material.
|
DUE: Lab 5 assignment |
3/29 | Easter holiday break, no classes But let's set up project team meeting using Skyp or zoom!! | |
4/05 |
Demonstration of advanced topics: (Mr. Elliott Post)
|
DUE: Homework #5 DUE: Informal Project Proposal DUE: Lab #6 |
4/12 |
Demonstrations
of additional topics: Probably a "flipped" class. Watch the videos on your own time, and project walkarounds in class.
|
|
4/19 | Project Help Day (Mr. Elliott Post) |
DUE: Lab #7 (unless otherwise instructed) |
4/26 |
Supervised project work (and possibly some topics from the previous
week) |
|
5/03 |
Project Presentations, in lieu of Final Exam | DUE: Project PPTs , report, code. |
Spring Semester, 2018 | |
Spring Semester Open registration ends at midnight | Jan. 14 |
Martin Luther King, Jr., Holiday, No classes | Jan. 15 |
Spring Semester Begins. Late and Change of Registration begins - Late registration fee applies | Jan. 16 (Tues) |
Late and change registration ends. Last day to withdraw without a mark of "W" | Jan. 22 |
Last day to drop class(es) with a Bursar credit of 100%- dates maintained by Bursar | Jan. 29 (Mon) |
Last day to convert from credit to audit or vice versa - Last day to request or cancel pass/no pass option | Jan. 29 |
Last day to drop class(es) with a Bursar credit of 50%- dates maintained by Bursar | Feb. 12 (Mon) |
Summer Registration Begins | Feb. 12 |
Ash Wed (46 days before Easter): Classes meet, Special worship services available | Feb. 14 |
Last day to drop class(es) with a Bursar credit of 20% (zero credit thereafter) | Feb. 19 (Mon) |
Last day for students to submit assignments to change an "I" grade, from the preceding Fall Semester and the preceding "J" Term, to a letter grade; Faculty may set an earlier deadline | Feb. 26 |
Early alert process begins on Mon week 7 and runs through Fri of the week 9 | Feb. 26 |
Last day to file applications with Deans' offices for degrees awarded in December for this year | Mar. 1 |
Spring Break: No classes | Mar. 5 - 10 |
Classes Resume | Mar. 12 |
Last day (5:00 p.m.) to withdraw with a grade of "W", after this date, the penalty grade of "WF" is assigned | Mar. 26 |
Good Friday , No classes (offices closed) | Mar. 30 |
Easter Holiday: No classes Thurs evening (classes that start 4:15 p.m. or later are canceled) through Mon afternoon (classes beginning on or after 4:15 p.m. will be held) | Mar. 29 - Apr. 2 |
Fall Semester UGRD Registration begins | 16-Apr |
Spring Semester classes end | 27-Apr |
Final Examinations | April 30 - May 5 |
*Study Day Wednesdays: No daytime exams will be held. | |
Evening classes meeting at 4:15pm or later will hold exams as scheduled. |