Setup/Enabeling the Module
Place a Jira ticket requesting Survey module addition to Dossier
Please provide the user groups (PowerSchool group) that you wish to have access to:
Survey module reporting
Survey settings (mapping the file results to the reporting and filtering
Survey Upload - who can upload a new set of results
Survey Results Requirements
The Division Feedback Surveys module expects:
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
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”)
If these requirements are met the process can continue.
Survey creation and upload
If you are creating a new survey:
Click on the Upload in the top navigation
Click the green + icon on the right side of the survey list
Name the Survey
Identify which school year the survey results are for
IF multiple worksheets in one excel file
Enter the worksheet names for student, parent and staff results
Upload the file
Save
This pulls all the raw data into the system
IF there are multiple excel files
Choose which file you are going to start with
Enter that worksheet name leaving the others blank
Upload the file
Save
This sets up the Survey and the initial imported data
Then for the other files:
Click the upload data icon on the right side of the Survey the data is for
Skip the data already uploaded
Enter the name for the worksheet to be imported in the identified data category (Student, Staff, Parent) - the data to be added will show new
Upload the file
Save
Repeat for other files
If you are replacing or adding data:
Click upload icon
For each respondent type select Additional Data (adding to existing), Replace (remove original data and upload as new), or skip