CIS 142 Online - CRN 11199
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 Year Code|
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
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.
|Optional Orientation||8/17/18 at 6:00 p.m room 315|
|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
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
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 -
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
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 -
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