Weekly Student Progress Tracker
Weekly Student Progress Tracker
— Prompt —
Create an Excel spreadsheet to track weekly academic progress for students in [insert grade level/class]. Include columns for assignments, test scores, attendance, and participation. Calculate weekly averages and overall grade. Use conditional formatting to flag scores below 70%. Include a dashboard showing class average trends.
Why It Works
Weekly breakdowns with automatic grade calculations provide actionable insights for teachers and students.
Example Output
A spreadsheet where students' weekly math quiz scores auto-average and low performers are highlighted in red.