|Welcome to the Articulator 2015!|
|This sheet is meant to assist the elementary end-of-year articulation process. It is designed to import STAR assessment data and be used by teachers on a single grade level to create balanced classrooms for the following year. There is a different instructions tab for administrators and teachers. A variables tab helps to control elements that are unique to each school.|
|Where Teachers add their data|
|Teachers should click on the "Data Beta" tab on the bottom of the spreadsheet to get started. Each class on the grade level will be listed, organized by teacher. Colums A, B and AA through AF are editable.|
|The Down Arrows|
|Many of the editable fields have a down pointing arrow. Clicking this arrow presents a menu with the acceptable choices for that cell. You can use this arrow, or you can type in the field.||NEXT CLASS A|
|Practice using the down pointing arrow here||--->||1|
|Selecting Next Year's Class|
|Teachers are asked to do an initial placement when they add their class data. The "Next Class" cell will contain a number for each avalable class in the down arrow menu. Teachers may be asked to build two classes ( "Class A" and "Class B") if there is uncertainty about the number of classes for the following year. If this is the case, the two choices will have a different number of classes.||NEXT CLASS A||NEXT CLASS B|
|Place students in "Class A" and "Class B" if student numbers are close to splitting or contracting the class for next year.||--->||1||3|
|The student services categories (ESL, Speech, OT, PT, LRC, CSE, 504) simply require an "x" if the student qualifies. These are blue and can be found all the way to the right in columns Z through AF.|
|"Do Not Place With" and "Special Notes" Fields|
|On the far right of the "Data Beta" sheet you find the "Do Not Place With" and the "Special Notes" cells. Use commas between students who should be separated from the child in question. In the notes section, include anything that would be relevant to placement, including, but not limited to, strengths, weaknesses, and notes about parents)|
|Analyzing the Numbers|
|As teachers place students into classes, the numbers are instantly updated on the data dashboards. Each dashboard can be toggled from the "Class A" set to the "Class B" set. There are several ways to look at how classes are ballanced: |
---> The Number Dashboard Sheet calculates important numbers and arranges the classes into columns.
---> The Class Rosters show who is in which class and allows you to customize three columns of data to compair. You can also decide how data is orted using the drop down menus on the right.
---> Charts compairs each class using visual representations of the data
---> In Focus shows one class at a time and includes the "do not place with" and "special notes" data. Classes can be switched using the Class number drop down menu found in cell C1.