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 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 Reading 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
...
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 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)
...
RenaissanceBenchmarkCategoryName
...
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”
...
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; 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
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
...
CompletedDateLocal
...
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.
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
...
StudentUserID
...
Not sure if this is part of our design that user sees. We show student ID in top part of the design but that may be a different ID than this value.
...
Need to map students correctly with number for calculating test results and our Student ID numbers used in Rethink.
Note the trademark for Renaissance Learning.
Not the caution for imported/manual entry
Used for identifying specific student for inclusion of most recent CompletedDateLocal and RenaissanceBenchmarkCategoryName
Specified by OneRoster and intended to containan optional, machine-readable ID. CDI populates
© 2023 Renaissance Learning, Inc. All rights reserved. | www.renaissance.com R63547.230421 2Field Descriptionthis with the human-readable ID for an object.Customers that have imported or manually addedtheir roster information may not have this valuepopulated.Varchar(50)
...
SATBenchmarkCategory
...
This is an assessment type that would show either under the heading: Assessment or alone such as SAT Benchmark
SAT is for older students--maybe show on a design
These contain subcategories: each with a cut score
Levels include: At/Above Benchmark, Below Benchmark
...
We would need to show cut scores and write logic:
Given StudentUserID has a score equal to or greater than X in the Renaissance Field SATBenchmarkCategory, then we show At/Above Benchmark
Link to SAT Benchmark Cut Scores:
Link shows multiple content areas
...
ACTBenchmarkCategory
...
This is an assessment type that would show either under the heading: Assessment or alone such as SAT Benchmark
SAT is for older students--maybe show on a design
These contain subcategories: each with a cut score
Levels include: At/Above Benchmark, Below Benchmark
We would need show cut scores and write logic:
...
Link to ACT Benchmark Cut Scores:
Link shows multiple content areas
...
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
|
