Scholarship GPA History Window

This window allows you to view historical information for students on their progress from tier to tier and also to generate various reports.

Scholarship GPA History Tab

This tab displays historical information for all students on their progress from tier to tier. The Restrict by Year and Term group box can be used to view historical information by selecting a particular year and term. If the year and term columns are left blank, you will be able to view all students who had ever been eligible for the scholarship GPA.

The columns include information eligibility for scholarship programs. If your school has the Georgia HOPE license, there's specific information on the HOPE and Zell Miller programs.

Shortcut to View the details of an Import Batch

You can quickly jump to the details of a Scholarship GPA History row. Right-click the row, and select Show GPA/Checkpoint Import Data. The GPA/Checkpoint Import Batch window opens with the selected row already retrieved. Example

User Defined Tab

The User Defined tab contains columns from the GPA Tier History table that can be customized to fit your specific needs.

Reports Tab

The Reports tab is used to generate various reports by selecting criteria from the following group boxes:

Depending on the selected radio button, you will be able to view different information from the GPA Tier History table. You may display the report by student name (Students radio button) or hours (Tiers radio button). By choosing the Courses radio button, you will produce a single report that displays all of the courses from the Student Course History table that contribute towards the Scholarship GPA as well as a view of the students tier history.

You may use a query or choose an individual student ID Number. The Original Query will select all students who have ever been identified as eligible for the special GPA. The other query prefixed with _current will select only students where their most recent year and term enrolled is the same as the current year and term that has been identified on the Registration Configuration window. You may also click on the Customize button to create a customized InfoMaker report.

You can create a report that is specific to a GPA range by entering the specific numbers in the From and To columns. If the numbers entered are less than or equal to the number defined on the GPA Tier History table, the information will be displayed.

By choosing the appropriate checkboxes, a report can be generated to include students who are eligible, not eligible, eligibility that has changed, and eligibility that has not changed.

If the Years and Terms radio button is selected, the current year and term from the Registration Configuration window will automatically default into the group box. You may click on the Change button to select a different year and term. This will open the Select Report Criteria window, which can be used to select one or more year and term combinations to be included in the update process. If the year and term columns are left blank, all students will be displayed. The Term Begin and Term End Dates displayed are taken from the Year/Term Table definition.

If the Tiers radio button is selected, all tiers that have been defined will default into the group box. You may select a specific tier. If none are select, all tiers are displayed.

GPA/Checkpoint Import Tab

Use this tab to import information you receive back from the state. You select a file to import, assign an import date, and then select the rows to import.

Each row you import is assigned a Tier History App ID. It's not part of the student data; instead, it's used to mark rows that have already been imported.

You can view all the details of your batches on the GPA/Checkpoint Import Batch window.

GPA Eligibility Definition Tab

Use this tab to define codes for grant and scholarship eligibility. The tab serves as a translation table that maps the Georgia state reporting values to J1 values.

Georgia Scholarship Term Code Definition Tab

Use this tab to map years and terms to Georgia Scholarship Term codes. The tab serves as a translation table that maps the Georgia state reporting values to J1 values.

How To

1. On the GPA/Checkpoint Import tab, click the Select What to Import... button. Example

A pop-up window opens.

a. Click the Import from CHECS File radio button.

b. Click the Filepath icon to navigate to the file you received from the state. Example

c. In the Select GPACheckpoint File pop-up, select the file, and click Open. Example

d. Select the Import Date. (Today's date is the default.) The system assigns this import a Sequence Number. (Each import on a particular date is considered a batch, and each batch gets a Sequence Number.)

e. Click OK. Example

2. In the confirmation pop-up, click Yes. All the pop-ups close, and the information appears in the datagrid.

3. Select the rows you want to import.

4. Click Import Selected Rows. A message tells you whether the import was successful. The records are now updated and available. A Tier History App ID is assigned to each row you imported. It's in the final column. Example

5. To view the batch and all its details, open the GPA/Checkpoint Import Batch window.

On the GPA/Checkpoint Import tab, click the Select What to Import button. A pop-up window opens.
Click the Select Existing Import Batch radio button. Example
Select an Import Date. (Today's date is the default.)
If there was more than one batch on that date, select the Sequence Number of the batch you want.
Click OK. The pop-up closes, and information appears in the datagrid.
Select the rows you want to import.
Click Import Selected Rows. The records are now updated and available. A Tier History App ID is assigned to each new row you imported. It's in the final column. To view the batch and all its details, open the GPA/Checkpoint Import Batch window.