Extracting individual student results from master result for printing on excel sheet

  • Hello, I want an excel program that will extract the contents (values of results) from the sheet (HND 1 FIRST) and display it as a sample of the first student (ABIODUN RACHAEL).

    • Out of the labels (Name, Matric No, Department, Programme, Session), the matric no will be the variable to use to get the name and the corresponding student.
    • The student results will automatically extracted into the new page for printing like the sample attached.
    • The Course Codes, Course Units and Course Titles are in the attached document as (COURSE)
    • In the each student result, the row with alphabet codes A, B, C, D, F, AB represent Grade column in the corresponding print result.
    • In the each student result, the row next to the grade’s row is the score row which is the actual score for each course and the value is expected to be copied into the score column in the print result page
    • In the each student result, the row next to the score’s row is the point row which is the actual point the student get for each course and the value is expected to be copied into the Credit Point column in the print result page
    • In the table below in the print result page, TCP is the total credit point of the whole courses boldened under Credit Point column. TNU is the total unit of the offered courses boldened under Unit column in the print result page. GPA is the grade point.
    • Previous TCP, TNU, and GPA is empty because the results is the first of it kind for the set of the student while Cummulative GPA, is the same values with the present GPA because it is the result of first semester.
    • Course Still Outstanding (CSO), represent courses that the student failed with grade of (F or AB) in the main result such as student with serial no 12, 15, 17, 26, 33, 38, 40, 41, 42 and 44. The student with course that carries this grade F or AB, should have the corresponding course code be copied infront of the CSO.


    Thanks in anticipation

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!