CIS 155 - Introduction to Microsoft Access
Syllabus - Fall  2008 -Traditional and Online Sections
Horizontal Line of Flowers

Instructor:  Marge Hohly
Email address:  m.hohly@verizon.net
res02i0t@gte.net
mhohly@dslextreme.com
Hohly@cerritos.edu
Home page:  http://www.cerritos.edu/hohly
Location & Time:  5:00-10:00 pm BE-12
Ticket number:  #41878- Traditional (M 12:30-3:30 pm, W 12:30-2:30 pm)
#42986 - Online (Orientation: M 12:30-3:30 pm, 8/18/08, W 12:30-2:30 pm, 8/20/08)
Phone number: 

Skype address:

 (562) 860-2451 Ext. 2736 voice mail available 

marge.hohly
Office hours:  3:30 - 6:30 p.m. Monday, in SS-25 or BE-12
6:00 - 6:50 p.m. Tuesday, in SS-25 or BE-12 
4:00 - 5:00 p.m. Wednesday in SS-25 
Office: SS-25

 

Textbooks: 
New Perspectives on Microsoft Access 2007 - Comprehensive by Joseph Adamski & Kathleen Finnegan, Course Technology, 2007
ISBN 13: 978-1-4239-0589-9
ISBN  10: 1-4239-0589-X		 Access 2007 cover graphic
Materials:  A USB drive (best choice) or writable CD's.

Horizontal line of flowers 
BASIS FOR DETERMINING COURSE GRADE

Lab Assignments 15 @ 20 points each

300

2 Exams  @ 75 pt each      150
Final Exam

100

Total Points

550

  A=495, B=440, C=357, D=275, Fail=274 and below

horizontal line of flowers
Tentative Schedule  

Week
day

 Topics to be covered

Chapters
Lecture Text

Lab
Assignments

1
Aug. 18/20
  • Introduction to Microsoft Office Access 2007
 1 Lab 1 - Tutorial 1

2
Aug. 25/27
  • Getting Started with Microsoft Office 2007I
  • Creating a Database  cont.
 1  

3
Sept. 1/3
  • Building a Database and Defining Table Relationships
  • School Holiday - Labor Day Monday only
 2 Lab 2
Lab 3

4
Sept. 8/10

  • Building a Database and Defining Table Relationships
  • Maintaining and Querying a Database
 2(cont.) Lab 4
Lab 5

5
Sept. 15/17
  • Maintaining and Querying a Database (cont)
 3  Lab 6
Labs 1-3 are due by 11 pm Wednesday 9/17 PDT (9/18, 2 am EDT)

6
Sept. 22/24
  • Creating Forms and Reports
  • Creating Forms and ReportsCreating Forms and Reports
 4 Lab 7

7
Sept. 29/Oct. 1
  • Creating Forms and ReportsCreating Forms and Reports
  • Creating Advanced Queries and Enhancing Table Design
 4(Cont.), 5
 		  Lab 8
Lab 9
Labs 4-5 are due by 11 pm Wednesday 10/1 PDT (10/2, 2 am EDT)

8
Oct. 6/8
  • Creating Advanced Queries and Enhancing Table Design
  • Creating Custom Forms
 5 (cont.) 
6		  Labs 6-7 are due by 11 pm Wednesday 10/8 PDT (10/9, 2 am EDT)

9
Oct. 13/15
  • Creating Custom Forms
  • Exam 1 - covers chapters 1-4
 6 (cont) if time available Lab 10
Lab 11

10
Oct. 20/22
  • Creating Custom Reports
 6(cont.)
7		 Lab 12
Labs 8-9 are due by Wednesday 10/22 at 11 p.m. PDT (10/23, 2 am EDT)

11
Oct. 27/29
  • Creating Custom Reports
 7 Lab 13

12
Nov. 3/5
  • Using Action Queries and Advanced Table Relationships
 9 Lab 14
Labs 10-11 are due by  Wednesday 11/5 at 11 p.m. PST (11/6, 2 am EST)
13
Nov. 10/12
  • Using Action Queries and Advanced Table Relationships
  • Tuesday Only 11/11, Veteran's Day Holiday
 9 Lab 15
14
Nov. 1719
  • Exam 2 (Chapters 5-7) given  in BE-12
     Labs 12-13 are due by Wednesday 11/19 at 11 p.m. PST (11/20, 2 am EST)
15
Nov.  24/26
  • Automating Tasks with Macros
  • Thanksgiving Recess 11/27-30 - campus closed
    10 Lab 16 - Bonus    
16
Dec. 1/3
  • Lab day
  • Managing and Securing a Database
 12 Labs 14 are due by Wednesday 12/10 at 11 p.m. PST (12/11, 2 am EST)
17
Dec. 8/10
  •  Last day to submit labs and lab corrections
   Labs 15-18 are due by Wednesday 12/10 at 10 p.m. PST (12/11, 1 am EST)
Note: labs 16-18 are bonus labs and not required
18
Dec. 17
  • Final
    Wednesday, 12/17, 12-2  p.m.  (All  chapters)
     

Please Note: CIS labs are closed during final exams, 12/13-12/19.
Last day to drop with a grade of a "W" is 11/21/08

The above schedule is subject to change. Changes will be announced in class and updated on this website.

NOTE: The server for this class is located in the East and thus the times shown there are EDT (Eastern Daylight Time) or EST (Eastern Standard Time).  Remember to subtract 3 hours from the server time to get the Pacific Daylight Time (PDT) or Pacific Standard Time (PST).

NOTE:  The student will need access to Microsoft Office2007 to do the assignments for this course.  The Office suit needs to include  Access 2007.  If you do not have the software on your computer you may do the hands-on work on the campus computers. The campus labs have Office 2007 loaded.  Cerritos College does not supply students computer software for home computers.

The lab assignments and links to lecture and supporting materials are found on the class web pages.   Please refer to these pages for more information.  Make sure that you print out the separate sheets that contain the lab assignments.  When saving any component of the lab include your last name in the file name/title.

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 on the college websites.    It is the students responsibility to retrieve their assignments from the Web pages or in the classroom. All assignment must be submitted to your instructor with the required printouts and  the database(s) for the assignment uploaded into webct for each assignment.   

There are  two websites for the class.  One site is located on the Cerritos College website at http://www.cerritos.edu/hohly and the other is on Webct and can be reached at http://ct.webct.com.


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 is expected in this course.  The College Academic honesty/Dishonesty Policy policy will be enforced in this class.  If there are any questions as to what this policy is, see the college catalogue or the Schedule of Classes (pages 138-139).

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 165-166 of the Fall 2008 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.

 

horizontal line of flowers

(C155Sp2008syl.html)
  last update:  12/15/2008