One approach to this is to calculate the Status on the Course table. There can be two status fields on the course record.
[Status Manual] and then [Status] with the latter really being [Status (calculated)] but with just a clean name of [Status].
You can roll up a Summary count of the # of child records in various statuses and then based on those, then calculate the final status. The alternative is to get into "Actions" to actually try to update the Course status field when certain conditions are true, but my first suggestion is to calculate the Status as a formula-text field
