Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

MTSS Dashboard where fields are present: Admin, Classroom, Student

Note: LaunchDate could be used to build automation for shutting down the tier customization setting screen once the first launch date has passed. For example, on 7/28/23 district file has a launchdate of 7/28/23, and then logic is built in to recognize the date and turn off the tier customization screen for that district.

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.

  • Although Star Reading is given to grades 3 and above, some districts may instead give an older student the Star Early Literacy test because the student’s skills are at that level. Expect some outliers.

  • 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 be
adjusted 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 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

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

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

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

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

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

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

  • This is a little better choice to identify the class/teacher where the student 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.

  • 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

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

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)