First-Year Students Not Taking FYS Courses 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. Start by selecting the button you see when the database opens:   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.   Here is an example of the table that shows students that have taken a First-Year Seminar:   Here is an example of the table that shows students that have not taken a First-Year Seminar: This database is the following: Campus or College Specific Semester Specific Admit Semester Specific Click on Download Here to download the MS Access database.

Printer friendly view