Final Project
Final Project: Office Operations Package
Create a workbook and presentation that together show you can manage office data and communicate it clearly. Paper versions are acceptable where devices are limited.
Requirements
- A three-tab workbook: timesheet with overtime formula, inventory with IF reorder status and conditional formatting, and expenses with SUMIF summary
- At least one absolute reference and one protected sheet
- A sorted and filtered table with a short written finding
- A one-page printed monthly report with a chart and three insights
- A redesigned 5–6 slide presentation that passes the Accessibility Checker
- Speaker notes on every slide
- A five-minute delivered presentation of your monthly report
- A one-page reflection on your growth in Excel and PowerPoint
Timeline
- Module 4: workbook built
- Module 7: report and deck drafted
- Module 8: submit package and present
Grading Rubrics
Grading Rubrics
Every rubric uses the same four levels. Your instructor will mark the level that best matches your work for each row and add a short comment.
Module Assignment Rubric
| Criterion | Excellent (4) | Proficient (3) | Developing (2) | Beginning (1) |
|---|---|---|---|---|
| Completeness | Every required part is done | Most required parts are done | About half the parts are done | Little of the assignment is done |
| Accuracy & Skill | Skills applied correctly with no significant errors | Minor errors that do not affect the result | Several errors that affect the result | Major errors throughout |
| Professional Quality | Neat, clear, and ready for an employer to see | Clear with small issues | Hard to follow in places | Unclear or disorganized |
| Effort & Growth | Went beyond the minimum or clearly improved | Solid, consistent effort | Minimal effort | Little evidence of effort |
Total possible: 16 points.
Reflection Journal Rubric
Journals are graded on effort and reflection, never on spelling, grammar, or the details of a personal story.
| Criterion | Excellent (4) | Proficient (3) | Developing (2) | Beginning (1) |
|---|---|---|---|---|
| Completion | Responds fully to every part of the prompt | Responds to most of the prompt | Responds to part of the prompt | Entry missing or one line |
| Connection to Lesson | Clearly applies the week's skill or idea | Mentions the lesson | Vague link to the lesson | No link to the lesson |
| Faith Reflection | Thoughtfully engages the Scripture or faith theme | Engages the faith theme | Brief mention of faith theme | Does not address the faith theme |
| Personal Application | Names a specific next step or change | Names a general next step | Next step is unclear | No next step |
Total possible: 16 points.
Participation Rubric
Scored at the end of each module. Average the eight scores for the Attendance & Participation grade.
| Criterion | Excellent (4) | Proficient (3) | Developing (2) | Beginning (1) |
|---|---|---|---|---|
| Attendance & Punctuality | Present and on time for the full session | Present; late or left early once | Missed part of the session more than once | Absent without make-up work |
| Preparation | Completed assignment and brought workbook every time | Usually prepared | Sometimes prepared | Rarely prepared |
| Engagement | Contributes thoughtfully and draws others in | Contributes regularly | Contributes when asked | Seldom contributes, even when invited |
| Respect & Covenant | Models the classroom covenant for others | Follows the covenant consistently | Needs occasional reminders | Needs frequent reminders |
Total possible: 16 points.
Final Project Rubric: Office Operations Package
| Criterion | Excellent (4) | Proficient (3) | Developing (2) | Beginning (1) |
|---|---|---|---|---|
| Completeness | All eight items included | Six or seven items | Four or five items | Three or fewer |
| Formulas & Accuracy | All formulas correct, including IF, SUMIF, and absolute references | Minor errors | Several errors | Formulas missing or wrong |
| Data Organization & Charts | Clean tables, correct sorting/filtering, clear chart with message title | Mostly clear | Unclear in places | Disorganized |
| Presentation Design | Applies all four principles; accessible; minimal text | Mostly well designed | Text-heavy or inconsistent | Poorly designed |
| Delivery & Reflection | Confident, on time, with thoughtful reflection | Clear delivery and reflection | Hesitant or brief | Not delivered or no reflection |
Total possible: 20 points.
Quick Guide
Excel & PowerPoint Quick Guide
Keep this guide with your important papers after release.
Essential Excel Formulas
| Item | Details |
|---|---|
| =SUM(A2:A10) | Adds a range |
| =AVERAGE(A2:A10) | Finds the mean |
| =MIN( ) / =MAX( ) | Smallest / largest value |
| =COUNT( ) / =COUNTA( ) | Counts numbers / non-empty cells |
| =IF(C2<5,"Reorder","OK") | Makes a decision |
| =SUMIF(C:C,"Supplies",E:E) | Adds values meeting a condition |
| =(C2-B2)*24 | Hours between two times |
| $A$1 | Absolute (locked) reference (F4 toggles) |
Excel Habits
- ☐ One kind of data per column; one record per row
- ☐ Enter numbers without symbols; format as currency
- ☐ Freeze the header row
- ☐ Spot-check one result with a calculator
- ☐ Show Formulas: Ctrl + `
- ☐ Check Print Preview before printing
Choosing a Chart
| Item | Details |
|---|---|
| Column / bar | Compare categories |
| Line | Change over time |
| Pie | Parts of a whole (few categories) |
PowerPoint Design
- ☐ One idea per slide
- ☐ About 20 words or fewer per slide
- ☐ 24-point font or larger
- ☐ High contrast; don't rely on color alone
- ☐ Alt text on images
- ☐ Use the Slide Master for consistency
- ☐ One simple transition
Before You Present
- ☐ Rehearse out loud three times
- ☐ Know your first and last lines
- ☐ Use Presenter View and speaker notes
- ☐ Arrive early; test equipment
- ☐ Bring a backup copy or handouts
- ☐ Breathe, pray, and serve your audience
Being confident of this very thing, that he which hath begun a good work in you will perform it until the day of Jesus Christ.— Philippians 1:6 (KJV)
Final Exam
- 1.
A range is written as:
- 2.
To enter money in Excel, you should:
- 3.
Every formula begins with:
- 4.
=AVERAGE(B2:B6) returns:
- 5.
An absolute reference looks like:
- 6.
Filtering data:
- 7.
Ctrl + T creates:
- 8.
=IF(C2<5,"Reorder","OK") returns "Reorder" when C2 is:
- 9.
SUMIF adds values that:
- 10.
Best chart for a trend over 12 months:
- 11.
The Slide Master controls:
- 12.
Minimum recommended slide font size:
- 13.
Presenter View shows:
- 14.
Which principle groups related items?
- 15.
Formatting a number as currency changes the stored value.
- 16.
Honest time recording on a timesheet is part of integrity at work.
- 17.
Color alone is enough to communicate meaning on slides.
- 18.
You should rehearse a presentation out loud before delivering it.
- 19.
An employee worked 7:30 a.m. to 4:00 p.m. with a 0.5-hour unpaid break. How many hours did she work?
- 20.
Explain how Proverbs 11:1 applies to working with spreadsheets.