We need to show mapping for Star Reading to our RethinkEd Platform.
We need to determine Tier Level designations.
Academic Assessment Data:
SR.csv (reading assessment scores for students in middle elementary grades and up)
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 tier 3
For the case when PercentileRank >= 23 & PercentileRank < 25 the student will be assigned to tier 2 with an 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 indicator (such as a down arrow) showing that they are close to moving to tier 2
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 ELA Tab.
Renaissance Field Information:
Grade level of the assessment taken (this may beadjusted in Renaissance).Varchar(20)
...
GradeEquivalent
...
Grade Equivalent
Grade Equivalent is seen by user as a heading and beneath it is a grade equivalency for the student.
...
...
Used in Student View as part of graphs and charts. (See image: Grade Equivalent)
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, ScreeningWindowEndDate
Renaissance Field Information:
Grade Equivalent (GE) value. Grade Equivalentscores range from 0.0 to 12.9+. They representhow a student’s test performance compares withthat of other students nationally. A GE scorepreceded by a “greater than” sign (>) is a cappedscore. GE scores in excess of three grade levelsabove the student’s actual grade are capped,meaning that such GE scores are shown as “>[student’s actual grade level + 3].” This preventsthe misinterpretation that students with
© 2023 Renaissance Learning, Inc. All rights reserved. | www.renaissance.com R63547.230421 8Field Descriptionexcessively high GE scores are capable of workat those higher grades.Text
...
PercentileRank
...
Percentile Rank
Percentile is seen by user as a heading and the student’s percentile is shown beneath it in the Student View
...
...
Used in several areas including: Student View, Classroom View, Account Settings
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-referencedscore provides a measure of student’s readingability compared to other students in the samegrade nationally; it indicates the percentage of thestudents nationally who obtained scores equal toor lower than the score of the student. Scoresrange 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 ofwindow).This will only be populated as long as the schoolthe assessment is linked to is tied to a screeningwindow on the site and the assessment taken fallswithin 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 ofwindow).This will only be populated as long as the schoolthe assessment is linked to is tied to a screeningwindow on the site and the assessment taken fallswithin 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 theschool’s set screening windows (blank if outsideof screening windows).This will only be populated as long as the schoolthe assessment is linked to is tied to a screeningwindow on the site and the assessment taken fallswithin 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
...
Suggest: Put field for student id and state id in the UI
...
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 notprovided.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 determineinserts, updates, and deletes when importing datafrom an external source. The mapping of sourcedID to any specific field may vary by externalsource and is only guaranteed for manualOneRoster imports. CDI populates this field with afabricated 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 bythe district.Varchar(max)
...
DistrictName
...
Shown in the highest level for Admin Reports.
...
Need to make sure the naming conventions are the same as the data we get from the external data sources.
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
...
Category Rating
Category names: At / Above, On Watch, Intervention, Urgent Intervention is listed under the Category Rating
...
Used to fill Category Rating column in Student View in Star Early Literacy, Star Reading and Star Math.
Renaissance Field Information
Renaissance default benchmark categories; theseare standard across all Renaissance customers.At/Above Benchmark: At/Above 40 PR
Field DescriptionOn Watch: 25 – 39 PRIntervention: 10 – 24 PRUrgent Intervention: Below 10 PR
...
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 studenttested
...
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.
Not sure this is necessary for us.
Renaissance Field Information
CompletedDate converted to the time zoneconfigured for the site where the assessment wastaken. If there is a discrepancy between these twovalues, 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 (CoordinatedUniversal Time); this is the time standardcommonly used across the world.Datetime
...
CourseSourcedID
...
Not in design
...
Internal field for problem solving and keeping a running log.
Renaissance Field Information
Internal ID for the course used to determine inserts, updates, anddeletes when importing data from an external source. The mappingof sourced ID to any specific field may vary by external source andis only guaranteed for manual OneRoster imports. CDI populatesthis field with a fabricated composite key.varchar(max)
...
ClassSourcedID
...
Not in design
...
Internal field for problem solving and keeping a running log.
Renaissance Field Information
Internal ID for the class used to determine inserts, updates, anddeletes when importing data from an external source.The mapping of sourced ID to any specific field may vary byexternal source and is only guaranteed for manual OneRosterimports. CDI populates this field with a fabricated composite key.varchar(max)
...
TeacherSourcedID
...
Not in design
Internal field for problem solving and keeping a running log.
Renaissance Field Information
...
We need to show mapping for Star Reading to our RethinkEd Platform.
We need to determine Tier Level designations.
Academic Assessment Data:
SR.csv (reading assessment scores for students in middle elementary grades and up)
See: Renaissance for more information about Tiering and students whose scores are in close proximity to a different tier Level.
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.
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 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
 |
Renaissance Field Information:
|
CurrentGrade Grade |
 |
Renaissance Field Information: CurrentGrade
Grade
|
GradeEquivalent | Grade Equivalent
 |
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
|
