IQA Dates with Feedback

This report allows you to report on IQA feedback records across your portfolios.  

1. Generating the Report:

1.1    If you want to see all IQA feedback in the last month, set the filters as follows:

    Verification Feedback Date:
    Start Date: Select a date
    End Date: Select a date

    Evidence Verification
    Select: I want to see evidence Internal Quality Assured by: leave as any IV, or select a user

1.2    Click ‘Generate Report’

Note: If a candidate is on a course with more than one learning aim, you will get a row for each learning aim, so you will need to remove duplicates see Step 2

2. Exporting the Report:

2.1    Click ‘Export to Excel’, and ‘Enable Editing’, and depending on your version of Excel, you might need to format cells E,F,M,S     back to dates
2.1    Next, click ‘Data’ in the Excel menu
2.3    Select ‘Remove Duplicates’, which will open a dialogue box
2.4    Select only CandidateName and IVTimeStamp
2.5    Click ‘OK’

Note: The excel sheet will now be displaying a row for each IQA feedback record.  There still might be more than one row per candidate, but the feedback date stamp (column M) should be different.