1 calpads uat end of year (eoy) checkpoint meeting may 16, 2012

1

CALPADS UAT End of Year (EOY)Checkpoint Meeting

May 16, 2012

22

Introductions and Ground Rules

Introductions– CDE / CSIS Participants– IBM Participants

Ground Rules– Mute phones while listening (*6 to mute and un-

mute)– Do not place your phone on HOLD– Silence cell phones– Introduce yourself (name and LEA) when

speaking– One conversation at a time

3

Agenda

Introductions / Ground Rules EOY UAT Schedule Update EOY UAT Status Update EOY UAT Release Update EOY UAT Issue Update EOY UAT Reminders EOY UAT Service Desk Recap Walk On / Q & A / Online Poll Next Steps

3

4

EOY UAT Schedule Update

Test Week 4 EOY 1 Course Completion and EOY 3 Student Discipline CALPADS Pre-production environment will be available daily from 6:00

am to 8:00 pm. An updated EOY UAT Known Issues and UAT Release Update were

posted to the UAT FTP site on Wednesday 5/16/12

Recommended Testing Schedule for EOY UAT

4/16-4/20 4/23- 427 4/30-5/4 5/7-5/11 5/14-5/18EOY UAT Modules/Functions TW1 TW2 TW3 TW4 TW5EOY 2 Program ParticipationEOY 4 Student WaiversEOY 3 DisciplineEOY 1 Course CompletionWrap Up

Legend Testing

Testing continues if needed

5

EOY UAT Status Update

Test Week 5– Wrap Up of UAT testing– Continue testing EOY 1-4 as needed

SCTE Testing Update– Following SCTE modules will be available on 5/17

Security Roles Batch Online Input Validation Rules (IVRs) Extracts (ODS and Rejected Records) Submission Error Report

6

EOY UAT Status Update

SCTE Testing Update, continued– Following modules will be available early next week

ODS Reports Snapshot Reports Certification Errors (CVRs) EOY 1 Snapshot included CTE data

7

EOY 1 UAT Status Update

17 out of 41 (43%) LEAs sent in at least one Execution Log for EOY 1 Approximately 1/3 have tested the Online and Batch submission for

Course Completion

8


9


40 out of 41 (98%) LEAs sent in at least one Execution Log for EOY 2

Approximately 80% have tested the Online and Batch functions Approximately 60% have tested Certification and Reports

10


11


27 out of 41 (68%) LEAs sent in at least one Execution Log last week

Approximately 50% have tested the Security, Online and Batch functions

Approximately 1/3 have tested Certification and reports

12


13


23 out of 41 (58%) LEAs sent in at least one Execution Log for EOY 4

Approximately 40% have tested the Online and Batch functions Approximately 1/3 have tested Certification and Report Functions

14


15

EOY Release Update

5/16 Release Update document is currently available on the FTP site

Problem # IssueDate Resolved

2456EOY: 1.0a - Expected Schools Information Report School dropdown menu contains Adult Education Schools as a selectable option

5/16/12

2452EOY2: Report 5.5 Homeless Student List - Column sorting functionality does not work (both ODS and Snapshot versions)

5/16/12

2451EOY: Timeout and slowness issues reported in Preproduction

5/16/12

2444EOY: CALPADS Home page - Anomaly Status and CALAPDS Notifications sections overlap

5/16/12

16

EOY Release Update

5/16 Release Update, continued


2440EOY3 Reports Snapshots 7.3 and 7.4 appear to be counting student twice due to 2 enrollment records

5/16/12

2438EOY3: Discipline batch file upload - IVR GERR0001 does not trigger on required field 4.18

5/16/12

2432Another LEA District can delete my delete/modify Waiver records at my district

5/16/12

2429EOY1: Report 1.0a - EOY1 - Course Comp col should be "N" for Schools where highest grade level is grade 6

5/16/12

17

EOY Release Update

5/16 Release Update, continued


2428 EOY1: Post failed, no Explanation given 5/16/12

2416EOY3: SDIS0094 error total does not match actual rejected records count

5/16/12

2407 EOY2: Report 5.1 links to 5.3 broken 5/16/12

2400EOY1: SCSC0128 triggers when grade level is valid for the course code

5/16/12

18

EOY UAT Issue Update

Known Issues list is currently available on the FTP site 5/16 UAT Known Issues Highlights:

Problem # Issue

2465EOY1: ODS Course Completion ODS extract file includes records from other LEAs when staff has multiple demo records

2464EOY1: Report 3.11 - Duplicate student rows display for students with more than 1 enrollment for the reporting year

2463EOY1: ODS reports 3.9 and 3.10 incorrectly showing totals for a school when no data has been submitted

2462EOY3: Report 7.4- Disciplinary Actions - Count by Offense is calculating the # of Offenses & Disciplinary Action Taken incorrectly

2461EOY3: Report 7.6 Persistently Dangerous Offense Expulsions - Report does not include schools that do not have reported discipline incidents

19


5/16 UAT Known Issues Highlights, continued:

Problem # Issue

2460EOY1: Student Course Section Completion ODS Extract Download has duplicate records

2459 EOY4: Invalid CERT072 warning

2458 EOY1: Missing field detail on CERT098 error records

2457 EOY4: Student Waiver ODS extract times out on download

2455EOY1: Invalid CERT099 errors for students enrolled in End of Year course sections

2453EOY4: ODS Report 6.1 - Includes counts for NPS school students not submitted or found on the 6.2

2448EOY2: Snapshot 5.3 report slow to render, or request results in error message displayed

20



Problem # Issue

2446EOY3: 7.3 report - column lines are malformed (both ODS & Snapshot)

2445EOY3: 7.4 - Disciplinary Actions - Count by Offense - Lines on the PDF are malformed

2443EOY4: Report 6.1, 6.2 and 6.3 (both ODS & Snapshot) show only schools with waivers reported

2441EOY3: Report 7.2 Snapshot & ODS listing students for each enrollment in the reporting year.

2439 EOY3: ODS 7.5 - Discipline Offenses - Student List is duplicated

2435 EOY3 - Report 7.3 Calculating # of Suspensions incorrectly

2427EOY2: Report 5.4 does not display schools on the Expected Schools list that do not have homeless students

21



Problem # Issue

2420EOY4: 6.3 CAHSEE Waivers and Exemptions report - duplicate student waivers displayed

2418 Extract Files Names are not saved correctly.

2414EOY3: SSID not enrolled on incident date, but SDIS0245 does not trigger unless the Incident Disciplinary Action Duration Days field is also populated

2410EOY3: SDIS roles do not allow access to the Manage Submissions menu selection

2399 EOY UAT - Aggregate reports don't render automatically

22

EOY UAT Reminders

LEAs should report their progress to the CDE using the UAT Test Scenario Execution Log and emailing the updated log once a week on Friday to the CALPADS UAT Service Desk account

– [email protected]

Please include the following in the title of the email:– “Execution Log 2011MMDD for XXXX ”– Where MM is and month submitted and DD is the day

submitted and XXXX the name of your LEA– This Fridays Execution Log submittal should be titled as

follows: “Execution Log 20110309 for Palo Alto Unified”

2323

Walk On / Q and A / Online Poll

24

Next Steps

Complete execution (and retesting as needed) of the UAT Test Scenarios listed in the document located on the FTP site

Continue to review the updated Known Issues and Release Notes posted on the FTP site

Continue to report any issues or problems to the UAT Service Desk

Continue to submit Execution Log via CALPADS UAT Service Desk once a week (Fri by COB)

25

UAT Communications

CALPADS UAT Email for defect reporting, issues, and questions

– [email protected] UAT Weekly Check Point Meetings

– WebEx URL: http://csis.webex.com– WebEx Phone: 888-426-6840 – Participant Code: 4603184

UAT Service Desk– Phone: 916-445-4795 – voicemail only

UAT Documents posted at– ftp://ftp.cde.ca.gov/calpads-uat/

25

26

EOY UAT Service Desk Recap

Reporting Problems to the Service Desk LEA UAT participants should report all problems (potential defects, issues) as they are

identified by emailing the UAT email account:– [email protected]

NOTE: DO NOT report UAT problems through the CALPADS webform When reporting a PROBLEM include the following in your email:

– Subject– Your name– Phone number– Bread crumb– Describe what you were doing, what you expected from the system, and what happened

Requesting Help from the Service Desk LEA UAT participants should request Help by emailing the UAT email account:

– [email protected]

When requesting HELP include the following in your email:– Subject (include the word “help”)– Your name– Phone number– CALPADS UAT user ID– Job # (if applicable)– Description of what you need help with26