This table provides a summary of your application progress for each term and program.

Each row provides data from a specific term. If you select one of these rows, below will appear the different programs represented in that data, which should be all of the programs to which you are assigned in Slate. In the example above, the highlighted top row of 1272 - Fall 2026 has been selected, revealing the four programs included in that highlighted row's data.

For example, the total 191 unsubmitted apps is calculated by adding the 10 unsubmitted apps in Herbology MS, the 27 unsubmitted apps in Herbology PHD, the 74 unsubmitted apps in Transfiguration MS, and the 80 unsubmitted apps in Transfiguration PHD.

The columns of this table provide the following information for each term (going left to right):

• Unsubmitted Apps: Count of applications that selected this program in this term but did not submit the application
• Submitted Apps: Count of applications that were submitted for this program and this term
• Total Recommended Apps: Count of total applications in this program in this term that were recommended for admission (G60) by the program
• In Grad Review: Count of applications in this program in this term currently in the Graduate School Admissions Office review workflow (i.e., currently being reviewed by Graduate Admissions)
• Accepted: Count of admitted applications that have accepted their admission offer in the Admitted Applicant Decision Reply Form
• Admitted No Reply: Count of admitted applications that have not yet filled out the Admitted Applicant Decision Reply Form
• Declined/Withdrawn: Count of applications that have been admitted and declined their offer of admission from the program, or applications that have been recommended and withdrew their application before being fully admitted (G59). This number will also include any applicant who was originally admitted to this term and then was later approved for a term change to a new term.

These tables can be a helpful resource for the following reasons:

• Quick snapshot of current application progress
• Term-by-Term and Program-by-Program comparison made quite simply
• They are already set up to display the programs to which you are assigned in Slate - so no work necessary!

This section allows you to put in a program purchased fee grant code to see if it has already been used by an applicant. If the results confuse you for any reason, contact feegrants@grad.wisc.edu with questions.

The Homepage Queries table, depicted above, is a list of ready-made queries that you can use to pull information of your application. Below, we describe the different queries you will see in this table:

All Application Queries

• All Applications (submitted and unsubmitted): This query will pull every prospective student's info in your programs, no matter where they are in the application process (even those who have a decision made by the program).
• All Submitted Applications: This query will pull a list of all of the submitted applications your programs have received (even those who have a decision made by the program).
• All Unsubmitted Applications: This query will pull a list of all of the unsubmitted applications that have selected your program as the intended program of study.

Before Recommendation

• All submitted applications in Coordinator/Program Review Workflow: This query will pull a list of all of the applications that are currently in your Coordinator/Program Review Workflow
• Applications in Awaiting Recommendations Bin: This query will pull a list of applications that are specifically in the "Awaiting Recommendations Bin" in your Coordinator/Program Review Workflow. Applications in this bin have been submitted but have yet to provide the required number of letters of recommendation set by the program.
• Applications in Awaiting Other Materials Bin: This query will pull a list of applications that are specifically in the "Awaiting Other Materials Bin." This bin is a good place to store applicants that are missing information your specific program needs in order to be reviewed.
• G00 Grad Coord Review Applications bin: This query will pull a list of applications that are specifically in the "(G00) Grad Coordinator Review" bin. This bin stores submitted applications that have provided all of the necessary materials (including recommendations).
• Grad Coord Final Processing Applications bin: This query will pull a list of applications that are specifically in the "Grad Coord Final Processing" bin.
• My Queue: This query will pull any applications that are currently in your Queue in the Slate Reader.

Faculty/Committee Review

These queries will specifically pull a list of applications that are in the Faculty/Committee Review column in the Coordinator/Program Review Workflow (Bins 1-5).

After Recommendation

• All recommended applications that have not been withdrawn: This query will pull a list of your students that your programs have recommended for admission minus the students who have withdrawn their application (if you are familiar with G-codes, any student who has a G60 or G61 code that did not also have a G57, G58, or G59 on their record).
• Recommended applications needing English proficiency (G35 bin): This query will pull a list of all recommended applicants that have yet to provide proof of English proficiency (e.g., official TOEFL/IELTS scores).
• Applicants currently in GSAR (Prosheet) Process (G10, G05): This query will pull a list of all students who are currently in the Graduate School Approval Request (GSAR) process. 
  
  

After Admission/Denial/Withdrawal

• All admitted applications (G11, G12, G13): This query will pull a list of each of your applicants that has been through the review process and admitted to the Graduate School, including reentry students (G12). Note that this query will also include applicants that have withdrawn after being admitted.
• All Recommended Applications That Have Been Withdrawn: This query will pull a list of your applicants that were withdrawn after being recommended by the program (G59).
• Applicants who have ACCEPTED offer of admission: This query will pull a list of all of your applicants that have been admitted and have accepted the offer of admission.
• Applicants who have NOT RESPONDED to offer of admission: This query will pull a list of applicants that have been offered admission to your program but have not yet responded to the offer.
• Applicants who have DENIED offer of admission: This query will pull a list of applicants that have been offered admission to your program and have denied that offer.
• All applications no longer considered (G50, G57, G58, G59, G90): This query will pull a list of all of your applicants that are no longer being considered for admission because they withdrew themselves from consideration before being reviewed (G50), were withdrawn by the Graduate School (G57), were withdrawn by the program (G58), withdrew themselves after being recommended (G59) or were denied admission (G90).

This part of the Tracking Data tab should look familiar: this is a recreation of the bins you will find in the Coordinator/Program Review Workflow. In addition to showing you how many applications are currently in each bin for your assigned programs, you can also click each bin to reveal the list of applications in that bin.

In the example depicted above above, selecting the Faculty/Committee Review Bin 1 bin opens a pop up that displays the three applications in that bin: Buckingham Badger, Hermione Granger, and Neville Longbottom.

If you were to select an application row, you would be brought to the application tab in Slate for that specific application. There is also a link to be brought directly to the application in the Reader review platform.

To the top left of this view, you will find a "Go to my bins" button, which will open the Browse bins view in the Reader a new window. Selecting the "Go to my queue" will open your Queue in the Reader in a new window.

This view in the Tracking Data tab shows you a version of the Graduate School's Admission Review workflow. When a program has moved applications through the workflow and either recommended for admission, withdrawn, or denied an application, these applications enter into the Graduate School's workflow. Like applications in the Coordinator/Program Review Workflow, the Graduate School's Office of Admissions moves applications through this workflow to be processed.

Some key bins to be aware of as a Graduate Coordinator:

• Missing Official Trns (G02): This bin holds applicants/applications that have yet to provide official transcripts to the Graduate School. It is very common for applicants who have been recommended to the Graduate School to be sent to this bin because the Graduate School needs an applicant's official transcripts in order to be reviewed for admission. Applicants hanging out in this bin will receive reminders to send official transcripts every three weeks; however, if you see an applicant hanging out in this bin for too long, it may be a good idea to investigate.
• Missing TOEFL/IELTS (G35): This bin holds international applicants/applications that Graduate Admissions has determined lacks proof of English proficiency. If an applicant lands in this bin, they are sent an automated email requesting English proficiency (e.g., such as a TOEFL, IELTS, or Duolingo test score). If you see an applicant hanging out in this bin for a while, it might be worth checking in on.
• Recommended to 2+ programs (G06): This bins holds applications that has been recommended to multiple programs. It is important to note that while this applicant may have been admitted to a different program, the applications that are held within this bin have not yet been admitted into the program specified in that application. In order for the application to be moved from this bin, the Graduate Admissions team needs to hear from the applicant which program the applicant wishes to pursue. Applicants who land in this bin are sent an automated email to inform Graduate Admissions of their choice. If you see an applicant hanging out in this bin for a while, it might be worth checking on because they may need help making their program decision.
• Requiring Follow Up (G06): This bin holds applications that may have sent in official transcripts and English proficiency, but the Graduate School still needs more documentation to process this admission. Often, the Graduate School has reached out to the applicant to provide additional transcripts (e.g., the applicant sent an in-progress Masters Degree transcript but the Graduate School needs to see an official transcript of a bachelor's degree) or the English proficiency score provided was too low or has expired and the applicant needs to take another English proficiency exam. In these cases, the Graduate Admissions team tries to add notes to the application file so Graduate Coordinators can see what Graduate Admissions is waiting for.

This customizable pivot table will allow you to quickly summarize and reorganize admissions data from Slate into useful data tables. You can manipulate the variables and use filters to build data tables that can be copied or easily captured in a screenshot for your next report.

The pivot table will reset to the default table settings every time the page is refreshed, as shown in the screenshot below.

Open the accordion panels below for detailed explanations about each section of the pivot table and their function.

• Data Table: This is the count of submitted applications based on the columns and rows. Manipulating the column and row variables will and adding filters will affect the counts in the data. (This section is highlighted in blue in the bottom right section of the screenshot above.) 
  
  
• Variables: These are categories that the data is sorted by. Moving these to different parts of the tracking data tab is how you can customize the data shown in the data table. Each variable has a drop down box that is accessed by the down arrow on the right side of the box. The drop down box will allow you to filter the specific data shown in regards to that category. (A couple of the variables are highlighted in orange in the screenshot above.)
  
  
• Column Variables: Variables put in this section will determine the column categories in the data table. When multiple variables are in this section, the table will create a hierarchy of columns. The first variable on the left is the parent level, and any sequential variables will be the child level and nested under the parent. (This section is highlighted in purple in the screenshot above.)
  
  
• Row Variables: Variables put in this section will determine the row categories in the data table. When multiple variables are in this section, the table will create a hierarchy of rows. The first variable on the top is the parent level, and any sequential variables will be the child level and nested under the parent.
  
  
• Other Variables: Variables in this section do not affect the columns or rows but can be used to filter the data table. Order does not matter for this section.
  
  

Please note: the table will reset to the default table every time the page is refreshed.

The Data Table presents the count of submitted applications based on the columns and rows. Filters can be applied to any of the variables, which will affect the counts in the data. 

For example, by selecting the "Plan - Subplan" variable (as shown in the screenshot above), you will be able to select only the Graduate School programs you wish to include in the table. In the table above, it has been filtered to only populate results for three programs: African Studies MA, African Cultural Studies MA, and African Cultural Studies PHD program. By default, the pivot table will initially include all programs that you have permissions to view.

The pivot table variables are the categories that the data is sorted by. 

Moving these to different parts of the tracking data tab is how you can customize the data shown in the data table, as shown with the "Latest Decision" variable in the screenshot above. 

Each variable has a drop down box that is accessed by the down arrow on the right side of the box. The drop down box will allow you to filter the specific data shown in regards to that category. as shown with the "Term" variable in the screenshot above.

Variables placed in the Column Variables section will determine the column categories in the data table. When multiple variables are in this section, the table will create a hierarchy of columns. The first variable on the left in the Column Variables section is the parent level, and any sequential variables will be the child level and nested under the parent. 

In the table shown in the screenshot above, the "Term" (1) is the parent variable, and "Latest Grouping" (2) is nested under Term, and "Latest Bin" (3) is nested under Latest Grouping.

Variables put in the Row Variables section will determine the row categories in the data table. When multiple variables are in this section, the table will create a hierarchy of rows. The first variable on the top is the parent level, and any sequential variables will be the child level and nested under the parent.

In the table in the screenshot above there is only one variable - "Plan - Subplan" - meaning that every row in the data table represents a specific graduate school program.

Variables put into the Other Variables section do not affect the columns or rows and order does not matter for this section. However, you can use these variables to filter the data table.

For example, by selecting the small down arrow in the "Domestic or International" variable (as shown in the screenshot above), you will be able to decide if the data table will include domestic applications, international applications, or both. In the example above, it is filtering to only show international applications.

Applying a filter to a variable will display only data that meet specific criteria. 

In the example below, we'll go through how to show results for just three programs:

1. Click the down arrow on the right side of the “Plan - Subplan” variable (default location is in the Row Variables box)
   
   
   
2. Click the Select None button to deselect all programs.
   
   
   
3. Click the box next to the program(s) you want to display. You can use the search function to find specific programs.
   
   
   
4. Once you've selected the programs you wish to display in the data table, click Apply.
   
   
   
5. You've successfully applied a program filter!
   

Notes: 

• The pivot table default is to show all terms in Slate and every submitted application in the workflow. If an applicant has been admitted/denied/withdrawn, they will show up as “No Longer in the Workflow”
• You can filter on any variable in the pivot table, such as specific term, bin, domestic/international, etc. When a filter is applied, the text of that variable is italicized (as shown for the "Plan - Subplan" variable in the screenshot above).

By changing your selected row and column variables, you can create tables to display a wealth of information specific to your needs.

In the example below, we'll demonstrate how changing the row and column variables can create a table that displays the count of latest decisions -- that is, the number of applications that have been admitted, withdrawn, and denied:

1. Starting from the default pivot table, drag the “Latest Grouping” and “Latest Bin” variables to the Other Variables box. In the screenshot below, it shows clicking and dragging only the "Latest Grouping" variable.
   
   
   By leaving “Term” in the column variable box, the data table now displays a column for each term in Slate. The data table, as shown below, now displays the number of submitted applications by program and term.
   
   
   
2. Now drag the “Latest Decision” variable to the column variable box and drop it to the right of the “Term” variable.
   
   
   The “Term” variable become parent level and the “Latest Decision” variable is the child level. This means that the full set of variables in latest decision are shown under each term.
   
   
   
   
3. To see all the decisions regardless of terms, move the “Term” variable to the other variable box (where you moved “Latest Grouping” and “Latest Bin”).
   
   
   
   
4. To show only one term in the data table, you can filter the “Term” variable while in the other variable box. Click on the down arrow in the “Term” variable, then select which term(s) you want displayed in the data table.
   
   
   The columns in the data table show only latest decisions. The data table is showing data for term 1262.  The font for the “Term” variable is italicized, showing that a filter is in effect.
   

Table Showing Domestic and International Applications for Specific Term

Table Showing Status of Applications Currently Being Reviewed by Graduate School Admissions office

Table Showing How Many Applications are in Program Review, How Many Applications are in Graduate School Review, and How Many Applications are Processed

The final table in the Tracking Data tab is a Graduate School-wide count of submitted apps, recommended applications, and admitted applications for a given term. It is important to note that this data is not considered official data fit to be published -- however, it does provide a good estimate of total number of submitted applications, recommended applications, and admitted applications for each term that has been processed in Slate.