How Should I Prepare My Data File to Upload to the Panorama Platform?
What You’ll Learn
We know that gathering data about your students, staff, and families isn’t always easy, so we want to help. Use this guide to interpret and resolve some common data file errors. Email us at email@example.com if you have any other questions.
Note: These data file templates are optimized for our online clients who are uploading their data through Panorama's survey portal. If you work with a project manager at Panorama, your data file template may look slightly different.
Why Data Format Matters
When running a survey administration, it’s critical to have data that is formatted correctly in order to be accepted by our platform and to ensure that the correct surveys are created for the correct survey-takers. Ensuring your data is formatted in such a way that our platform can read your data file will allow the data file upload stage in the process to happen quickly and successfully.
Download the appropriate data file templates so that you’re aware of the information that is required by our platform in addition to the optional information that may provide additional insights on your reports. Each of these data templates also includes some sample data to help you better understand what is expected in each column of the .xlsx file.
NOTE: Once your file is ready, please make sure to delete the sample data sheet from your file before uploading it to the platform.
| Data Templates for Feedback Surveys
||Data Template for SEL Measures|
| Student Surveys about Schools
Student Surveys about Teachers
Family Surveys about Schools
Teacher/Staff Surveys about Schools
| Student SEL Self-Reflection
Teacher SEL Reflection
Data Quality Checklist
Complete each step of this Data Quality Checklist before uploading any data file. For more information and guiding screenshots of Panorama's platform, see our Data File FAQ Two-Pager.
- Make sure your data file is formatted as an .xlsx file: Uploading a file in a .csv or .xls format will cause your file to get "stuck". Make sure to always check your file extension before uploading it to the platform.
- Remove duplicates or empty/incomplete fields: Check for and remove duplicate ID numbers, duplicate or empty email addresses, or email addresses that are incomplete.
- Remove all hyperlinks from your data file: Occasionally, entering email addresses in your data file will create hyperlinks. Our platform cannot support importing hyperlinks, so please remove or undo all hyperlinks before uploading your data.
- Remove all blank rows from your data file: The data file upload will stop at the first blank row in your file, so only the data appearing above the first blank row will be imported into our platform.
- Use only numeric values for grade levels: Only use 3-12 to represent grade level. Avoid “grade 3” and “3rd”, for example. Note: For Family and Teacher Perception of Student (TPOS) surveys, if you must include data for Pre-K and Kindergarten, please assign a numeric value to each grade level. For example, use the number 0 for Kindergarten and -1 or -2 for Pre-K.
- Match your column headers with the data file template: This will ensure that the platform recognizes all columns correctly. If column headers do not match the template, the platform will think required information is missing!
- Ensure the school and/or district names match any previous data uploads: If not, you’ll create a new school or district rather than adding to the existing one! This can negatively impact your reporting experience.
- Make sure to delete the "Sample Data" sheet from your data file: If you used any of the templates included above, they might contain sample data that will need to be deleted before your final data file is uploaded. We ask you to do this in order to avoid the platform reading the information from the incorrect tab. If after you upload your file you see only 10 students listed, this might be why! Make sure to re-upload your file without this extra tab and this should solve the problem.
Review these data file guides to learn more about the information that is required by our platform and the optional information that may provide additional insights on your reports. Understanding what kind of information is required in which column of your data file with examples can help you see around corners and identify areas where you may need additional support accessing data.