|
Enrollment Data Instructions
Access Instructions
Your access is authorized based on your network username and password. The domain name is fortlewis. If you encounter problems logging on, contact Amy Yeager in the Institutional Research office to obtain authorization.You will first have to log off and back onto the network to activate the authorization. If you currently have access, you can go directly to the Enrollment Data by clicking below:
Go Directly to Enrollment Data
- Select the file that you want
- Census Enrollment Summary Data-Adobe Acrobat (.pdf) file contains static enrollment data for each term at census-you can control click on all files
- Current Term
Enrollment Data
Student and course data for the current term are electronically available as a joint project of the Offices of Records, Computing, & Institutional Research. Data come from Banner and are in an Excel spreadsheet (version 2.1). The datasets include the most common data elements traditionally requested. Please note that data are updated regularly, and will change as students add and drop courses, enroll & withdraw, and otherwise modify their records. These data are available in two ways.
For Crystal Designer, MS Query and Access (ODBC) users the tables are:
FLC_STUDENT_CURRENT_REG
FLC_STUDENT_REG_COURSES
Upon opening the website you will see four files: Documentation includes a DATA DICTIONARY for each excel file which defines and explains all fields in the file. Please open these files first and read the descriptions. Most users find that keeping a printout of these dictionaries is very useful.
We suggest that you save that part of the spreadsheet which you will use on your own hard drive, floppies, zip or M: drive. Because these files are relatively large, saving the whole file(s) on your network drive could consume a good part of your disk quota. At the end of the term data will change to the next current term (i.e. data will change from Fall to Winter on the last day of Fall classes), so you may want to save data to an archive file if you think you will need it again.
The CURRENTLY ENROLLED STUDENTS spreadsheet contains one row per enrolled student. Basic background information about students such as gender, ethnicity, major, minor, student type, class, advisor, credits earned (prior to the beginning of the term), GPA, academic standing and graduation status is contained. Both permanent and local addresses with telephone numbers as well as FLC email addresses are included for those of you who want to contact students. It is very important NOT TO CONTACT any student who shows a Y (Yes) flag in the CONFIDENTIALITY_FLAG field (column D). All FLC employees are required to keep student data confidential according to the Family Educational Rights & Privacy Act (FERPA).
The CURRENT TERM REGISTERED COURSES spreadsheet contains one row per student per class. Student data, including ACT, SAT and Index as well as demographic information, are contained in this view along with the basic course information for which the student is registered.
The User Helpline (x7444 or helpline@fortewis.edu) can assist you with questions about Excel. If you have specific questions about the data that are not addressed in the data dictionaries, please contact Amy Yeager (x7426 or yeager_a@fortlewis.edu). | 
