Excel Student Handwriting Dashboard - 24/11/2025 02:52 EST

I need a straightforward Excel solution that lets me record handwriting scores from several subject-specific sheets and see—at a glance—how each student’s handwriting is improving over time.

Here is what I’m looking for:
• A clean data-entry template on every subject sheet so I can enter a simple numeric score for each student and date.
• A central dashboard that automatically pulls those scores, aggregates them, and shows trend lines or progress bars for handwriting improvement.
• Quick filters to view one student, one subject, or an overall class summary.
• Basic conditional formatting that highlights noteworthy changes—both positive and negative—without cluttering the view.

I’m comfortable with Excel basics but need you to set up the formulas, pivot tables, charts, and any simple VBA or Power Query steps required so everything updates when I add new scores. A brief note or screenshot guide explaining how to maintain or expand the file will wrap up the job.