CIS 142 Database I is a 3 unit class. Students should be prepared to spend about nine hours a week on class material.  For a typical in-class course this means three hours in class with six additional hours of homework time. Online students need to spend those hours reading the textbook and website materials as well as doing the tutorials and assignments.

Except for the midterm and final, class work does not need to be done on the campus.  However, if a student is experiencing problems with their own computer, they need to find another machine to work on. This may mean using a computer in a school lab.

Topics covered are database design, queries, forms, reports and basic SQL statements.

Not all versions of Microsoft Office have Access included (including Office 365) - please make sure your version has Access before you begin the class.  You MUST use the 2016 version Access for this class.  There are several ways to obtain Access. You may purchase a copy of Microsoft Office that includes Access from College buys. If you already have Office or Office 365 and simply need Access you can download a free copy of through Dreamspark

The materials you need for for this class is a Cengage Unlimited Code.  A single semester Cengage Unlimited single semester code costs $119 but allows 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.  It can be used for both (all classes).  You can also rent a hardcopy of  the text for $7.99 if you wish.  If you think you will be using Cengage books next semster as well you can purchase a year long code for $179.99.  Please watch this short video for more information.  DO NOT purchase the access code from a web site such as Craig's list.  The access codes cannot be reused so you will be wasting your money.  

This class cannot be completed using only a cell phone. You will need to use a computer running Access 2016.


Textbook and materials

Cengage Unlimited Single Semester Code Cengage Unlimited Single Semester Code
Cengage Unlimted Year Code Cengage Unlimited Year Code


  1. This class is hosted in Canvas and also involves access to a publisher website.  Canvas will be used for class annoucements and email, discussion groups and some projects other work will be in the publsiher website.  For information on logging into Canvas please visit You must be registered through Admissions and Records (A&R) 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.
  2. Once in Canvas, you will find the Getting Started in Class section.  After carefully reading the syllabus you will need to take the Syllabus quiz.  The Syllabus quiz will not count towards your grade but 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 you have gotten 100% on the syllabus quiz, the first Course Content module will open. 
  3. Another important link in the Getting Started Module is a Using Canvas Features pdf.  This will show you how you can receive Canvas annoucments via text if you choose and also walk you through using some other Canvas features.
  4. The Content and Topics section of this syllabus gives directions on how to log into the publisher website used for this class.
  5. You must complete 70% of the work assigned in the first two weeks of class and have you permanent code in order to be able to continue with class. If you fall below the 60% of the work assigned at any time you may be dropped from the class for non participation. 
  6.  If you have additional questions, please attend an optional orientation listed in the important dates section.
  1. The teacher may officially withdraw a student who is not participating but 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.

  2.  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 exam session.  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 taken into account 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. 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. Exams cannot be given early.

  3. This class will use both Canvas and the Cengage publisher website.  For information on logging into Canvas please visit  It can take 24 hours after registration for your account to be enabled in Canvas.

  4. Pay attention to Due Dates and times carefully - Homework may include both work done in Canvas and a publisher website.  If you are having technical issues, there are Labs on campus available for students to complete their homework.   It is the student's responsibility to make sure all assignments are submitted properly.  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.
  5. The best way to contact the instructor outside of class is through email. All emails for this class should be sent through the Canvas mail system. This is to help keep emails from ending up end 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 48 business hours. For example if an assignment is due at 5 p.m. on Thursday, it is best to send questions by at least that morning to allow time for the Instructor to answer. If Canvas is down, you may email to Answers to messages that are left on voicemail or come to email outside of Canvas may be delayed or not returned.
  6. 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.

  7. 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.

  8. 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.

  9. 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. Not having the required materials is not sufficient justification for a student's failure to complete assignments. There may a copy of textbooks on reserve in the library, but a student has no guarantee of access to that copy at any point in time.

There are two separate categories of points for this class; Homework and Exams.  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.  Exam points consist of the midterm and final and students must take both exams in order to pass the class. The exams will be held on campus.  No quizzes or surveys done online count as exams.

In order to receive a C in the class, a student must get at least 70% of the points in both the homework and tests categories. 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.     

Students must maintain at least 60% of the homework points at all times in order to remain in the class. Missing one week’s worth of assignments is considered unsatisfactory attendance and non-participation. Please refer to the Fullerton College Catalog.    

Event Date
OPTIONAL orientation 5:30 p.m. room 315 1/25/19
Class Begins 1/28/19
Last Day to Add Classes, Drop Without a W, Drop for a Refund 2/10/19
Last Day to Apply for Spring Graduation 2/14/19
On Campus Midterms 3/21 and 3/22 Time TBA
Spring Break 4/15 - 4/21/19
Last Day to Withdrawl from Class 4/28/19
Last Day of the Class 5/24/19
Last Day of the Semester and Commencement 5/25/19

The homework is listed in Canvas and arranged by due date.  There is also Resource folder that contains helpful materials for the chapter.  It is important to read the notes included in the Resource folder.   Each due date also shows the assigned work. 

Homework will include both projects that are assigned and submitted into Canvas as well as projects that are submitted into the Cengage Website.  The Canvas assignments may vary in type from small reviews over covered material to database assignments to reinforce ideas.

The work in the Cengage website includes Simulation Trainings, Book projects and other Cengage Grader projects.  In order to complete the trainings and Projects you will need to purchase the Cengage Access code. You may use the Cengage web site for about 2 weeks without a key code, however if the temporary code runs out before you enter your permanent code you may lose your work and you may be dropped from class.   When creating your account in Cengage make sure you use the same name that you use in A&R.  If the names are different, you may not receive a grade for the class.  Also please enter your Student ID in the ID# field.

To access the Cengage Trainings and Projects you must enable your browser Pop-Ups.

Simulation Trainings are web based simulations that do not require you to have the actual application. They can be done an unlimited amount of times and your highest score will always count.  You can stop them at any time and pick up later where you left off.  This Training Video will provide further details about how to complete a training. The videos can also be found under the Getting Started Module in Canvas.   

The Book Projects will walk you step by step through pages in the book to learn the skills of that chapter.  If you have questions, this is the time to get those questions answered since later you will have projects that require the same skill set but do not give you step by step instructions.   Projects can be done up to 5 times each before the due date.  That means if you submit a project early enough, you can view your grade report to see if you made errors.  If there are issues, you can fix them and resubmit up to 4 more times to get a better grade.  Grader Projects are similiar to Book Projects except you will download instructions from the website instead of following steps in the book.

You must make sure to start each project with the file you download from the website even if it appears to be blank.  Each file is marked with the student's name.  This means that you must be very careful to not use or upload another student's file because this violates the academic honest policy.  This Project Video will provide further details about how to complete a project.   


Skills Center - Location: Library 
The skills center has staff and materials available to assist you with improving your writing, reading, thinking, vocabulary, keyboarding, study skills, and more. No appointment is necessary and it is free.  For information call (714) 992-7144 

Writing Center – Location: Library 
The Writing Center’s mission is to promote students’ success and independence as writers in college and beyond. We also strive to provide an environment that is conducive to writing and learning and to serve as a model for peer interaction. We help writers make their own choices about a text rather than “fixing” papers for them. We don’t write on students’ papers; we counsel students about the choices they have as writers. For information call (714) 992-7153 

Tutoring Center – Location: Library 
Free tutoring by appointment. Walk-in tutoring for math, accounting, physics, and chemistry. For information call (714) 992-7483. 

Student Success Workshops - TBA

Career Builder Series - TBA

Complete list of support services

  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
© 2019 Nancy Woolridge. All rights reserved.