Tabellab
Teaching & School Admin Beginner

Creating & Selling Online Courses: Lesson Plans, Production Hours, Pricing, Launch Funnels & Completion Rates

Plan, produce and price an online course: runtime and scripts, production hours, net revenue per sale, launch funnels and where students drop off, with every cell checked as you go.

8 lessons 8 labs 2.1 h Certificate

One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.

About this course

In this course you plan and sell a fictional online course in a spreadsheet. You turn a module outline into runtime, script words and whole slides per lesson, and estimate production hours with format factors, a contingency and a WORKDAY finish date. You compare buying and subscribing for equipment, calculate the net per sale after coupons, revenue shares and fixed fees, and pick the best price from a price test. You measure a launch funnel by channel, compare cohort-based and self-paced runs per instructor hour, find where students drop off and calculate quiz pass rates, and finish with a course P&L, a payback period and a revenue chart.

Lessons

  1. The Course Outline: Modules, Lessons, Runtime, Script Words & SlidesLab14 min Pro
  2. Production Hours: Hours per Finished Minute, Formats & a Realistic Finish DateLab16 min Pro
  3. Equipment & Tools: Buy vs Subscribe, Cost over 24 Months & Cost per CourseLab14 min Pro
  4. Pricing: List Price, Coupons, Revenue Shares & Net per SaleLab16 min Pro
  5. The Launch Funnel: Sign-ups, Show-ups, Buyers & Visitors NeededLab15 min Pro
  6. Cohort-Based vs Self-Paced: Seats, Live Hours & Net per Instructor HourLab15 min Pro
  7. Engagement: Drop-Off Curve, Completion Rate, Biggest Drop & Quiz Pass RatesLab16 min Pro
  8. Capstone: Course P&L, Refund Rates, Payback of Production Hours & a Revenue ChartLab17 min Pro