15. Final Project: Blinkit Maharashtra Monthly Report
15.7 Submission Checklist and Marking Guide
Steps before you submit
- Protect the structure; hide
Calc; protect the Dashboard sheet with slicers usable (Module 14). - Set print area and page setup for the Dashboard (A4 landscape, 1 page).
- Fill the
Notessheet: data problems and fixes, KPI definitions, answers to the five questions, refresh steps. - Save as
Blinkit_Final_Project_<YourName>.xlsmplus the exported PDF. - Prepare a 60-second "Explain your project" answer using STAR (Module 18.1).
Marking guide (100 marks).
| Area | What the evaluator checks | Marks |
|---|---|---|
| Data cleaning | All planted problems fixed; reconciliation table correct; raw sheet untouched | 20 |
| Tables and formulas | Named Tables; correct lookups with no #N/A; fee slab and On Time logic correct; absolute/structured references | 20 |
| PivotTable analysis | Five pivots correct; target achievement; one-sentence answers | 15 |
| Dashboard | Answers all 5 questions; KPI cards linked; slicers connected to all pivots; one screen; clean design | 20 |
| Macro | Runs without error; .xlsm; error handling; button assigned |
10 |
| Protection and printing | Structure protected; print-ready; PDF exported | 5 |
| Documentation and explanation | Notes sheet complete; clear 60-second project explanation | 10 |
| Total | 100 |
Grades: 85+ Excellent · 70–84 Good · 55–69 Needs polish · below 55 Redo the weak stages.
Ravindra Bagale's Tip
Many students leave the Notes sheet empty when submitting their project – and lose 10 marks. Documentation is the proof of your work: what the problems were, what you did, how you checked the numbers. In an interview too, you can read these same Notes and speak confidently.
Ravindra Bagale's Tip – मराठी
बरेच students project submit करताना Notes sheet रिकामी ठेवतात – आणि 10 marks सोडतात. Documentation म्हणजे तुमच्या कामाचा पुरावा (proof): काय problem होते, काय केलं, आकडे कसे check केले. Interview मध्ये पण हेच Notes वाचून तुम्ही confidently बोलू शकता.
Ravindra Bagale's Tip – हिंदी
बहुत से students project submit करते समय Notes sheet खाली छोड़ देते हैं – और 10 marks गँवा देते हैं. Documentation तुम्हारे काम का सबूत (proof) है: क्या problems थीं, क्या किया, आँकड़े कैसे check किए. Interview में भी इन्हीं Notes को पढ़कर तुम confidently बोल सकते हो.
Practice task
Mark your own project with the table above before submitting, and fix every area where you gave yourself less than 70% of the marks.
Thodkyaat sangaycha tar (quick recap)
- Raw → Clean (reconcile) → Tables + lookups → Pivots → Dashboard → Macro → Protect + Print.
- Pratyek stage che proof Notes sheet var.
- Hach project tumcha interview "Explain your project" uttar – STAR vapra.
Shabbas mitrano! Aata practice aani interview tayari – pudhe exercises.