This shows you the differences between two versions of the page.
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 | + | 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: |
+ | |||
+ | ===== 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 |
- | - 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 | + | | English |
- | | Math | + | | Math | 113 | 30 | 31 | |
- | | Science | + | | Science |
- | | Social Studies | + | | Social Studies | 19 | 89 | 92 | |
+ | |||
+ | ^ Fourth Grade ^ 1st 9 ^ 2nd 9 ^ 3rd 9 ^ | ||
+ | | English | ||
+ | | Math | ||
+ | | Science | ||
+ | | Social Studies | 58 | 59 | 60 | | ||
+ | |||
+ | ^ Fifth Grade ^ 1st 9 ^ 2nd 9 ^ 3rd 9 ^ | ||
+ | | English | ||
+ | | Math | 42 | 101 | 103 | | ||
+ | | Science | ||
+ | | Social Studies | 40 | 52 | 57 | | ||
+ | |||
+ | |||
+ | ^ Sixth Grade ^ 1st 9 ^ 2nd 9 ^ 3rd 9 ^ | ||
+ | | English | ||
+ | | Math | 2701 | 2702 | ||
+ | | US History | 2 | 74 | 75 | | ||
+ | |||
+ | ^ Seventh Grade ^ 1st 9 ^ 2nd 9 ^ 3rd 9 ^ | ||
+ | | Civics | ||
+ | | English | ||
+ | | Math | ||
- | ^Sixth Grade ^Test ID ^ | + | ^ Eighth |
- | | US History | + | | Math |
- | | | + | | Science |
- | | | + | | Reading |
- | | | + | | Writing |
- | | | | + | |
- | ^Course | + | ^ Course |
- | | World History | + | | Algebra |
- | | World History | + | | Algebra |
- | | US History | + | | Biology |
- | | Chemistry | + | | Chemistry |
- | | Biology | + | | Earth Science |
- | | Earth Science | + | | English 11 Writing | 23 | 102 |
- | | Geometry | + | | English 11 Reading |
- | | Algebra I | 65 | + | | Geometry |
- | | Algebra II | + | | US History |
- | | English 11 Writting | + | | World Geography |
- | | English 11 Reading | + | | World History I | 14 | 104 | 105 | |
+ | | World History II |