Queries whose name begins with jmath. Primary contact is Lee Ann Bowles bowlesla@jmu.edu section last updated 3/29/2015.
Jmath003 (NTS): Dual enrollment in math crses. Returns students who have entered as freshman and received credit for a transfer course by "dual enrollment" from a community college. For the following courses: MATH 220, 205, 235 and/or 236 Want to know their placement score on entering JMU and the grades in any mathematics courses taken at JMU.
Jmath004 (NTS): MATH231/232 analysis. Returns students enrolled in MATH 232 for the prompted for term and the grades they received for MATH 231
Jmath005 (NTS): MATH236/237 analysis. Returns students enrolled in MATH 237 for the prompted for term and the grades they received for MATH 236.
Jmath006 (NTS): Math 108 analysis. Returns students enrolled in MATH 108 and when they took math107 and their grade.
Jmath007 (NTS): Math 207 analysis. Returns students enrolled in MATH 207 and when they took math107 and 108 and their grade.
Jmath008 (NTS): MATH205 course analysis. Returns students who satisfy ALL of the following: Have taken Math205 at JMU Have not taken Math155 or Math156 at JMU (nor had transfer credit for these) Scored 23 or above on the math placement test Took Math205 2 years or more after taking the math placement test.
Jmath009 (NTS): Math PME data JR/SR. Returns a list of students who qualify for PME membership as defined by the math department.
Jma009a (NTS): Similar to jmath009, but the logic is for Sophomores as defined by the math department.
Jmath010 (NTS): Freshman w/AP credit. Returns a list of incoming freshmen with MATH AP Credit and their grade for their first math course @ JMU.
Jmath011 (NTS): Math107 course analysis. Returns the following information for Math 107: Current students enrolled, shown by name. Year first enrolled at JMU. Current academic level. Math AND Stat Placement Scores. Ever took 107 previously. If took 107 previously, show term, instructor, and grade received
Jmath012 (NTS): Math108 course analysis. Similar to jmath011, but using math108 as the required course.
Jmath013 (NTS): Math207 course analysis. Similar to jmath011, but using math207 as the required course.
Jmath014 (TS): Major GPA w/test data. Prompts for a term. Returns major GPA for 23 different majors as desired. Includes 5 specific test scores and the grades for psyc101 and hist225.
Jmath015 (NTS): Course and test comparison. Prompts for a term range and up to four courses. Returns a list of students who have taken the course and specific test scores.
MBA
Queries whose name begins with jmba. Primary contact is Tisha McCoy mccoynta@jmu.edu and Tracie Esmaili esmailtb@jmu.edu section last updated 2/19/2018. On 2/19/2018 the logic used in several of the jmba queries which HAD contained a list of hard coded student group codes to indicate specific graduate program cohorts was replaced with new logic. The new logic uses the first three characters of the student group 30 characters description field and requires that it begin with MBA.
jmba01 (NTS): MBA students. Contains prompts for a range of admit terms for the three academic programs: GR120, GR125 and GR130 and the most current effective dated row for the given academic program. Person running this query is reminded to pay particular attention to the “CURRENT Status” and “Last term attended” fields.
jmba02 (NTS):COB MBA program analysis. Contains no prompts because the query is designed to return a distinct populations from “forever”. The population is defined as students in the three programs GR120, GR125 and GR130. The original course list was provided and hard coded. On 2/19/2018, the hard coded list was replaced to allow ALL GR career courses to be returned.
jmba03 (NTS): Basic student group data. Returns a list of students (NON UG careers) who have been assigned to any student group whose first three characters=MBA. User running this query should pay particular attention to the values returned in the fields Group Status and Program Status.
jmba04 (TS) Active MBA NOT in cohort. Returns a list of students currently active in one of the three programs: GR120, GR125 or GR130 who are NOT in an active student group whose first three characters begin with MBA.
jmba05 (NTS) Aggregate MBA stats. Users listed above do NOT have access to all records present, so they will not be able to see/run this query. Contains prompts for an admit term range for the three academic programs: GR120, GR125 and GR130. Returns aggregate counts for the following populations: Applied, Accepted, Enrolled and Graduated.
jmba06 (NTS): Individual Program application. Users listed above do NOT have access to all records present, so they will not be able to see/run this query. Permission was given for desmitpa to schedule this query and have the results sent to Tracie Esmaili. Uses a run control by the same name and a recurrence definition named MBA which is configured to run weekly on Monday’s at 10:30 AM. Results are currently being emailed to Tracie Esmaili. The query contains a prompt representing the admit term >= the value provided.
