First-Year Students Not Taking FYS Courses
This database can be used to determine which first-year baccalaureate students, registered for the current semester in a specific college or at a specific campus, did not take a first-year seminar class.
Once you have selected the above button, you will see a table like shown below, but without the red boxes. The red boxes are shown here to indicate where you need to input your criteria:
COLLEGE CODE: Use to receive college/department specific data (if you do not want a specific college, leave this blank).
Examples include:
LA = Liberal Arts
HH = Health & Human Development,
BA = Business Administration
CAMPUS CODE: Use to receive campus specific data.
Examples include:
UP = University Park
BR = Beaver Campus
BK = Berks-Lehigh Valley Campus
ADMIT SEMESTER: Use to receive specific students that were admitted in a specific semester.
Examples include:
199900FA = First-Year Students in the Fall of 1999
199900SP = First-Year Students in the Spring of 2000
"199900FA" Or "199900SP" = First-Year Students in the Fall of 1999 or Spring of 2000
Note: This query also contains the field code_stud_majr_lvl which we have set with "A" as the criteria. This means that the query will only pull undergraduate baccalaureate degree students, since undergraduate associate degree students are not required to take a first-year seminar.
Now close this table and run the four queries as seen on your screen (and below) in the order in which they appear.
Campus or College Specific
Semester Specific
Admit Semester Specific
Click on Download Here to download the MS Access database.