We need to show mapping for Star Reading to our RethinkEd Platform.
...
See: Renaissance for more information about Tiering and students whose scores are in close proximity to a different tier Level.
For each season (as defined by the column ScreeningPeriodWindowName), tiering will be based on the most recent value of the PercentileRank column for each student, where most recent is determined by the CompletedDateLocal column and each student is identified StudentUserID column. Note that in current designs (week of 06/19/23), information on tiering is provided for each season, so tiers should be shown separately by season. We specify to look at the most recent date in case a student completed the assessment twice in the same season.
Here is the mapping for students:
Using the most recent date (as per the CompletedDateLocal column) within each student (as identified by the value in the StudentUserID column) and each value of ScreeningPeriodWindowName (so that students have a tier for each value of ScreeningPeriodWindowName):
PercentileRank < 10 = tier 3
For the case when PercentileRank >= 8 & PercentileRank < 10 the student will be assigned to tier 3 with an indicator (such as an up arrow) showing that they are close to moving to tier 2
PercentileRank >= 10 & PercentileRank < 25 = tier 2
For the case when PercentileRank >= 10 & PercentileRank < 12 the student will be assigned to tier 2 with an indicator (such as a down arrow) showing that they are close to moving to For each season (as defined by the column ScreeningPeriodWindowName), tiering will be based on the most recent value of the PercentileRank column for each student, where most recent is determined by the CompletedDateLocal column and each student is identified StudentUserID column. Note that in current designs (week of 06/19/23), information on tiering is provided for each season, so tiers should be shown separately by season. We specify to look at the most recent date in case a student completed the assessment twice in the same season. Important note: Designs for the week of 07/17/2023 combine English Language Arts results across Star Reading and Star Early Literacy. Some students will have separate results in the same season for both tests. If that happens, use the most recent assessment results to map to a tier, regardless of whether those results are from Star Early Literacy or Star Reading (see Star Early Literacy (SEL) | Renaissance | Assessment Integration ).
Here is the mapping for students for default tiers (see note below about when users change the default):
Using the most recent date (as per the CompletedDateLocal column) within each student (as identified by the value in the StudentUserID column) and each value of ScreeningPeriodWindowName (so that students have a tier for each value of ScreeningPeriodWindowName):
PercentileRank < 10 = tier 3
For the case when PercentileRank >=
8 & PercentileRank <
10 the student will be assigned to tier
3 with an approaching indicator (such as an up arrow) showing that they are close to moving to tier
2
PercentileRank >= 10 & PercentileRank < 25 = tier
2
For the case when PercentileRank >=
10 & PercentileRank <
12 the student will be assigned to tier
2 with an at risk indicator (such as a down arrow) showing that they are close to moving to tier
Tara has created a spreadsheet (named “tier_mappings_for_academic_asessments” + date/time stamp) to show default tiers and at-risk/approaching indicators for academic assessments across all different assessment makers (iReady, Renaissance, NWEA MAP, etc.). She has written code that will help update the spreadsheet as we integrate new academic assessments. The idea is for DEV to use this spreadsheet as the source of truth for tier recommendations, at-risk, and approaching indicators for academic assessments.
Important note: DEV will always use the .csv file with the most recent date/time stamp in its name from the following SharePoint folder: MTSS Academic Assessment Mapping. For this assessment, the specs below also spell out how default tiers will work, but all of this same information is also in the most recent .csv file.
MTSS Dashboard where fields are present: Admin, Classroom, Student
Design:
Star Reading Fields
...
Renaissance Field
...
Rethink Field
Mapping Points
...
Logic for Rethink Set Up
...
ScaledScore
...
Scaled Score
Scaled Score is seen by user as a heading and beneath it is the scaled score for the student.
...
Used in Student View as part of graphs and charts.
Scaled scores are different for each grade so graphs need to reflect a starting and ending range that shows the user scaled scores that particular grade and student. (See outside link to Renaissance Benchmark Cut Scores).
Renaissance Field Information:
Scaled Score of student’s Star Reading test (0-
1400); this is the Enterprise Scale.
Integer
...
Grade
...
Users see The Star ELA Tab when a student has taken the Star ELA test in the year selected.
...
...
Star Reading given to students in grades 3 and older.
Given a student has taken the Star Reading, then we will show the Star Reading Tab.
Renaissance Field Information:
Grade level of the assessment taken (this may be
adjusted in Renaissance).
Varchar(20)
...
GradeEquivalent
Grade Equivalent
...
3
For the case when PercentileRank >= 23 & PercentileRank < 25 the student will be assigned to tier 2 with an approaching indicator (such as an up arrow) showing that they are close to moving to tier 1
PercentileRank >= 25 = tier 1
For the case when PercentileRank >= 25 & PercentileRank < 27 the student will be assigned to tier 1 with an at risk indicator (such as a down arrow) showing that they are close to moving to tier 2
Important note: When a user changes from the default mapping for tiers, the at risk indicator (such as a down arrow) will apply when the student has the minimum PercentileRank or the minimum PercentileRank +1 for tier 1 or tier 2. The approaching indicator (such as an up arrow) will apply when the student has the maximum PercentileRank or the maximum PercentileRank -1 for tier 2 or tier 3.
MTSS Dashboard where fields are present: Admin, Classroom, Student
Design:
Star Reading Fields
Renaissance Field | Rethink Field Mapping Points | Logic for Rethink Set Up |
ScaledScore | Scaled Score
|
|
|
Grade equivalency is provided for each season of the test and is part of data collection specific to the seasons.
See below for: ScreeningPeriodWindowName, ScreeningWindowStartDate, ScreeningWindowEndDatePercentile Rank
Percentile
Renaissance Field Information: |
Grade Equivalent (GE) value. Grade Equivalent
scores range from 0.0 to 12.9+. They represent
how a student’s test performance compares with
that of other students nationally. A GE score
preceded by a “greater than” sign (>) is a capped
score. GE scores in excess of three grade levels
above the student’s actual grade are capped,
meaning that such GE scores are shown as “>
[student’s actual grade level + 3].” This prevents
the misinterpretation that students with
© 2023 Renaissance Learning, Inc. All rights reserved. | www.renaissance.com R63547.230421 8
Field Description
excessively high GE scores are capable of work
at those higher grades.
Text
PercentileRank
| ||
CurrentGrade Grade |
|
Renaissance Field Information: CurrentGrade
Grade
|
GradeEquivalent | Grade Equivalent
|
|
|
|
Percentile Rank (PR) is used to determine the benchmarks categories for Renaissance (At / Above = PR 40, On Watch=PR 25-39, Intervention=PR 10-24, Urgent Intervention=PR below 10) so we are stuck with them for the corresponding text equivalent.
We allow users to adjust the Tier levels based on these benchmarks (See image: Settings).
Renaissance Field Information:
Percentile rank (PR) value. Norm-referenced
score provides a measure of student’s reading
ability compared to other students in the same
grade nationally; it indicates the percentage of the
students nationally who obtained scores equal to
or lower than the score of the student. Scores
range from 1 to 99.
Integer
ExtraTime
Shown on Student View
Extra time is a heading with either of the following responses given:
Yes
No
Renaissance Field Information
“Yes” if the student was given extra time to complete the test.
varchar(3)
Empty State
Given the value is null or left empty, then we will not show the heading nor the value beneath it on the Student View.
ScreeningWindowStartDate
Screening window start date is not shown to the user but is used to determine what information is contained within each of the seasons.
Used to determine the start date for each of the tests: Fall, Winter and Spring.
In addition, our settings allow users to change Tier designation BEFORE the testing window begins for Star Early Literacy, Star Literacy and Star Math. (See: Settings)
See Star Early Literacy for image in settings.
Renaissance Field Information
Start date of screening window (blank if outside of
window).
This will only be populated as long as the school
the assessment is linked to is tied to a screening
window on the site and the assessment taken falls
within that window.
Varchar(max)
ScreeningWindowEndDate
Screening window end date is not shown to the user but is used to determine what information is contained within each of the seasons.
Used to determine the end date for each of the tests: Fall, Winter and Spring.
See Star Early Literacy for example of an empty state in the Student View.
Renaissance Field Information
End date of screening window (blank if outside of
window).
This will only be populated as long as the school
the assessment is linked to is tied to a screening
window on the site and the assessment taken falls
within that window.
Varchar(max)
ScreeningPeriodWindowName
This shows as Fall, Winter, Spring in the designs
We will be combining Star Early Literacy with Star Literacy to show the tier levels in the graph.
We need to name each of the seasons for ELA:
ELA Fall
ELA Winter
ELA Spring
Test needs to be given within the testing window in order to count. Field to determine this are: ScreeningWindowStartDate and ScreeningWindowEndDate
See: Star Early Literacy for future development example that shows multiple years.
Renaissance Field Information:
Name of screening window if test is within the
school’s set screening windows (blank if outside
of screening windows).
This will only be populated as long as the school
the assessment is linked to is tied to a screening
window on the site and the assessment taken falls
within that window.
Varchar(255)
SchoolYear
Shown in upper right corner in many areas.
Shown in Admin Reports, Classroom and Student Views.
We default to the current school year.
Given there is data for multiple school years, we will list the school years in order of the most recent to the least recent in the drop down field.
Renaissance Field Information
Name of the school year in Renaissance.
Varchar(max
SchoolYearStartDate
Not part of the design
This doesn’t show for the user but is used to identify the start of the school year: maybe useful for calculations for Attendance, Incidents--perhaps connect to Powerschool section.
Renaissance Field Information
First day of the school year in Renaissance.
Datetime
SchoolYearEndDate
Not part of the design
This doesn’t show for the user but is used to identify the start of the school year: maybe useful for calculations for Attendance, Incidents--perhaps connect to Powerschool section.
Renaissance Field Information
Last day of the school year in Renaissance.
Datetime
StudentStateID
Possible visual connection
This may / may not show for the user. We have a place for a student ID but it may be our ID for the student and not a State Id.
This is used to connect the student to the test they took.
Renaissance Field Information
Student’s state ID in Renaissance, blank if not
provided.
Varchar(50)
StudentFirstName
Student Names
Included in the student name in all areas of MTSS Dashboard.
Renaissance Field Information
Student’s first name in Renaissance.
Varchar(50)
StudentMiddleName
(maybe)
See image above for StudentFirstName
Included in the student name
Given no student name is included, then this field is left blank and student’s middle name is not included.
Given the student’s middle name is included, then this field is included as part of the student’s name.
Student’s middle name in combination with grade/ classroom name could serve as a secondary reliability check for the data value.
Renaissance Field Information
Student’s middle name in Renaissance.
Varchar(50)
StudentLastName
See image above for StudentFirstName
Included in the student name
Renaissance Field Information
Student’s last name in Renaissance.
Varchar(50)
DistrictSourcedID
Not part of the design
Used to make updates to data; please note manual OneRoster imports below.
Renaissance Field Information
Internal ID for the district used to determine
inserts, updates, and deletes when importing data
from an external source. The mapping of sourced
ID to any specific field may vary by external
source and is only guaranteed for manual
OneRoster imports. CDI populates this field with a
fabricated composite key.
Varchar(max)
DistrictStateID
Not part of the design
If district provided it.
Renaissance Field Information
State ID for the district, blank if not provided by
the district.
Varchar(max)
DistrictName
Shown in the highest level for Admin Reports.
Contained in our structuring for District Name in the Admin Reports; map this to existing district name.
Renaissance Field Information
Name of the district in Renaissance.
Varchar(max)
SchoolName
Shown in admin reports as a list of schools within a district.
Used to name each of the school buildings within our lists of schools within a specific district; may map this to existing names of schools for the district.
Renaissance Field Information
Name of the school where the student tested.
Varchar(max)
RenaissanceBenchmarkCategoryName
( Tara, Is this one old information?)
It could still be useful for identify the category rating column.
This shows as the name of the test-Example: Star Reading and is a header for information contained beneath it. -part of the design
Shown in graphic representation. For example: Urgent Intervention, Intervention, On Watch, At or Above, or N/A
Suggest account settings so user can decide their own words to put on the graphic to represent their state identification of proficiency categories “standardize customization”
Possible usefulness in Student View for Category Rating
Potential usefulness: Used to fill Category Rating column in Student View.
Tiering will be based exclusively on the most recent value of the RenaissanceBenchmarkCategoryName column for each student, where most recent is determined by the CompletedDateLocal column and each student is identified by StudentUserID column.
Renaissance default benchmark categories; these
are standard across all Renaissance customers.
At/Above Benchmark: At/Above 40 PR
Field Description
On Watch: 25 – 39 PR
Intervention: 10 – 24 PR
Urgent Intervention: Below 10 PR
Need to input cut scores for different types of state tests so that the right graphic shows.
N/A shows when student did not take the assessment-empty state-not sure if this is a category provided by Renaissance or one we need to create/include if no values are included in the data set
CourseName---Let’s think about this one and replace it-See also GroupOrClassName .
Suggest: TeacherSourceID
TeacherIdentifier
This field may not be right for us. What other field could we use to name the test? Should we rename what is listed as values so that they
Need to be able to get the kids to the proper classroom with the proper teacher whose classroom they are assigned
Suggest:
TeacherSourcedID
Internal ID for the teacher is used to determine
inserts, updates, and deletes when importing data
from an external source. The mapping of sourced
ID to any specific field may vary by external
source and is only guaranteed for manual
OneRoster imports. CDI populates this field with a
human-readable ID.
Varchar(max)
TeacherIdentifier
Internal teacher ID.
Varchar(max)
GroupOrClassName (Possibility from Above)
Need to find the best field that most closely matches the classroom name.
This is a little better choice than what is listed above to identify the class/teacher where it belongs. I am looking to map this to the classroom.
We have several other fields to choose from that name the teacher which may be better.
Renaissance Field Information
Name of the class or group where the student
tested
CompletedDateLocal
(Maybe)
Shows in design with the title of the seasons. Contained within each of the tabs for a cumulative view of all the seasons and in column headings.
Contained in all dashboards-Admin, Classroom, Student.
We combine the scores for Star Early Literacy and Star Reading to get one graph.
Used for updating the RenaissanceBenchmarkCategoryName. See Column Definitions document for field description.
CompletedDateLocal converted to the time zone
configured for the site where the assessment was
taken. If there is a discrepancy between these two
values, CompletedDate (which is stored as UTC)
is considered authoritative.
Datetime
CompletedDate
(maybe)
Not in design
Not sure this is necessary for us.
Renaissance Field Information
Date the assessment was completed.
Date and time is reported as UTC (Coordinated
Universal Time); this is the time standard
commonly used across the world.
Datetime
Renaissance Field Information:
| ||
PercentileRank | Percentile Rank
|
Renaissance Field Information: |
ExtraTime |
|
Renaissance Field Information
Empty State
|
ScreeningWindowStartDate |
|
Renaissance Field Information
|
ScreeningWindowEndDate |
|
Renaissance Field Information
|
ScreeningPeriodWindowName
|
|
Renaissance Field Information:
|
SchoolYear |
|
Renaissance Field Information
|
SchoolYearStartDate |
|
Renaissance Field Information
|
SchoolYearEndDate |
|
Renaissance Field Information
|
StudentStateID |
|
Renaissance Field Information
|
StudentFirstName |
|
Renaissance Field Information
|
StudentMiddleName (maybe) |
|
Renaissance Field Information
|
StudentLastName |
|
Renaissance Field Information
|
DistrictSourcedID |
|
Renaissance Field Information
|
DistrictStateID |
|
Renaissance Field Information
|
DistrictName |
|
Renaissance Field Information
|
SchoolName |
|
Renaissance Field Information
|
RenaissanceBenchmarkCategoryName | Category Rating
|
Renaissance Field Information
|
GroupOrClassName (We are having trouble finding a field that will match with the Classroom and ensuring that the students are in the proper classroom. GroupOrClassName is the closest we can get. We will most likely need to write something that combines multiple items to ensure that we can map effectively. ) |
|
Renaissance Field Information
|
CompletedDateLocal (Maybe) |
|
Renaissance Field Information
|
CompletedDate (maybe) |
|
Renaissance Field Information
|
CourseSourcedID |
|
Renaissance Field Information
|
ClassSourcedID |
|
Renaissance Field Information
|
TeacherSourcedID |
|
Renaissance Field Information
|
LaunchDate |
|
Renaissance Field Information
|
StudentSourcedID |
|
Renaissance Field Information
|
StudentIdentifier |
|
Renaissance Field Information
|
StudentUserID |
|
Renaissance Field Information
|
StudentEmail |
|
Renaissance Field Information
|
Gender BirthDate MultiRace HispanicOrLatino AmericanIndianOrAlaskaNative Asian BlackOrAfericanAmerican NativeHawaiianOrOtherPacificIslander White |
|
|
EnrollmentStatus |
|
Renaissance Field Information
|
DistrictRenaissanceID |
|
Renaissance Field Information
|
DistrictSourcedID |
|
Renaissance Field Information
|
SchoolSourcedID |
|
Renaissance Field Information
|
CourseCode CourseName |
|
Renaissance Field Information CourseCode
CourseName
|
TeacherEmail TeacherFirstName TeacherLastName |
|
Renaissance Field Information TeacherEmail
TeacherFirstName
TeacherLastName
|
RenaissanceBenchmarkCategoryLevel RenaissanceBenchmarkCategoryMinPercentileRank RenaissanceBenchmarkCategoryMaxPercentileRank |
|
See also: RenaissanceBenchmarkCategoryName Renaissance Field Information RenaissanceBenchmarkCategoryLevel
RenaissanceBenchmarkCategoryMinPercentileRank
RenaissanceBenchmarkCategoryMaxPercentileRank
|
DistrictBenchmarkCategoryName DistrictBenchmarkProficient DistrictBenchmarkCategoryLevel DistrictBenchmarkNumberOfCategoryLevels DistrictBenchmarkMinPercentileRank DistrictBenchmarkMaxPercentileRank |
|
Renaissance Field Information DistrictBenchmarkCategoryName
DistrictBenchmarkProficient
DistrictBenchmarkCategoryLevel
DistrictBenchmarkNumberOfCategoryLevels
DistrictBenchmarkMinPercentileRank
DistrictBenchmarkMaxPercentileRank
|
SchoolBenchmarkCategoryName SchoolBenchmarkProficient SchoolBenchmarkCategoryLevel SchoolBenchmarkNumberOfCategoryLevels SchoolBenchmarkMinPercentileRank SchoolBenchmarkMaxPercentileRank |
|
Renaissance Field Information SchoolBenchmarkCategoryName
SchoolBenchmarkProficient
SchoolBenchmarkCategoryLevel
SchoolBenchmarkNumberOfCategoryLevels
SchoolBenchmarkMinPercentileRank
SchoolBenchmarkMaxPercentileRank
|