Content Comparison

...

• 3 respondent types: Student, Parent/Guardian, Staff

  • These can be separate files OR worksheets in a single excel workbook

• Excel spreadsheet:

  • First row to be a header row identifying the columns

  • All other rows are expected to be data rows

  • Columns are expected to be:

    • Survey data (times, ip addresses, etc.) - not used in the module

    • Filtering data (school location, FNMI declaration, etc.)

      • NOTE: School (by number or name) is required for filtering by location and data access

        • MAKE SURE if number then it is PowerSchool school_number, if school name must match PowerSchool school name exactly

    • Questions

      • It is expected that the column header value is the full text of the survey question

      • It is expected that the data rows contain the text of the answer (“Agree” not “1”)

...

• Click the + icon on the right side of the Reports table (below the Survey Columns section - it may be collapsed

  • Select the column (will be shown by the content of the column which should be the question text)

    • You may select multiple columns that you want to group - they will have the same report type and must all have the same response sets

  • Change (if desired) the Name of the column (remove #, reword for reporting, etc)

  • Select the Report Type (Bar, Donut, Qualitative)

    • Note: Qualitative data is not currently reported on

  • Select the Color Schema matching the responses to the question

  • Enter the order in which you would like to see this on the page

  • Save

At this point the Reports area will display the defined reports for the selected Survey