Student Head Counts: By Faculty/Department/Qualification_m30dis

Management Report:

Student Information Student Head Counts: Click on: By Fac/Dept/Qualification

This Dashboard displays dynamic information from Enrolled_Students. This includes only the primary qualification of students.

User Filter Selection:

Academic Year

Faculty

Department Name

Qualification
Stats Ethnic Group

Gender

Post Graduate or Undergraduate

Selection Rules

This unduplicated student headcount, is done by counting all primary qualification registrations active in the Academic Year as selected by the end user via (filter). Where more than one primary qualification registration for a student may be active for the year (for example where Academic Blocks are longer than 12 months), the registration with the highest academic year / qualification number will be counted.

Example of m30dis

Academic Year	The user can select any YEAR from the Dashboard under this feature, and it will populate only on the GRAPH the desired measurment. IT WILL NOT update the SHEET only the bottom list.
Faculty	The user can select a FACULTY from the Dashboard, and it will populate only on the GRAPH the desired measurment. IT WILL NOT update the SHEET only the bottom list.
Department	The user can select a DEPARTMENT from the Dashboard, and it will populate only on the GRAPH the desired measurment. IT WILL NOT update the SHEET only the bottom list.
Qualification	The user can select a QUALIFICATION from the Dashboard, and it will populate only on the GRAPH the desired measurment. IT WILL NOT update the SHEET only the bottom list.
Post / Under Graduate	The user can select a GRADUATE TYPE from the Dashboard, and it will populate only on the GRAPH the desired measurment. IT WILL NOT update the SHEET only the bottom list.
Gender	The user can select a GENDER from the Dashboard, and it will populate only on the GRAPH the desired measurment. IT WILL NOT update the SHEET only the bottom list.
Ethnic Group	The user can select a ETHNIC GROUP from the Dashboard, and it will populate only on the GRAPH the desired measurment. IT WILL NOT update the SHEET only the bottom list.

The Summary List	The summary list is a list that is updated each time the user alters or selects a different entity on the Dashboard.
Students per Qualification	The list updates each time a user changes the filter on the dashboad, this column displays all the Students per Qualifications.
Gender	This column populates if the user selects from the filter "GENDER". If no filter is selected then both Genders print.
Grant Total	Total Head Counts of Students per Qualifications.

Example of List.

Example of the SHEET as per 2012 selection on filter.
The user can at any point in time, select from the drop down filters, and readjust the report to his/her desired outcome.

Example of Dashboard selected filters.
Also NOTE that the user can MOVE the Filters around on the Spreadsheet to suit there needs. By clicking on the filter next to the NAME of the filter, when the mouse poointer changes to moving the mouse

the user can move the filter around.

Example of Clearing the filters.:

P Please Note that if the user decides to Click "OPEN" directly, then the document in question is labled as "doexcel" this document SHOULD NOT be saved, it can be worked on.
The User will have to click on SAVE and then open the document for actual e.g mis21dis....!