Docstoc

data-entry-template

Document Sample
data-entry-template Powered By Docstoc
					2009 California State Physical Fitness
Included in this workbook are 2 worksheets for you to enter your physical fitness testing data for submission to the state. Field names have been pre-entered in each worksheet in row 1. Please do not change or move them. Following are instructions and descriptions of the fields in each of the worksheets.

School Record
Please enter one row for each grade 5, 7, and/or 9 for each school with grade 5, 7, and/or 9 in your district. Column A B Field Name C_CODE D_CODE ChrtNum Description The 2-digit county code from the school CDS code. The 5-digit school district code from the school CDS code. If the school is an independent charter school and you want the school's data to be reported separate from the district, enter the 4-digit charter school number. Otherwise enter 0000. The 7-digit school code from the school CDS code. District name. School name. The grade, 5, 7, or 9. The total number of students enrolled in the grade at the time of testing. (Total should equal sum of TotalTested and TotalNotTested). The total number of students in the grade tested. The total number of students in the grade not tested. The total number of students in the grade not tested due to absence. The total number of students in the grade not tested due to an Individual Education Plan (IEP). Section 504 Plan, or Disabilities. The total number of students in the grade not tested due to extraordinary circumstances. The total number of students in the grade not tested due to medical excuse. The sum of students in the grade not tested due to one of the preceding listed reasons (i.e., add absent [K], IEP [L], circumstance [M], medical [N]).

C D E F G H I J K L

S_CODE DISTRICT SCHOOL Grade TotalStudents TotalTested TotalNotTested absent IEP circumstance

M N O

medical TotalReasons

Student Record
Please enter one row for each student fully or partially tested or not tested. If a student did not test in all 6 categories, be sure to enter the reason code to indicate why the student was partially tested. If a student did not test in all the 6 categories, be sure to fill in the reason for missing data. Leave the cells blank for the results of tests that the student did not attempt. Column A B Field name C_CODE D_CODE ChrtNum Description The 2-digit county code from the school CDS code. The 5-digit school district code from the school CDS code. If the school is an independent charter school and you want the school's data to be reported separate from the district, enter the 4-digit charter school number. Otherwise enter 0000. The 7-digit school code from the school CDS code. District name. School name. The student's last name. Only the first 12 characters will be used. The student's first name. Only the first 8 characters will be used. The student's middle initial. The student's CDE assigned SSID. Only the first 10 characters will be used. The grade, 5, 7, or 9. The student's date of birth, 2 digits for month, 2 for day, 4 for year. The student's gender, M or F. The student's 3-digit ethnicity code, as follows. 100 - American Indian or Alaskan Native 201 - Chinese

C D E F G H I J K L M N

S_CODE DISTRICT SCHOOL Lastname (12) Firstname (8) mid. Init. (1) Student ID (10) Grade DOB(MMDDYYYY) Gender Ethnicity

IncompleteData O

P

PACER MileRunMin

202 - Japanese 203 - Korean 204 - Vietnamese 205 - Asian Indian 206 - Laotian 207 - Cambodian 299 - Other Asian 301 - Native Hawaiian 302 - Guamanian 303 - Samoan 304 - Tahitian 399 - Other Pacific Islander 400 - Filipino 500 - Hispanic or Latino 600 - African American or Black ( not of Hispanic origin ) 700 - White ( not of Hispanic origin ) 999 - Declined to state If a student did not test in all 6 categories enter one of the following reason codes. Otherwise, leave this cell empty. 20 - Absent on test date and all make-up sessions for one or more sessions 23 - IEP/Section 504 Plan/Disabilities 24 - Extraordinary circumstances 25 - Medical Excuse If a student did not test in all the 6 categories enter one of the following reason codes. Otherwise, leave this cell empty. 10 - Absent on test date and all make-up sessions for one or more sessions 13 - IEP/Section 504 Plan/Disabilities 14 - Extraordinary circumstances 15 - Medical Excuse Enter the number of laps. Enter the minutes portion of the time to complete the mile run, recorded in minutes and seconds. Note: Values of 59 or 99 indicate student did not complete the test. Enter the seconds portion of the time to complete the mile run, recorded in minutes and seconds. Valid values are 0 - 59. Enter the minutes portion of the time to complete the walk test, recorded in minutes and seconds. Note: Values of 59 or 99 indicate student did not complete the test. Enter the seconds portion of the time to complete the walk test, recorded in minutes and seconds. Valid values are 0 - 59. Enter 15-second heart rate (i.e. number of heart beats in 15-seconds)at the conclusion of the one-mile walk. Valid values are 0 - 45. Enter the student's weight in pounds at the time of the walk test. Enter the median triceps skinfold measurement in millimeters. Valid values are 0 - 40. Enter the median calf skinfold measurement in millimeters. Valid values are 0 - 40. Enter the feet portion of the student's height recorded in feet and inches. Enter the inches portion of the student's height recorded in feet and inches. Valid values are 0 - 11. Enter the student's weight in pounds at the time the height is recorded. Enter the percent body fat measured by bioelectric impedance or other automated device. Valid values are 00.0 - 99.9. Enter the number of curl-ups completed. Valid values are 0 - 75. Enter the number of inches measured. Valid values are 0 - 12. Enter the number of 90-degree push-ups completed. Valid values are 0 - 50. Enter the number of modified pull-ups completed. Valid values are 0 - 50. Enter the number of seconds measured. Valid values are 0 - 30. Enter the number of inches measured for the left side. Valid values are 0 - 12.

Q MileRunSec R MileWalkMin S MileWalkSec T Heart U V W X Y Z AA AB AC AD AE AF AG AH Weight FatTricep FatCalf HeightFT HeightIN IndexWeight Bioelectric CurlUps TrunkLift PushUps ModPullUps ArmHang SitReachLeft

SitReachRight AI AJ AK AL StretchL StretchR Test Date Enter the number of inches measured for the right side. Valid values are 0 - 12. Enter 1 if the student passed or 2 if the student failed the test for the left side. Enter 1 if the student passed or 2 if the student failed the test for the right side. First day that student tested(MMDDYYYY).

School_Record

C_CODE

D_CODE

ChrtNum

S_CODE

DISTRICT SCHOOL Grade

TotalStudents TotalTested

TotalNotTested

absent IEP

circumstance

medical TotalReasons

Page 4

Student_Record

C_CODE

D_CODE

ChrtNum

S_CODE

DISTRICT SCHOOL Lastname (12) Firstname (8) mid. Init. (1) Student ID (10) Grade DOB(MMDDYYYY)

Gender

Ethnicity

IncompleteData PACER

MileRunMinMileRunSec MileW alkMin

Page 5

Student_Record

MileW alkSec Heart

W eight

FatTricep FatCalf

HeightFT

HeightIN

IndexW eight Bioelectric CurlUps

TrunkLift

PushUps

ModPullUps Arm Hang SitReachLeft SitReachRight StretchL

StretchR

Test Date(MMDDYYYY)

Page 6


				
DOCUMENT INFO
Shared By:
Tags: data-, entry
Stats:
views:399
posted:11/28/2009
language:English
pages:6
Description: data-entry-template