Course Enrollment & Student Progress Analytics

Track enrollments, completions, and student progress across all courses. Free .xlsx with formulas. Tracks Total Enrollments (Year-to-Date), Active Learners.

Education · dashboard · CC0 public domain · Built by Sheetly AI

About this template

This education dashboard brings together indicators like "Total Enrollments (Year-to-Date)", "Active Learners" and "Average Course Completion Rate" in a single view. Edit the entries in the Data tab and the dashboard numbers update instantly — no need to build the spreadsheet from scratch.

Use this dashboard template to monitor course enrollments, completion rates, and student progress over time. Enter each enrollment event with the associated student, course, status, and progress metrics. The top KPIs will summarize total enrollments, active learners, average completion rate, and average progress percent. Filter or sort the data by course, instructor, or status to identify trends and improve your training programs.

Released under the CC0 license (public domain): download, edit and use it freely — including commercially — with no attribution required.

Use cases

• Visualize indicators like "Total Enrollments (Year-to-Date)" and "Active Learners"
• Make faster decisions based on "Average Course Completion Rate"
• Compare your classes without building the spreadsheet from scratch
• Edit the entries in the Data tab and watch the dashboard recalculate automatically

Key features

• Total Enrollments (Year-to-Date)
• Active Learners
• Average Course Completion Rate
• Visual dashboard with 3 automatic indicators
• Editable formulas in the Data tab
• In-cell mini charts (sparklines)

What's inside the file

• 3 tabs: Dashboard, Data, Instructions
• 39 working formulas — including SUM, AVERAGE, COUNTA. They recalculate as you edit, so the sheet stays yours after download.
• Sized for real data: up to 37 rows × 7 columns already laid out and formatted.

Everything is a normal .xlsx: it opens in Excel, Google Sheets, LibreOffice and Numbers, with no add-ons, no macros and no locked cells.

Download the .xlsx free

Related free templates

• Tutoring Attendance & Learning Progress Dashboard — Track tutoring hours, student attendance, and learning outcomes in one view. Free .xlsx with formulas. Tracks Total Tutoring Hours, Average Outcome Score.
• Classroom Assessment Item Analysis & Grade Distribution — Track question performance and grade distribution across classroom assessments. Free .xlsx with formulas.
• After-School Program Attendance & Progress Dashboard — Track session utilization, student attendance, and academic progress by term. Free .xlsx with formulas.
• Tutoring Enrollment & Learning Outcomes Dashboard — Track student enrollment, session utilization, revenue, and academic progress. Free .xlsx with formulas. Tracks Active Students, Monthly Tutoring Revenue.
• Classroom Participation & Grade Distribution Dashboard — Track student engagement, assignment completion, and grade trends by class. Free .xlsx with formulas.
• College Course Load & GPA Progress Dashboard — Track credits, grades, and GPA progress across semesters. Free .xlsx with formulas. Tracks Total Credits Attempted, Total Credits Completed, Cumulative GPA.

Browse every free Excel template built by Sheetly AI.