Description
Database 1 is a 3-unit class. Students should be prepared
to spend about 9 hours a week on class material. This is the
equivalent of 3 hours' time in the classroom and 6
additional hours of homework time. In an online
course, the 9 hours will consist of reading the announcements, emails and
the textbook, going through tutorials and videos, taking part in
discussions, optional Zoom sessions and doing
assignments quizzes and exams.
This course teaches students to use Microsoft Access
2019 to create, access and maintain databases on the
personal computer. Topics include database theory,
design, editing, indexing, query techniques, custom
form creation, report design, printing and relational
techniques.
Requirements
This class requires a code for a publisher website and
Microsoft Office 2019. You can follow instructions to obtain
a free subscription to
Office 365
that can be used. Be aware that there is not a version
of Access for the Mac. There is a
Remote PC option
you can install, but I cannot guarantee how speedy it will
be. You will also need to purchase a Cengage Access Code.
The Unlimited Cengage codes allow you access to ALL
Cengage books. This means that if you have two or more classes
that use a Cengage book, you will only need to buy one code.
The Cengage Access code gives you access to the ebook but
you can also rent a hardcopy of the text for $7.99 if you
wish. You can purchase the codes either in the bookstore or
directly from
Cengage.
Please watch this
short video for more information for information
on obtaining and using the Cengage Access Code.
Getting Started
This class is hosted in
Canvas and also involves access to a publisher website.
Canvas will be used for class announcements and email, discussion
groups and projects. For information on logging into Canvas
please visit the
Fullerton
College Distance Education page. You must be registered
through Admissions and Records to be able to log into Canvas.
It can take 24 hours after registration for your account
to be enabled in Canvas. The Canvas class is typically not
available to students until the start of the semester.
Once in Canvas, carefully read the syllabus and take the
Syllabus quiz. You must achieve a perfect score on the syllabus
quiz in order to see any other class content. The Syllabus
quiz can be taken as many times as needed. After achieving
100% on the syllabus quiz in Canvas, the rest of the course
content will not be available to you. Click on one of the
assignment links and you will be prompted to create a
Cengage account and enter your access code. Once you
have completed these steps you can begin working in class.
Make sure to also explore the other links in the Getting
started Module for additional information on using Canvas
and for help with Cengage and information on
how to complete all the different activities.
You must complete 70% of the work assigned by the end
of the second week of class
and have your permanent code in order to be able to continue
with class.
Guidelines
Students can be dropped from the class for non-participation.
For an online class, participation is defined as maintaining
60% of the points in class at all times or missing one week's
worth of work. For a campus class, students can be dropped
for missing the equivalent of one week's worth of class
meetings. Please view the
College Catalog for more details. While the teacher
may officially withdraw a student who is not participating,
it is the student’s responsibility to withdraw if the student
decides not to, or is unable to continue in the class. Failure
to do so may result in a failing grade. You do not need
the instructor’s signature to drop the class. You can drop
the class using WebStar. The Instructor cannot drop you
after the Last Drop Date. It is the student's responsibility
to make sure they are properly registered in the class and
have not been dropped for non-payment or non-participation.
Any student not appearing on the roster at the end of the
semester will not receive a grade. It is also the student's
responsibility to notify the instructor if they change their
name during the semester. If the name and Student ID number
do not match the name on the Admissions and Records roster,
the student may receive an incorrect grade.
Due to Covid Exams will be online. Students must take all
exams in order to be able to pass the class. If a review
is provided for any exam, it will be closed at least the
day before the first exam session. Several exam sessions
will be available to choose from. A survey will be posted to
allow students to select their session. If a student does
not make a selection they may not be able to take the exam. Makeup exams are not
guaranteed and it is up to the discretion of the Instructor
whether or not to give a makeup for a missed exam. Things
considered in that decision will include the amount and
quality of work the student has already completed, the reason
for missing the exam and the advance given notice by the
student. Makeup exams can be much more difficult than the
original exam and will be given at a time selected by the
instructor. Most likely the last day of the semester.
Exams cannot be given early. It is the student's responsibility to make sure
the instructor has all portions of the exam, including uploaded
files and all paperwork, before the student leaves the Exam.
Pay attention to Due Dates and times carefully - Homework
may include both work done in Canvas and a publisher website.
It is the student's responsibility to make sure all
assignments are submitted properly. Work Due dates are
listed in Canvas. The student is responsible to check course
announcements, email and web content on a regular basis.
Late work is not accepted for any reason. There
will be extra credit assignments available to make up the
points for the occasional missed assignment. Each
student will begin with 100 extra credit points. Each time a
student requests additional time to complete assignments, 25
of those extra credit points will be lost. Students
should not expect replies to emails requesting extensions
to due dates. If you enter the class late you
cannot expect extra time to complete the work.
The best way to contact the instructor outside of class
is through email. Send emails for this class through the
Canvas mail system. This helps keep emails from ending
up in the spam filter or junk mail. Please include your
full name, student number, CRN and relevant question information
such as chapter or quiz number in all emails. Proper sentence
structure including capitalization and punctuation will
aid the instructor in understanding your questions and allow
for a more timely and helpful response. Here is a
Fun link about this topic. The instructor will
attempt to answer all properly formatted emails within
24 business
hours, but it is not guaranteed. Questions sent last minute
may not be answered in time. If Canvas is down, you may
email to nwoolridge@fullcoll.edu. Answers to messages that
are left on voicemail or come to email outside of Canvas
may be delayed or not returned.
Each student must abide by the
Academic Honesty policy. All issues of academic dishonesty
will be reported. This includes accidental submission of
another student's work. There will NOT be any warnings.
Students are expected to have reviewed and comply with the
full
College Catalog and students should familiarize themselves
with the following
District, College,
and Division Policies including but not limited to the
Academic Honesty policy.
If you need additional time to complete a test or if you
require special accommodations, you must notify the instructor
in a timely manner and make arrangements with the
Disability
Support Services. This may include filling out forms
and making sure they are delivered to the instructor. Otherwise
you will be expected to adhere to general class accommodations.
Each student needs to take an active part in his/her own
education by reading the book, and checking the web site. A
student is responsible for all material covered in class.
The class material, as presented, assumes the student has
purchased the textbook bundle and/or website access. Missing
a class or not having the required materials is not
sufficient justification for a student's failure to complete
assignments.
Evaluations
There are two types of points in the class: Homework
and Exam. If a student achieves at least 70% of the homework
points and 70% of the total exam points in the class, the
final grade will be based on the average of the Homework
and Exam percentage. In order to achieve a C in the class
each student must get at least 70% of the points in both
the homework and test category. For example, if a student
receives 80% of the points for the homework, but only 60%
for the tests, they will get a D grade. Likewise, if a student
receives 90% of the points on the tests and only 65% of
the points on the homework, the student will receive a D
grade. If the student gets 80% of the homework points and
70% of the exam points, the average of those two scores
would be 75%, giving the student a C in the class.
Upon completion of CIS 142 F, Database 1, students should
be able to
1. Create a database and design appropriate tables and relationships
for a given set of data
2. Design and create queries to select, update or delete
requested information
3. Design and create functional forms and reports that allow
input, lookup and display of data
Dates
Classes begin - Monday, January 24
Last day to drop with refund - Sunday, February 6
Last day to drop without a W - Sunday, February 6
Last day to add - Sunday, February 6
Last day to apply for Spring Graduation - Thursday, February 17
Last day to withdraw from classes - Sunday, April 24
Last day of the Semester - Saturday, May 21
Contact
Nancy Woolridge
nwoolridge@fullcoll.edu
Virtual Office Hours (held via email and zoom)
Monday 10 a.m.-11:30 a.m. and 7- 8:30 p.m.
Tuesday 10:00 a.m. - 11:30 a.m.
Wednesday 8:30 p.m. - 9:30 p.m.
Thursday 10 a.m. - 10:30 a.m.