Learning Situation Assessment and Competency Gradebook Template

This comprehensive Teacher Evaluation Record template is designed to streamline the complex process of tracking student progress through multiple learning stages. Built specifically for educators who need to align classroom activities with formal competency standards, the workbook provides a structured environment to record grades, select assessment instruments, and automatically calculate final outcomes. It eliminates the need for manual tallying and complex formula writing, allowing you to focus more on teaching and less on administrative data entry.

The template is organized into nine distinct Learning Situation modules, each accessible via independent navigation buttons. Within each situation, you can manage a roster of up to 28 students. The interface features intuitive dropdown menus for selecting evaluation criteria (ranging from 1.1 to 4.3) and assessment instruments such as exams, infographics, or group projects. The system is built to handle up to eight different criteria per learning situation, providing the flexibility needed for diverse lesson plans. A dedicated summary section aggregates all data to provide a clear view of student achievement across four core competencies.

This tool is particularly useful for teachers working in systems that require competency-based reporting. It solves the common headache of mapping individual classroom tasks to broader educational goals. By automatically converting rubric scores (1-4) into a standard 10-point scale (where 1 equals 2.5 and 4 equals 10), it ensures grading consistency across the entire academic term. Whether you are managing a small seminar or a full classroom of 28 students, this template maintains organization and clarity.

How to use:

1. Start by entering your student names in the editable roster column; these names will automatically populate across all learning situations for consistency.
2. Navigate to a Learning Situation card and use the dropdown menus to select the specific criteria and assessment instruments being evaluated for that unit.
3. Enter the scores (1 to 4) for each student as they complete their tasks; the template will store these values for the final calculation.
4. Click the Competency Summary button to view the final arithmetic means for each of the four specific competencies, providing you with a ready-to-report final grade for every student.

Expected benefits include a significant reduction in manual calculation time and improved accuracy in competency-based reporting.