Save time organizing your student math data and planning your small groups! This Google Sheet Small group math planning and data spreadsheet will sort your students automatically once you enter the data. Then use the "small group lesson planning" tab to quickly create your small group lesson plans for the week.

8 TEXAS 3rd Grade Strands:

• Place Value
• Fractional Units
• Problem Solving
• Algebraic Reasoning
• Geometry & Measurement: Shapes & Area
• Geometry & Measurement: Capacity, Perimeter, Fractions & Time
• Data Analysis
• Personal Financial Literacy

ORIGINAL VERSION:

Class Roster & Data:

Add student names. Use the dropdown under each TEKS to choose the progress level of each student. ("Meets", "Developing", or Approaching"). You can get this data from any formal or informal assessments. This can be updated after you have practiced in small group, or have given additional assessments. Once you have entered the data you have, click on the "small group data" tab.

Small Group Data:

You will not do any typing on this page. Student names will appear after you have entered student data. They will be grouped based on the progress level you assigned on the Class Roster & Data tab. Use this information create your weekly small group lesson plans.

Weekly Small Group Lesson Plans:

Add the times for each small group. Use the dropdowns to insert which group you will be teaching each day and time. Add students for each group at the bottom. Use the drop down menu to choose the TEKS you will be practicing in small group. You can duplicate the tab and rename for each week of the year.

Hide any tabs you are done using. You can always access them by clicking on the three horizontal lines in the bottom left corner.

UPDATED VERSION:

Score Criteria Tab:

Edit Group Titles:

When you edit the text, it will automatically change the titles on the "Bluebonnet Small Group Data" tab.

Edit Cell Colors:

"Score Criteria" tab: If you want to change the colors, you must change them by clicking on each cell. Click on "Format" at the top, then choose "conditional formatting". Change the color to your liking.

"Percent Class Roster & Data" tab: Click on cell B3. Click on "Format" at the top, then choose "conditional formatting". Change the colors to match the colors you chose on the "Score Criteria" tab.

"Percent Small Group & Data tab: Click on the empty cell in the upper left hand corner to highlight the entire sheet. Click on "Format" at the top, then choose "conditional formatting". Change the colors to match the colors you chose on the "Score Criteria" tab.

Edit Percent Score Ranges:

To customize the score range, change the numbers to fit the criteria you want for your classroom. It will automatically be changed in the "Percent Small Group Data" tab.

Percent Class Roster & Data tab:

Add student names. Enter the student score under each TEKS (percent). You can get this data from any formal or informal assessments. This can be updated after you have practiced in small group, or have given additional assessments. Once you have entered the data you have, click on the "percent small group data" tab.

Percent Small Group Data tab:

You will not do any typing on this page. Student names will appear after you have entered student data. They will be grouped based on the progress level you assigned on the Percent Class Roster & Data tab. Use this information create your weekly small group lesson plans.

Updated Weekly Small Group Lesson Plans tab: (6 GROUPS INSTEAD OF 5)

Add the times for each small group. Use the dropdowns to insert which group you will be teaching each day and time. Add students for each group at the bottom. Use the drop down menu to choose the TEKS you will be practicing in small group. You can duplicate the tab and rename for each week of the year.

Hide any tabs you are done using. You can always access them by clicking on the three horizontal lines in the bottom left corner.

If you cannot find what you are looking for, send me a message at tanya@teacheratheart.com, or visit my website:www.teacheratheart.com and fill out a request form.  I can create something for you.

Please be so kind as to leave a review.  If I am missing something or made a mistake, I am more than happy to add, or fix it so you can download the updated version.