Page Comparison

...

The Coronavirus Aid, Relief, and Economic Security (CARES) Act contains a provision for Higher Education Emergency Relief and Student Aid. USF receives funds that will to be used for emergency student aid. Students who have expenses related to the disruption of campus operations due to COVID-19 are eligible to apply for this program. 

...

Report Elements Glossary Table

Overview

The CARES Act report contains data pertaining to CARES Act applications and funding. Specifically, the report provides a table of all students who have initiated an application for CARES Act funding, including the amount requested, details of the virus impacts, and the expenses to which the funds will be applied, such as rent, relocation costs, or food. 

When a student initiates an application, Archivum records the entry with a status of Incomplete. Once the student submits all requested documentation, the Approval Status changes. A student has seven days to complete the application after initiating, after which time the Approval Status remains in the database as Incomplete and the student must submit another application. 

Filter Panels

Filters are listed on both the top and left panels of the report.

...

• Click the down arrow to select from options in the filters and narrow down your results. 
• To deselect an item, click on the option again. 
• To select multiples in a filter, hold the Ctrl key as you check the boxes. 
• Blank options exist for some filters, which indicates the student did not complete this item in the application. 
• Use the date sliders to narrow down the time frame for submitted and reviewed applications. 

Data Panel

The panel on the right is the main work area showing the filtered results. To work with data in this panel:

• Select a column header to sort by that value, such as Student Name or Reviewed Date.
• Select an individual row in the table to highlight the item. Select it again to return to the full table view.

Tasks

Export Data to Excel

To export filtered results to Excel:

1. Hover over the table, then click the ellipses in the top right corner of the table display. 
   The report displays a menu:
   
2. Select Export Data, then work with the data in Excel.

Set Date Ranges

You can set ranges for dates for the Submitted Date element and the Reviewed Date element. Use the sliders in the side Filter panel to adjust or type dates in to the date fields. When you filter for date ranges, the table adjusts immediately. In addition, the selections available in the remaining filters are narrowed down to correspond with the selected dates. For example, reviewers who did not review applications during the specific time you filtered will not display in the Reviewer Name drop-down field. 

Reset to Default

If you have made any changes, such as implementing filters or sorting the table, you have the ability to return the sorting and filtering to the report creator's default view. Click the Reset to Default image in the Report Header: 

Filters

Impact Reasons

Expense Options

...

Submitted Date

Reviewed Date

Report Elements

Total Amount Approved

Total Amount Requested

...

Reviewer Name

Date Refreshed

...

Report Elements Glossary Table

The table below lists all of the elements used in the CARES Act report.

...