3.1 - Headcount Trends Over Time

• The line graph shows headcount by fiscal year (FY) for (1) the overall university; (2) a selected college, school, VP portfolio (C/S/VP), or department; and (3) all units on campus other than the selected unit. The color key labeling the groups is in the upper left corner. Scales for each group are different to allow for relative comparison among the groups. (The column graphs at the bottom of the sheet will be described later.)

►       Headcount can be displayed in one of three ways. Select the relevant Headcount Type in the upper left corner.

• The default is a Snapshot: a typical headcount in any of the three semesters. Fall is the default semester. Select the semester of interest using the dropdown menu box next to the Headcount Type by clicking on the down arrow and select Fall, Spring, or Summer. The semester menu only works for the snapshot view.
• Full Time Equivalent (FTE): a count of full-time equivalent appointed hours for an entire FY. (Nine full-time months equal one FTE for faculty; summer appointments are added on.)
• Cumulative: a count of the number of employees who worked during the FY regardless of their number of total hours.
• Query the data to answer questions

►       Hover over a name or color on the color key in the upper left corner of the page to highlight an organizational group. Select the C/S/VP or Other UT Units groups to display only their values (note that the university group remains visible, but only the values of the subgroup are displayed for the university). Select the same name or color to turn off highlight.

►       Hover over FY points on any line to display relevant information such as specific headcount, percent change from the previous year, and data sources.

►       Click on a FY point to highlight data in this and related graphs for the selected FY. Select again to turnoff highlight.

►       In the upper right corner, select the Table button to display tabular information in place of the line graphs.

►       Filters allow you to focus on specific information. This report contains several filters across the top of the page. You can use the filters singly or in combination to refine, or “slice,” the data. The filters are described below.

• Filter for Employee Type using the dropdown menu at the top of the page: click on the down arrow, click on the “All” check mark to remove all check marks, then click the boxes of employee types you want to include.
• Filter to view Monthly or Hourly employees using the dropdown menu at the top of the page: click on the down arrow, select monthly or hourly.
• Filter to view specific Job Category(ies) (Occupational Group) using the dropdown menu at the top of the page: click on the down arrow, click on the “All” check mark to remove all check marks, then click the boxes of job categories you want to include. If specific job titles are of interest, then use the Job Titles filter.
• Filter to view one or more Job Titles using the dropdown menu at the top of the page. After selecting the dropdown menu by clicking on the down arrow, remove titles by clicking the check marks of titles you want to exclude, or click on the “All” check mark to remove all check marks, then click the boxes of titles you want to include. If categories of job titles, or occupations, are of interest, then use the Job Category filter.

►       Printing dashboards

• You may want to print dashboards to share with others. The graphs showing on the screen are what is printed. Multiple prints are required if a graph needs to be scrolled to reveal additional sections of the graph.
• Click on the Download button at the bottom or top of the page.
• For a PDF document, select PDF
  • For most dashboards select Landscape (you will be able to see the document on-screen before printing and change if desired).
  • Under Content, select This Dashboard
  • Click on the Download button, a small window will appear,  Download PDF,  click on Download
  • A Microsoft Open/Save window will open, click on the Open with button and click OK
  • For an  Image of the dashboard, select Image
    • A small window will appear,  Download Image,  click on Download
    • A Microsoft Open/Save window will open, click on the Open with button and click OK
    • You can print directly from the Windows Photo Viewer or copy it and paste it into a Word document
      ►       Clear all filters and return to default settings by selecting Revert at the bottom or top of the page (You can return an individual filter to its default settings by selectingabove the filter drop down menu.)

Example 3.1.1

Example 3.1.2

Example 3.1.3

For questions or comments, contact:

Karen Blanchette: karenblanchette@austin.utexas.edu (512.475.8055)

John Moore: john.moore@austin.utexas.edu (512.475.8062)