Testing and NC WISE

1
Testing and NC WISE
NC WISE Training TeamNCDPI
2
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.
3
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

4
Accountability Information
5
Communication Model
LEA NC WISE Project Team
LEA Testing Team
NC WISE Project Team
DPI Accountability
6
NCDPI Accountability Website
Navigation http//www.dpi.state.nc.us/accountabil
ity

• State Tests
• Policies and Procedures
• Testing and Accountability Results
• Testing Calendars
• Accountability Directory
• School Test Coordinator Handbook
• For more info contact your RAC

7
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

8
General NC WISE Vocabulary
9
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.

10
Vocabulary More Information

• For more definitions of educational acronyms,
  please see http//www.dpi.state.nc.us/acronyms/

11
What is NC WISE?
12
NC WISE Components

• NC WISE Architecture
• NC WISE Repository
• Data Centers
• Software Components
• eSIS
• WebApps
• Reporting Hub

13
NC WISE Architecture Diagram
School
School
School
School
School
School
14
NC WISE Architecture Diagram
School
School
School
School
School
School
School
School
School
15
NC WISE Architecture Diagram
16
Software Components Diagram
17
Testing Data Flow
ABC Tools
eSIS
WebApps
18
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.

19
Test Upload
20
Test Upload Process

• A folder (SUBMIT_SCO) has been created in each
  district's SecureShell location
• Once the SCO files have been uploaded the
  automated processing will move the data into NC
  WISE
• All accountability tests are uploaded to eSIS
  nightly
• Error reports will be provided via the Web site
  https//www.rep.dpi.state.nc.us/app/wisesco/

21
SAT Test Upload Process

• 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

22
Test Upload Resources

• The user guide has been posted to
  https//www.rep.dpi.state.nc.us/2009/2009_docs.htm
  l
• If there are any questions, please contact your
  Regional Accountability Coordinator

23
Getting Started in eSIS
24
Getting Started with eSIS

• eSIS is a web-based application.
• Use Internet Explorer.
• Disable pop-up blockers.
• J initiator must be installed.

25
Logging In
Typically FirstName_LastName
Donald_Duck
Password provided
LEA999
LEA plus LEA number
Do not share logins!
26
Logging In - Path
LEA test and training environment
Navigation esis-xut.ncwise.org
Production environment
Navigation esis.ncwise.org
26
27
Logging In

• Do not log in more than once!

28
Logging In - Steps

• From the Login dialog box
• Type the user name in the Username field.
• Type the password in the Password field.
• Click Connect.
• The eSIS Start screen opens.

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

30
eSIS START Screen
31
eSIS Hot Keys

• Query Hot Keys
• F7 Enter
• - wildcard
• F8 Execute
• Shift F2 record count

32
Counting Records - Steps

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

33
Exercise

• Determine how many 7th grade females a Middle
  School has.

34
Selecting a School

• LEA Testing Coordinators can view multiple
  schools data or one school at a time.

35
Locking a School - Steps

• From the eSIS Start screen, click the Select
  School icon.
• Highlight the appropriate school.
• Check Lock School.
• Click Ok.

36
Exercise

• Using the Lock School feature, select a Middle
  School.

37
Test Data in eSIS
38
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

39
Exporting Precode and Member Files
40
Standardized Testing Export - Path
Navigation Administration gt Standard
Tests/Assessment gt Export Students
41
Standardized Testing Export
42
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.

43
Exporting a Precode File - Steps

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

44
Exercise

• Create a Precode file.

45
Adding a Test
46
Student Standardized Testing - Path
Navigation Main Menu gt Change Student gt
Standardized Testing gt Student Test Scoring
47
Student Standardized Testing
48
Student Standardized Testing
49
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.

50
Adding a Test - Steps

• 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.
• From the Test field, click the question mark (?).
• A menu of all possible tests appears.
• From the Select Test menu, click the appropriate
  Test Name.

51
Adding a Test Steps

• Click Ok.
• Verify the Test name in the Add Test window,
  click Ok.
• The test has now been added to the student
  record.
• Type the students scores in the Values fields of
  the Test Scores tab.

52
Adding a Test Steps

• 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 drop-down
  list, click the appropriate accommodation if
  applicable.

53
Exercise

• Add an EOG Math test score to an 8th grade male
  student.

54
High School Exit Standards
55
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

56
Things to Remember

• The Assessment Date for the exemption must be
  recorded as xx/25/20xx.

57
Exemption Codes

• P Review committee/principal gave credit
• Q Transfer/Principal gives exit credit
• V Not required to meet exit standard

58
Recording Exemptions - Steps

• From the Tests section, click the ADD. The Add
  Test screen opens with current school, grade and
  date information populated. Update the default
  information as necessary.
• Type xx/25/20XX in the Assessment Date field.
• This date must be used for recording Exemptions
  no matter when the actual exemption was decided
  upon.

59
Recording Exemptions Steps

• Click the ? to the right of the Test field.
• From the list, click or use the Find field to
  select the appropriate test. Click OK.
• Click OK in the Add Test window.

60
Recording Exemptions Steps

• On the Test Scores tab, type N, beside the Met
  Exit Standard column.
• Click the SubTest Detail tab.
• Click the appropriate exemption code from the
  Exemption drop-down list.
• Click Save.

61
US History First Attempt
62
US History Retest 1
63
US History Retest 2
64
US History Committee Review
65
US History Committee Review
66
Exercise

• Add an English 1 test exemption to a 10th grade
  student.

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

68
High SchoolGraduation Project
69
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

70
What Appears on the Transcript?

• The original test with the score values.
• The additional test with the exemption reason.

71
Running the Student Standard Test Summary Report
72
Student Standard Test Summary Report - Path
Navigation Reports Icon gt Standardized Testing
gt Student Standard Test Summary
73
Reports Tree
74
Demographic Extract
75
Student Standard Test Summary
76
Student Standard Test Summary
77
Student Standard Test Summary
78
Running the Standard Test report - Steps

• Double click the Student Standard Test Summary
  report.
• From the extract dialog box, click Specify
  Extract Criteria.
• Click Clear Extract Criteria.
• From the Grades drop-down list, click the
  appropriate grade level(s).
• Define additional fields of criteria as needed.

79
Running the Standard Test report Steps

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

80
Running the Standard Test report Steps

• 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.
• Click the appropriate Test Name.
• Note Use the Find field to query for the test
  or scroll through the list.
• The Test Number will auto populate.
• Click the Printer icon.
• The report will display in .pdf format.

81
Exercise

• Run the Student Standard Test Summary report for
  8th grade students.

82
Getting Started in WebApps
83
What is WebApps?

• The WebApps site is used to perform multiple
  activities
• State Reporting (UERS)
• User Security
• Building ACC Test and Data Files

84
Accessing WebApps / UERS
85
Logging In
Use the same login and password as is used for
eSIS.
https//webapps.ncwise.org
86
Logging In - Steps

• From the Log In section
• Type the user name in the Username field.
• Type the password in the Password field.
• Click Go.
• WebApps opens to the Profile tab.

87
Exercise

• Log into WebApps using the
• XUT environment URL provided.
• Use same user ID, password, and database as you
  would with Production.

88
Test Data in WebApps
89
Objectives

• View the Profile tab
• View the Message Center
• Download ACCData an ACCTests files

90
Viewing the Profile Tab
91
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.

92
User List Tile
Message Center Tile
Profile Tile
93
Downloading files from UERS Adhoc Reports Tab
94
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.

95
ACC Data and Test Files
96
Building ACC Data Files - Steps

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

97
Building ACC Data Files Steps

• Verify the date.
• Note If the date is not correct, click Edit.
  Type the correct date.
• Click Run ACCData.
• A message appears asking the user to be patient.

98
Building ACC Data Files Steps

• Click Refresh to verify the file creation is
  complete.
• Click Download.
• Click Save.
• Save the file to the folder as directed by your
  RAC.

99
Building ACC Test Files - Steps

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

100
Building ACC Test Files - Steps

• Verify the date.
• Note If the date is not correct, click Edit.
  Type the correct date.
• Click Run ACCTest.
• A message appears asking the user to be patient.

101
Exercise

• Build an Acc Test File.

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

103
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

104
Questions
105
More Information
106
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

107
NC WISE Reference Documents
http//www.ncwise.org/eSIScategories.html

• eSIS User Roles
• NC WISE Security and Administration Guide
• Standardized Testing and Exit Standards

108
Training Support Contacts

• NC WISE Training Team Mailbox
  ncwisetraining_at_dpi.state.nc.us
• NC WISE Service Deskhelp_at_dpi.state.nc.us
• 919.807.4357

109
www.ncwise.org