Student Reports

This query retreives the detail information of the credit results generated from external test scores (eg. Advanced Placement, GCE A-Level, Transfer Credit, International Baccalaureate). It contains a Detail by Student pivot report which shows the credit results generated for each of the student. The credit result record includes items such as the generated credit subject code and the units, the applied credit subject code and the units, the registration subject code and the units. There are also summary counts by Generated, Applied, and Registered credit tresults. Limits (search criteria) of the query are: entrance term code, credit result category (e.g. A-Level, Advanced Placement, Transfer Credit, International Baccalaureate), and Generated Credit Subject Code (eg. '5' for Chemistry, '8' for Physics, '18' for Mathematics).

Huey Chan

06/07/2004

This query retrieves the detail information of the credit results and the test scores that are associated with the credit results. Limits (search criteria) of the query are: entrance term code, credit result category (e.g. A-Level, Advanced Placement, Transfer Credit, International Baccalaureate), and Generated Credit Subject Code (eg. '5' for Chemistry, '8' for Physics, '18' for Mathematics). One report groups the detail information by generated credit subject and another report groups the information by student. Items displayed in the reports include: Full name and MIT ID of the student, generated and applied subject information (with subject code, subject number, and number of units), apply credit message, the credit result category and name, and the test category, test code, and test description.

Huey Chan

06/07/2004

This query retreives the detail information of the external test scores which include the test code, test component code, test description, test score value, and the test taken month and year. The limits of the selection are: entrance term, test category, and test description. In addition to a Detail by Student pivot report, the query also includes a summary section of number of test scores by test category (eg. AP, A-Level, Transfer Credit) and test.

Huey Chan

06/07/2004

The total and average loan debt of a student graduating from MIT by term. This query contains two reports. The first report shows the total amount and the average amount of loans by degree within a department. The second shows the total loan amount for each student by degree within a department.

Huey Chan

03/23/2000

Report showing undergraduate and graduate student award information. There are two report tabs, one by fund type (federal, etc.) and one is by individual student. Limit criteria are year, Y/N registered, and department.

Huey Chan

03/13/2000

Report showing the itemized costs for students attending MIT, for example: books, tuition, board, room.

Huey Chan

03/13/2000

Shows financial support (tuition, stipend, insurance) history for one student. Limit criterion: student's MIT ID. There are two views/tabs in this report: (1) Student Support History - shows the individual student financial support history by academic term, includes information such as appointment type, level of effort, awarding department, and cost collector. (2) History by Cost Collector - summary of amount awarded to the student by cost collector and academic term.

06/25/2002

This query is for use by authorized administrators. The query will return a list of all students in a selected term enrolled in a selected Department (Grad Course 1, Grad Course 2, or Grad Course 3), grouped by program and amount of tuition assessed. There are two formatted reports, one summarizing the number of students at each level of tuition assessed, and a detailed report listing each student.

11/21/2005

For an awarding department, shows and overview of student financial support by sponsor. Limit criteria: Awarding department and term code. There are three views in this report: (1) Detail by Sponsor - shows the detail funding information (including appointment type, level of effort, home department, award status) for each student in the selected awarding department and academic term, grouped by sponsor name (with sponsor code) and cost collector. (2) Summary by Sponsor & Cost Collector - summarizes the amounts of tuition and stipend awarded for the academic terms by sponsor and cost collector. (3) Summary by Sponsor & Student -- summarizes the amounts of tuition and stipend awarded for the academic terms by sponsor and student.

06/25/2002

Student Financial Support for Awarding Department For an awarding department, shows student financial support by academic term. Limit criteria: Awarding Department and term code. There are five views in this report: (1) Detail by Cost Collector - shows the detail funding information (including appointment type, level of effort, home department) for each student in the selected awarding department and academic term, grouped by cost collector and GL account. (2) Detail by Student - shows the funding information (including appointment type, level of effort, home department, and cost collector) of all students in the selected awarding department and academic term. Records are sorted by student's name. (3) Summary by Cost Collector - summarizes the amounts of tuition, stipend and insurance awarded for the academic term by cost collector. (4) Summary by Student - summarizes the amount of tuition, stipend and insurance awarded to each student for the academic term by appointment type (Fellowship, Reseach Assistant, Teaching Assistant, etc.) (5) Different Departments - shows the funding information of students in the selected awarding department who are enrolled in another department, in other words, students whose awarding departments are different from their home departments.

06/25/2002

For a graduate home department, shows student financial support by academic term. Limit criteria: Graduate Home Department, and term code. Five views are included in this report: (1) Detail by Cost Collector - shows the detail funding information (including appointment type, level of effort, awarding department) for each student in the selected home department and academic term, grouped by cost collector and GL account. (2) Detail by Student - shows the funding information of all students in the selected home department and academic term, including appointment type, level of effort, awarding department, and cost collector. Records are sorted by student's name. (3) Summary by Cost Collector - summarizes the amounts of tuition, stipend and insurance awarded for the academic term by cost collector. (4) Summary by Student - summarizes the amounts of tuition, stipend and insurance awarded to each student for the academic term by appointment type (Fellowship, Reseach Assistant, Teaching Assistant, etc.) (5) Different Departments - shows the funding information of students in the selected home department who are supported by another department, in other words, students whose home departments are different from their awarding departments.

06/25/2002

Shows "Who is Teaching What" information as recorded on MITSIS, including data about the roles (e.g., Lecturer, Tutor, Grader, Administrator) of instructors in various sections of subjects offered by academic term. This report has three views: detail by Master Subject ID, detail by Instructor, and detail by Subject ID.

Huey Chan

12/21/2000

Shows instructors and their roles in different sections of different subjects by academic term for MIT Subject Evaluation. This report has two views: detail by Master Subject ID and detail by Instructor.

Huey Chan

12/21/2000

This query retrieves the detail information of student pre registration records for specific academic term(s) and subject(s). Class List is included as one of the reports in this query.

Huey Chan

06/29/2004

This query contains summary and detail reports about degrees (PhD, MNG, MBA, SM, SB, etc.) awarded to students for specific academic years.

Huey Chan

07/03/2003

This query contains two summary reports that display the number of registered students in each of the subjects offered by a selected course/academic department for particular academic terms. The first is grouped by Subjects; the second, by Master Subjects. There are also detail reports which show the number of registered students in each of the sections of the offered subjects (e.g., Lecture, Lab, Recitation). Limit criteria are: academic term code and course number.

01/29/2001

This query contains several student subject enrollment reports with different levels of detail and organization (e.g., grouped by Subject or Master Subject). The Detail reports show all the students registered in each of the sections of the subjects offered in a selected course/academic department. Limit criteria: academic term and course number.

01/29/2001

This query shows a list of subjects and the responsible faculty for the subject, by academic term and Course.

08/04/2006