Table Generator Help
Table Generators are tools that allow users to access aggregate GVSU information
over the internet.
Using a table generator, getting the information you want is a
simple drag-and drop process, but the tool has the flexibility to help you get exactly the
data you need without a lot of unnecessary information.
We currently have four table generator tools:
- the Degree Table Generator accesses data about GVSU degrees granted and their recipients*;
- the Enrollment Table Generator accesses data about GVSU students*;
- the Faculty Table Generator accesses data about GVSU faculty members;
- the Section Table Generator accesses data about GVSU courses and course sections;
* - Access to the Degree and Enrollment Table Generators is restricted to GVSU employees to comply with
federal rules on the confidentiality of student records.
Examples and explanations in the remainder of this document are taken from various Table
Generators, but the functionalities described apply equally to each one.
The table generator interface consists of two principal parts:
- A few dozen colored boxes which represent the characteristics that can appear in your
table ("Pods");
- A gray table diagram (at the bottom of the page), with white boxes representing the
ways the data can appear in the table ("Slots").
You design your table by choosing the pods you want and putting them into the slots where
you want them.
For example, (in the Enrollment Table Generator) if you put the Class pod into one of the of the slots labeled "Row",
it would specify a table that looks something like this:
| Headcount |
---|
Class | |
FRESHMAN | 4093 |
SOPHOMORE | 4281 |
JUNIOR | 3982 |
SENIOR | 6037 |
MASTERS | 3670 |
Total | 22063 |
The table shows the number of students by class, with the classifications listed down the
left side of the table. (You specified Class as a "Row" variable, so the table has a row
for each class.) If you put Class in one of the slots labeled "Column" instead, the table would look
like the following, with the classifications listed across the top of the table:
| Class |
FRESHMAN |
SOPHOMORE |
JUNIOR |
SENIOR |
MASTERS |
Total |
Total | 4093 | 4281 | 3982 |
6037 | 3670 | 22063 |
---|
When you've designed your table the way you want it to appear, click the "Submit Request"
button, and your table will be created exactly as you've requested, and you can read it in your
browser, open it up as a spreadsheet, print it, or go back and modify the specifications.
The parts of the window:
There are 3 general parts to the table generator page:
- The available pods -- Here you'll find all of the variables you can use to design your table.
- The table diagram -- This is where you create your table layout. The white boxes are empty slots.
- Help and Table options -- The buttons on the left side of the page allow you to (a) access this help
page, (b) specify whether you want an HTML table or a Microsoft Excel spreadsheet,
(c) save or restore a pre-defined table layout, (d) submit your table request, or
(e) reset all parameters to their initial values.
|
|
How to move a pod:
Unless you're using a touchscreen device, the easiest way to move a pod is just to click it and
drag it to where you want it to be. Use
the left mouse button to click and drag the pod, and release the button over the desired location
to drop the pod. Pods can only be dropped in appropriate slots or in their "home" location. If
you drop a pod anywhere else on the page, it will return to its "home" location. The home location
is the space reserved for the pod in the list of available pods (the upper 2/3 of the page).
You can also move a pod by using its options menu. Left click (or tap) on the pod to view the
list of
actions you can take with the variable. Among the options listed will be a list of places where the
pod can be moved. These options will include some, but not all, of the following:
- Make it a COLUMN variable -- puts the pod in the highest available "Column" slot.
- Make it a ROW variable -- puts the pod in the highest available "Row" slot.
- Make it a PAGE variable -- puts the pod in the "Page" slot.
- Make it a DATA variable -- puts the pod in the highest available "Data" slot.
- Promote it -- Moves the variable to the next higher slot within the same table dimension.
For example, a pod in the second "Row" slot can be promoted to the first "Row" slot.
- Demote it -- Moves the variable to the next lower slot within the same table dimension.
For example, a pod in the first "Row" slot can be demoted to the second "Row" slot.
- Remove it from the table -- sends the pod back to its "home" location.
For information about the difference between higher and lower slots within a table dimension, see the
section on slot order below.
If you move a pod (either by drag-and-drop or the pod options menu) to a slot that is already
occupied by another pod, the pods will trade places, with the displaced pod going to the place where
the pod you moved started. (If the pod you moved was in its "home" location, the displaced pod will
go to its own home, not to the exact spot where the new pod was located.) If the
displaced pod is not allowed to occupy the slot from which you moved the new pod, the displaced pod
will go to its home location instead.
Other things you can do with a pod:
In addition to moving a pod into, around in, or out of the table, there are several
other useful actions available from the pod options menu. Not all options are available
for all pods, and some options are context-sensitive -- they only appear on the options
menu when the situation makes them appropriate.
The following actions may be available from the options menu:
- See more details about it in the data dictionary -- Opens this help page to the
Data Dictionary entry for the variable. The data dictionary contains more
extensive information about the variable, its values, and its formatting.
- Control the way values will be grouped in the table -- Opens the
Formatting Window for the variable. The formatting window allows you to
customize the way values of certain variables will be grouped in your table. This option
is only available for selected variables and only when those variables are in a "Row",
"Column", or "Page" slot.
- Allow duplication of records for [students]
with multiple values -- Set the
duplication flag for this variable. See Duplication for details. This
option is only available for selected variables and only when those variables are in a
"Row", "Column", or "Page" slot. (The word "students" is replaced with "faculty members" or "graduates" as appropriate.)
- Disable duplication of records for [students] with multiple values -- Remove the
duplication flag for this variable. See Duplication for details. This
option is only available for selected variables and only when those variables are in a
"Row", "Column", or "Page" slot and duplication has previously been enabled. (The word "students" is replaced with "faculty members" or "graduates" as appropriate.)
- Use it for record selection -- Opens the Record Selection Window
for the variable. The selection window allows you to limit the population included in your
table to those students (or faculty members, course sections, or degrees)
with certain values of the variable.
- Clear its record selection setting -- Removes any current selection parameters
for the variable. This option only appears if record selection parameters have previously been set.
- Do nothing -- Closes the option window without making any changes. (Clicking
the "X" at the upper right of the options window has the same effect.)
The parts of the table (the slots)
A table can show your information in up to four different ways: across the columns
of the table; down the table in rows; broken up into many different table pages;
or as the data element summarized within the table's individual cells. The
following examples (from the Section Table Generator) illustrate the 4 types:
Data = Number of Sections
Course Prefix = FRE
| Course Level |
Lower-division |
Upper-division |
Total |
Instructor Rank |
|
Assistant Professor |
4 | 6 | 10 |
Associate Professor |
1 | 2 | 3 |
Total |
5 | 8 | 13 |
|
|
In the tables to the left, Course Level is laid out as a "Column"
variable, while Instructor Rank is shown as a "Row" variable. Course
Prefix is a "Page" variable here, meaning that a separate table is created for each
subject area. Finally, the "Data" element for these tables is Number of Sections
, so each cell shows the number of sections with the characteristics described by the
"Column", "Row", and "Page" variables. A table with two data elements, Number of
Sections and Census Credit Hours, is shown below. In it, the data
elements are arrayed horizontally, as if they were values of a "Column" variable. |
Data = Number of Sections
Course Prefix = GER
| Course Level |
Lower-division |
Upper-division |
Total |
Instructor Rank |
|
Assistant Professor |
2 | 1 | 3 |
Professor |
1 | 5 | 6 |
Total |
3 | 6 | 9 |
|
Course Prefix = FRE
| Data Type |
Number of Sections |
Census Credit Hours |
Instructor Rank |
|
Assistant Professor |
10 | 446 |
Associate Professor |
3 | 142 |
Total |
13 | 588 |
|
The Table Generator allows you to select up to 2 column variables and up to 2 row
variables. You can select one page variable and up to 4 data elements.
If you select more than one data element, a new pod, Data Variables, will appear
in your table diagram. This pod is a placeholder that controls how the multiple data
variables will be dispayed in your table. You can move it around in your table (to other
"Column", "Row", or "Page" slots), but the only way to remove it from the table is to
remove "Data" variables until only one "Data" slot is occupied, at which time the Data
Variables pod will disappear. The Data Variables pod will initially be placed
in an empty "Column", "Row", or "Page" slot if possible. If all of those slots are filled,
Data Variables will displace the pod in the second "Column" slot.
The following tables illustrate effects of different placements of Data Variables:
- Data Variables in a "Column" slot
Course Prefix = FRE
| Data Type |
Number of Sections |
Census Credit Hours |
Instructor Rank |
|
Assistant Professor |
10 | 446 |
Associate Professor |
3 | 142 |
Total |
13 | 588 |
- Data Variables in a "Row" slot
Course Prefix =
FRE
| Instructor Rank |
Assistant Professor | Associate Professor | Total |
Data Type | |
Number of Sections |
10 | 3 | 13 |
Census Credit Hours |
446 | 142 | 588 |
- Data Variables in the "Page" slot
Data Type = Number of Sections
| Instructor Rank |
Assistant Professor | Associate Professor | Professor | Total |
Course Prefix |
|
FRE | 10 | 3 | | 13 |
GER | 3 | | 6 | 9 |
Total | 13 | 3 | 6 | 22 |
Data Type = Census Credit Hours
| Instructor Rank |
Assistant Professor | Associate Professor | Professor | Total |
Course Prefix |
|
FRE | 446 | 142 | | 588 |
GER | 151 | | 183 | 334 |
Total | 597 | 142 | 183 | 922 |
The significance of order within table dimensions
With both column and row elements, you have the option of nesting variables. Nesting a
variable means that the different levels of the second variable will be shown for each level of the
first variable. For the "Column" slots, a variable in the right-hand slot will be nested within
the variable in the left-hand slot. For "Row" variables, the variable in the lower pod is nested
within the variable in the upper slot. In both cases, if there is only one variable specified for that
particular dimension (i.e. only one "Column" variable or only one "Row" variable), it makes no
difference which of the two slots it occupies.
The tables below give examples of nested "Row" variables. In the first table, Course Level values
are nested within Night/Weekend categories, while the second table has Night/Weekend nested within
Course Level. The same data are displayed either way, although the presentation differs slightly.
| Number of Sections |
Night / Weekend |
Course Level |
|
Evening and Weekend |
Undergraduate | 3 |
Graduate | 24 |
Total | 27 |
No Evening or Weekend |
Undergraduate | 2817 |
Graduate | 449 |
Total | 3266 |
Evening |
Undergraduate | 382 |
Graduate | 174 |
Total | 556 |
Weekend |
Undergraduate | 5 |
Graduate | 28 |
Total | 33 |
Total |
Undergraduate | 3207 |
Graduate | 675 |
Total | 3882 |
|
| Number of Sections |
Course Level |
Night / Weekend |
|
Undergraduate |
Evening and Weekend | 3 |
No Evening or Weekend | 2817 |
Evening | 382 |
Weekend | 5 |
Total | 3207 |
Graduate |
Evening and Weekend | 24 |
No Evening or Weekend | 449 |
Evening | 174 |
Weekend | 28 |
Total | 675 |
Total |
Evening and Weekend | 27 |
No Evening or Weekend | 3266 |
Evening | 556 |
Weekend | 33 |
Total | 3882 |
|
For "Data" variables, slot order only affects the order in which the types of summary data
appear. For example, the first Enrollment Table Generator table below has Headcount before Attempted Hours,
while the second table has their positions reversed.
| Data Type |
Headcount | Attempted Hours |
Gender | |
Female |
11909 | 134273 |
Male |
8002 | 92104 |
Total |
19911 | 226377 |
|
| Data Type |
Attempted Hours | Headcount |
Gender | |
Female |
134273 | 11909 |
Male |
92104 | 8002 |
Total |
226377 | 19911 |
|
Note that the four data slots are in "row-major" order, meaning
that any variables in the two top data slots will appear before any variables in the lower
data slots. |
Table Layout Hints
As a rule, you should make
your tables as uncomplicated as possible. The more variables you add to the table,
the larger and more unwieldy your table becomes. At the extremes, your table can
become so large that it slows your web browser to an apparent halt. Here
are some hints for laying out tables that will give you the information you want without
tons of unwanted data:
- Only use variables that you actually need.
- Use record selection to trim the amount of data your table presents.
- If you use variables with lots of different values (like Major, Department, or
Course ID), use them
as row variables, since row variables take up much less space on your screen or page than
column or page variables.
Record selection:
By using the pods' Record Selection windows, you can modify your table request to only include
information about the students (or faculty members, degrees, or courses) that are of interest to you.
For example, you can use the Faculty Table Generator to create a table
of only Engineering faculty, or only tenured faculty members, or female Associate Professors.
You can access the Record Selection window for a variable by choosing "Use it for record selection"
from the pod's options menu. Note that a variable does not need to be part of your table layout
to be used for record selection.
The Record Selection menu will take one of three forms. For continuous variables, you are asked to
designate a range of values to include (or exclude); for most variables with discrete values you are given
a selection list of possible values; for some variable with many possible text values, you can give a text
string to match, with wildcards if necessary.
Selecting a range:
To select a range of values, simply enter the lower and upper bounds of the range in the appropriate
boxes in the selection window. The default contents of the text boxes, "Low" and "High", are special
values which can be used to create open-ended ranges. For example, "Low" to "500" is how you would select
all values less than or equal to 500. (Note that selection ranges include both their lower and upper
bounds.)
You also have the option of excluding the values in the range (and keeping all others). To do this,
select "Exclude" instead of "Include" in the first selection box.
Selecting specific values:
To make a single selection from the drop-down list, just click the desired value. To make multiple
selections, select the first value by clicking it, then make subsequent selections by holding down the
Ctrl key and clicking the additional values.
Text string matching
Type as much of the text value as you want. Use the ? and * wildcard characters to represent unknown characters.
- ? represents any single letter, numeral, or symbol (including space).
- * represents 0 or more letters, numerals, or symbols (including spaces).
Note that a trailing * is presumed. That is, if you type "Clark" in the selection window for INSTRUCTOR
you might get results for people named Clarkson as well as those named Clark.
Examples:
Typing this... | ... might yield these |
Smith, C |
Smith, Calvin
Smith, Carl
Smith, Carla
Smith, Carol
Smith, Charles
Smith, Cheryl
Smith, Cristine
|
Smith, Ch |
Smith, Charles
Smith, Cheryl
|
Smith, C*r |
Smith, Carl
Smith, Carla
Smith, Carol
Smith, Charles
Smith, Cheryl
Smith, Cristine
|
Smith, C?r |
Smith, Carl
Smith, Carla
Smith, Carol
|
Smith, Carl |
Smith, Carl
Smith, Carla
|
Smith, Carl? |
Smith, Carla
|
All of the text-matching selection windows are case-insensitive, meaning that capital letters will
be matched to their lower-case counterparts and vice versa. Additional information about text-matching
is available in the appropriate data dictionary entries.
Applying your selections
When you have designated your selection criteria, click the "Done" button. The pod for which
you just created selection criteria will now have asterisks (*) in its upper corners as a visual
reminder that you have made exclusions.
If you specify selection criteria for more than one variable, those criteria are compounded --
records must meet all selection criteria to be included in the table. For
example, if you select "Associate Professor" for Rank and "Female' for Gender you will get data
only for faculty members who are female AND hold Associate Professor rank. (In logic terminology, you're making
"and" operations, not "or" operations.) With these selections you could get the following simple
trend breakdown for female Associate Professors:
College |
Academic Year |
2002-03 | 2012-13 | Total |
COLLEGE OF COMMUNITY & PUBLIC SERVICE |
2 | 12 | 14 |
COLLEGE OF EDUCATION |
5 | 13 | 18 |
COLLEGE OF HEALTH PROFESSIONS |
| 5 | 5 |
COLLEGE OF INTERDISCIPLINARY STUDIES |
| 5 | 5 |
COLLEGE OF LIBERAL ARTS & SCIENCES |
61 | 91 | 152 |
KIRKHOF COLLEGE OF NURSING |
10 | 12 | 22 |
PADNOS COLLEGE OF ENGINEERING & COMPUTING |
| 2 | 2 |
SEIDMAN COLLEGE OF BUSINESS |
5 | 14 | 19 |
UNIVERSITY LIBRARIES |
5 | 3 | 8 |
Total |
88 | 157 | 245 |
To remind you that your table shows a subset of the GVSU faculty rather than the entire
population, there will be a small extra table at the end of each report that summarizes the
selection criteria you submitted. For the example above, the summary table looks like this:
Summary of Record Selection Criteria
Characteristic | Selected Values |
Academic Year |
2012-13 |
|
2002-03 |
Rank |
Associate Professor |
Gender |
FEMALE |
About term (semester) or year selection
You can generate tables with GVSU data from a single semester or from multiple semesters. By default, tables
will generally include data from the most recent relevant semester. Degree Table Generator tables default to
the most recent complete academic year.
The record selection windows for Term or Academic Year include an option for "Most Recent Term"
(or Year). This allows stored layouts to access updated data as it becomes available (e.g. a query that
asks for Fall 2012 enrollment will always yield Fall 2012 figures, but a query for "Most Recent Term" will not.)
Note that selecting more than one term will not automatically result
in a table that shows trend data. You must also include Term as a table element
(That is, the pod should be in the table diagram). If you use multiple terms' data, but do not
specify Term as a table variable, data will be aggregated across terms. It is not possible
to unduplicate by term (that is, to count how may individuals meet certain criteria in at least one
term in a multi-term range). If you need unduplicated counts for a multi-semester period,
please contact the Office of Institutional Analysis directly.
Formatting variables:
With many variables, you have a choice about how the values will be categorized in your
table. This allows you much more flexibility to create the table precisely the way you
need it. For example, the default Degree Table Generator categories for age include the
range "25-29". However, if you need to know how many bachelor's degree recipients were over 25 (i.e.
26 or older), the default doesn't quite work. You can use the formatting window for Age
to tell the table generator to use a single cutpoint at 26, and your table will have just
two age categories -- representing "Under 26" and "26 and Older".
There are two types of formatting windows you may encounter. A few variables have a
limited number of formatting options available, and their formatting windows present a
drop-down list with the choices. Following is a list of those variables and links to
their data dictionary entries, where you can find specific details about formatting options.
The other type of formatting window appears for continous variables -- that is, variables like
Age or Attempted Hours that can take any value within an expected range. For these
variables a default rule for separating the values into categories has been assigned (these are
described in the variables' data dictionary entries), but you can apply a customized formatting
rule if you want.
The custom formatting rule for a continuous variable can take either of two forms: a list
of specific cutpoints, or an interval for equal-size ranges.
- To designate specific cutpoints, simply type the cutpoints in ascending order, separating
the values with commas. For example if you want to see data about three groups of students --
those taking less than 12 hours, those taking 12 to 17 hours, and those taking 18 or more
hours -- you would type "12,18" (without the quotation marks) in the formatting window for
Attempted Hours.
- To designate intervals, you use the form "byRatL", where R is the size
of each range and L is the low end of the lowest interval. For example "by10at15"
specifies that each of the categories should span 10 units (let's say years, in the case
of Age), and the lowest 10-year range should start at 15. This would result in
categories like 15-24, 25-34, 35-44, etc. Note that any values that are less
than L will still be reported in a catch-all category labeled "0-14". Either
R or L or both can be a negative number or a decimal, but they cannot contain
letters, special symbols (other than "-" and "."), or spaces. (Quotation marks in these
instructions are for clarity -- you should not type them in the formatting window.)
In cases where the university does not know (or did not know at the time the data were captured) the value for
a variable for one or more records, the missing data will be reported as a separate category, typically labeled
with a period (.).
Record duplication:
Enabling duplication by a variable in your table is a way of acknowledging that some
characteristics are not restricted to "one to a customer." For example, a student can have more
than one major at a time. If you specify an Enrollment Table Generator table showing students'majors but
don't enable duplication, you'll get a tabulation of students' primary majors, and the total for the table
will correctly reflect the number of students at the university (provided you didn't use
record selection). However, the number of students majoring in any given field may be under-reported,
because students who
declared the program as their second major will only be counted toward their primary program. If you run
the same table with duplication enabled, you will get accurate counts of the number of students in each
particular major, but the total for the table will be higher than the actual number of students at the
university.
The decision of whether to enable duplication is substantive, based on your needs. If you want each
student (or faculty member, course section, or degree) to be counted only once and you want the totals to be easier to interpret, avoid duplication.
On the other hand, if you want to be certain to count every instance of a characteristic and aren't
worried about the values in the totals, then you should use duplication.
It is only possible to enable duplication for one variable at a time.
When you enable duplication for a variable, it is automatically disabled for any other variable. You will
receive an alert if the table generator disables a prior setting in this way.
It is only possible to enable duplication when the variables are specified as column, row, or
page variables. Once the variable pod is in a column, row, or page slot, click on it to open the options menu, then
choose "Allow duplication for [students] with multiple values".
The following Table Generator variables can have duplication enabled.
Table options
The Table Options area at the left side of the Table Generator screen contains controls to access this help
page, control the table format, save or restore a pre-defined table layout, submit your table request, or reset
all parameters to their initial values. The Section Table generator also allows users to specify how cross-listed
courses should be tabulated.
Excel output
You can request your Table Generator output in HTML form (which will appear in your browser), or as an Excel
spreadsheet. The only substantive difference between the two is that HTML output has the variable labels hyperlinked
to their data dictionary entries. In fact, both forms of output are actually constructed in HTML -- the "Excel"
versions are just presented to your browser in a form that induces it to send the file to Excel for opening. Your
browser will probably ask whether you want to open the file or save it -- open it. Then Excel will typically issue a
warning that looks like this:
Select "Yes" to open the file. There is nothing harmful in it!
Storing table layouts
If you have a Table Generator request that you make repeatedly, you can save the specification to reuse later. Once
you have made the specification, click the "Save Layout" button. You will be prompted to give it a name. Choose something
that will help you identify it later, then click "OK". Note that only about 30 characters will show up in the selection
list.
Stored layouts write the table specification to a tiny cookie on your computer. This has a couple noteworthy
implications. First, you are saving the description of the table, not the table itself. Second, the save
layout is only available on the computer on which it was created. If you get a new computer, you'll need to recreate
your saved layouts.
Restoring saved layouts
Saved layouts are listed in a drop-down menu right above the "Submit" button. The list is pre-populated with some
general-interest layouts that are available to all users. Layouts that you have created personally will appear below
the prefabricated ones, in the order that you created them.
Remember that layouts that are with an explicit term specified will be restored with that specification. If
you intend to re-use the table to acquire updated data over time, you should use the "Most Recent Term" (or year)
selection in the records selection window rather than a specific term.
Managing saved layouts
If you have saved layouts that you created on your computer, you can rename or remove them. To do so, choose "Manage
stored layouts" from the layout selection list. (It should be at the very bottom, below the prefabricated layouts
and any that you've created. It won't appear on the list if you don't have any saved layouts.) The Manage Stored
Layouts window will look similar to the following:
You can delete or rename any of your layouts, then choose "Done" to save your changes. You can click "Cancel" to
exit without making changes. If you do save your changes, they won't be apparent on the Table Generator screen until
you refresh the page.
Data Dictionary:
Following is a list of data elements available in the
Enrollment Table Generator.
Term
The semester in which the student was enrolled. Note that
table generator data are captured on the census date for each particular term. This
avoids the ambiguities that result from reporting directly
from a constantly changing database. Results of table generator queries are stable --
you will get the same results today as you got yesterday if you use the same parameters.
A downside to the use of census data is that data that are incomplete or incorrect when
they are captured are not changed to reflect subsequent improvements.
By default, the most recent academic term with census data will be selected. For
fall and winter, the census occurs at the end of the first week, so current semester data
is generally available in the ETG beginning in the middle of the second week. In GVSU's Spring /
Summer semester, the census is during the 1st week of the 2nd session, so ETG data generally
become available during the 1st week of July.
Back to variable list
College of Major
This is the GVSU college that is responsible for the student's major. Note that the table generator groups
majors according to the college that currently administers them. Thus, even though the College of Liberal
Arts and Sciences wasn't created until 2004, the table generator will roll majors up to CLAS, even when
reporting data from before 2004. There is currently no way to use the Enrollment Table Generator to summarize
data according to older organizational structures.
If duplication by College is enabled, students with multiple majors will be counted
once in each college in which they have a major. Thus, a student majoring in Finance and Sociology would be
counted twice, once in Seidman College of Business, and once in the College of Liberal Arts and Sciences. A
student majoring in Finance and Management would only be counted once, since both majors are in the same college.
However, if
College is included (as a Column, Row, or Page variable) in a table for which duplication
by
Major has been enabled, each student will be counted once in each of her/his majors, and subtotals
for college may include double-counted students. (e.g. the Finance/Management student would be counted twice
toward the Seidman College of Business total.)
Back to variable list
Major
The student's academic major. Unless
duplication by major is enabled, only students'
primary major is counted. If duplication is enabled, students with multiple majors are counted once in
each appropriate program. A list of extant majors can be viewed by opening the Record Selection window from
the pod options window.
Back to variable list
Degree Sought
The degree toward which the student is working. Possible values are:
- B -- Indicates that the student is seeking a bachelors degree but has not yet declared a specific degree.
- BA
- BBA
- BFA
- BM
- BME
- BS
- BSE
- BSN
- BSW
- DPT
- M -- Indicates that the student is enrolled as a non-degree-seeking graduate student.
- MA
- MBA
- MED
- MHA
- MHS
- MNM
- MPA
- MS
- MSA
- MSE
- MSN
- MST
- MSW
Back to variable list
Emphasis
The student's emphasis or concentration within his/her major. Note that emphases tend to be under-reported,
with substantial differences among majors in the completeness of reporting. A list of extant emphases can
be viewed by opening the Record Selection window from the pod options window.
Back to variable list
Minor
The student's declared minor. A list of extant minors can be viewed by opening the Record Selection window
from the pod options window.
Back to variable list
Class
The student's classification. Values and definitions are as follows:
Freshman | 0-24 earned hours |
Sophomore | 25-54 earned hours |
Junior | 55-84 earned hours |
Senior | 85+ earned hours |
Masters | Graduate-level enrollment including non-degree and EdS students, but excluding those in doctoral programs |
Doctoral | Doctoral students |
An alternative formatting option that groups students into Undergraduate and Graduate is available.
See
Formatting Variables above for additional directions.
Back to variable list
Honors
Indicates students who were enrolled in the Frederik Meijer Honors College for the given term.
Back to variable list
Earned Hours
The total number of credit hours the student had earned at her/his level (undergraduate/graduate) as of the
census date for the term. Includes credits earned at GVSU and any transferred in from other institutions.
When used as a
data variable the number presented within the cells is the average credits earned by
applicable students. When used as a categorical (column, row, or page) variable, the default groupings are
0-9, 10-19, 20-29, etc.
Back to variable list
Non-GVSU Hours
The total number of credit hours the student has applied toward studies at the current level
(undergraduate/graduate) that were not earned at GVSU. This includes both transfer and AP/CLEP/IB credit. For
continuing GVSU students, this may include credits earned elsewhere after their initial GVSU enrollment.
When used as a
data variable the number presented within the cells is the average credits transfered by
applicable students. When used as a categorical (column, row, or page) variable, the default groupings are
0-9, 10-<19, 20-29, etc.
Back to variable list
Attempted Hours
The number of credit hours for which the student was registered as of the census date for the term.
When used as a
data variable the number presented within the cells is the total credits attempted by
all applicable students. When used as a categorical (column, row, or page) variable, the default groupings are
0-2, 3-5, 6-8, etc.
Back to variable list
FT / PT Status
Indicates whether students enrolled in enough credits in the term to qualify as full-time students. For
undergraduate students, 12 hours is the minimum enrollment for full-time status. Graduate students must
enroll for 9 hours or more to be considered full-time.
Back to variable list
Full-Time Equivalence
The ratio of a student's credit load for the term to a hypothetical full-time load. For undergraduates,
the denominator is 15 credit hours; for grad students it's 12 hours. Thus, an undergraduate student enrolled
for 15 credit hours is accounted as [15/15=] 1 FTE, while a graduate student taking 15 hours counts as
[15/12=]1.25 FTE.
When used as a
data variable the number presented within the cells is the total FTE for all
applicable students. When used as a categorical (column, row, or page) variable, the default groupings are
0.0-0.49, 0.5-0.99, 1.0-1.49, etc.
Back to variable list
1st Admit Type
This is the category of admission that applies to the student's first admission to GVSU. It is really
only meaningful for undergraduate students, since grad students who completed their undergraduate degrees
at another institution are categorized as "transfer" students upon admission to GVSU grad programs, even if
they have no prior graduate-level credit. The possible values are:
- FTIAC -- Student entered GVSU with no previous higher education experience
- Transfer -- Student entered GVSU with prior credit from another institution
- Continuing -- Student entered GVSU prior to the adoption of the current student records system, so it
can't be determined from the system what the student's status was upon initial admission.
Back to variable list
Term Admit Type
This is the category of registration that applies to the student for the term being reported. The possible
categories are:
- FTIAC -- Student has no previous higher education experience
- Transfer -- Student is new to GVSU, but has prior credit from another institution (Credits earned
concurrently with high school enrollment or in the summer immediately after high school graduation
do not contribute to this determination... students whose only prior credits were earned under those
conditions are admitted as FTIACs.)
- Continuing -- Student has attended GVSU previously. In that prior term, the student may have been a
FTIAC,transfer, or continuing student.
Note: If you want to distinguish students who were initially transfer students from "native" GVSU students,
use
1st Admit Type instead of this variable.
Back to variable list
Non-degree
Indicates whether the student was admitted as a degree-seeking or non-degree student. Note that both
undergraduate and graduate non-degree status are possible.
Back to variable list
Age
The student's age as of the census date for the term.
When used as a
data variable the number presented within the cells is the average age of
applicable students. When used as a categorical (column, row, or page) variable, the default groupings are
as follows:
- 0-17
- 18
- 19
- 20-21
- 22-24
- 25-29
- 30-39
- 40-49
- 50-59
- 60+
Back to variable list
Gender
The gender of the student, as recorded in the university's student records.
Back to variable list
Ethnicity
The ethnicity of the student, as recorded in the university's student records. Beginning in 2010-11, students
are given the option of reporting multiple ethnic backgrounds, so duplicative reporting by ethnicity is possible.
If duplication by ethnicity is not enabled, students who indicated more than one ethnic background are reported
as "2 or more",
unless they indicated Hispanic/Latino origin, in which case they are reported as "Hispanic",
following the reporting convention mandated by the US Department of Education. If duplication by ethnicity
is enabled, counts from semesters prior to to Fall 2010 are identical to the unduplicated counts.
Back to variable list
MI Residency
Indicates whether the student is a resident of the state of Michigan for the purposes of calculating tuition.
Note that some students are categorized as "International", meaning that they come from outside the US, but
have their tuition assessed at the in-state rate. Not all international students fall into this category, so
if you want data specific to international students, use
Citizenship to select records.
Back to variable list
Citizenship
The student's country of citizenship as of the census date for the term. A list of applicable countries can
be viewed by opening the Record Selection window from the pod options window.
Back to variable list
Visa Type
The students visa type as of the census date for the term. Possible values are:
- A1 -- Ambassador or diplomat and immediate family
- A2 -- Other foreign government official
- B1 -- Visitor for business
- CI -- US citizen
- E1 -- Treaty trader/investor
- E2 -- Dependents of investor
- F1 -- Student
- F2 -- Family of student
- G1 -- Foreign repres to an international org
- G2 -- Dependents of G1
- G3 -- Respres of non-recog international org
- G4 -- International assoc officer and family
- H1 -- Employment
- H2 -- Dependents of employee
- H4 -- Spouse/child of alien
- I -- International media and family
- IM -- Immigration card holder
- J1 -- Exchange visitor
- J2 -- Family of exchange visitor
- K1 -- Financee of US citizen
- K2 -- Dependent of fiancee
- L1 -- Inter-company transfer
- L1 -- Intracompany transfer
- L2 -- Dependent of L1
- L2 -- Dependent of transferee
- M1 -- Vocational nonacademic
- M2 -- Dependents of voc trainee
- NR -- Not required
- OT -- Other
- PR -- Permanent resident
- R -- Religious worker
- R1 -- Religious worker
- R2 -- Dependents of religious worker
- RF -- Refugee
- TD -- Dependent of TN
- TN -- Prof Can & Mex
- UN -- Visa type unknown
- WT -- Visa waiver
Back to variable list
Geog. Origin
This is the geographic origin of the student. For students who entered GVSU as Michigan residents, this
field contains their county of residence at the time of their initial application, For students who are
not citizens of the United States, the country of citizenship is reported. For all others, the state in
which their permanent address is located is reported. A list of extant place values can be viewed by
opening the Record Selection window from the pod options window.
An alternative formating options allows the students to be grouped into the following broader categories: Michigan;
Other United States; or International.
Back to variable list
On-campus residence
The residence hall (if any) where the student lived during the term. Three formatting options are available:
- Building Name - this is the default option. Student who do not live in a campus residence hall
are labeled "OFF CAMPUS"
- On-campus / Off-campus
- On-campus - Allendale / On-campus -Grand Rapids / Off-campus
Back to variable list
Allendale Campus
Indicates whether the student took one or more classes on the Allendale campus during the term
Back to variable list
Pew Campus
Indicates whether the student took one or more classes on the Pew campus in downtown Grand Rapids during the term
Back to variable list
Meijer Campus
Indicates whether the student took one or more classes on the Meijer campus in Holland during the term
Back to variable list
Muskegon
Indicates whether the student took one or more classes on the Muskegon campus during the term
Back to variable list
Traverse City
Indicates whether the student took one or more classes on the Traverse City campus during the term
Back to variable list
On-line
Indicates whether the student took one or more classes on-line during the term.
Back to variable list
First Generation
Students who answered "Neither" to the question "Have either of your parents graduated froma four-year
college? [Both / Father / Mother / Neither]".
Back to variable list
Veteran
Students who have indicated to GVSU that they are veterans or current members of the US armed
forces. GVSU began requesting this information on admissions applications in 2009-10, so data are
not reported for earlier semesters. Even after 2009, data are incomplete, since continuing students
who applied before 2009 are not required to re-apply. We anticipate that veteran data will be reasonably
complete and accurate beginning in about 2014.
Back to variable list
Section
The section ID of courses in which the student enrolled during the term. Note that duplication by section is
automatically enabled, meaning that a student who is enrolled in more than one section meeting given criteria
is counted more than once if
Section is used in the table.
There are three formatting options available for
Section:
- By section -- The full 11-digit (or 10-digit) section number is used (Examples: SPA 322 A, WRT 098 AA).
- By course -- The 7-digit section number is used (Examples: SPA 322, WRT 098).
- By prefix (rubric) -- The 3-character course prefix that indicates the broad content area of the course is
used (Examples: SPA, WRT).
Back to variable list
Headcount
The number of students who meet given criteria. This is the default data variable for Enrollment Table Generator
tables.
Back to variable list
Data Variables
This pod is a placeholder that controls how the multiple data
variables will be dispayed in your table. You can move it around in your table (to other
"Column", "Row", or "Page" slots), but the only way to remove it from the table is to
remove "Data" variables until only one "Data" slot is occupied, at which time the
Data
Variables pod will disappear. The
Data Variables pod will initially be placed
in an empty "Column", "Row", or "Page" slot if possible. If all of those slots are filled,
Data Variables will displace the pod in the second "Column" slot.
Back to variable list