Student Roster Reports

1
Student Roster Reports

• NMPED
• Title I BureauRoxann Morris

2
Session Purpose

• Participants will learn
• How to find the Student Roster Reports.
• How to flow information into Excel
• How to Auto Filter to narrow information
• How to sort to find bubble students

3
First---

• I will show you----- please watch and listen
• Then--- we will complete activities together
• Next--- you can play and experiment
• Last--- we can share what we learned together.

4
Watch me--- first----
5
Next follow me---

• Log on to https//nmreport.escholar.com
• Enter your user name/password
• Add escholar to trusted sites

6
Go to Public Folders
7
Follow this path--
8
Click---Run with options----
9
Change to Excel 2002
Then click RUN
10
Scroll to pick a district
Click NEXT
11
Scroll and select a school
Click NEXT
12
Select test content
Select content
Click NEXT
13
WAIT----
14
SAVE the file to a place YOU know where it is---
15
(No Transcript)
16
(No Transcript)
17
Click on a column Right click in the
column Scroll to Hide This hides the data that
you do not want to view at this time
18
Delete Header rows Select Data pull down
menu Select Filter Select Auto Filter
19
Click on the arrow to select which achievement
level to view In this case I selected all
students in Proficiency Level 2 Then Scale Score
sort click Ascending--- Who are your bubble kids?
20
To get EVERYONE back--- You must click ALL in the
column
21
Sort---

• Use multiple sorting levels to find your bubble
  students.
• Sort by
• Current Grade Level
• Scaled Score then--- achievement level code

22
Now--- you try!

• Create a list of the students in your school who
  are within 5 scale score points of moving to the
  next level?
• Level 1 to 2?
• Level 2 to 3?
• Level 3 to 4?

23
Understanding Check!

• Did you learn?
• How to find the Student Roster Reports.
• How to flow information into Excel
• How to Auto Filter to narrow information
• How to sort to find bubble students