Transcript New Testing Coordinators - North Carolina Public Schools

Testing and
NC WISE
NC WISE Training Team
NCDPI
Document Use
This document is the property of the NC DPI and
may not be copied in whole or in part without the
express written permission of the NC DPI.
This curriculum is intended for LEAs to use and/or
customize for re-delivery based on specific LEA
needs. If modifications and additions are made to
this curriculum, LEAs are responsible for the
content.
2
Overview








Accountability Information
Vocabulary
What is NC WISE?
Test Upload
Getting Started in eSIS
Testing Data in eSIS
Getting Started in WebApps
Testing Data in WebApps
3
Accountability Information
4
Communication Model
LEA NC WISE
Project Team
LEA Testing
Team
NC WISE
Project Team
DPI
Accountability
5
NCDPI Accountability Website
Navigation:
http://www.dpi.state.nc.us/accountability







State Tests
Policies and Procedures
Testing and Accountability Results
Testing Calendars
Accountability Directory
School Test Coordinator Handbook
For more info – contact your RAC
6
The Life Cycle of a Test





Member file is created
Precode is created
Tests are administrated and scored
Tests are uploaded to eSIS
Reporting begins


NC WISE: Transcript, Reporting Hub
Accountability: AYP and ABCs
7
General NC WISE Vocabulary
8
Vocabulary



NC WISE – North Carolina Window of
Information on Student Education.
eSIS – Electronic Student Information
System.
WebApps – Web application that manages
user security and UERS.


UERS – Uniform Education Reporting System.
Reporting Hub – Web application that
enables you to run customized reports.
9
Vocabulary – More
Information

For more definitions of educational acronyms,
please see: http://www.dpi.state.nc.us/acronyms/
10
What is NC WISE?
11
NC WISE Components

NC WISE Architecture



NC WISE Repository
Data Centers
Software Components



eSIS
WebApps
Reporting Hub
12
NC WISE Architecture Diagram
Data Center
LEA
School
School
School
School
School
School
13
NC WISE Architecture Diagram …
Data Center
LEA
School
School
School
LEA
School
School
School
School
School
School
School
LEA
School
School
School
School
School
School
School
School
School
14
NC WISE Architecture Diagram …
Data
Center
Data
Center
Data
Center
NC WISE
Repository
Data
Center
Data
Center
15
Software Components
Diagram
eSIS
Reporting
Hub
WebApps
16
Testing Data Flow
ABC Tools
eSIS
WebApps
17
How do I get access?


LEA Testing Coordinators must have an NC
WISE login created by the LEA Coordinator.
LEA Testing Coordinators must have at
least the user role of LEA Testing
Coordinator.
18
Test Upload
19
Test Upload Process
1.
A folder (SUBMIT_SCO) has been created in
each district's SecureShell location
2.
Once the SCO files have been uploaded the
automated processing will move the data into
NC WISE
3.
All accountability tests are uploaded to eSIS
nightly
4.
Error reports will be provided via the Web site
https://www.rep.dpi.state.nc.us/app/wisesco/
20
SAT Test Upload Process
1.
2.
3.
4.
Obtain SAT data file from ETS
Download the ‘Student Upload for NC
WISE SAT Upload Tool (School)’ from
the Reporting Hub
The MS Access application matches
students and creates the .SCO file
Test Upload process imports data into
eSIS
21
Test Upload Resources

The user guide has been posted to
https://www.rep.dpi.state.nc.us/2009/200
9_docs.html

If there are any questions, please contact
your Regional Accountability Coordinator
22
Getting Started in eSIS
23
Getting Started with eSIS

eSIS is a web-based application.



Use Internet Explorer.
Disable pop-up blockers.
J initiator must be installed.
24
Logging In
Donald_Duck
LEA999
Typically
FirstName_LastName
Password provided
LEA plus LEA number
Do not share logins!
25
Logging In - Path
LEA test and training environment:
Navigation: esis-xut.ncwise.org
Production environment:
Navigation: esis.ncwise.org
26
Logging In …

Do not log in more than
once!
27
Logging In - Steps
1.
From the Login dialog box:
1.
2.
2.
Type the user name in the
Username field.
Type the password in the
Password field.
Click Connect.
The eSIS Start screen opens.
28
Exercise

Log into eSIS using the:



https//:esis-xut.ncwise.org.
Use the same user ID and
password that you would
with Production.
Use the Data Center number
and XUT for the Database.
29
eSIS START Screen
30
eSIS Hot Keys

Query Hot Keys:
 F7 – Enter
 % - wildcard
 F8 – Execute
 Shift +F2 – record count
31
Counting Records - Steps
1.
2.
3.
4.
From the START screen, press
F7.
Type ’08’ in the Grade field.
Press Shift + F2 to review a
count of all 8th grade
students.
Press F8.
32
Exercise

Determine how many 7th
grade females a Middle
School has.
33
Selecting a School

LEA Testing
Coordinators
can view
multiple
schools’ data or
one school at a
time.
34
Locking a School - Steps
1.
2.
3.
4.
From the eSIS Start screen,
click the Select School icon.
Highlight the appropriate
school.
Check Lock School.
Click Ok.
35
Exercise

Using the Lock School
feature, select a Middle
School.
36
Test Data in eSIS
37
Objectives





Exporting Precode/Member files from
eSIS
Adding a test to a student record
Tracking High School Exit Standards
Recording Graduation Project Tests
Running the Student Standard Test
Summary report
38
Exporting Precode and
Member Files
39
Standardized Testing Export Path
Navigation: Administration > Standard
Tests/Assessment > Export Students
40
Standardized Testing Export
41
Things to remember:

Communicate with your Data Managers




Admission and withdraw records must
accurate!
Precode and Member files must be
named: Precode.xxx / Member.xxx
Member files are created using the same
steps as Precode.
Contact your RAC for information on
where to save the Member file.
42
Exporting a Precode File - Steps
1.
2.
3.
From the School drop-down list, click the
appropriate school.
From the File Type to Create drop-down list,
click Pre-Code.
Click Save As.
a.
b.
4.
Locate or create a file folder to house the Precode file
In the Save File as: field, Type c:\ precode.xxx
(Replace xxx with the school number.)
Click Create.
43
Exercise

Create a Precode file.
44
Adding a Test
45
Student Standardized Testing
- Path
Navigation: Main Menu > Change Student >
Standardized Testing > Student Test Scoring
46
Student Standardized Testing
47
Student Standardized Testing …
48
Things to Remember

All attempts must be recorded as
separate records in the database.

The Student Standardized Testing screen
can be queried for multiple student entry.
49
Adding a Test - Steps
1.
From the Tests section, click ADD.
The Add Test window opens with current
school, grade and date information
populated. Update the default the
information as needed.
2.
From the Test field, click the question
mark (?).
A menu of all possible tests appears.
3.
From the Select Test menu, click the
appropriate Test Name.
50
Adding a Test – Steps …
4.
5.
Click Ok.
Verify the Test name in the Add Test
window, click Ok.
The test has now been added to the student
record.
6.
Type the student’s scores in the Values
fields of the Test Scores tab.
51
Adding a Test – Steps …
7.
8.
9.
Type the appropriate information in the
Attempts, field of the Sub Test Detail
tab.
From the Exemption drop-down list,
click the appropriate exemption if
applicable.
From the
Accommodations/Modifications dropdown list, click the appropriate
accommodation if applicable.
52
Exercise

Add an EOG Math test
score to an 8th grade male
student.
53
High
School Exit Standards
54
High School Exit Standards

A Score Type of Met Exit Standard has
been added to some EOC tests, with
possible values of Y (yes) and N (no).





Algebra 1
English 1
Biology
Civics/Economics
US History
55
Things to Remember

The Assessment Date for the
exemption must be recorded as
xx/25/20xx.
56
Exemption Codes



P – Review committee/principal gave
credit
Q – Transfer/Principal gives exit credit
V – Not required to meet exit standard
57
Recording Exemptions - Steps
1.
From the Tests section, click the ADD.
2.
Type xx/25/20XX in the Assessment
Date field.
The Add Test screen opens with current
school, grade and date information populated.
Update the default information as necessary.
This date must be used for recording
Exemptions no matter when the actual
exemption was decided upon.
58
Recording Exemptions – Steps …
3.
Click the ? to the right of the Test field.
4.
From the list, click or use the Find field
to select the appropriate test. Click OK.
5.
Click OK in the Add Test window.
59
Recording Exemptions – Steps …
5.
On the Test Scores tab, type ‘N’, beside
the Met Exit Standard column.
6.
Click the SubTest Detail tab.
7.
Click the appropriate exemption code
from the Exemption drop-down list.
8.
Click Save.
60
US History – First Attempt
61
US History – Retest 1
62
US History – Retest 2
63
US History – Committee Review
64
US History – Committee Review…
65
Exercise

Add an English 1 test
exemption to a 10th grade
student.
66
Report Card Message

Accountability Services Division
recommends a School Message be
included to help parents correctly
interpret final marks as they relate to the
EOC and Exit Standards.
67
High School
Graduation Project
68
HS Graduation Project


Progress towards completion of the
graduation project will be tracked via
tests within eSIS.
Four Components





Paper – GP00
Product – GP01
Portfolio – GP02
Presentation – GP03
These tests are Met/ Not Met
69
What Appears on the
Transcript?

The original test with the score values.

The additional test with the exemption
reason.
70
Running the Student
Standard Test Summary
Report
71
Student Standard Test
Summary Report - Path
Navigation: Reports Icon > Standardized
Testing > Student Standard Test Summary
72
Reports Tree
73
Demographic Extract
74
Student Standard Test Summary
75
Student Standard Test Summary …
76
Student Standard Test Summary
77
Running the Standard Test
report - Steps
1.
2.
Double click the Student Standard
Test Summary report.
From the extract dialog box, click
Specify Extract Criteria.
a.
b.
c.
Click Clear Extract Criteria.
From the Grades drop-down list, click the
appropriate grade level(s).
Define additional fields of criteria as needed.
78
Running the Standard Test
report – Steps …
d.
e.
f.
3.
4.
Click Run Extract.
eSIS will build an extract of all students in
the current school and display the count.
Click Go Back.
Exit out the Door.
From the extract dialog box, click Run
Report.
Type a meaningful name in the Report
Title if applicable.
79
Running the Standard Test
report – Steps …
5.
6.
Verify the Report Period Start Date and
Report Period End Date fields.
From the Test Name field, click the question
mark (?).
A menu of all possible tests appears.
7.
Click the appropriate Test Name.
Note: Use the Find field to query for the test or
scroll through the list.
8.
9.
The Test Number will auto populate.
Click the Printer icon.
The report will display in .pdf format.
80
Exercise

Run the Student Standard
Test Summary report for
8th grade students.
81
Getting Started in WebApps
82
What is WebApps?

The WebApps site is used to perform
multiple activities:



State Reporting (UERS)
User Security
Building ACC Test and Data Files
83
Accessing WebApps / UERS
84
Logging In
Use the same login
and password as is
used for eSIS.
https://webapps.ncwise.org
85
Logging In - Steps
1.
From the Log In section:
1.
2.
2.
Type the user name in the
Username field.
Type the password in the
Password field.
Click Go.
WebApps opens to the Profile
tab.
86
Exercise

Log into WebApps using
the:


XUT environment URL
provided.
Use same user ID, password,
and database as you would
with Production.
87
Test Data in WebApps
88
Objectives



View the Profile tab
View the Message Center
Download ACCData an ACCTests files
89
Viewing the Profile Tab
90
Using the Profile Tab

Three tiles:



Message Center – review messages on
processes performed on the site.
Profile – view information for the user that is
currently logged into WebApps.
User List – view information about users
within an LEA or school.
91
Message
Center Tile
User List
Tile
Profile Tile
92
Downloading files from UERS
Adhoc Reports Tab
93
Things to Remember



Adhoc Reports sub-tab is used to run
and download ACCData and ACCTest
reports.
Time-intensive operation.
Can continue other work while this builds.
94
ACC Data and Test Files
95
Building ACC Data Files Steps
1.
2.
3.
From the WebApps Profile screen, click
the UERS tab.
Click the Adhoc Reports tab.
From the Select A School drop-down,
click the appropriate school.
The screen refreshes to display the last time
ACC Data was run.
96
Building ACC Data Files –
Steps …
4.
Verify the date.
Note: If the date is not correct, click Edit.
Type the correct date.
5.
Click Run ACCData.
A message appears asking the user to be
patient.
97
Building ACC Data Files –
Steps …
6.
7.
8.
Click Refresh to verify the file creation
is complete.
Click Download.
Click Save.
Save the file to the folder as directed by
your RAC.
98
Building ACC Test Files Steps
1.
2.
3.
From the WebApps Profile screen, click
the UERS tab.
Click the Adhoc Reports tab.
From the Select A School drop-down,
click the appropriate school.
The screen refreshes to display the last time
ACC Test File was run.
99
Building ACC Test Files Steps
4.
Verify the date.
Note: If the date is not correct, click Edit.
Type the correct date.
5.
Click Run ACCTest.
A message appears asking the user to be
patient.
100
Exercise

Build an Acc Test File.
101
Reporting Hub



NC WISE LEA Coordinator access
Data Manager access
Reports include:




Student Upload for NC WISE SAT Upload Tool
(School)
Test Scores Report (School)
Testing Information with Exit Standards (LEA)
Testing Information with Exit Standards (School)
102
ABC Tools




Data Manager and ‘Coordinator’ access
Application on ‘REP’ site with user manual
Use ACCdata, ACCtest and member files to
populate the database
Useful reports:


Historical Audit
HS Exit Standards
103
Questions
104
More Information
105
Accountability Reference
Documents
https://www.rep.dpi.state.nc.us





Test Upload User Guide
SAT Upload User Guide
ABCTools User Manual
Reason Codes
Data Collection Schedule
106
NC WISE Reference Documents
http://www.ncwise.org/eSIScategories.html



eSIS User Roles
NC WISE Security and Administration
Guide
Standardized Testing and Exit Standards
107
Training & Support Contacts


NC WISE Training Team Mailbox:
[email protected]
NC WISE Service Desk:
[email protected]
919.807.4357
108
www.ncwise.org
109