Penn%20Data%202001%20-%20Completion

1
Penn Data 2001 - Completion

• Revised Student Database
• Tables 1-7
• Sign Off Procedure
• Preschool Report Aggregate

2
Revised Student Database

• Two ways to submit data
• Export file of Revised Student Database
• Excel file received from PSU

3
Export file of Revised Student Database

• Update static file sent December 1, 2001
• Update exiting Items (fields 18 19)
• Add Students that should have been included on
  the December 1, 2001 file.

4
Excel File Received from PSU

• Update Exiting information (Items 18 19)
• All other data cells will be locked
• Add Students that should have been included on
  the December 1, 2001 file at the bottom of the
  file.

5
Tables 1-7

• Tables 4 and 5 have changed from last year
• Due Date July 12, 2002
• Naming Convention Table_IU_Date.txt
• equals which table sending (1-7)
• equals IU number
• Date equals Month Year (example July2002)

6
Sign Off Procedure

• Revised Student Database
• Verify 1
• Age by Disability
• By IU and School District
• Verify 2
• Disability by School District
• Tables 1-7
• Each Table will be sent to the IU for
  Verification
• At the request of an IU, PSU will send a
  verification file that includes Student ID,
  Last Name, First Name, Birth Date, and Disability

7
Things to Remember

• Due Date July 12, 2002
• Naming Convention Student_IU_Date.txt
• equals IU number
• Date equals Month Year (example Dec2002)
• How many students are you adding?
• The files should be zipped into one file
• Naming convention - IU_Date.zip
• equals IU number
• Date equals the date the file was sent (example
  July122002)
• Do not update any data items except Items 18 19
• IU is responsible for the accuracy of their data

8
Preschool Report

• Aggregate Count July 1, 2001 June 30, 2002
• Due Date July 5, 2002
• Naming Convention Preschool_IU_Date.txt
• equals IU number
• Date equals Month Year (example Dec2002)

9
Penn Data 2002

• Timeline
• Export Specifications
• Student Database
• Edit Checks
• Tables 1-7
• Preschool
• Web Site

10
Timeline

• Export File of Student Database
• Dec 1 - January 6, 2003
• Revised - July 11, 2003
• Tables 1-7
• July 11, 2003
• Preschool (monthly reports)
• 5th of each month for the time period July 1,
  2002 through the last day of the previous month

11
Export Specifications

• General format of data files
• Standard ASCII comma-separated variable (csv)
  file
• 30 data fields for each record (29 commas)
• No blank rows
• Each line should be terminated by a carriage
  return/line feed combination (No extra spaces)
• Naming Convention Student_IU_Date.txt
• equals IU number
• Date equals Month Year (example Dec2002)

12
Export Specifications

• Reminders
• December 1 count includes those students who have
  a current IEP and are receiving services as of
  December 1 includes children ages 3-21
• Revised December 1 count
• Records of students who should have been counted
  on December 1 and were missed
• Students reported on December 1 and have exited
  special education

13
Edit Checks

• No quotes
• No parenthesis
• Middle Initial is only one character (no periods)
• Nicknames are not allowed in first name field
• Format date fields as mmddyyyy - 02011990

14
Edit Checks - Continued

• Include leading zeroes
• If child is in EI then data items 27-30 must be
  complete
• If disability is gifted then type of service must
  be gifted
• If student is 16 or older they must have
  Transition unless gifted

15
Edit Checks - Continued

• If the student is in grades 5, 8, or 11 they must
  participate in PSSA/PASA
• Fields that can be blank for gifted students
• Participation in PSSA/PASA Item 9
• Services Plan Item 16
• Transition Item 17
• Location of Intervention Item 20

16
Tables 1-7

• Table 1
• 2 rows of data with each row containing 1 data
  values
• Table 2
• 4 rows of data with each row containing 2 data
  values
• Table 3
• 19 rows of data with each row containing 2 data
  values
• Table 4
• 13 rows of data with each row containing 7 data
  values

17
Tables 1-7 - Continued

• Table 5
• 5 rows of data with each row containing 7 data
  values
• Table 6
• 8 rows of data with each row containing 108 data
  values
• Table 7
• 8 rows of data with each row containing 5 data
  values

18
Preschool

• Preschool Database Monthly Report
• Due the 5th of each month for the time period
  July 1, 2002 through the last day of the previous
  month
• Every record should include items 26-30
• Naming Convention - Preschool_IU.txt
• equals IU number

19
File(s) Submission

• Send files to
• Email
• bsedata_at_psu.edu
• Floppy Disk
• PennData
• Pennsylvania State Data Center
• Penn State Harrisburg
• 777 West Harrisburg Pike
• Middletown, PA 17057

20
(No Transcript)