EC - Student Activities Grid
Student Activities Grid Overview
This program provides a 'Grid' style data maintenance tool to facilitate rapid review and editing of extra-curricular data across multiple student records. Simultaneously display and update multiple student activity records. You would use this program instead of Student Admin > Extra Curricular > Student Information > Student Activities when there is a need to change more than one record in the database.
General and UD Tab
Fields from the 'General' and 'User Defined' tabs can be used as selection criteria to pick the students to include in the grid.
These tabs are similar to those displayed in Student Admin > Student Records > Student Information > Students.
Activity Details and Activity UD Tabs
To use the grid to update data for all students involved in an activity, do not enter selection criteria on the 'General' and 'UD' tabs. Instead, use the 'Activity Details' and 'Activity UD' tabs.
To do this, use the 'Activity Details' tab to select the appropriate 'Year', 'Semester*', and 'Activity' combination that you want to include in the grid.
Once these selections have been made the 'Activity Type UD Fields' and 'Activity UD' fields will also become available as filters for your grid.
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', 'Surname', 'Activity', 'Year' and 'Semester*' 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', 'Entry Year Group', 'PC/Tutor Group', 'Activity Year', 'Semester'*, 'Term'** and 'Activity Level'.
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 to the last 'Save'.
- If you have not yet saved, the data will be restored 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.
Important!
Your Administrator would normally carry out 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.
* The description of the extra curricular period that is displayed in this field is school definable (therefore it may not necessarily be 'Semester'). For example, your school may be term-based (as opposed to semester based) and accordingly this screen may be displaying a description of 'Term'.
** The description that is displayed in this field is school definable (therefore it may not necessarily be 'Term'). There also may be no field here at all if your school is not using this functionality.