[Sitedocs]

sitedocs/os98

Oregon Standards database (1998) documentation.

Performance task entry and relationships as of July 14, 1998. This application is still in beta test (14 July 1998). The flow chart and documentation will be updated accordingly.

27 Nov 2000 update:  Eugene School District 4J uses the os98 performance task database <http://www.open.k12.or.us/os98/4jperform> for its Performance Assessment - Can Do! sample tasks. Academic content standards in the os98 database are no longer being updated. For current academic content standards, see os2000.

[v]Flow Charts of application use
[v]Implementation Details
[v]See Also
[v]Footnotes

Flow Chart Details

os98 Search Wizard

wizard.ncgi - 41KB


Performance Task Database - Part 1 of 3

Part 1of 3 - 80KB


Performance Task Database - Part 2 of 3

Part 2 of 3 - 104KB


Performance Task Database - Part 3 of 3

Part 3 of 3 - 98KB


Top of page[^]


Implementation Details

os98 serves as the container for the standards set by the ODE. The data given to OPEN by the ODE is in PageMaker 6.5 format. The PageMaker file must then be copied into an Excel spreadsheet designed to be inserted into os98 database.

Creating the proper Excel spreadsheet format:

These spreadsheets are the master files for the os98 database. The scoring guides have been separated from the standards for the sake of expediency.

Some critical notes about working with these files:

  • Name of the spreadsheet corresponds to the database into which the data is placed using tab2sql at the command line. This is EXCLUSIVE of the parenthetical portions of the title.
  • The name of the worksheet corresponds to the name of the table within the database.
  • The name in the data header (cell 1 above any particular column) corresponds to the field.
  • Fields in the Excel spreadsheet cannot contain returns. Use <BR> instead (don't use <P> it is rendered differently on browsers).

To make updates:

Make changes in the Excel format. Then, AND THIS IS CRITICAL, save each sheet as a Tab-Delimited file (.txt) You can save only one sheet at a time. DO NOT make changes after you have saved as .txt. You will be prompted when you close the document to save in .xls format. DO NOT DO THIS. Many fields will be truncated.

Uhm, let me say this clearly:

  1. Make all changes in the Excel spreadsheet.
  2. Save the changes to the Excel spreadsheet.
  3. Save each worksheet as .txt, calling it the name of the sheet. (make no changes)
  4. Close the document and DO NOT save as Excel.
  5. Upload the updated spreadsheet and .txt files to /home/www/beta/os98/sourcedata
  6. Run tab2sql from the command line.

Tab2sql looks like:

tab2sql [filename.txt] [database] [table]
tab2sql score.txt os98 score
tab2sql benchmarks.txt os98 benchmarks
etc.

Once the tab2sql process is done the "prebuild" scripts must be run. These scripts join the data from the general traits, special traits, benchmarks, content standards, and common curriculum goals into two tables. The scripts are found in /home/www/beta/os98 and are called prebuild.ncgi and scorebuild.ncgi. They are executed simply by typing ./scorebuild.ncgi and ./prebuild.ncgi from the command line.

Fields created from scripts are as follows:

Table = prebuild
+-----------------+----------------+--------+
|      Field      |      Type      | Length |
+-----------------+----------------+--------+
| subject         | varchar()      |     0  |
| strand          | varchar()      |     0  |
| id              | int4           |     4  |
| cstext          | varchar()      |     0  |
| cgtext          | varchar()      |     0  |
| bm13            | varchar()      |     0  |
| bm12            | varchar()      |     0  |
| bm10            | varchar()      |     0  |
| bm8             | varchar()      |     0  |
| bm5             | varchar()      |     0  |
| bm3             | varchar()      |     0  |
| pass            | varchar()      |     0  |
| ode             | varchar()      |     0  |
| strandsort      | int4           |     4  |
| subjectsort     | int4           |     4  |
+-----------------+----------------+--------+

Table = scorebuild
+-----------------+----------------+--------+
|      Field      |      Type      | Length |
+-----------------+----------------+--------+
| subject         | varchar()      |     0  |
| strand          | varchar()      |     0  |
| trait           | varchar()      |     0  |
| descript        | varchar()      |     0  |
| geneid          | int4           |     4  |
| specid          | int4           |     4  |
| description     | varchar()      |     0  |
| label           | varchar()      |     0  |
| score           | varchar()      |     0  |
| strandid        | int4           |     4  |
+-----------------+----------------+--------+

After running the "prebuild" scripts you will be able to access the data from the os98 search wizard found at http://beta.open.k12.or.us/os98/wizard.ncgi

Top of page[^]


See Also


Top of page[^]


Footnotes


Top of page[^]