Creating Our Proprietary AI School Safety Assessment: Questionnaire Design with Automated Scoring and Reporting
Step 1: Define the Questionnaire
• Create a list of yes/no questions. Each "Yes" will be scored as 1, and "No" as 0.
• Group the questions into distinct categories or safety zones, organized by levels (e.g., Levels 1 through 4 with corresponding subsections)
• Example:
LEVEL 1: WALK-THROUGH ASSESSMENTS℠ (WTA)
Gates
1. Is the school equipped with perimeter barriers capable of stopping vehicles? (Yes/No)
2. Are the appropriate perimeter barriers or gates installed and secured by effective locking systems (e.g., electronic control, heavy-duty padlocks) when not in use? (Yes/No)
Step 2: Use a No-Code Platform for the Questionnaire
You can use no-code tools like Typeform, Google Forms, or Jotform to create the questionnaire. These tools allow you to design interactive and visually appealing forms without technical expertise.

1

2

3

4

1

Design the Questionnaire

2

Add Categories

3

Insert Questions

4

Enable Logic
1. Design the Questionnaire:
  • Add categories as headings.
  • Insert questions with a "Yes/No" toggle or button.
  • Enable logic to display scores dynamically (if the tool allows).
2. UX Best Practices:
  • Use clear instructions at the start.
  • Make it mobile-friendly.
  • Use progress bars for longer forms to enhance user engagement.
Step 3: Automate Scoring

1

Integrate Form Responses with a Scoring System
  • Use Google Sheets or Airtable to collect responses.
  • Add a formula to calculate scores. For example: =SUMIF(range, "Yes")
  • Divide the total by the number of questions for a percentage score.

2

Implement Weighted Scoring
For weighted scoring, multiply responses by a weight factor in the formula.

3

Review and Adjust
Regularly review the automated scoring system to ensure accuracy and make adjustments as needed.
Step 4: Generate a UX-Designed Report
To automatically create and design the report, you can use platforms like:

1

2

3

1

Advanced UX Reporting
Custom design tools like Figma for visually-rich, static reports

2

Branded Template Creation
Canva or Google Slides for report design

3

Data Collection & Report Generation
Zapier or Make for automation
1. Zapier or Make to automate data collection and report generation.
2. Canva or Google Slides for report design.
  • Create a branded template with:
  • Dynamic Safety Score (overall score).
  • Category Scores (e.g., Emergency Preparedness: 85%).
  • Insights and Recommendations based on scores.
3. Advanced UX Reporting Options:
  • Use Airtable Interfaces for live dashboards.
  • Use a custom design tool like Figma for visually-rich, static reports.
Step 5: Test the Flow
1
Test the form
Test the form with sample questions.
2
Generate sample reports
Generate sample reports to ensure scoring logic works correctly.
3
Adjust UX
Adjust UX for clarity and ease of navigation.
Optional Step 6: Use Professional Assistance for Custom Features

1

2

3

4

1

Professional
Designer or developer

2

Enhance Functionality
Custom features

3

AI-driven Insights
Based on questionnaire trends

4

Interactive Dashboards
Tableau, Power BI, or similar
• Engage designer or developer to enhance functionality if required:
  • Add AI-driven insights based on questionnaire trends.
  • Use interactive dashboards (via Tableau, Power BI, or similar tools).
Example Flow

1

1. User Experience
  • User answers a clean, visually guided gamification Yes/No questionnaire.
  • Progress bar shows completion percentage.

2

2. Real-Time Feedback
  • Upon submission, the app generates a Dynamic Safety Score (DSS) and displays actionable insights on a branded report - SafetyNet|REPORT℠.

3

3. Downloadable Report
  • Users receive a comprehensive report PDF SafetyNet|REPORT℠ summarizing results, strengths, and areas for improvement.
Guidance on Specific Tools
Building the Questionnaire Tool Recommendation: Typeform
Why?
  • User-friendly, interactive design.
  • Easy Yes/No toggle options.
  • Conditional logic to show/hide questions dynamically.
Steps:
  1. Sign up for a free account at Typeform.
  1. Start a new form and use "Yes/No" question blocks.
  1. Use categories as section headings (e.g., Emergency Preparedness, Behavioral Safety).
  1. Enable scoring via logic jumps or calculated fields.
Alternative: Google Forms
Why?
  • Simple and free.
  • Integrates easily with Google Sheets for scoring.
Steps:
  1. Create a form in Google Forms.
  1. Add categories using section breaks.
  1. Use multiple-choice (Yes/No) questions.
  1. Link responses to Google Sheets for automatic scoring.
Automating Scoring Tool Recommendation
Google Sheets
Why?
  • Free and flexible for simple scoring and calculations.
Steps:
  1. Collect responses from Google Forms or Typeform.
  1. Use a formula to score responses: Example: =COUNTIF(B2:B20, "Yes") for total "Yes" answers.
  1. Add weighted scoring if needed: Example: =SUMPRODUCT(B2:B20, C2:C20) where C is a weight column.
Alternative: Airtable
Why?
  • Combines data collection and scoring in one tool.
  • Great for creating visual dashboards.
Steps:
  1. Set up a base with questions and responses.
  1. Use formulas to calculate scores directly in Airtable.
  1. Create visual summaries with the Airtable Interface Designer.
Generating Reports Tool Recommendation
Google Docs with Zapier
Why? Automatically generate professional PDF reports based on questionnaire data.
Steps:
  1. Use Zapier to connect Google Forms or Typeform responses with Google Docs.
  1. Design a report template in Google Docs with placeholders (e.g., {{score}}, {{recommendations}}).
  1. Zapier replaces placeholders with real data and emails the report.
Alternative: Canva
Why? Design visually appealing, branded reports.
Steps:
  1. Use the free templates in Canva.
  1. Customize with your branding, logo, and colors.
  1. Export reports as PDFs for sharing.
Advanced Option: Airtable + Interface Designer
Why? Real-time dashboards and dynamic visuals.
Steps:
  1. Create an Interface in Airtable that visualizes scores and trends.
  1. Share links to the live dashboard with users.
Drafting the Questionnaire Structure

Tailored Structure
A tailored 4-Level structure for your school safety questionnaire:
LEVEL 1: Walk-Through Assessments℠ (WTA)
Our comprehensive assessment framework evaluates safety across multiple zones:
A. Exterior Assessment (19 Zones)
  • Fencing and walls integrity and monitoring
  • Playground equipment inspection and maintenance
  • Parking lot lighting and monitoring
  • Plus 16 additional exterior safety zones
Each zone requires a Yes/No response to ensure thorough evaluation of external safety measures.
B. Interior Assessment (25 Zones)
  • Fire drill regularity
  • Evacuation route markings
  • Emergency alarm testing
  • Plus 22 additional interior safety zones
Each zone requires a Yes/No response to ensure comprehensive internal safety assessment.
LEVEL 2: Behavioral Assessments℠ (BA)
A. Threat (8 Zones)
  • Is there a formal threat assessment policy in place? (Yes/No)
  • Are staff trained to identify potential threat indicators? (Yes/No)
  • ... (Complete the 8 zones under Threat)
B. Mental Health (13 Zones)
  • Are mental health resources available for students? (Yes/No)
  • Are staff trained to recognize mental health challenges? (Yes/No)
  • ... (List all 13 zones related to mental health support)
C. Bullying (9 Zones)
  • Are anti-bullying programs implemented school-wide? (Yes/No)
  • Is there a system for students to report bullying anonymously? (Yes/No)
  • ... (Complete the 9 zones focused on bullying prevention)
LEVEL 3: Safety Partnership Assessments℠ (SPA)
[Multiple Sections] (9 Zones)
1. Does the school have a partnership with local law enforcement? (Yes/No)
2. Are first responders involved in safety drills and planning? (Yes/No)
... (Complete all 9 zones under Collaborative Partnerships).
LEVEL 4: Comprehensive Systems & Security Assessments℠ (CSSA)
[Multiple Sections] (11 Zones)
  1. Are surveillance cameras installed and operational? (Yes/No)
  1. Is access to the school controlled via secure entry points? (Yes/No)
  1. ... (Complete the 11 zones focused on technology and infrastructure).
GRAND TOTAL: 94 Safety Assessment Zones
Exterior Assessment
19 zones covering perimeter security, playground safety, and facility monitoring
Interior Assessment
25 zones addressing internal safety measures and emergency protocols
Behavioral & Partnership Assessment
39 zones focusing on threat assessment, mental health, bullying prevention, and community partnerships
Systems & Security Assessment
11 zones covering technology infrastructure and security systems
This structured framework ensures a comprehensive approach to school safety, addressing every critical aspect of prevention, preparedness, and response.
Next Steps for You
1. Choose a Tool
  • Use Google Forms + Sheets for simplicity and cost-effectiveness.
  • Use Typeform + Airtable for a polished, interactive experience.
2. Build the Questionnaire
  • Start with the structure provided above.
  • Add specific questions unique to your school safety goals.
3. Set Up Scoring Logic
  • Use formulas in Google Sheets or Airtable for instant scoring.
  • Include weighted scores if needed.
4. Create the Report Design
  • Use Google Docs with a template for automation.
  • Alternatively, design a professional PDF with Canva.
5. Test the Flow
  • Run a pilot test with sample data.
  • Generate a sample report to ensure everything aligns.