|
|
 |
Instructions for Completing the Cohort Worksheet July 2007
- For the student under appeal please provide the following information in the row entitled "Appellant:"
- The student's state assigned identification number (SASID)
- The student's GPA for each of the course titles indicated at the top of the worksheet at grade 10 and 11. Use the numerical values shown in the table below.
- The highest MCAS score the student received in the subject area of the appeal.
- For every student in the cohort group (defined as ALL the students in the school who took the same sequence of courses identified at the top of the worksheet AND who passed the MCAS test in the subject area of the appeal), please provide:
- The students' GPAs for each course (use the numerical values shown in the table below)
- The highest MCAS score received by the student in the subject area of the appeal.
| A | A- | B+ | B | B- | C+ | C | C- | D+ | D | D- | F |
| 4.0 | 3.7 | 3.3 | 3.0 | 2.7 | 2.3 | 2.0 | 1.7 | 1.3 | 1.0 | 0.7 | 0.4 |
| | | | | | | | | | | | |
| | | | | | | | | | | | |
Please also note the following:
- The cohort worksheet will not accept numerical grade values 0.0 to 0.3. Grades of "F" must be assigned a value of 0.4 indicating that the student's work was equivalent to or above 0.4.
- The worksheet may include grade 9 courses. Similarly, the worksheet may include grade 12 courses, if the student under appeal and the cohort group have competed at least two terms of the grade 12 courses. In this case, average grades for the two terms should be provided. If grade 10 and/and or 11 courses are not included, rational must be provided.
- Rather than listing ALL the students who took the same sequence of courses in the worksheet, you may include only those students who scored 220 to 228. If you have more than 25 students in a cohort with MCAS scores 220-228, or if there are questions about the cohort email mcasappeals@doe.mass.edu for further instructions.
Worksheet Summary Definitions
| Student's GPA: | The average grade for the courses identified in the worksheet |
| Median GPA of Cohort Within 220-228: | The grade point average that half of the students in the cohort scored above (or below) |
| Number of Students in Cohort: | The number of students in the cohort whose MCAS scores ranged from 220-228
This number must be at least 6 in order to make a determination based on the cohort worksheet |
| Mean GPA of Cohort: | The cohort's average grade point average for the courses identified in the worksheet |
| Standard Error of the Mean: | A measure of the error associated with the cohort's average grade |
| GPA at 2 Standard Errors of the Mean (SEM): | This number is calculated by subtracting two Standard Errors of the Mean from the Mean GPA of the Cohort |
last updated: July 11, 2007
|
|