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 must be in a format that the software that loads the it 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

Third Grade 1st 9 2nd 9 3rd 9
English 12 28 29
Math 113 30 31
Science 79 32 33
Social Studies 19 89 92
Fourth Grade 1st 9 2nd 9 3rd 9
English 50 87 88
Math 49 100 91
Science 16 68 69
Social Studies 58 59 60
Fifth Grade 1st 9 2nd 9 3rd 9
English 7 77 78
Math 42 101 103
Science 18 46 47
Social Studies 40 52 57
Sixth Grade 1st 9 2nd 9 3rd 9
English TBA TBA TBA
Math TBA TBA TBA
US History 2 74 75
Seventh Grade 1st 9 2nd 9 3rd 9
Civics 45 95 96
English TBA TBA TBA
Math TBA TBA TBA
Eighth Grade 1st 9 2nd 9 3rd 9
Math 4 85 86
Science 48 110 112
Reading 25 80 81
Writing 82 83 84
Course 1st 9 2nd 9 3rd 9
Algebra I 65 66 67
Algebra II 43 54 55
Biology 3 94 99
Chemistry 72 73 71
Earth Science 22 90 93
English 11 Writting 23 102
English 11 Reading 13 21 39
Geometry 24 36 38
US History 76 108 111
World Geography 41 97 98
World History I 14 104 105
World History II 61 106 107
benchmark/mass_load.1158950788.txt.gz · Last modified: 2006/09/22 14:46 (external edit)