User Tools

Site Tools


benchmark:mass_load

This is an old revision of the document!


Preparing for Mass Loading of Student Data for Benchmark Testing

In order to get student data loaded for each nine-weeks benchmark test, the data that is needed to be sent must be in a format that the software that loads the data can read. The software needs two pieces of information: the section ID and the test ID that we want that course to use. The section ID will need to be obtained from SASIxp and the test ID will be listed further on down in these instructions.

To get the data in the proper format, follow the instructions as follows:

  1. Open Excel
  2. In row 1, column A, place the section ID (e.g. 1150-01)
  3. In row 1, column B, place the test ID (e.g. 23)
  4. In row 2, column A, place the next section ID (e.g. 3130-01)
  5. In row 2, column B, place the next test ID (e.g. 65)
  6. Continue with each section that needs to take a test on the immediately following line.
  7. Put nothing else into the file including, but not limited to, school name or labels for the above data
  8. When finished, save the file and send it to cedwards@wcs.k12.va.us. In the email, identify the school from which the data came.

Remember that some classes will need to take two tests like English 11. Each section that needs two tests will need a separate line and test like so:

A B
1150-01 23
1150-01 13

Testing IDs for the First Nine Weeks

Third Grade Test ID Fourth Grade Test ID Fifth Grade Test ID
English 12 English 50 English 7
Math 113 Math 49 Math 42
Science 79 Science 16 Science 18
Social Studies 19 Social Studies 58 Social Studies 40
Sixth Grade Test ID Seventh Grade Test ID Eighth Grade Test ID
US History 2 Civics 45 Reading 25
Writing 82
Math 4
Science 48
World Geography 41
Course Test ID
World History I 14
World History II 61
US History 76
Chemistry 72
Biology 3
Earth Science 22
Geometry 24
Algebra I 65
Algebra II 43
English 11 Writting 23
English 11 Reading 13
benchmark/mass_load.1158858197.txt.gz · Last modified: 2006/09/21 13:03 (external edit)