Examples

Here are example queries to get you started. Feel free to copy these and change what you need.

Persistence and Completion Prediction Queries

• Average Persistence and Completion Scores by Origin
• Average Persistence and Completion Scores by GPA Band
• Average Persistence and Completion Scores by Term
• Dropped Students with Low Persistence and Completion Scores
• Student Predictions by Credit Load
• Average Persistence and Completion Scores by Transfer Credit Band
• Financial Aid Impact Analysis
• Student Predictions by Course

Completion Prediction Queries

• Student Completion Prediction by Years in College and Awards
• Student Completion Predictions
• Daily Completion Score Shifts
• Weekly Completion Score Shifts

Engagement Scores Queries

• Student Engagement Scores
• Student Top Features
• Student Top Features Latest

Persistence Prediction Queries

• High GPA Students with Low Persistence Scores
• Percentile Binned Students by Persistence Score
• Student Persistence Predictions
• Student Persistence Prediction by Age
• Student Persistence Prediction by Location
• Student Persistence Score Shift
• Student Persistence Risk Indicators
• Student Persistence Prediction by College
• Student Persistence Prediction by Financial Aid
• Discovering Term Names and Continuation Patterns
• Students Who Continued from One Term to Another
• Summary Count by Career Type
• All Continuation Patterns from a Specific Term

Student Feature Queries

• Latest Student Feature Values
• Single Student Ranked Features
• Top and Bottom Percentile Section LMS Features Values
• Student Feature Peer Comparison (Avg & Z-Score)

Academic Queries

• First-Generation College Student Academic Performance Analysis
• Developmental Education Effectiveness Analysis
• Course Modality Performance Comparison
• Cohort Progression Milestone Tracking
• Academic Standing Recovery Patterns
• Academic Outcomes
• FTPT (Full-Time Part-Time) Risk Analysis

Utility Queries

• Active Student Subquery