House Bill 2504

Spring 2011 Course Syllabus

POFI-1349-71 (Spreadsheets)

Faculty Information
SemesterSpring 2011
InstructorSchipplein, Patricia Lynn
Phone(409) 984-6384
Business and Technology
Chair:Michael Trahan
Telephone:(409) 984-6378
Hours:10:00-11:00 MW; 10:00-12:00 F; 9:30-11:00 TR; 12:30-2:30 TR
Building:Student Center (PAMP)
Room #:405
Course Information
Course ID #10226
Course Subject-Number-SectionPOFI-1349-71
Course TitleSpreadsheets
Course Description Spreadsheet software for business applications.
Course Prerequisites POFI 1201 or keyboarding and mousing skills or consent of instructor.
Required Textbooks Microsoft Excel 2010 (Levels 1 and 2), Benchmark Series by Rutkosky, ISBN # 978-0-76383-771-6; Spreadsheets Project Book (purchased in the Dean’s office)
Learning Objectives The student will identify the components of a computer system; demonstrate basic understanding of commonly used applications; explain the impact of computers on society; explore computer careers; identify fundamental programming structures; and demonstrate proficiency in basic operating system functions.
Major Assignments Date: January 18-21

General Info: None

Lecture: Introduction to class; go over course syllabus

Assignments: Purchase textbooks


Date: January 24-28

General Info: Students may begin applying for spring graduation.

Lecture: Chapter 1        

Assignments: Complete End-of-Chapter Exercises

Date: January 31–February 4

General Info: None

Lecture: Chapter 2

Assignments: Give Chapter 1 Quiz; Complete Chapter 2 End-of-chapter exercises

Date: February 7-11

General Info: None

Lecture:         Chapter 3

Assignments: Give Chapter 2 quiz; complete Chapter 3 end-of-chapter exercises

Date: February 14-18

General Info: None

Lecture:         Chapter 4        

Assignments: Give Chapter 3 quiz; complete Chapter 4 end-of-chapter exercises

Date: February 21-25        

General Info: None

Lecture: No lecture        

Assignments: Give Chapter 4 quiz; complete Unit 1 Performance Assessments

Date: February 28-March 4

General Info: February 28—Last day to drop or withdraw and still receive a Q/W

Lecture: No lecture

Assignments: Exam 1 (Chapters 1-4)

Date: March 7-11

General Info: Spring Break

Lecture: Spring Break—students may/may not work this week.

Assignments: No assignment


Date: March 14-18

General Info: None.

Lecture:         Chapter 5

Assignments: Chapter 5 end-of-chapter exercises

Date: March 21-25

General Info: None

Lecture:         Chapter 6        

Assignments: Give Chapter 5 quiz; Chapter 6 end-of-chapter exercises

Date: March 28-April 1

General Info: None

Lecture:         Chapter 7

Assignment: Give Chapter 6 quiz; Chapter 7 end-of-chapter exercises

Date: April 4-8

General Info: April 6—last day to drop or withdraw from the semester

Lecture: Chapter 8        

Assignments: Give Chapter 7 quiz; Chapter 8 end-of-chapter exercises

Date: April 11-15

General Info: April 14—last day to apply for spring semester

Lecture: No lecture        

Assignments: Give Chapter 8 quiz; Unit 2 Performance Assessments

Date: April 18-22

General Info: April 22 (Friday)—Good Friday—No Classes

Lecture: No lecture

Assignments: Exam 2 (Chapters 5-8)

Date: April 25-29

General Info: None

Lecture: Level 2 Chapter 2

Assignments: Level 2 Chapter 2 End-of-Chapter Exercises

Date: May 2-6

General Info: None

Lecture: No lecture        

Assignments: Spreadsheet Projects

Date: May 9-11

General Info: None

Lecture: No lecture

Assignments: Spreadsheet Projects

Date: May 12

General Info: None

Lecture: None

Assignments: Final Exam on Friday, May 13, from 8 to 10:30 a.m.

Date: May 20

General Info: None

Lecture: None

Assignment: Commencement Exercises, Parker Center, 6:30 p.m.

Discussion Topics 1.        Preparing an Excel Worksheet

2.        Inserting Formulas in a Worksheet

3.        Formatting an Excel Worksheet

4.        Enhancing a Worksheet

5.        Moving Data within and between Worksheets

6.        Maintaining Worksheets

7.        Creating a Chart in Excel

8.        Enhancing the Display of Workbooks

Attendance Policy Research has shown a cause and effect relationship between attendance and college success. See Additional CIS Class Policies below.

You should attend every class meeting. The instructor reserves the right to drop you from the class if you miss more than 6 hours of class.

You are allowed 3 absences per semester without a doctor’s excuse. After the 3rd absence, I will lower your final average for the class by 2 points for each absence.

Tardiness is not acceptable. You are required to be on time. Once the class is in progress, the instructor reserves the right to deny access to the classroom or impose other penalties.

Missed quizzes will each be recorded as a zero. No makeup quizzes will be given.

You are responsible for completing and submitting all assigned homework when due and for being prepared for each class meeting. This applies even if you were absent for the previous class meeting. No late homework assignment will be accepted.

Cell phones should be set to vibrate during class time. You may quietly leave the room to answer an important call if needed—be sure to return quietly as well. Cell phones may not be visible or answered during a testing period. Any violation of this rule will result in the student receiving a zero on the test.

Determination of Final Grade Exams                                         60%

Projects and Class Assignments                20%

Final Exam                                20%

Final Exam Date May 17, 2011 - 5:00 PM
Campus Policies
Lamar State College - Port Arthur

Mission Statement

Lamar State College-Port Arthur is an open-access, comprehensive public two-year college offering quality instruction leading to associate degrees and a variety of certificates. The college, a member of The Texas State University System, has provided affordable, quality educational opportunities to residents of the Southeast Texas area since 1909.Lamar State College-Port Arthur embraces the premise that education is an ongoing process that enhances career potential, broadens intellectual horizons, and enriches life. The faculty, staff, and administration share a commitment to a mission characterized by student learning, diversity, and community service. The foundations for student success include compensatory education programs designed to fulfill our commitment to accommodate students with diverse goals and backgrounds, technical education programs that provide for the acquisition of the skills and demeanor necessary for initial and continued employment, and a core curriculum that develops the values and concepts that allow the student to make a meaningful contribution in the workplace or community. Student achievement is measured by the completion of courses and programs of study, successful performance following transfer to a baccalaureate program, and the attainment of individual goals.

Lamar State College-Port Arthur operates in the belief that all individuals should be:

* Treated with dignity and respect;

* Afforded equal opportunity to acquire a complete educational experience;

* Given an opportunity to discover and develop their special aptitudes and insights;

* Provided and opportunity to equip themselves for a fulfilling life and responsible citizenship in a world characterized by change.

 College Grading Scale

Below 59F

(Some specialized programs may have different grading scales)


 Academic Dishonesty

Academic dishonesty in any form will not be tolerated.  Please consult the student handbook for consequences of academic dishonesty.  These policies will be strictly enforced.


 Facility  Policies

        No food, drinks, or tobacco products are allowed in the classroom.

        Only students enrolled in the course are allowed in the classroom.

        Cell phones and/or pagers are allowed ONLY on vibrate mode. Leaving the classroom to answer a page or phone call may constitute an absence or a tardy.


 Special Considerations

         The American with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the Special Populations Coordinator, Room 231, in the Madison Monroe Building. The phone number is (409) 984-6241.

Copyright ©2010 Lamar State College - Port Arthur. All Rights Reserved.