Main Menu
SIS 2000+ Mark Reporting
Last update: 8/16/2000 jmm
Step
1, Set-Up Tables
Before
Mark Reporting applications can be used, there are several tables that
need to be set up through the Table Editor, under the System Menu. The
tables are shown and described below.
For more information on how to use the Table Editor interface, see Table
Editor.
1.1 Set up Term Codes Table (zterms)
This table holds the term codes for both the school's Track
Terms and the school's Mark Reporting Terms. Furthermore, all term codes
needed for all tracks in the district are stored here.
Track Terms are mainly used for scheduling and attendance taking purposes
and their start and end dates are defined through the Track
Editor. A Track Term may also be used as Mark Reporting Term when a
Mark Reporting Term coincides with a Track Term.
Mark Reporting Terms are not used in the Track Editor. They relate to
the Mark Reporting Timeline that will created in the next step. Each Point
on the Mark Reporting Timeline must have its own term defined in this table.
Fig. 7 - sample set up for Term Codes Table.
-
Termc -
A user-defined code for each of the school's terms.
-
Descript -
Enter the full description of each term.
-
Trmstart -
This numeric value defines which Track Term (based on the number of
terms defined for the target track through the Track Editor) each term
begins in. If there are a total of four Quarters in a track, the
'Quarter 1 Progress' term would start during term 1, so a '1' would be
entered in this column. Likewise, a '3' would be entered for a 'Semester
2' code because it starts on the third term defined in a track.
-
Trmdur -
This is a numeric value that defines how long each term lasts. Again,
this is based is how many Track Terms have been defined in the Track Editor.
If there are a total of four Quarters in a track, then 'Semester
1' would have a duration of two quarters, so a '2' would be entered in
this column, and so on.
-
Trmend -
This is a read-only calculated field. The value displayed will be the
sum of the Trmstart and the Termdur values.
-
Isprogrpt -
This is a numeric value that tells the system which codes are Progress
Report (or Mark Reporting) Terms exclusively, as opposed to regular (Track)
terms. A '1' in this column equals "Yes", indicating this is a Mark Reporting
Term and not a Track Term. Terms with a '1' in this column will not show
up as choices in the Track Editor or in the Master Schedule when course
are being assigned to terms. Terms with a '0' will show as Mark Reporting
Terms and will also show as Track Terms in the Track Editor and
Scheduling applications ('Semester 1' and 'Semester 2' in the example are
used as both Track Terms and Mark Reporting Terms).
-
Snreserve1, Snreserve2 -
These fields are not currently being used by the system.
1.2 Set up Mark Type Codes (zmarktyp)
For each point in the Mark Reporting Timeline, the type of Marks to
be collected will eventually be defined. (i.e., for the First Quarter Report
Card Timeline Point, Academic Marks and Behavior Marks are to be collected)
Through this table (Fig. 8), the types of Marks that can be selected for
each Timeline Point will be named.
Fig. 8 - sample set up, Mark Type Codes table.
-
Marktypc -
A user-defined, single-character code for the Mark Type. It is advisable
to use the first letter of each Mark Type Description. Only the code will
be displayed in the Mark Reporting entry applications.
-
Descript -
The full description of the Mark Type.
-
Shortdesc -
An abbreviated, four-character description of the Mark Type.
-
Trnmarkn -
There are five possible columns in a SIS 2000+ transcript for displaying
marks for various Mark Types. Enter numbers 1 - 5, corresponding to the
columns, for each Mark Type to be displayed in the transcript. The class
ranking calculation looks in column 1 first. Therefore, a '1' should be
entered in the Trnmarkn field for the Mark Type that will be used
in that calculation (normally the primary Mark Type, such as 'Academic'
or its equivalent). If a zero is entered in this field for any Mark Type,
that Mark Type will not be included in the transcript or its calculations
(such is often the case with 'Behavior', 'Effort', 'Citizenship', etc.).
Be careful when entering a '1' in this field for more than one Mark Type.
If, in the Post to History procedure, two Mark Types are posted at the
same time that have a Trnmarkn value of '1', the second Mark Type
(alphabetically) will end up being Mark Type that is used for the class
ranking calculation. If the two Mark Types will not be posted at the same
point in time, then there will be no conflict.
-
Snsort -
for sorting how the Mark Type Codes will display in the drop-down boxes
in the applications.
1.3 Mark Set Codes (zmarkset)
Mark Sets are used to group the actual Marks that are going to be assigned.
(i.e.: "Letter Marks (no +/-) would include the Marks 'A', 'B', 'C', 'D',
'F'). In this table (Fig. 9) the Mark Sets to be used are only being given
a code, a description, and a few other attributes. The actual letters or
numbers that will be collected and keyed into the Mark Reporting database
will be defined later in the Mark Values application.
Fig. 9 - Here is an example of how to set-up the Mark
Set Codes.
-
Marksetc -
A user-defined code for each Mark Set.
-
Descript -
Enter the full description of the Mark Set.
-
Isnumeric -
Enter a '1' or '0' to designate whether or not a Mark Set is numeric.
A '1' designates that a Mark Set uses number Marks as opposed to letter
Marks.
-
Speedexprs -
This field is marked with a '1' if the Mark Set is used by Speede Express.
-
Snhide -
Enter a '1' if the Mark Set is to be hidden; to not appear in a drop-down
box in the Mark Reporting applications.
-
Snsort -
A numeric value used for sorting the Mark Set Codes as they appear
in the drop-down boxes.
1.4 Mark Calculation Definitions
Mark Calculations are used to define groupings of Marks that will be
calculated to derive a Final or Average Mark. In this table (Fig. 10),
the different types of Mark Calculations that will be used later in the
Mark Reporting Set-Up process are named and given codes.
Fig. 10
-
Markcalcc -
Enter a 3-character, user-defined code for each Mark Calculation.
-
Descript -
Enter the full description of each of your Mark Sets.
-
Snsort -
A numerical value used for sorting the Mark Set Codes as they appear
in the drop-down boxes.
< Timeline Worksheet | Next
Step >