+ Reply to Thread
Results 1 to 6 of 6

Creating individual student reports

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    Uk
    MS-Off Ver
    Excel 2010
    Posts
    3

    Creating individual student reports

    Hi everyone (new on here).

    I have a database with 500 student names, there student numbers, there class and the number of times Present, absent, Authorised absent without uniform and the final column is their average daily grade.

    I would like to create individual reports for each student that i can print out (A4) and put into their individual files.

    The report needs to include student name and number, their class and the 4 pieces of data (attendance data and average daily grade) + a comments box (unfortunately will have to be manually filled).

    Is there any way i can do this from an excel spread sheet?

    Thanks very much in advance!

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Creating individual student reports

    Hi 1987,

    Welcome to the forum.
    What format (databae) you have ...?

    Can you extract the data from that database into Excel .. please upload that extract. thanks

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    05-09-2012
    Location
    Uk
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Creating individual student reports

    Hi sorry for the late reply been busy at work!

    So this is a sample of the excel spreadsheet i am working from.book3.xlsx
    To explain the cream coloured data is their attendance code for the week mentioned in the header.
    The sky blue is their score for the above week and the final 5 colums are the totals which need to be included in a report.

    Is there anything i can do from this to create individual student reports that can be printed and put into the individual student files?

    What would be even better is as well as the report containing the 5 end colums (the totals/averages) if i could include some kind of written statement bank which is given depending on their grade.!

    Thanks again,
    C1987
    Last edited by c1987; 05-15-2012 at 12:04 AM. Reason: (explaining the spreadsheet)

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Creating individual student reports

    Hi C1987,

    You can use pivot table in this case which will source the data from Sheet1.... see the attached file.. sheet "Pivot".

    book3(1).xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

  5. #5
    Registered User
    Join Date
    05-09-2012
    Location
    Uk
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Creating individual student reports

    Hmm thats good but not really what i wanted.
    Is there any way of populating into a word document form?

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Creating individual student reports

    Yes... you can create separate sheets with required pivots and then you can copy - paste special - link as RTF in different word pages.... now you can easily refresh these word documents when there is any change in excel pivots... thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1