15. Final Project: FreshGo 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 |
About this data: Teaching sample for a fictional shop “Summit Schools”. Figures and names (e.g. Vikram Rao) are made up for this lesson on submission checklist and marking guide.
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 बोल सकते हो.
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.
Worked example — submission checklist and marking guide
Why
Meera Joshi in Pune and Sophie Martin abroad both need a clear, repeatable way to use submission checklist and marking guide on a NovaCraft Tools sheet without breaking totals.
What
Submission Checklist And Marking Guide is the Excel idea this page teaches. We will walk one tiny example end to end.
How
- Open a blank sheet. In A1 type a short label for submission checklist and marking guide.
- Enter a small made-up value for Meera Joshi using € where money appears.
- Add a second value for Sophie Martin using ₹ so you see mixed currencies stay numeric.
- Apply the method from this lesson step by step (menu or formula as shown above).
- Check the result still works inside SUM or a simple check cell.
Formula / action
Follow the formula or ribbon steps shown in this lesson (keep values numeric).Meaning: Once submission checklist and marking guide is correct on one row, copy the same pattern down the column.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of submission checklist and marking guide on a blank sheet for NovaCraft Tools.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Rohan Patil and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Emma Clarke.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply submission checklist and marking guide to a 5-row made-up NovaCraft Tools table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with submission checklist and marking guide.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as NovaCraftTo_practice.xlsx.
Hint: Use a clear file name for class.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
