Excel charts, trackers & lookup tables

0% OF THE COURSE COMPLETE

REAL-LIFE EXAMPLE — WHY TODAY MATTERS

A coaching centre wanted a monthly attendance and fee tracker with charts. Rakib built it with a pivot-style summary and a bar chart — the owner showed it to guardians at the meeting. Ongoing 3,000 taka/month work from one tracker.

Your day — 3 blocks, 6 hours

10:00u201312:00 Concept teach + live demo

12:00u201314:00 Guided practice set (trainer circulates)

14:00u201316:00 Lab / client work + debrief & exit ticket

By the end of today you will be able to:

Explain the core concepts of: Excel charts, trackers & lookup tables
Apply them in guided practice with a real-client scenario
Ship the day's lab artefact to the portfolio folder and log practice hours

Before class

Review yesterday's exit ticket; open today's checklist in the portal.

Homework (after class)

Polish today's artefact; log 1 practice hour; update earnings tracker if paid work resulted.

Lab — Lab W2A — Lab D: pricing sheet with SUM/IF/VLOOKUP

Practice set: Excel charts, trackers & lookup tables — verifiable output uploaded to portfolio folder SB-<id>-D06.

Acceptance: Acceptance criteria on course page; upload artefact link. Trainer approval required.

Submit this lab AI help with this lab

Checkpoint

Exit ticket (5 min) + practice-set check; weekly quiz on Thu.

Rubric (4-point per outcome)

Concept accuracy (3) · practice quality (3) · artefact completeness (3) · professionalism (3)

Missed the live day? Replay the slides above, ask SajibTutor "Teach me day 6", and submit the lab late — your trainer reviews the attendance flag.