πŸ“š How To Use Feedback Analytics

Complete guide to uploading your feedback data and analyzing it with our powerful analytics platform.

πŸ“‘ Quick Navigation

πŸš€ Getting Started

Quick Start (3 Steps)

  1. Prepare your feedback data in Excel format with the required column headers (go to the Google sheet provided by Debin and download it as an Excel file)
  2. Upload your file using the "Upload Data" button
  3. View comprehensive analytics instantlyβ€”no installation required
⚠️ Important First Step: Don't edit the downloaded Excel sheet.

What You Can Analyze

Once your data is uploaded, access these analytics features:

βœ… Analyze Data Quality

Check for missing values, data validity, and identify potential issues in your feedback responses.

πŸ“Š View Statistical Distributions

Understand score distributions with histograms, boxplots, and summary statistics (mean, median, IQR).

πŸ’¬ Sentiment Analysis

Automatically analyze the sentiment of text feedback to identify positive, negative, and neutral responses.

🏷️ Topic Modeling

Discover key themes and topics in open-ended feedback using advanced NLP techniques.

🎯 Key Driver Analysis

Identify which factors most strongly influence student satisfaction scores.

πŸ“ˆ Historical Trends

Track feedback metrics over time by academic year and course to identify improvement areas.

πŸ“‹ Preparing Your Data

File Requirements

Your feedback data must be in Excel format:

Sample Files -->

🎯 Try with Sample Files

Want to explore the system without your own data? Download one of our sample feedback datasets to see how the analytics work:

βœ“ Available Sample Files:
1 Download Sample File: Click on any sample file above to download it to your computer.
2 Upload to the System: Go to "Upload Data" and select the downloaded file.
3 Explore Features: Navigate through all analytics tabs to understand what insights you can extract from your own data.

πŸ’‘ These sample files contain real (anonymized) student feedback data with all required columns. Perfect for learning how the platform works before uploading your own data!

πŸ“€ Uploading Data

Step-by-Step Upload Process

1 Click "Upload Data" button on the home page or from the navigation menu.
2 Select Your File: Click "Choose Files" and select your Excel file (supports .xlsx, .xls, .csv).
3 Review Preview: The system will show a preview of your data. Check that columns are correctly identified.
4 Submit for Analysis: Click "Analyze Data" to start the analysis process (may take 30-60 seconds for large datasets).
5 View Results: Navigate through different analysis sections using the dashboard tabs.
πŸ’‘ Tip: You can upload multiple files if your data is split across several Excel sheets or filesβ€”the system will combine them automatically.

πŸ“Š Understanding the Analytics

Overview Tab

The Overview section provides a comprehensive health check of your feedback data:

Data Quality Metrics

Missingness: Shows percentage of missing values per column. Green (low) to red (high) severity indicators help you identify data gaps.

Validity Checks

Valid vs Invalid Scores: Counts how many score values are within the expected 1-7 range. Invalid entries are marked for review.

Straightlining Detection

Response Fatigue: Identifies respondents who gave the same score to all questions (possible lack of engagement or fatigue).

Distribution Plots

Histograms & Boxplots: Visual representation of score distributions. Look for patterns, outliers, and overall satisfaction levels.

Sentiment Tab

Analyzes the emotional tone of open-ended feedback using VADER sentiment analysis:

Sentiment Breakdown

Each text column is analyzed for positive, negative, and neutral sentiment. Scores range from -1 (very negative) to +1 (very positive).

Interpretation

Use these insights to understand the overall tone of feedback and identify areas of concern (high negative sentiment) or satisfaction (high positive sentiment).

Topics Tab

Extracts key themes from suggestion text using advanced topic modeling:

Top 5 Topics

Automatically discovers the most common themes in student feedback. Hover over topic bars to see the related keywords.

Topic Sentiment

Shows sentiment distribution within each topic (positive βœ…, neutral ➑️, negative ⚠️).

Topic-Score Correlation

Heatmap showing average score values for feedback within each topic. Darker colors = higher scores.

Key Drivers Tab

Identifies which factors most strongly influence overall satisfaction (future_score):

Feature Importance

Ranked list showing which competencies (competency, clearness, availability, approachability) matter most to students.

Priority Matrix

Plots factors by Importance vs Satisfaction, with 4 quadrants:

Historical Trends Tab

Tracks feedback metrics over time:

Overall Trends

Line chart showing average scores across all 5 competencies over academic years and terms.

Course-Specific Trends

Drill down by individual course (subject_code) to see improvement areas and track course-level performance.

πŸ”’ Security & Privacy

How Your Data is Protected

βœ“ In-Memory Processing: All data is loaded into secure RAM. Nothing is permanently stored on disk.
βœ“ Session Isolation: Each upload creates an isolated session. Your data is separate from other users.
βœ“ Auto-Cleanup: Sessions expire after 30 minutes of inactivity, automatically clearing all data from memory.
βœ“ HTTPS Encryption: All communication is encrypted end-to-end using industry-standard SSL/TLS protocols.

❓ Frequently Asked Questions

What happens to my data after analysis?

Your data is never stored. After 30 minutes of inactivity or when you close your session, all data is automatically deleted from memory. You can download results as images or export analytics before your session expires.

How long does analysis take?

Analysis typically takes 30-60 seconds for datasets with 200-500 responses. Larger datasets may take longer.

Can I upload multiple files at once?

Yes! You can select multiple Excel files and the system will combine them into a single dataset for analysis.

What if my data has missing values?

Missing values (empty cells) are treated as NaN. The Overview tab will show you the percentage of missing data per column. Some analyses (like sentiment) skip rows with missing text, while others (like distributions) exclude NaN values from calculations.

Can I re-upload data to refine the analysis?

Yes! You can start a new upload session anytime. Each session is independent and isolated from previous analyses.

How do I interpret the topic labels?

Topics are automatically extracted from your feedback text. Each topic is represented by a set of keywords. Review the actual feedback comments to understand the context.

What does "Cronbach's Alpha" mean?

It's a measure of internal consistencyβ€”how well the 5 competency scores correlate with each other. Values above 0.7 indicate good reliability. Higher values suggest the competencies are measuring related constructs.

Can I download the charts and data?

Yes! All charts are generated as high-quality images that you can right-click and download.

What if I have sensitive or confidential feedback?

This platform is designed for confidentiality. Your data is secure in memory and never stored. After your session expires, it's completely gone.

Ready to Get Started?

Upload your feedback data and start analyzing in seconds.

Upload Data Now