CIS 208A - Oracle SQL And Pl/SQL
Syllabus
Fall 2009 - Online Classes
Tentative schedule


 

Instructor:  Marge Hohly
Email address:  m.hohly@verizon.net
res02i0t@gte.net
Hohly@cerritos.edu
Home page:  http://www.cerritos.edu/hohly
Location & Time:  Orientation Tuesday 8/19/08 in BE-12  7:00-10:00 pm
Ticket number:  CIS 208AC - #23475 (Online)
Phone number:  (562) 860-2451 Ext. 2736 voice mail available 
Office hours:  6:00 - 7:00 p.m. Tuesday in SS-25 or BE-12
4:00 - 5:00 p.m. Wednesday in SS-25
4:00 - 5:00 p.m. Thursday in SS-25
Office: SS-25

 

Textbooks: 

Textbook material provided online in the Oracle iLearning Center  
Support materials will be provided on the websites to support this class  
Materials:  A USB drive for your copies of assignments and class work. 
 

 


 
TENTATIVE BASIS FOR DETERMINING COURSE GRADE

Lab Assignments 12 @ 20 points each

240

4 Exams  @ 50 points each

200

Final Exam

  50

Total Points

490

  A=441 , B= 392 , C= 318, D= 245 , Fail= 244  and below


 


Tentative Schedule  

Week
day

Topics to
be covered

iLearning
Sections

Quizes
&
Exams

Lab
Assignments

1
Aug. 18

  • Overview of class
  • Introduction to iLearning
     

2
Aug. 25

  • Review of SQL
  • PL/SQL Introduction/Fundamentals
Section 1   Lab 1

3
Sept. 1

  • Variables & Datatypes
Section 2   Lab 2

4
Sept. 8

  • SQL in PL/SQL
  • Labor Day 
    Monday Holiday 9/7
  Section  3   Lab 1 Due 9/8
Lab 3

5
Sept. 15

  • Program Structure
Section 4   Lab 2 Due 9/15
Lab 4

6
Sept. 22

  • Cursors
 Section 5    Lab 3 Due 9/22
Lab 5

7
Sept. 29

  • Cursors cont.
 Section 5   Lab 4 Due 9/29
 

8
Oct. 6

     Exam 1 (midterm part 1 )
& Exam 2 (midterm part 2 )
after section 5
complete online by Sunday
 
 

9
Oct. 13

  • Exceptions Handling
  Section 6   Lab 5 Due 10/13  
Lab 6  

10
Oct. 20

  • Procedures
 Section 7    Lab 7 

11
Oct. 27

  • Functions
 Section 8    Lab 6 Due 10/27
 
12
Nov. 3
    Exam 3 - after section 8 complete online by Sunday  Lab 7 Due 11/3
Lab 8
13
Nov. 10
  • Packages
  • 11/11 Veteran's day Wednesday Only holiday campus closed
 Section 9   Lab 9
14
Nov. 17
  • Triggers
 Section 10
 
Lab 8
Due 11/17
Lab 10
15
Nov. 24
  • Thanksgiving Holiday Thursday-Sunday Nov. 26-29
  Exam 4 -
after Section 10 complete online by Sunday
 Lab 9
 Due 11/24
 
16
Dec. 1
  • Advanced Data Types
  • Dependencies
 Section 11 & 12
 
 Lab 10
 Due 12/1
Lab 11 & 12
17
Dec. 8
  • Review
     Lab 11 & 12
 Due 12/8

 
18
Dec.15
  • Final Tuesday, Dec. 15 - 8:00 - 10:00 p.m.
    Comprehensive
   Final Exam (after section 12) complete by Tuesday 12/15  

Please Note: CIS labs are closed during final exams, 12/12 - 12/18.
Last day to drop with a "W" is 11/20

The above schedule is subject to change.

NOTE:

NOTE:  The student who wants to work at home, will need access to Internet.  You will be provided with access to the text and testing materials through iLearning on the Oracle Academy website.  Your user access code to this site will be provided by your instructor.  You will also need access to the Application Express (APEX) SQL server.  This again is accessible via a web browser.  The user ID and password will be also provided by your instructor when they become available.  

The lab assignments and links to lecture and supporting materials are found on the class web pages.  There are three sites for this section.  One at Cerritos College (http://www.cerritos.edu/hohly/),   the iLearning site and APEX.   Please refer to these pages for more information.  Make sure that you print out the separate sheets that contains the lab assignments.

Revisions to schedule will be made to the syllabus and posted on the web sites for this class. Lab, lectures, and supporting materials for this class are posted on the two main sites (Cerritos College website, and iLearning).  Some things are only available on the iLearning site.  The iLearning site has exams, lecture notes, and quizzes  not found on the Cerritos site.  APEX site is the PL/SQL and SQL compilier for your use during this course, you can use the editor to run your code and verify that it is correct prior to submitting your work.    Instructions to log on to the site will be provided during orientations. The Cerritos website contains the information like the class syllabus, lab assignments, PowerPoint presentation, support material, links to iLearning and APEX and other procedural materials.   It is the students responsibility to retrieve their assignments from the Web pages. All assignment must be submitted to your instructor via email (m.hohly@verizon.net).  They will ONLY be accepted via email to the m.hohly@verizon.net address, or on paper to your instructor.     The online student MUST submit their files via email to the m.hohly@verizon.net address and they will have more detailed submissions online.  This will be explained at the orientation and in the online lab instructions.

Remember it is critical to keep in contact with your instructor.  If you have not been heard from  for 3 weeks or are not making academic progress you will be dropped from the class.

Academic Honesty/Dishonesty Policy:   The work submitted by each student in this class is expected to their own work, not the work of others. Please be sure to read the college’s Academic Honesty/Dishonesty Policy found in the catalogue and schedule of classes.  A copy of the catalogue is located at www.cerritos.edu and the Academic Honest/Dishonesty Policy is found on pages 135-136 of the Fall 2009 schedule of classes.   Don't put your credit in this course at risk by violating this policy. 

For tests be sure to study and answer questions on your own without help from other students.  For the homework assignments make sure you create your own files from scratch and do your own typing.  I know some of you work together, share books and computers.  That’s OK.  What is not OK is having one person type up the assignment and then submitting it (file or printed document) for multiple students.  Trust me I have ways of figuring it out if you are cheating in this manner.  If I determine that you are cheating, then I will do one of the following actions as stated from the college’s policy:

One or more of the following actions are available to the faculty member who suspects a student has been cheating or plagiarizing:

1. Review-no action.

2. An oral reprimand with emphasis on counseling toward prevention of further occurrences.

3. A requirement that work be repeated.

4. A reduction of the grade earned on the specific work in question, including the possibility of no credit for the work.

5. A reduction of the course grade as a result of item 4 above, including the possibility of a failing grade for the course.

6. Referral to the Office of Judicial Affairs for further administrative action, such as suspension or expulsion.


 


 

(C211cFa2009syl_T.htm)
 last update:  08/25/2009