STR - Students Grid Entry

This program provides a tool to simultaneously display and update multiple current student records. You would use this program instead of Student Admin > Student Records > Student Information > Students when there is a need to edit more than one record in the database.

The Student Grid Entry program is for updating current students.  To update non-current students, use TASS.web program Student Admin > Past Students > Student Information > Past Students Grid Entry.

General and User Defined Tabs

Fields from the 'General' and 'UD' tabs can be used as selection criteria to filter the data that will be available in the grid.

These tabs are similar to those displayed in Student Admin > Student Records > Student Information > Students.

The 'Calendar' icons in the 'General' tab display date range pickers, these windows allow the entry of a date range, e.g. All student records with a 'Date of Birth' date between 01/01/06 and 31/12/06.

You may also notice that the dropdown menu arrows next to selected fields in the 'General' and 'User Defined' tabs look different, these different arrows indicate that more than one selection can be made from the drop-down menu for your search criteria.

Process Tab

The 'Process' tab controls the columns that will be displayed in your data grid. Select the fields to include in your data grid by highlighting them with your mouse. The 'Student Code' and 'Surname' fields are automatically included and are not available for selection.

Holding down the 'Shift' key while clicking on your options enables a range selection, holding down the 'Ctrl' key allows individual selection of additional fields.

Sorting options are available by selecting the radio buttons on the left of the screen. These options include Student Code, Surname, Year Group and PC/Tut Group.

When the grid is populated, data will be displayed within columns.

Each row contains data from a master record matching your search criteria, and each column is a field matching your additional fields from the 'Process' tab.

Click an individual cell to make a change.

If you are editing a table-referenced field that requires a code to be entered, click into the cell and either use the drop-down list or key in the code.

Example:

Use the 'Fill Down' button to replicate the same data down the column.

If you make a mess, use the 'Restore' button to undo your changes. Unsaved data will be lost.

• The data will be restored back to the last 'Save'.

• If you have not yet saved, the data will be restored back to the way it was when you loaded the Grid.

To sort by a column, click on the column heading. To sort by multiple columns use shift-click in the second and subsequent columns that you want to sort by.

To add a new column to your grid without having to go back to the previous screen, right-click on a column heading.

Select 'Save' to commit your changes to the database or 'Cancel' to return to the selection screens.