Creative Dad On the Job · Pathways · Data & Analytics

912W-SRA

Retail Sales Report Analyst

Data & AnalyticsLevel 1 · 6–8 hrs5 sessions · 75–90 minutesTeam 4–6 (5 is ideal; see roles)Project brief, draft

Turn three months of sales data into a one-page report the board can read in two minutes.

Client scenario

Welcome to the analytics team. You've just been hired as data analysts by Second Chapter Thrift (fictional), a nonprofit thrift store that sells donated clothing, books and housewares and uses the money to fund a job-training program. The store's board meets next week, and it wants a clear monthly report.

Client: The Store Manager (the teacher in role). The manager presents our report to the board.

The store has three months of sales data in a messy spreadsheet and no clear picture of what's selling.

Roles

  • Lead Analyst
  • Data Cleaner
  • Chart Designer
  • Report Writer
  • Quality Lead

The twist: The manager hands over the Manager's Request (H3): the board chair wants to see average sale per customer, compared month to month, in tomorrow's report.

Standards mapped

Mapped means the framework is verified and the teacher confirms the evidence. It isn't a claim that a project meets a standard.

  • NACE (Dec 2025)
  • ED Employability Skills Framework
  • CA Standards for Career Ready Practice
  • CCSS ELA
  • CCSS Math

Not tagged in this brief: NGSS SEP, ISTE Students.

Safety, devices and privacy

  • School devices only. No phones, and no personal accounts. Spreadsheets are made in an offline tool or a school-managed account.
  • The dataset is fictional and has no personal information. There are no customer names, cards or contact details, and students never add any.
  • Nothing leaves the classroom. The "board" is the teacher (and, if you like, another team). Reports are not emailed or posted anywhere.
  • No photos of students. Reports, logs and the Evidence Sheet carry no student names or personal information. Sign work "Team [#]".
  • Low-cost, school-realistic materials only. Follow the school's usual classroom rules.

Creative Dad On the Job is in-class client project work. It is not a paid, off-campus On-the-Job Training (OJT) placement.

Budget levels

Totals and Amazon links come from the materials sheet.

Materials links go to Amazon. Prices are estimates and may change. As an Amazon Associate, Creative Dad Company earns from qualifying purchases.

Quick Start

Digital downloads only. $0 to buy. Printing is noted separately.

$0 to buy. Printing $2–$4, noted separately.

Print-only version workable

Student time: one class period, one day.

Teacher prep / build-ahead: separate from student time.

Scale it

The default plan is one class period on a single day.

Scale back: Fit it into a shorter period, use fewer effects, or run a demo instead of a build.

Scale up: Add one extra effect, or spread the share-out across another day.

Ambiance video

Ambiance video coming soon from Creative Dad Studio

  • Sales dataset (fictional)Borrow or school has1 file per team$0
  • School devices with spreadsheet softwareBorrow or school has1–2 per team$0
  • Printing: brief, role cards, templates, handoutsPrintingAbout 40–60 pages$2–4
  • Classroom timer or wall clockBorrow or school has1$0

Full Experience

Up to $25 per class (class of about 30, 6 groups).

About $2–$4 per class (class of about 30, 6 groups). Fits under $25 per class.

Student time: one day.

Teacher prep / build-ahead: separate from student time.

Scale it

The default plan is one school day.

Scale back: Fit the build into one period with fewer effects.

Scale up: Spread the work across days, or add more effects.

Total Transformation

The bigger kit, priced per class (class of about 30, 6 groups).

About $11–$19 per class (class of about 30, 6 groups).

Student time: one day (one session, one-day event).

Teacher prep / build-ahead: separate from student time.

Scale it

The default plan is one session, a one-day event.

Scale back: Shorten the event, or run a demo for a smaller audience.

Scale up: Spread the build and the event across days, or invite a bigger audience.

  • Graph paper (fallback only)Optional1 pad$5–8Amazon
  • Sticky notes for the findings wallOptional1 pack$4–7Amazon

The rest of the brief is part of a subscription

Sessions, role duties, deliverables, materials, free tools, and the teacher setup use the same Creative Dad account as the project library. There is no separate student login.