Reports allows you to compile specific information about the applicants included in your query.
1. To create a report, you must first create a saved query. Refer to this guide to do so: How to Create a Saved Query
2. Find the query you wish to create a report for in your "Saved Queries" under My Queries & Reports. Select the New Report button shaped like a histogram.
3. The first section, Step 1, is typically best left alone by default.
4. The second section, Step 2, is best thought of as the columns in your Excel spreadsheet. Whichever boxes you check will appear as a separate column in your final spreadsheet.
-
The "Programs & Terms" section contains brief information about the study abroad programs.
-
Uncheck the ID# box. It is NOT the UGA myID number; It is the Portal ID# and therefore should almost always NOT be selected.
-
-
"Program Parameters" contains information about the study abroad program itself.
-
"Applicant Parameters" contains information about students from the Banner/Athena Student Information System(SIS).
-
This section will not gather information about transient students because their information is not held in Banner/Athena.
-
If you wish to include the students 81#, you should select UGA ID.
-
Student names are always included in a report so there is no option to select for them.
-
-
"Applicant Addresses" section contains the addresses we have on file for students in the Banner/Athena SIS.
-
"Questionnaires & Questions" contains all questions asked for all applications asked on the GoAbroad portal.
-
If you wish to select specific questions, click the Arrow next to the questionnaire and select the question(s) from that particular set.
-
-
Transient student information can be found by selecting Transient Applicant Core Information.
-
"Assessment & Final Scores" will show the final scores of students for assessments.
-
"Additional Information" contains information about the application that does not fit into other categories.
5. Save your report by entering a unique name in the Save Report As box.
-
Select New Window if you want the report to pop up in a new window within the browser.
-
Select Export as Excel to have the report save as an Excel spreadsheet. This is the recommended method of exporting data because it allows a user to manipulate data
-
NOTE: There is no limit to the amount of students a report can pull up, but large amounts may take a VERY long time to process.
-
-
Select Export Essay Content if you wish to see the content of essay questions. This is left off by default because they can get very long, and increase the time it takes to generate a report.
6. Click Results to generate the report.
7. If you would like to put another saved query into the same format as this report, scroll down to the "Combine Queries & Reports" section on the Administrative homepage under My Queries & Reports. Select the Query you would like to format and the Report you wish to generate.
-
Run Report will produce a report in a new window within the browser.
-
Excel Export will export a report in Excel format.
If you have any questions or concerns, feel free to contact:
This email address is being protected from spambots. You need JavaScript enabled to view it.