SleekView for Education WP: LearnPress courses and student items as tables
Education WP ships on top of LearnPress, so SleekView reads learnpress_user_items, learnpress_user_itemmeta, and the lp_course post type directly. Build per-student progress views, instructor grading queues, and stalled-learner reports without scripting.
♾️ Lifetime License available
Course progress as a real workspace, not a profile screen
Education WP is a LearnPress-based theme, which means the actual data sits in LearnPress tables: learnpress_user_items tracks enrolment, lesson, and quiz progress, with metadata in learnpress_user_itemmeta. Courses, lessons, and quizzes are post types (lp_course, lp_lesson, lp_quiz). The default Education WP admin focuses on a friendly profile-per-student experience, which is fine for occasional review but painful for daily ops where you want to scan dozens of learners at once.
SleekView reads the LearnPress tables directly so course managers can build the views their workflows actually require. A per-student progress table joins learnpress_user_items for course, lesson, and quiz rows into one row per student per course. A stalled-learner report filters where status != 'completed' and start_time is older than a chosen threshold. A quiz grading queue surfaces attempts where graduation = 'in-progress' across the whole catalogue, sorted by oldest submission first.
Inline edits to status route through the LearnPress course-item API where supported, so completion hooks, certificate issuance, and integration notifications fire normally. Direct-table writes are available for back-fill scenarios where you do not want side effects. Multisite Education WP installations get per-subsite scoped views automatically.
Workflow
Build the Education WP views the default admin doesn't ship
Read the LearnPress tables
learnpress_user_items as the base. SleekView joins learnpress_user_itemmeta for scores, attempts, and any custom meta your install adds.
Compose course and quiz columns
wp_posts on item_id to surface course and quiz titles. Add user columns from wp_users for student name and email.
Filter by progress state
item_type, status, graduation, and start_time in saved views. Stalled-learner queries become a one-click filter.
Save per-role views
Sample columns
A typical Education WP user-items view
learnpress_user_items joined with the lp_course post and user.
wp_learnpress_user_items + wp_learnpress_user_itemmeta + wp_posts (post_type=lp_course)
| Student | Course | Item | Status | Grade | Updated |
|---|---|---|---|---|---|
| alex@studio.co | UX Foundations | Course | Completed | — | Apr 24 |
| ria@design.io | CSS Mastery | Quiz | Passed | 88% | Apr 24 |
| tom@hello.dev | JS Bootcamp | Lesson | In Progress | — | Apr 23 |
| mia@brew.coop | JS Bootcamp | Quiz | Failed | 42% | Apr 23 |
Comparison
Default Education WP admin vs SleekView
Default Education WP admin
- Default screens are profile-shaped, not list-shaped
-
learnpress_user_itemsisn't surfaced as a sortable table - Cross-course grading queues require custom queries
- Stalled-learner reports aren't a built-in view
-
Pivoting
learnpress_user_itemmetainto per-student columns needs SQL
SleekView
-
Per-student progress table joining course, lesson, and quiz rows from
learnpress_user_items -
Cross-course grading queue filtered to
graduation = 'in-progress' -
Filter stalled learners by
statusandstart_time -
Surface
learnpress_user_itemmetavalues (score, attempts) as columns - Save views per role (instructor, admin, support)
Features
What SleekView gives you for Education WP
Per-student progress views
Filter learnpress_user_items by user_id and group by item_type. One table that shows every course, lesson, and quiz attempt for a student in a single screen.
Grading queue for instructors
Filter user items to item_type = 'lp_quiz' and graduation = 'in-progress', sort by submission date, and grade inline. No clicking into each attempt individually.
Stalled-learner reports
Filter where status != 'completed' and start_time is older than N days. Find learners who began but never finished, so customer success can follow up before drop-off becomes attrition.
Audience
Who uses SleekView for Education WP
Instructors
Per-course completion table sorted by who's stalled. Grading queues filter pending quiz attempts (graduation column) into a clean review list across all courses.
L&D admins
Course-completion rates and quiz pass rates across the catalogue, filtered by date range. Pivoting learnpress_user_itemmeta gives per-student progress columns at a glance.
Customer success
Per-student activity history visible during support calls, with last-active date plus current course stage in one row. No jumping between profile screens.
The bigger picture
Why LMS data needs row-level workspaces
Learning programs live or die by completion rates, and completion rates depend on early intervention with stalled learners. Education WP's default admin is friendly and profile-shaped, which is great for occasional one-off reviews and bad for the daily reality of scanning hundreds of learners across dozens of courses. The LearnPress tables underneath (learnpress_user_items, learnpress_user_itemmeta) are well-structured and indexed, so the data is ready for a list-shaped workspace, but the default admin doesn't expose them that way.
Instructors grading manually want a queue of pending submissions sorted by oldest first, not a per-quiz drill-down. L&D admins doing course design want per-question pass rates to identify ambiguous quiz items. Customer success agents want per-student histories visible during support calls without flipping between five screens.
SleekView's job is to expose the underlying tables as a composable workspace so each role can build the view their job actually requires. Same data, no extra add-ons, dramatically more flexibility for the people who run the program day to day.
Questions
Common questions about SleekView for Education WP
No. SleekView reads the underlying LearnPress tables (learnpress_user_items, learnpress_user_itemmeta) and post types (lp_course, lp_lesson, lp_quiz), so the views described work on stock Education WP plus core LearnPress. Add-ons that introduce extra tables (assignments, certificates) are exposed when their schema is detected.
Yes. Progress is computed from the count of completed lp_lesson and lp_quiz child items relative to the course's total items. SleekView aggregates that into a per-student progress column. The aggregate is heavier than direct columns, so opt in per view rather than including it everywhere.
Per-question answers are stored as serialised meta on learnpress_user_itemmeta for quiz attempts. SleekView exposes them as a related child view so you can drill from a quiz score down to what the student actually answered, useful for grading manually-reviewed quizzes.
Where SleekView uses LearnPress's course-item API (mark course complete, mark lesson complete, set quiz graduation), the standard learn-press/ action hooks fire. Direct table edits skip hooks by design for back-fill scenarios. Pick per-view based on whether side effects are wanted.
Yes. Course access driven by paid memberships (LearnPress Paid Membership Pro add-on, or third-party gating) is reflected in learnpress_user_items the same way as free enrolments, so SleekView treats them uniformly. Membership-specific filters can be saved per view.
Yes. Any SleekView export goes to CSV or JSON, so you can hand a filtered table to external BI tools or learner-record stores without re-running the query. Helpful when L&D needs to combine Education WP data with HRIS data.
 
Queries hit indexed columns (user_id, item_id, item_type, status, graduation). Pagination is keyset where possible, so seeking past page 100 stays fast. Aggregate columns are opt-in to keep list views responsive.
Yes. Translated lp_course posts share enrolment via the language-link relationship, and SleekView can group rows by original course ID so progress views aren't fragmented across translations. Per-language filters are available where the install has WPML or Polylang active.
Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkoutBrowse more
- Woocommerce Currency Converter
- Woocommerce Paytm Gateway
- Yith Woocommerce Affiliates
- Woocommerce Credit Notes
- Woocommerce Glsship
- Bigcommerce Bridge
- Woocommerce Pdf Vouchers
- Presta Shop Bridge
- Pretty Links
- Aelia Currencyswitcher
- Solid Affiliate
- Woocommerce Startrack
- Woocommerce Advanced Bulk Edit
- Wcfm Vendor Staff
- Wpc Product Quantity