OAB 202
Microsoft Excel & PowerPoint Essentials
Office Administration with Biblical Work Ethic CertificateOffice Administration Certificate24 contact hours8 sessionsCost: No tuition. All materials are provided.
Certificate Enrollment
This course is part of the Office Administration with Biblical Work Ethic. One payment of $997 covers all 4 courses in the certificate.
“The hand of the diligent maketh rich.” — Proverbs 10:4
This course builds the Excel and PowerPoint skills used every day in offices. In Excel you will enter and format data, write formulas and functions, sort and filter lists, build timesheets, inventory logs, and expense trackers, and create charts. In PowerPoint you will design clean presentations and deliver them with confidence.
Syllabus
Course Syllabus
| Item | Details |
|---|---|
| Course | OAB 202 · Microsoft Excel & PowerPoint Essentials |
| Program | Bridge to Opportunity · Office Administration with Biblical Work Ethic Certificate |
| Contact Hours | 24 hours · 8 weekly sessions of 3 hours |
| Format | Online to start; in-person once facility clearance is granted |
| Prerequisites | OAB 201 recommended. BTO 101–103 must be complete before beginning the certificate. |
| Cost | No tuition. All materials are provided. |
| Instructor | ________________________ |
| Meeting Time | ________________________ |
Course Description
This course builds the Excel and PowerPoint skills used every day in offices. In Excel you will enter and format data, write formulas and functions, sort and filter lists, build timesheets, inventory logs, and expense trackers, and create charts. In PowerPoint you will design clean presentations and deliver them with confidence.
Faith Integration
Numbers and presentations both carry trust. Accurate spreadsheets protect an organization's resources, and honest presentations tell the truth clearly. We practice stewardship with numbers and humility and courage when we stand before others to present.
Learning Outcomes
By the end of this course, you will be able to:
- Enter, edit, and format data in an Excel workbook.
- Write formulas and use functions such as SUM, AVERAGE, MIN, MAX, COUNT, and IF, with relative and absolute references.
- Sort, filter, and organize data using Excel tables.
- Build practical office spreadsheets: a timesheet, an inventory log, and an expense tracker.
- Create, format, and print charts and worksheets.
- Build a PowerPoint presentation using layouts, themes, and consistent design.
- Design slides that communicate clearly and accessibly.
- Deliver a short presentation using speaker notes and Presenter View.
Course Materials
- This student workbook
- Access to Excel and PowerPoint (or approved equivalents such as the free web versions or LibreOffice) during class
- Printed grids and practice files when devices are limited
- Calculator and pen or pencil
Weekly Schedule
| Week | Module | Assignment Due |
|---|---|---|
| 1 | Excel Fundamentals and Data Entry | Contact and Supply Workbook |
| 2 | Formulas and Functions | Budget with Formulas |
| 3 | Organizing Data: Sort, Filter, and Tables | Organized Data Report |
| 4 | Practical Office Spreadsheets | Office Operations Workbook |
| 5 | Charts and Printing | One-Page Monthly Report |
| 6 | PowerPoint Fundamentals | Five-Slide Orientation Deck |
| 7 | Designing Effective Presentations | Redesigned Deck |
| 8 | Presenting With Confidence | Final Project Submission |
How You Will Be Graded
| Component | Weight | What It Includes |
|---|---|---|
| Attendance & Participation | 15% | Being present, prepared, and engaged in discussion and group work (Participation Rubric) |
| Reflection Journal | 15% | Eight weekly entries connecting the lesson to your life and faith (Journal Rubric) |
| Module Assignments | 25% | Eight weekly assignments (Module Assignment Rubric) |
| Module Quizzes | 10% | Eight short quizzes, each given at the start of the next session (Module 8's is given with the final exam) |
| Final Exam | 10% | Given in the last session; covers all eight modules |
| Final Project | 25% | A practical project that brings the whole course together (Final Project Rubric) |
To pass this course: earn 70% or higher overall and attend at least 80% of sessions.
Classroom Covenant
- We begin and end each session in prayer. Participation in prayer is always welcome, never required.
- What is shared in class stays in class. We protect one another's stories.
- We speak with respect, listen without interrupting, and disagree with grace.
- We come prepared, do our own work, and ask for help when we need it.
- We follow all facility rules. Safety and security come first.
- We believe the best about one another and about what God can do.
Support & Accommodations
If reading, writing, vision, hearing, or any other need makes a part of this course harder, tell your instructor privately. Materials can be read aloud, enlarged, or completed orally. Missed sessions can be made up using the module pages. If you are transferred or released, your completed work stays on record and you can finish online.
Welcome
Welcome
This companion walks beside you through OAB 202. Numbers and presentations can both feel intimidating. Each week's reading and devotions will help you see these skills as tools for honesty, stewardship, and service, and the Quick Guide at the back will keep the formulas and steps close at hand.
How to Use This Companion
- Read the weekly reading after each class session. It takes about 10 minutes.
- Reflect on the questions. These are for you; you do not have to turn them in.
- Meet with God through the five daily devotions between sessions.
- Keep the Quick Guide at the end to carry home after release.
Thy word is a lamp unto my feet, and a light unto my path.— Psalm 119:105 (KJV)
Course Modules
Final Project, Rubrics & Final Exam
Course Materials
Materials for this course are coming soon.