Office: K-112
Phone: 508-678-2811
Email:
Priscilla.Grocer@bristolcc.edu
Course
Description (from catalog):
This course is an introduction to the Oracle database. The student will learn to
work with Oracle and the structured query language SQL as they design,
manipulate and access the database. In addition, the concepts and design of
relational databases will be analyzed and implemented.
Course Objectives:
The primary objective of this course is to teach the student to work with
Oracle both in the development of the database and the use of SQL and PL/SQL.
At the completion of this course, the following objectives should have been
accomplished:
Texts: The textbook for this course is: Oracle9i:
SQL with an Introduction to PL/SQL
Lannes L Morris-Murphy
Course Technology
You can get a version of Oracle 9i from oracle - look at the section under
Installation and login at my site. There is one reference that is really step by step.
Material to be
Covered: The order in the syllabus does not necessary reflect the order that
will used in the course. Please use the weekly schedule sheet to follow the
assigned topics.
Requirements and Grading: The
student will be expected to complete all assigned work. In addition there will
be a final exam.
A schedule of assignments, projects, exams, quizzes etc. will be posted on the
Web site. Students should check on a regular basis.
Grading percents are:
Evaluation:Assignments,
programs and exams are graded using either number grades or letter grades based
on the following (A=90-100, B=80-89, C=70-79, D=60-69, F=below 60). The
student's grade for the course will use the same scale and will be based on the
percentages explained in the grading section. Plus and minus grades will be
given.
Many of the assignments in this class are open ended - the grading will be
based on how well the project demonstrates mastery of the material. Students
who do a minimum of work will be graded accordingly. Assignments are only
accepted if they are credible work and meet the minimum requirements and
standards for that assignment. Assignments that are not accepted can be
resubmitted. Resubmission is allowed on graded assignments, with permission of
the instructor. You cannot earn an A+ on an assignment that is resubmitted. The
instructor will only accept, without penalty, resubmissions on credible work.
Resubmissions must be done within a week to avoid additional penalties for late
assignments.
Note: To achieve an A+, on open-ended assignments, students must have done
sufficient extra work in development or implementation tot make the assignment
standout. In doing assignments, students must do their own work. Relying too
heavily on my examples or working too closely with someone else will be
penalized.
Assignments are due the week
after they are assigned. Late
assignments will be penalized. If the assignment is one week late it will drop
10%, two weeks late will drop 20%, three weeks late will drop 30% and anything
over 3 weeks late will drop 40%.
For purposes of this class, the week will end at midnight on Sunday. The
new week will start on Monday morning.
Attendance:
Because this course can be taken over the web, in class, or a mixture of the
two, attendance is based on email communication. Students must report their
status once a week. This report can be combined with the submission of an
assignment.
Methodology: This course is offered as an in class course or as a Distance
Learning, course or as a course where the student can put together there own
combination of in class and online participation. For in-class students, it is
a combination of lectures and interactive projects with supplementary information available on
the Web. Web based students will be relying on the information at the Web site
for the information being presented in class with interaction through a variety
of online techniques. Web based students are invited to attend class at any
time if they feel that hearing a lecture would be valuable. Lectures are recorded and put online and Smartboard notes are captured and put on line.All students should
read the assigned notes, study the presentations available and avail themselves
of other resources at the web site in mastering the course material. In
addition, students will be working independently on projects designed to give
them additional computer skills and practical experience in analyzing and
solving problems. When appropriate, exercises and problem solving techniques
are used. This syllabus is not to be construed as a contract in any way, shape,
manner or form. This syllabus contains a suggested course outline and will be
generally followed, subject to change according to the instructor’s discretion
and needs. Academic flexibility is important!
Interaction Plan: This is an
asynchronous course with synchronous components if you decide to attend
classes. Communication includes email , blog, IM including voice, and online
office hours and help sessions.
Other methods of online communications may also be used. In addition open lab help session are
scheduled and students may request in person meetings. Students must communicate with the
instructor at least once a week via email and must turn in homework and
participate in online communication to be successful.
Back to the Top
Return to home page
Return to previous page - CIS50