Is it possible for a course to have two names.

@Richard Pan - each section of a course can have it's own name. Our grade level Math Courses have sections with names like - Algebra, Geometry. Similarly our History course in sixth grade has section names that relate to the course content.

@Richard Pan If the report card template looks at the Course ID field, then all students in the same class who use the same report card template get the same Course ID. You could, I suppose, have four different templates (two report cards and two transcripts), where one pulls the Course ID and the other pulls the Course Name… No. That's a terrible suggestion. Maintaining that year over year would be a nightmare, and if I implemented something like that I would deserve to be mocked by my successors!

@Candace Chesler is right. You'll need two different courses, one class of each course, both taught in the same place and time. It's more initial overhead to set up separate courses, create separate classes, and then schedule the classes at the same time, but it means all classes in your database can get the same treatment, all the reports will turn out correctly, and it'll be very clear to the teacher which student is (technically) in which course.