This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
benchmark:mass_load [2008/10/09 15:11] cedwards |
— (current) | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== 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 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: | ||
- | - Open Excel | ||
- | - 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 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**) | ||
- | - Continue with each section that needs to take a test on the immediately following line. | ||
- | - **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**. | ||
- | |||
- | 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 | ||
- | | Math | 113 | 30 | 31 | | ||
- | | Science | ||
- | | Social Studies | 19 | 89 | 92 | | ||
- | |||
- | ^ Fourth Grade ^ 1st 9 ^ 2nd 9 ^ 3rd 9 ^ | ||
- | | English | ||
- | | Math | 49 | 100 | 91 | | ||
- | | 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 | 2706 | | ||
- | | US History | 2 | 74 | 75 | | ||
- | |||
- | ^ Seventh Grade ^ 1st 9 ^ 2nd 9 ^ 3rd 9 ^ | ||
- | | Civics | ||
- | | English | ||
- | | Math | 2698 | 2700 | 2704 | | ||
- | |||
- | ^ Eighth Grade ^ 1st 9 ^ 2nd 9 ^ 3rd 9 ^ | ||
- | | Math | 4 | 85 | 86 | | ||
- | | Science | ||
- | | Reading | ||
- | | Writing | ||
- | |||
- | ^ Course | ||
- | | Algebra I | 65 | 66 | 67 | | ||
- | | Algebra II | 43 | 54 | 55 | | ||
- | | Biology | ||
- | | Chemistry | ||
- | | Earth Science | ||
- | | English 11 Writting | 23 | 102 | ||
- | | English 11 Reading | ||
- | | Geometry | ||
- | | US History | ||
- | | World Geography | ||
- | | World History I | 14 | 104 | 105 | | ||
- | | World History II | 61 | 106 | 107 | |