Examples

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

Persistence + Completion Prediction Queries

• Student Predictions by Credit Load

Completion Prediction Queries

• Student Completion Prediction by Years in College and Awards
• Student Completion Predictions

Persistence Prediction Queries

• Average Persistence Score by Origin
• Average Persistence or Persistence Score by GPA Band
• Average Persistence Score by Term
• Dropped Students with Low Persistence Scores
• 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 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)

Utility Queries

• Active Student Subquery