TER - Teacher Grid Entry

Teacher Grid Entry Overview

This program provides a tool to display and update multiple teacher records simultaneously.

You would use this program instead of Student Admin > Teacher Records > Teacher Information > Teachers when there is a need to change more than one record in the database.

It populates the data into a grid where it can be modified in bulk within the columns.

General and UD Tabs

Fields from the 'General' and 'UD' tab can be used as selection criteria to filter the returned data. These tabs are similar to those in Student Admin > Teacher Records > Teacher Information > Teachers.

The 'date picker' calendar icons displayed in the 'General' tab are 'date range pickers' and allow the entry of a date range, e.g. All teachers with a 'Last Updated On' 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 display in your data grid.

Select the fields to include in your data grid by highlighting them with a mouse-click.

The 'Teacher Code' field is automatically included and is not available for selection. If no other fields are selected, the 'Surname' field will also be included.

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

You can also pick the sort order by clicking on the radio button on the left of the screen.

Sort by options include: 'Teacher Code', 'Surname', 'Department' and 'Teacher Initials'.

Once the data grid has been populated, data will be displayed within columns. 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' icon to replicate the same data down the column.

This Grid allows you to sort the displayed data by multiple columns. To sort your data by a column, click on the right-hand side of the column heading. You can sort in ascending or descending order.

The column heading will now indicate that you have sorted using this column by displaying a '1'. If required, repeat the process on the second column which will then display a '2' in the column heading (and so on for subsequent column sorting).

If you make a mess, use the 'Restore' icon to undo your changes.

Click on 'Save' to commit your changes to the database or select the 'Cancel' button to return to the selection screens.

Important!

Your Administrator would normally process this procedure, and your school may have security restrictions on this module. Please refer to your Administrator for more information regarding those restrictions and any specific requirements your school may have regarding changing of data.