User Tools

Site Tools


benchmark:mass_load

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
benchmark:mass_load [2006/09/21 10:02]
cedwards created
benchmark:mass_load [2016/05/16 10:40]
jlester removed
Line 1: Line 1:
 ====== Preparing for Mass Loading of Student Data for Benchmark Testing ====== ====== 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.+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 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. 
 + 
 +===== Frequently Asked Questions ===== 
 +**Q:** **If I am loading data for the High Schools, should I include courses at the Technical School?**\\ 
 +**A:** No, the Technical School provides the data for their students from each of the High Schools. 
 + 
 + 
 +====== Getting a List of Section IDs ====== 
 + 
 +To get the list of Section IDs for each course from SASIxp, follow these steps: 
 +  - Open SASIxp and log in. 
 +  - Double-click the **SASI Modules** globe in the upper right hand corner of the screen. 
 +  - Double-click the **Basic Scheduling** folder. 
 +  - Double-click the **Sections** Atom. 
 +  - Click the **Sections** menu at the top of the screen. 
 +  - Click **Sections List (MST02)** 
 +  - On the drop-down box labeled **MASTER SCHEDULE LISTING**, select **MST04: by Crs ID, Period, Tch ID** 
 +  - Click **Print** 
 + 
 +You will only need the sections for the tests that correspond to your grades. 
 + 
 +====== Preparing the Data for the Testing System ======
  
 To get the data in the proper format, follow the instructions as follows: To get the data in the proper format, follow the instructions as follows:
   - Open Excel   - Open Excel
-  - In row 1, column A, place the section ID (e.g. *1150-01*) +  - In row 1, column A, place the section ID (e.g. **1150-01**) 
-  - In row 1, column B, place the test ID (e.g. *23*) +  - In row 1, column B, place the test ID (e.g. **23**) 
-  - In row 2, column A, place the next section ID (e.g. *3130-01*) +  - In row 2, column A, place the next section ID (e.g. **3130-01**) 
-  - In row 2, column B, place the next test ID (e.g. *65*) +  - In row 2, column B, place the next test ID (e.g. **65**) 
-  - Continue with each section that needs to take a test on the following line.  +  - Continue with each section that needs to take a test on the immediately following line
-  - When finished, save the file and send it to cedwards@wcs.k12.va.us+  - **Put nothing else into the file including, but not limited to, school name or labels for the above data**
 +  - 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: 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:
Line 17: Line 39:
 |1150-01 | 13 | |1150-01 | 13 |
  
-====== Testing IDs for the First Nine Weeks ====== +====== Testing IDs ====== 
-^ Third Grade ^ Test ID          ^ Fourth Grade ^Test ID ^        ^Fifth Grade ^Test ID +^ Third Grade    1st 9 2nd 9 3rd 9 
-| English        | 12   English        50  | English        | 7  +| English        | 12    28    29    | 
-| Math           113  Math           49  | Math           | 42 | +| Math           | 113   | 30    | 31    | 
-| Science        | 79   Science        16 |  | Science        18 +| Science        79    32    | 33    | 
-Social Studies 19  Social Studies 58 |  | Social Studies 40 |+| 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    | 2705    | 937   | 1756   | 
 +| Math       | 2701    | 2702  2706   | 
 +| US History | 2       | 74    | 75     | 
 + 
 +^ Seventh Grade ^ 1st 9 ^ 2nd 9 ^ 3rd 9 ^ 
 +| Civics        45    | 95    | 96    
 +English       2699  936   | 1757  | 
 +Math          2698  2700  2704  |
  
-^Sixth Grade ^Test ID   ^Seventh Grade ^Test ID ^   ^Eighth Grade ^Test ID +Eighth Grade    1st 9 2nd 9 3rd 9 
-US History  Civics 45   | Reading         | 25 | +Math            4     85    86    | 
-|            |                | Writing         | 82 | +Science         | 48    110   112   | 
-              |        |      | Math            | 4  +Reading         | 25    80    81    
-              |        |      | Science         | 48 | +Writing         | 82    83    84    |
-|            |    |        |     |  World Geography 41 |+
  
-^Course               Test ID +^ Course              1st 9 ^ 2nd 9 ^ 3rd 9 
-World History     14      +Algebra           65    | 66    | 67    
-World History II    | 61      +Algebra II          | 43    54    | 55    
-US History          76      +Biology             3     | 94    | 99    
-| Chemistry           | 72      | +| Chemistry           | 72    73    71    
-Biology             | 3       +| Earth Science       | 22    | 90    | 93    | 
-| Earth Science       | 22      +| English 11 Writing | 23    | 102         | 
-| Geometry            | 24      +| English 11 Reading  | 13    | 21    | 39    
-Algebra I           65      +| Geometry            | 24    | 36    | 38    
-Algebra II          43      +US History          76    | 108   | 111   
-English 11 Writting 23      +World Geography     41    | 97    | 98    
-English 11 Reading  13      |+World History I     14    | 104   | 105   
 +World History II    61    | 106   | 107   |