Bossier Parish Community College

Section Syllabus

Spring 2008

Advanced MS Excel CIS 207 - 91

The Course Meets:  Internet

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

Office: G 118                                                Telephone 318-678-6374

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

 

Professor Office Hours:

MWF 

09:00 – 11:300 am

During office hours I will be in G 118

Tue, Thu

12:00 - 1:30 pm

 

Section Requirements:

Text: New Perspectives on Microsoft Office Excel 2007, Comprehensive

ISBN 13: 978-1-4239-0585-1 © Aug. 2007 (904 pages)

Author(s): June Jamrich Parsons, Dan Oja, Roy Ageloff, Patrick Carey

 http://oc.course.com/np/Office2007/Excel.cfm

Course description: An in-depth exposure to database design (presently Microsoft Excel 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 (Excel).

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 one exam the FINAL.

C. Excel:   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, chapter and project number in the file name ie StudentXYZ_Chapter 1_Project 1F.doc
Additionally, YOUR NAME AND Chapter NUMBER MUST BE INSIDE EACH document!!! . 
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.

 

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.

ALL Assignments and make-up work must be turned in by the last day of class, May 2, 2008!!!

 D. GRADING:  

Introduction Quizzes, Chapter quizzes     60 points
Word 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:  BADM22051F04tbrown).

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, 
BlackBoard http://blackboard.bpcc.edu/ ,  
Student email http://student.bpcc.edu/

Section Calendar

WEEK

DATE

Learning Activity

Assessment**

1

01.13

Intro to class, First Assignment, Work on Tutorial 1

Practice Test Office & Managing Files

2

01.20

Work on Tutorial 2

Tutorial 1:  Case Problems [1 and 2] .

3

01.27

Work on Tutorial 3

Tutorial 2:  Case Problems [1 and 2] .

4

02.03

Work on Tutorial 4

Tutorial 3:  Case Problems [1 and 2] .

5

02.10

Work on Tutorial 5

Tutorial 4:  Case Problems [1 and 2]

6

02.17

Work on Tutorial 6

Tutorial 5:  Case Problems [1 and 2]

7

02.24

 

Tutorial 6:  Case Problems [1 and 2]

8

03.02

Review Textbook and feedback from Assignments

Work on Tutorial 7

Midterm

9

03.09

Work on Tutorial 8

Tutorial 7:  Case Problems [1 and 2]

 

 

Spring Break

 

10

03.23

Work on Tutorial 9

Tutorial 8:  Case Problems [1 and 2]

11

03.30

Work on Tutorial 10

Tutorial 9:  Case Problems [1 and 2]

12

04.06

Work on Tutorial 11

Tutorial 10:  Case Problems [1 and 2]

13

04.13

 

Tutorial 11:  Case Problems [1 and 2]

14

04.20

Work on Tutorial 12

 

15

04.27

 

Tutorial 12:  Case Problems [1 and 2]

16

05.05

Review Textbook and feedback from Assignments

Final Exam

 

 

 

** All Assessments are by 11:59 pm CST of the requested day.

 

 

 COURSE DATES:

 Classes begin

January 12, 2008

Schedule changes – online

January 12-15, 2008

Schedule changes – onsite

January 14, 2008 – 9:00 a.m.-11:00 a.m. & 3:00 p.m.-5:00 p.m.

Last day for 90% refunds for dropping a course (changing course load)

January 15, 2008

Last day for 90% refunds (resignations ONLY)

January 18, 2008

Martin Luther King Holiday

January 21, 2008

Last day for 50% refunds (resignations ONLY)

January 25, 2008

Last day for book refund

January 25, 2008

Last day to change from audit to credit or credit to audit

January 25, 2008

Mardi Gras Holiday

February 5, 2008

Last day to apply for graduation for spring semester 2008 and pay fee

February 29, 2008

Final day for removal of 'I' grades – fall 2007

March 6, 2008

Mid-term

March 10, 2008

Last day to drop without grade penalty - if regular attendance is maintained

March 26, 2008

Spring/Easter Break

March 17 – 22, 2008

Advance registration with advisors summer/fall

April 7 – June 2, 2008

Online registration for summer 2008

April 7 – June 2, 2008

Online registration for fall 2008

April 7 – August 19, 2008

Last day of classes/Last day to drop (if regular attendance is maintained)

May 2, 2008

Final examinations

May 3, - 9, 2008

Bookstore buyback

May 5 – 12, 2008

Spring graduation 2008

May 8, 2008 at 2:00 p.m.

Last day of spring semester

May 9, 2008

 

 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.