Ravindra BagaleCourses & study guides

15. Final Project: Blinkit Maharashtra Monthly Report

15.7 Submission Checklist and Marking Guide

By Last updated:

Steps before you submit

  1. Protect the structure; hide Calc; protect the Dashboard sheet with slicers usable (Module 14).
  2. Set print area and page setup for the Dashboard (A4 landscape, 1 page).
  3. Fill the Notes sheet: data problems and fixes, KPI definitions, answers to the five questions, refresh steps.
  4. Save as Blinkit_Final_Project_<YourName>.xlsm plus the exported PDF.
  5. 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

Khup students project submit kartana Notes sheet rikami thevtat – aani 10 marks sodtat. Documentation mhanje tumchya kaamacha purava (proof): kay problem hote, kay kela, aakde kase check kele. Interview madhe pan hech Notes vachun tumhi confidently bolu shakta.

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.