[Sitedocs]

sitedocs/os2000

Oregon Standards database (2000) documentation.

Note: for information about the os98 search wizard and the performance task database, see sitedocs/os98.

[v]Flow Charts of Application Use
[v]Implementation Details
[v]See Also
[v]Footnotes

Flow Chart Details

Top of page[^]


Implementation Details

Note: Scoring guides are no longer being maintained in the standards database but, rather, as static HTML pages. Consequently, it is NOT necessary to run scorebuild.ncgi as described in the os98 sitedocs.

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

Creating the proper Excel spreadsheet format:

The spreadsheet is the master file for the os2000 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/os2000/sourcedata
  6. Run tab2sql from the command line.

Tab2sql looks like:

tab2sql [filename.txt] [database] [table]

tab2sql cs.txt os2000 css
tab2sql ccg.txt os2000 ccgs
tab2sql benchmarks.txt os2000 benchmarks

Once the tab2sql process is done the "prebuild" script must be run. This script joins the data from the benchmarks, content standards, and common curriculum goals into a single table. The script is found in /home/www/beta/os2000/sourcedata and is called prebuild.ncgi. It is executed simply by typing ./prebuild.ncgi from the command line.

Fields created from the script 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  |
+-----------------+----------------+--------+

After running the "prebuild" script you will be able to access the data from the os2000 search page at http://beta.open.k12.or.us/os2000/search.html.

Top of page[^]


See Also


Top of page[^]


Footnotes


Top of page[^]