Lesson 4: Data Collection and Record Keeping
Objectives
In an Google document, the learners will create a template for collecting data and keeping records with 80% accuracy as graded by a rubric.
Tasks
The learners will create pre and post assessments to be used for data collection and cut off scores.
The learners will create a shared spreadsheet to utilize as a grade book.
The learners will develop a timetable with deadlines for grades to be put in the grade book.
The learners will create a timetable for assessing and regrouping of students.
Learn
While incorporating flexible grouping it is important to remember that students may or may not be working with their assigned homeroom teacher during a particular grading period. The issue with grading can be complicated when exchanging students amongst a team, therefore, a plan must be in place to assist in the process. I recommend using a Google Sheet with shared access among the team so teachers can access grades at their convenience and transfer them to the school's official grade book.

You can view a sample of a Google Sheet used for grading here: https://docs.google.com/spreadsheets/d/1uFVY9Of1KxJmqmXEUd9yU88GaWrzJZBsXXfWxfIBn9U/edit#gid=0

If you have never worked with Google Docs before, you can view a tutorial here: https://www.youtube.com/watch?v=32tHhXrNt8E
Before you are able to input any grades you will need to decide on your pre an post assessments. These assessments should cover the same objectives in order to evaluate what your students already understand on the topic.
Once you have decided the elements, you will need to collaborate with your team on a time table. Assessments should be given on the same days and under the same circumstances in order to be standardized.
Once pre-assessments are taken, input the scores into the shared Google Sheet specifically designated for Pre-assessments and desegregate by score. This will allow for easy grouping across the team.
It is important to note that scores on the pre-assessment should not be considered part of the students' overall grades. These are for informational purposes only.
Once the groups are formed, you will need to share expectations of switching classes with your students and designate items that they will need to take with them.
Your team will cover the unit in the same amount of time. The difference will be the teaching methods used and the depth of the concept covered.
Post assessments should also be given on the same day or time. Allow students to utilize any strategies specifically taught in their flexible groups.

Collaborate with your peers. Decide on pre-and post assessments to be utilized for each unit. Decide on a time-table of assessing and regrouping students. Look through the unit and decide which activities will be counted as part of their overall grade. Revise this plan as needed.
Create a Google Sheet to use as a shared electronic grade book. All members of the team should have access this document and be able to edit. View the attached rubric to ensure you have all necessary elements included in your electronic grade book.
Submit your planned pre and post assessments, as well as your grade book to me for review. I will use the rubric to evaluate your work.

It is helpful to set deadlines for grades to be entered into the grade book. This will ensure efficiency during report card time.
What's Next?

Go on to Lesson 5: Lesson_5:_Putting_It_All_Together

Return to the Flexible Grouping Intro page - Flexible_Grouping