Bossier Parish Community College

Section Syllabus

Fall 2009

Advanced MS Access CIS 209 - 91

 

The Course Meets:  Internet  08.20 == 12.08

Instructor:  Paul Weaver              E-Mail Address:   pweaver6374@bpcc.edu

Office: A – 2nd Floor                       Telephone            318-678-6374

Class Website:        http://www.bpcc.edu/~paweaver/

 

 

Professor Office Hours:

Primary contact via e-mail. Secondary via telephone.

                                                                                          

Section Requirements:

 

Text: New Perspectives on Microsoft Office Access 2007, Comprehensive
(978-1-4239-0589-9) Joseph J. Adamski, Kathy Finnegan  ISBN 13: 978-1-4239-0589-9 © 2008   http://oc.course.com/np/Office2007/Access.cfm 

 

Course description: An in-depth exposure to database design (presently Microsoft Access 2007). The course includes how to plan, define, create, and modify spreadsheets. Practical applications of integration of other documents will also be explored in depth. 3 hrs. of lecture/lab.  

 

Prerequisite: CIS 115.
Also, you must have Internet access, an email account, access to Office 2007 Professional (Access).

 

Section Attendance requirements:

ATTENDANCE: You must COMMUNICATE with me regularly. Missing a total of two weeks of class are grounds for suspension. Not turning in assignments or taking tests equate to being absent from class and is grounds for suspension. REMEMBER, it your responsibility to contact me! IF YOU HAVE TO MISS, email or call!!! From BPCC, "Attendance will be checked every class meeting.  When a student has accumulated a total of two weeks of unexcused absences in a course, the instructor may suspend the student (College policy).  As a result of this action, the instructor will assign the student a grade of ‘F’ for the course."

 

Section Grading:

A. Evaluation Criteria: ALL ASSESSMENT EVALUATIONS ARE RECORDED IN BlackBoard

B. EXAMS: There will be two exams the Midterm and FINAL.

C. Access:   SEE CALENDAR BELOW FOR DUE DATES

You will complete the Chapter's preparation work chapter 1- 12. You will not turn these in. Additionally, for each of chapters 1 through 12, you will you will be required to complete both of the Case Problems [1 and 2] 

Keep good backups!!!

·      Make sure you name the files with your name, tutorilal and case number in the file name ie StudentXYZ_tutorial 1_Case 1.accdb

·    Additionally, YOUR NAME AND Chapter NUMBER MUST BE INSIDE EACH document!!! . Create a new table. On a form/report, etc.


 All assignments turned in late will be given 50% credit and must be turned in WITHIN ONE CALENDAR WEEK FOLLOWING THE REGULARLY SCHEDULED date to receive any credit!!
It is also suggested that you keep a copy of everything you send me until the course is over and you receive your grade, just in case there is a major technical difficulty with Blackboard. 

 

Assignments can be turned in at any time up until the deadline.  LATE WORK WILL NOT BE ACCEPTED!  If you have an extenuating circumstance, you must let me know about it ahead of time by phone.  It is highly recommended that you turn assignments in ahead of time to ensure that you do not encounter a technological difficulty.

 

ALL LATE-Assignments and make-up work must be turned in by the last day of class, December  8, 2009!!!

 

 D. GRADING:  

Introduction Quizzes, Chapter quizzes   60 points
Access Case Problems [1 and 2] .            840 points (24 Projects @ 35 points each)
MidTerm                                                         50 points
Final Exam                                                    50 points
Total possible                                             1000 points

 

E. GRADING SCALE

900 or more points = A

600 through 699 points = D

 

 

800 through 899 points = B

less than 600 points = F

700 through 799 points = C

 

 

 

COMMUNICATION: When sending e-mail to your instructor the subject line must consist of the course name with the section included the semester code, and the student’s user name.  (Example:  SUBJECT:  CIS20991F09tbrown).

The above schedule and procedures in this course are subject to change in the event of extenuating circumstances.

KEY WEB PAGES:      www.bpcc.edu/~paweaver

 

Section Calendar, The “WEEK” starts on Thursday

WEEK

DATE

Learning Activity

Assessment**

 

1

08.20

Intro to class, First Assignment, Work on Tutorial 1

Practice Test Office & Managing Files

 

2

08.27

Work on Tutorial 2

Tutorial 1:  Case Problems [1 and 2] .

 

 

3

09.03

Work on Tutorial 3

Tutorial 2:  Case Problems [1 and 2] .

4

09.10

Work on Tutorial 4

Tutorial 3:  Case Problems [1 and 2] .

 

5

09.17

Work on Tutorial 5

Tutorial 4:  Case Problems [1 and 2]

 

6

09.24

Work on Tutorial 6

Tutorial 5:  Case Problems [1 and 2]

 

7

10.01

 

Tutorial 6:  Case Problems [1 and 2]

 

8

10.08

Review Textbook and feedback from Assignments

Work on Tutorial 7

Midterm

 

9

10.15

Work on Tutorial 8

Tutorial 7:  Case Problems [1 and 2]

 

 

10

10.22

Work on Tutorial 9

Tutorial 8:  Case Problems [1 and 2]

11

10.29

Work on Tutorial 10

Tutorial 9:  Case Problems [1 and 2]

 

12

11.05

Work on Tutorial 11

Tutorial 10:  Case Problems [1 and 2]

 

13

11.12

 

Tutorial 11:  Case Problems [1 and 2]

 

14

11.19

Work on Tutorial 12

 

 

15

12.03

 

Tutorial 12:  Case Problems [1 and 2]

 

 

16

12.08

Review Textbook and feedback from Assignments

Final Exam

 

** All Assessments are by 11:59 pm CST of the Wednesday of the week listed.

 BPCC SPECIFIC INFORMATION

 

All students who may be in need of special accommodations according to the guidelines of Section 504 of the Rehabilitation Act and Title II of the ADA should contact the Special Services Counselor, Morris Robinson, at 678-6315 or in Bldg. F Room 241.

 

BPCC library website:  www.bpcc.edu/library

Blackboard Link:  http://blackboard.bpcc.edu  (In the event the BPCC website goes down, you may still be able to log into Blackboard using this address)

How do I log into Blackboard?

To log into Blackboard your Username is your CWID number (Campus Wide Identification number) without any dashes or spaces. This ID number is given to you when you registered with BPCC for the current semester.  It is also located on the back of your BPCC student ID.  Your password is your birth date in the six digit format without any dashes or spaces (Example: January 1, 1980 would be entered as 010180). If you did not receive your CWID number when you registered at the college, you may log in to the BPCC CAVS system using your social security number as your "STUDENT ID:" and your birth date in the example above as your "PIN:" and a message stating "YOUR NEW LOG IN ID:" will display giving your CWID number.  If you have changed your name or need to correct the spelling of your name, you should contact the registrar’s office and your instructors to make sure everyone is made aware of the corrections.

How do I access Student Webmail?

Your logon information for your BPCC student email account is the first initial of your first name, all of your last name, and the last four digits of your social security number. Your password is your birth date in the six digit format. Please see the example below:  If your name was John Smith and your social security number was 999-00-9999 and your birth date was January 1, 1980 your logon information would look like this:

 

Username: jsmith9999                                      Password: 010180

All BPCC students are expected to become acquainted with College policies, requirements, procedures, and regulations, and to remain cognizant of them during attendance at BPCC.  See Student Handbook for details.

 

PLAGIARISM:  All assignments are to be completed individually.  If two or more students submit the same work, it will be considered cheating.  Students should be aware of the Student Academic Integrity policy described in the Student Handbook and that if the policy is violated, they will be subjected to disciplinary sanctions listed in the Handbook.  Cheating can result in a failing grade or dismissal from the College, so PLEASE do your own work.