Fall 2026

POFI 1349-71

Spreadsheets

Course Information

Department
BAIT
Instructor
Champagne, Adriane
Description
Skill development in concepts, procedures, and application of spreadsheets. This course is designed to be repeated multiple times to improve student proficiency.
Last Updated
Tuesday, September 22, 2026 9:01 AM
Course Syllabus
Published Structured Syllabus

POFI 1349-71

Spreadsheets
Term
Fall 2026
Instructor
Champagne, Adriane
Department
BAIT

Instructor Information

Instructor: Adriane Champagne


Email: champagneam@lamarpa.edu


Phone: 409-984-6416


Office Hours: Monday and Wednesday 9:00-10:00 a.m., and 11:00 a.m.– 12:00 p.m.; Tuesday and 8:30 a.m.-9:30 a.m. and 10:45 a.m. – 12:45 p.m. Thursday 8:30 a.m.-9:30 a.m. and 10:45 a.m. – 11:45 p.m. Fridays and other times by appointment in person or TEAMS meeting.

Subject to change


Additional Contact Information: Cristina Lawson 

Business & Industrial Technology Department Chair 

Lawsonac@lamarpa.edu

(409)984-6381

Course Description

Skill development in concepts, procedures, and application of spreadsheets. This course is designed to be repeated multiple times to improve student proficiency.

Required Textbook & Materials

ISBN: 9780357882221 New Perspectives Collection, Microsoft Office 365 Excel: Comprehensive Author: Patrick Carey | 1st Edition | Copyright 2025 Cengage Printed required

BOOK REQUIRED no access code.


Access to a computer with Microsoft Excel 365 required.

This course can not be completed on a phone or ISD chrome book. 

Textbook Purchasing Statement

Textbook Purchasing Statement: A student attending Lamar State College Port Arthur is not under any obligation to purchase a textbook from the college-affiliated bookstore. The same textbook may also be available from an independent retailer, including an online retailer.

Additional Materials/Resources

Note taking materials

Pre-requisites/Co-requisites

Basic computer skills

Learning Outcomes

Identify spreadsheet terminology and concepts; calculate data using formulas and functions; 'create and modify workbooks; insert graphics; generate charts and reports; and create and use special functions.

Program Student Learning Outcomes

1. Demonstrates professionalism in the administrative workplace environment.

2. Uses appropriate business administration skills.

3. Uses appropriate office software applications.

4. Creates effective business documents by applying ethical communication practices.

5. Evaluates business documents.

Lecture Topics Outline

Introduction to Course-Syllabus review, Online Learning Survey, Blackboard and Self Service Banner Managing Your Files- Getting Started-Excel Formatting Workbook Text and Data Performing Calculations with Formulas and Functions Calculating Data with Formulas and Functions Analyzing and Charting Financial Data Generating Reports from Multiple Worksheets and Workbooks. Managing Data with Data Tools

Major Assignments Schedule

Week 1 Introduction Blackboard, submission of Online learning survey

2 Excel Module 1: Developing a Purchase Order Report

3 Excel Module 1: PO Report (continued)

4 Excel Module 2.1 Creating a Sales Report assignment

5 Excel Module 2.2 Sales Report- Designing a Printout assignment.

6 Excel Module 3.1 Staffing a Call Center assignment

7 Excel Module 3.2 Calls assignment- Lookup Tables and Logical Functions

8 Exam 1 Module 1-3

9 Excel Module 4.1 Preparing an Investment Report assignment

10 Excel Module 4.2 Scatter Charts, Data Bars, and Sparkline (Sunrise) assignment

11 Excel Module 5.1 Summarizing Profit and Loss Statements assignment

12 Excel Module 5.2 and 5.3 External References assignment continued

13 Excel Module 6.1 Analyzing Employment Data assignment

14 Excel Module 6.2 and 6.3 Filters and Calculated fields assignment.

15 Exam #2 or MOS certification exam Quizzes will be given as needed.

Final Exam Date

December 8, 2026 at 9:30 a.m.

Grading Scale

90 - 100=A 80 - 89=B 70 - 79=C 60 - 69=D Below 59 = F

Determination of Final Grade

Exam/Test 40% Assignments and Quizzes 60%

Instructor Policies

Announcements: I will post announcements weekly, usually early in the week. These announcements indicate upcoming due dates and notes important to your success in this course. You should READ these Announcements every week. I also recommend using the Blackboard app on your phone, with notifications, so that you immediately receive notices of new announcements for this class. Use only your LSCPA email to communicate with me.


Assignments: No emailed work is accepted. You must submit all of your assignments in Blackboard. Homework and/or quizzes will be given each week. The assignments will open by Tuesday and will be due by the following Monday night, except the last week of class. This is subject to change. LATE WORK will only be accepted after meeting with instructor no later than one week after due date. Due dates are given, and enough time is given to complete all work. Students are responsible for completing all assigned homework, including reading assignments and video watching, by the required due dates. A failure to follow oral and/or written instructions could result in a 0 being given for the assignment.


There may be virtual meetings if needed. I am using these meetings as an opportunity for you to ask questions about the reading material and/or any assignments given. If you need a virtual meeting you will need to email me to schedule one on TEAMS.


Grades: All grades will be posted to your Blackboard under MyGrades. I will not discuss your grades over the phone or by e-mail. If you want to discuss your grades, you must schedule a virtual meeting on TEAMS or see me during office hours. I will not discuss your grades in front of other students.


Exams: Exams will be provided within a Blackboard examination window. The exams will be a hands on submission or timed test that is limited to 60 minutes maximum. Make-up exams will NOT be given. If you miss an exam your lowest test grade counts twice. If you miss two or more exams you will be assigned zeros as your lowest grade will be zero. There will be a final exam. All students must take the exam on the scheduled date, and time, and failure to do so will result in a 0 on the final exam. Feedback on specific exam questions will be given 24 hours after the exam is due. You must work alone while taking the exam. Cheating on exams is not acceptable and will be subject to violations of the Academic Dishonesty policy which could include failing the course.


Textbooks/supplies: Every student MUST have their own copy of the required textbooks by the end of the first week of class. The student will still be responsible for any assignments given. There is an in house copy of the textbook in the Gates Library. You will also need supplies to take notes. 


Academic Dishonesty: Copying, stealing, and/or submitting someone else’s work including AI is considered a violation of the Academic Dishonesty policy. Academic Dishonesty of any kind will not be tolerated. A student violating this policy will receive a zero on any assignment (first offense); a second incidence of academic dishonesty will result in failure of the class and/or meeting with program coordinator and/or department chair.


Software Requirements: If you are in a course that is using a specific software, you MUST have the software available to you either on your home computer or you must use the open lab provided in the Madison Monroe building or Gates Library on campus. Reliable Internet access is required for all my courses. Computer failure and lack of internet access are not acceptable excuses for missed assignments, projects, quizzes, or exams. There is access available on campus in the Library and the Madison Monroe building. DO NOT wait until the weekend or last minute to complete class work or exams. Do not complete assignments, quizzes, or exams on a phone or Chrome book as they will not submit properly. If you have a MAC computer it will be difficult to complete this course the book is formatted for a windows computer because that is what industry uses. 


"AI Tools in Our Course: This course recognizes that AI tools are increasingly part of the academic and professional landscape. You may use AI tools like Microsoft Copilot for brainstorming, outlining, or getting unstuck in your thinking process. However, the final written product must be substantively your own work.

When you use AI in your process, you must include a brief appendix to your assignment that explains: 1) which tool you used, 2) what prompts you provided, and 3) how you incorporated or modified the AI-generated content. Using AI without this documentation will be considered an academic integrity violation."


E-Mail/Voice Mail Etiquette: Students must use appropriate e-mail etiquette when corresponding with instructor; for example, complete sentences and a full subject line with your name and course name. Do not use slang or all caps this is a business professional environment. Voice mail messages should be clearly spoken identifying students name, course, and a return phone number.

Attendance Policy

Poor attendance is a leading reason for termination from a job in all areas of employment. With this factor in mind, the instructor monitors student attendance daily. In addition, attendance on a regular basis is necessary for proper skill development. ~ To be successful in this course, the student MUST purchase the assigned textbook and log into Blackboard at least 2-3 times weekly. Regular, reliable access to Blackboard via Internet is required for this course. Attendance is monitored via Blackboard reports of logins and interaction with face to face course. ~ Students are responsible for completing all assigned homework by due date and for being prepared for each class face to face or online meeting. This applies even if you were absent for the previous class meeting.

Additional Information

Classroom Etiquette: The following behaviors will result in the student being asked during class time to cease the action, leave the classroom and /or a Student Services conduct reporting form will be filled out: using cell phones, playing video out loud, talking, or keying while the instructor is giving instructions or during class discussions; surfing the Internet during lecture; and/or displaying a rude or negative behavior toward the instructor and/or other students.

MyLSCPA

Be sure to check your campus email and Course Homepage using MyLSCPA campus web portal. You can also access your grades, transcripts, academic advisors, degree progress, and other services through MyLSCPA.

Academic Honesty

Academic honesty is expected from all students, and dishonesty in any form will not be tolerated. Please consult the LSCPA policies (Academic Dishonesty section in the Student Handbook) for consequences of academic dishonesty.

ADA Considerations

The Americans 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 Disability Services Coordinator, Room 117, in the Student Sucess Center. The phone number is (409) 984-6241.

Facility Policies

No food or tobacco products are allowed in the classroom. Only students enrolled in the course are allowed in the classroom, except by special instructor permission. Use of electronic devices is prohibited.

HB 2504

This syllabus is part of LSCPA's efforts to comply with Texas House Bill 2504.

Mandatory Reporting of Child Abuse and Neglect

As per Texas law and LSCPA policy, all LSCPA employees, including faculty, are required to report allegations or disclosures of child abuse or neglect to the designated authorities, which may include a local or state law enforcement agency or the Texas Department of Family Protective Services. For more information about mandatory reporting requirements, see LSCPA's Policy and Procedure Manual.

Title IX and Sexual Misconduct

LSCPA is committed to establishing and maintaining an environment that is free from all forms of sex discrimination, including sexual harassment, sexual violence, and other forms of sexual misconduct. All LSCPA employees, including faculty, have the responsibility to report disclosures of sexual misconduct, including sexual harassment, sexual assault (including rape and acquaintance rape), domestic violence, dating violence, relationship violence, or stalking, to LSCPA's Title IX Coordinator, whose role is to coordinate the college's response to sexual misconduct. For more information about Title IX protections, faculty reporting responsibilities, options for confidential reporting, and the resources available for support visit LSCPA's Title IX website.

Grievance / Complaint / Concern

If you have a grievance, complaint, or concern about this course that has not been resolved through discussion with the Instructor, please consult the Department Chair.