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.  

 

 

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 online.fullcoll.edu. 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. The midterm and final exam that must be taken on campus. You will be required to sign up ahead of time for the exam period(s) you are selecting. A notice will be sent out closer to the time of the sessions calling for your selection time. If you are late in returning your request for a final session you will be delayed on exam day and you may not get your requested session. Each student must bring a pencil and driver’s license or student ID to the exam.  If a review is provided for any exam, it will be closed at least the day before the first exam session is available. If you do not take both the midterm and final exam in this class, you will receive a failing grade for the class. Makeup exams are not guaranteed and it is up to the discretion of the Instructor 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 are 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 test. Exams cannot be given early.  Do not plan vacation before the last day of the semester or you may miss the final. See the Important Dates section.

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

  4. Watch Due Dates and times carefully. Due Dates are listed in either Canvas and/or the Due Dates section of the syllabus. The instructor reserves the right to change the schedule so please check the web site and your email on a regular basis for updates. Work is typically due at 11:59 p.m. on Fridays although there can be exceptions. If you are having technical issues, there are labs on campus with computers available for homework assignments. 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. 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. Fun link about this topic.  The instructor will attempt to answer all properly formatted emails within 48 business hours, but it is not guaranteed. If an assignment is due at 11:59 p.m. on Friday, it is best to send questions by at least Friday morning to allow time for the Instructor to respond. 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.

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

  8. Each student needs to take an active part in his/her own education by reading the book, checking email and regular attendance on 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. Not having the textbook bundle is not sufficient justification for a student's failure to complete assignments. There may a copy of the textbook 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 8/17/18 at 6:00 p.m room 315
Classes Begin 8/20/18
You must have  70% of the work complete, have your permanent access code and have made a comment in the discussion group in order to be able to continue with class. 8/31/18
Last Day to Add Classes, Drop Without a W, Drop for a Refund 9/3/18
Last Day to Apply for Fall Graduation 9/6/18
Last Day to Withdrawl from Class 11/11/18
Veterans Day Holiday - No Classes 11/12/18
Thanksgiving Holiday - No Classes 11/22 - 11/25/18
Last Day fo the Semester 12/8/18

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.   

 


Work is typically due at 11:59 p.m. on Fridays but the instructor reserves the right to change the schedule and there may be exceptions. The student is responsible to check course announcements, email and web content on a regular basis.

Canvas Syllabus Quiz - will not count toward your grade but you must achieve 100% on the quiz in order to continue in the class
Chapter 1 Training

Chapter 1 Textbook Project - Download the starting file and use the Textbook for instructions

Chapter 1 Grader Project 1a - Download the starting files and Instructions
Chapter 2 Training
Data Types Survey Question

You must have your permanent SAM Code and and have completed the work up to this point with a score of at least 70% by 11:59 p.m on  8/31/18 or you may be dropped from the class.

Last Day to Add/Drop classes - 9/3/18
Chapter 1 Grader Project 1b - Instructions and Submission in SAM

Chapter 2 Textbook Project - Textbook instructions submitted in SAM
1st Excel Spreadsheet challenge - Instructions and Submission into Canvas
Canvas Discussion  - Data Types Discussion 1

Chapter 2 Grader Project 1a - Instructions and Submission in SAM
First Normalization Project - Instructions and Submission into Canvas
2nd Excel Spreadsheet challenge - Instructions and Submission into Canvas
Canvas Discussion  - Data Types Discussion 2

Chapter 2 Grader Project 1b - Instructions and Submission in SAM
Query Quiz - Done in Canvas
Chapter 3 Training - Done in SAM
Canvas Discussion  - Normalization Project Discussion

Chapter 3 Textbook Project - Textbook instructions submitted in SAM
Chapter 3 Grader Project 1a - Instructions and Submission in SAM
Data Types Quiz - Instructions and Submissions into Canvas

Second Normalization Project - Instructions and Submission into Canvas
Chapter 3 Grader Project 1b - Instructions and Submission in SAM

SAM Chapters 1 - 3 Capstone Project due 11:59 p.m. 10/10/18
Optional Midterm review - will not be graded
On Campus Midterms  Thursday 10/11/18 at 6:00 p.m  Room 315 or Friday 10/12/18 at 3:00 p.m. room 317 or Thursday 10/12/18 at 6:00 p.m. in room 315. The review will close on Wednesday 10/10/18.

Chapter 4 Training - Done in SAM
Chapter 4 Grader Project 1a - Instructions and Submission in SAM

Chapter 4 Grader Project 1b - Instructions and Submission in SAM
Chapter 5 Training - Done in SAM

Chapter 5 Grader Project 1a - Instructions and Submission in SAM
Chapter 6 Training - Done in SAM

Chapter 5 Grader Project 1b - Instructions and Submission in SAM
Chapter 6 Grader Project 1a - Instructions and Submission in SAM
Last Day to withdraw with W - 11/11/18

Chapter 6 Grader Project 1b - Instructions and Submission in SAM
Chapter 7 Training - Done in SAM

Chapter 7 Grader Project 1a - Instructions and Submission in SAM

Chapter 7 Grader Project 1b - Instructions and Submission in SAM
Final Review located in Canvas - The review will close the day before the first final session

Extra Credit Trainings - Availabe until Wednesday 12/5/18
On Campus Finals  -
Thursday 12/6/18 at 6:00 p.m  Room 315 or Friday 12/7/18 at 2:00 p.m. room 317 or Friday 12/7/18 at 6:00 p.m. in room 315. The review will close on Wednesday 12/5/18.


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.


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

Career Builder Series


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