How To Create a Report in Veracross to view the Number of Emails Parents Receive
What is a reasonable number of emails to get from a private school? If you use a Student Information System (SIS) to relay all emails via distribution lists then you should be able to generate a report to get this information. The short tutorial below walks you through what this looks like in one SIS called Veracross.
1. Pop out the Communications Summary Detail on a random parent person record.
2. Click on the Design button.
3. Remove the Person ID field.
4. Add the Role Field twice. Make the first field specify to include the Parent Role. Make the second one hidden and then specify to not include the Staff and Faculty Roles.
5. Specify a Date Sent date. For example, you can put in the first day of school.
6. Add the Full Name field to the query and click Summarize.
7. (Optional 1) Remove Parents with Multiple Children to get the most accurate average
8. (Optional 2) Adjust the report to only show specific Grades.
9. Run the query and export the results to an Excel File.
10. Use the average function in Excel to get an average.
How to Create Name Badges in Veracross that include Children’s Names
How To Edit Your Zoom Recording in the Cloud
About The Author
Tim
Tim Schwartz brings over 25 years of experience in the tech space. A lifelong learner, Tim has spent his career in spaces that allow him to combine his loves of technology and education. He cites his 12 years working abroad in a foreign language along with his BA in cultural anthropology for his deep understanding of the humanity behind different perspectives—a valuable and somewhat rare skill among technologists. Tim focuses on strengthening cybersecurity while increasing employee productivity, centralizing mobile device management, automating identity management and access, digitizing analog workflows, and introducing marketing automations to provide a positive—and digitally secure—experience for both employees and clients. Tim’s love of not only learning but also sharing what he knows extends far beyond the realm of technology. He holds a master’s degree in teaching Japanese as a foreign language, and he has authored numerous articles about improving early education and parenting.