Star Early Literacy (SEL) | Renaissance | Assessment Integration

 

We need to show mapping for Star Reading to our RethinkEd Platform.

We need to determine Tier Level designations.

 

  • Additional Mapping for same fields are found in Star Reading. Begin at LaunchDate which is in Green text and follow the remaining items. These fields apply also to Star Early Literacy.

 

Academic Assessment Data:

  • SEL.csv (early literacy assessment primarily for students in early grades – note this file only contains ELA scores, so any tier recommendations from data in this file will be for ELA)

  •  Star Early Literacy Definitions

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 Reading | 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 PercnetileRank +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 Dashboards where fields are present: Admin, Classroom, Student

Design:

 

Star Early Literacy (SEL):

Possible Additional Fields

CurrentGrade (Heather's suggestion-Do we want Grade or CurrentGrade?-meet on Thursday
Include: RenaissanceBenchmarkCategoryName for Category Rating in Student View



DistrictBenchmarkCategoryName-maybe this field because it has the text for each level: At / Above Benchmark, On Watch, Intervention, Urgent Intervention. It would match up to Category Rating in Student View.

StudentIdentifier--We will need this to link student academic assessment date to Powerschool data.



 

Renaissance Field

Rethink Field

Mapping Points

Logic for Rethink Set Up

Grade

  • Users see The Star Early Literacy Tab when a student has taken a the Star Early Literacy test in the year selected.

(4th Grade Example)

 

  • Star Early Literacy (SEL) is primarily given to students in Kindergarten, First Grade and Second Grade; however for Belleville a few students who are in older grades have taken the Star Early Literacy test instead of the Star Reading test because of their current reading level.

    • Given a student has taken the Star Early Literacy test in a given school year, then they will see the Star Early Literacy Tab. (See image: 4th Grade Example)

 

Renaissance Field Information:

Grade level of the assessment taken (this may be adjusted in
Renaissance).
varchar(20)

ScaledScore

  • 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 Early Literacy test (0-1400); this is
the Enterprise Scale.
integer

GradeEquivalent

  • 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 Equivalent scores range from
0.0 to 12.9+. They represent how a student's test performance
compares with that of other students nationally. (Because Star
norms go no lower than grade 1, the GE for a score below the
minimum for GE 1.0 will be reported as “< 1”.) 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 excessively high GE scores are
capable of work at 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-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

 

ScreeningPeriodWindowName

  • This shows as Fall, Winter, Spring in the designs

 

  • Future development showing multiple years.

 

  • 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

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)

Empty State and Future Development

  • Given a school has not submitted their Star Early Literacy Assessment within the testing window (Fall, Winter, Spring) then we will not show the the circle graph for the missed test. (Some districts only give the Fall and Spring Assessment)

  • We need to consider multiple years data: Consider including the year within the graphic. (See image: Future Development)


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.

  • In settings, the user can change the Tier Levels prior to the beginning of the ScreeningWindowStartDate for Star Early Literacy, Star Reading and Star Math.

 

 

  • 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)

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.

  • Given a student has no score for a particular season, we will show an empty state for that student’s information in the ELA Student View.

 

  • Used to determine the end date for each of the tests: Fall, Winter and Spring.

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)

Empty State

  • Given a student has not completed the test within the testing window for a particular season, then we will not be able to include that student’s information as part of the calculations for the season.

    • It impacts the ELA student View where an empty state will be shown. (See image: No Spring)

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.

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

  • Important note: We are planning on requiring customers to enter the school year start date and the school year end date in a form when they first start using the product. So we intend to use those user-supplied dates as the “source of truth” for school year start date and school year end date (see Define School Year Settings), not the information supplied by this Renaissance field.

  • This doesn’t show for the user but is used to identify the start of the school year: maybe a useful backup (in case we have trouble getting school year start date from the required form mentioned in the above bullet point) 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

  • Important note: We are planning on requiring customers to enter the school year start date and the school year end date in a form when they first start using the product. So we intend to use those user-supplied dates as the “source of truth” for school year start date and school year end date (see Define School Year Settings), not the information supplied by this Renaissance field.

  • This doesn’t show for the user but is used to identify the end of the school year: maybe a useful backup (in case we have trouble getting school year end date from the required form mentioned in the above bullet point) 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

  • 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; these are standard across
all Renaissance customers.
At/Above Benchmark: At/Above 40 PR
On Watch: 25 - 39 PR
Intervention: 10 - 24 PR
Urgent Intervention: Below 10 PR
This score should be considered an individual level score; the percentile
rank for the student’s assessment is used to determine the benchmark
range the student falls in at the time they took the assessment.

This field will be blank if the assessment taken was not in a grade that
had been normed. Grade K is intentionally blank.
varchar(max)

GroupOrClassName

See Star Reading for more information on GroupOrClassName.

  • Need to find the best field that most closely matches the classroom name.

 

  • 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

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

CompletedDateLocal

(maybe)

  • Not in design

  • Not sure this is necessary for us.

Renaissance Field Information

CompletedDate 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

 

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, 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)

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, 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)

TeacherSourcedID

  • Not in design

  • Internal field for problem solving and keeping a running log.

Renaissance Field Information

Internal ID for the teacher 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)