The club’s data

README.txt text file

Used inno challenge: it lists the files

Topic 5 lab data pack. Everything here is made up: no real people, emails or events.

events.xlsx                 an Excel workbook: the Events sheet (date, start, hours, room) and the Budget sheet
registrations.csv           every sign-up from the club's online form
signins/                    one sign-in sheet per event, typed at the door
receipts/                   receipts and invoices the club paid (and one refund)
certificate-template.docx   the Word template for certificates: {{Name}}, {{Events}}, {{Hours}}
president-request.docx      the club president's memo asking for a one-page report

events.xlsx Excel workbook · 2 sheets

Used inChallenge 1 · The real ticket revenueChallenge 3 · Certificates for everyone who cameChallenge 4 · The president’s one-pagerChallenge 5 · Stretch: receipts against the budget

Sheets:EventsBudget

registrations.csv 390 rows · 7 columns

Used inChallenge 1 · The real ticket revenueChallenge 2 · Who never showed upChallenge 4 · The president’s one-pager

signins/robotics-night.csv 28 rows · 3 columns

Used inChallenge 2 · Who never showed upChallenge 3 · Certificates for everyone who cameChallenge 4 · The president’s one-pager

signins/art-jam.csv 23 rows · 3 columns

Used inChallenge 2 · Who never showed upChallenge 3 · Certificates for everyone who cameChallenge 4 · The president’s one-pager

signins/career-panel.csv 30 rows · 3 columns

Used inChallenge 2 · Who never showed upChallenge 3 · Certificates for everyone who cameChallenge 4 · The president’s one-pager

signins/food-drive.csv 37 rows · 3 columns

Used inChallenge 2 · Who never showed upChallenge 3 · Certificates for everyone who cameChallenge 4 · The president’s one-pager

signins/debate-prep.csv 27 rows · 3 columns

Used inChallenge 2 · Who never showed upChallenge 3 · Certificates for everyone who cameChallenge 4 · The president’s one-pager

signins/ai-poster-studio.csv 24 rows · 3 columns

Used inChallenge 2 · Who never showed upChallenge 3 · Certificates for everyone who cameChallenge 4 · The president’s one-pager

signins/parent-info-night.csv 23 rows · 3 columns

Used inChallenge 2 · Who never showed upChallenge 3 · Certificates for everyone who cameChallenge 4 · The president’s one-pager

signins/chess-opening-night.csv 21 rows · 3 columns

Used inChallenge 2 · Who never showed upChallenge 3 · Certificates for everyone who cameChallenge 4 · The president’s one-pager

signins/film-night.csv 31 rows · 3 columns

Used inChallenge 2 · Who never showed upChallenge 3 · Certificates for everyone who cameChallenge 4 · The president’s one-pager

signins/spring-bake-sale.csv 23 rows · 3 columns

Used inChallenge 2 · Who never showed upChallenge 3 · Certificates for everyone who cameChallenge 4 · The president’s one-pager

signins/coding-cafe.csv 19 rows · 3 columns

Used inChallenge 2 · Who never showed upChallenge 3 · Certificates for everyone who cameChallenge 4 · The president’s one-pager

signins/poetry-slam.csv 33 rows · 3 columns

Used inChallenge 2 · Who never showed upChallenge 3 · Certificates for everyone who cameChallenge 4 · The president’s one-pager

receipts/receipt-01.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

PRINT HUB
Receipt no. R-3100
For: Robotics Night
------------------------
TOTAL   $150.52

receipts/receipt-02.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

Invoice from Print Hub
Event: robotics night
Amount due: 186.10 USD
Thank you!

receipts/receipt-03.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

Campus Bookstore — order 7402
Items for the Art Jam
Subtotal 60.16
Paid by card

receipts/receipt-04.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

HARDWARE DEPOT
Receipt no. R-3103
For: Career Panel
------------------------
TOTAL   $66.01

receipts/receipt-05.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

Invoice from Campus Bookstore
Event: career panel
Amount due: 27.73 USD
Thank you!

receipts/receipt-06.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

Hardware Depot — order 7405
Items for the Food Drive
Subtotal 68.33
Paid by card

receipts/receipt-07.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

SNACK STOP
Receipt no. R-3106
For: Debate Prep
------------------------
TOTAL   $55.74

receipts/receipt-08.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

Invoice from Corner Bakery
Event: debate prep
Amount due: 61.07 USD
Thank you!

receipts/receipt-09.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

Print Hub — order 7408
Items for the AI Poster Studio
Subtotal 95.44
Paid by card

receipts/receipt-10.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

PARTY SUPPLY CO.
Receipt no. R-3109
For: Parent Info Night
------------------------
TOTAL   $48.63

receipts/receipt-11.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

Invoice from Corner Bakery
Event: parent info night
Amount due: 77.06 USD
Thank you!

receipts/receipt-12.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

Party Supply Co. — order 7411
Items for the Chess Opening Night
Subtotal 94.34
Paid by card

receipts/receipt-13.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

PARTY SUPPLY CO.
Receipt no. R-3112
For: Film Night
------------------------
TOTAL   $24.05

receipts/receipt-14.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

Invoice from Campus Bookstore
Event: film night
Amount due: 65.47 USD
Thank you!

receipts/receipt-15.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

Print Hub — order 7414
Items for the Spring Bake Sale
Subtotal 100.32
Paid by card

receipts/receipt-16.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

HARDWARE DEPOT
Receipt no. R-3115
For: Coding Café
------------------------
TOTAL   $76.89

receipts/receipt-17.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

Invoice from Party Supply Co.
Event: coding café
Amount due: 54.40 USD
Thank you!

receipts/receipt-18.txt text file

Used inChallenge 5 · Stretch: receipts against the budget

Party Supply Co.
REFUND
Returned items from the Art Jam
Amount refunded: -$18.50

certificate-template.docx Word document

Used inChallenge 3 · Certificates for everyone who came

president-request.docx Word document

Used inChallenge 4 · The president’s one-pager