Posts by chattycapulet4u

    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

    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

    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 coursesboldened 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.

    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 coursesboldened 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 for your effort to contribute. Apology for late response , it was due to the upgrade of the site. The questions are answered as follows: 1) There are many course. Course D8 - k8 are required to be done in the Second semester in the second year while course L8 - T8 ought to have been written in their second semester First Year. Some students that failed the courses while in that year must write it again in the second year before they graduate, that is why thoses courses are added with the regular courses (which means not all students will write courses L8 - T8- students needs to write the ones he failed)


    2) In sheet 2, the label- Name, Matric Number, Programme, Session, only Programme and Session will have static values. The matric number will be supplied manually into the space provided infront of it labe and while name of the student and the courses with their course codes, course titles, course units, scores , grades, previous GPA, current GPA, Cummulative GPA, and Course Still Outstanding (CSO, if any) will be filled automatically into the strucure presentend in sheet 4 of the newly attached files.


    3) CSO means Course Still Outsanding. The courses that the students failed( AB, F) that he must write again. The student (SINAOLA TINUOLA) in the attached is an example of it. The template will look like that


    4)The result for each student will be generated as the matric number is supplied into C9 and J11 is clicked.


    Find the attched for explanation.
    Note: SMITH AYOBBAMI passed all required course from inception, so he didn't have cause to write additional courses like SINUOLA INUOLA in the students results attached.


    Thanks

    Hello,
    Find the attached for sample of what I try to do. The sheet 1 contains results of all students and sheet will display all information about courses of each students. At the click of the SEARCH button in Cell J11 in sheet 2, the Name (C8) and Matric No (C9) and results of the student with the Header( S/N, Course Code, Course Title, Course Unit, Score, Grade and Point) in A12 to G12 should be automatically extracted from sheet 1 based on the number of courses the student registered for. Also The Previous, Present and Cummulative grades should be extracted to the spaces provided. Students with Course still outstanding columns should be listed infront of A 25 in sheet 2. NOTE: Instead of manually writing the course code, course title,course unit, score, Grade and point, it should be extracted automatically and courses not registered by students should not be added.
    - In Sheet 1, Row 8, from D8 to T8, it represents the Course Unit
    - In Sheet 1, Row 7, from D8 to T8 , it represents course code
    - In sheet 1, for each student e.g Row 10, D10 to T10 contains the Grades
    - In sheet 1, Row 11, D11 to T11, contains the score
    - In sheet 1, Row 12, D12 to T12, contains the Points.
    Thanks

    Re: Extraction of row contents to another sheet


    Quote from nyatiaju;800660

    Check updated file:

    Your time and effort is acknowledge. I tried the updated code but the dsiplay for the results ommited first 2 rows before it displayed. Also, how can the code populate the results automatically by displaying the course code, course title, score, grade, and point for each student itself without instead of just extracting the value to the designed rows and cloumns. The reason being that some students wrote more courses than others. Instead of manually treaming/deleting the irrelavant courses, the only written courses will be the one to show. I appreciate you.

    Re: Extraction of row contents to another sheet


    Quote from nyatiaju;800643

    Try attached file:


    I got your response and it worked. What if the name of each student in cloumn 3 of sheet should be extracted to the column C8. Also the TCP,TCU and GPA contents for the PREVIOUS semester. Also, the TCP, TCU, and GPA for the present semester. And the contents of cummulative TCP, TCU and GPA should be extracted to the provided space in the new attached file in sheet 2. ALso, the courses the student failed and needed to be rewritten should be extracted into space provided in row 25 of sheet 2. Instead of manually peparing the template for the extraction, the code should populate the registered courses and results automatically instead of the template I created for the title (S/N, Course Code, Course Title, Score, Grade, TCP). Your effort is appreciated.

    Hello , I want to extract the contents(Results) of each student in the sheet1 of the attached file to the prepared template in the sheet2 of the attached file. At the point of entering the matric no in cell C9 in sheet 2 and pressing the matric no button in the cell B9 in the sheet2 the contents will be transfered to the spaces provided for the score, grade and points and also the TCP and GPA will be auto filled.