Office: K-112
email: Priscilla.Grocer@bristolcc.edu
Phone: 508-678-2811 ext 2403
Course
Description (from catalog):
Original Description: The students in this
course will learn to work with an open source database. They will learn the concepts of
creating a relational open source database, querying the database using
standard query techniques including SQL and maintaining the database.
Modified Description: The
students in this course will learn to work with an open source database and a
programming language to support the database. They will learn the concepts of creating a relational open
source database, querying the database using standard query techniques
including SQL and a programming language and maintaining the database. They will learn to use the database and
accompanying programming language in the web environment.
Course Objectives:
n
Understand
the concepts of open source and a database implementation
n
Develop the skills to work
effectively with an open source database
n
Design a relational open
source database
n
Develop the ability to
query the database
n
Develop the ability to use
SQL effectively
n
Develop the ability to
write programs to use the database
n
Learn a programming
language that can be used effectively to manipulate the database on the web
n
Write programs for the web
n
Develop the ability to
maintain the database
n
Contrast to other databases
widely used in industry
Texts:
PHP
6/My SQL by Andy Harris
Premier
Press, Course Technology
Available on line at ebrary.
Book
you might consider if you are interested in Game Development:
PHP
Game Programming by Matt Rutledge
Premier
Press, Course Technology, ISBN 1-59200-153-X
Outline:
This is
a listing of the topics being covered; the order will change depending on the
needs of the class.
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 using student option enrollment, which
means it, is offered as an in-class course, as a Distance Learning /Web based
course, or as a course where the student can mix in-class and web based. 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. 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 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 and shared with
other members of the class.
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.
Service Learning Project
Opportunity: Students with a strong mastery of LOGO/Alice are invited to
participate in a Service Learning project for extra credit. Bristol Community
College defines service learning as: "Service-learning is an unpaid,
credit-bearing, course-specific educational experience for which students
participate in a quality service-learning experience that does the following:
meets actual community needs and requires reflection on the service activity
that furthers the understanding of course content, broadens the appreciation of
the discipline, and enhances the sense of civic responsibility." You would
do this special project, including the reflection activity, as extra credit. It
will involve preparing a project, working with students from the Kuss Middle
School or Morton Middle School and then reflecting on the project. I want you
to think about whether LOGO is a good way to introduce middle school students
to logic, programming and computers and the ways that BCC could set up and
administer a project on a long term basis with young students using LOGO to
create an interest in the computing field. Your response should be sent to me
via email. Your work in service learning will be noted on your academic
transcript.
Back to the Top
Return to home page