Aligning Courses to Programs via Import

Updated
Watermark Support

System Administration stores and manages data for Program-to-Course alignments.

This data can be entered via CSV import, or through manual updating. This article will focus on entering Program-Course Alignment data via import. 

For information on entering this data manually, please see:

Aligning Courses to Programs Manually

Importing Program-Course Alignment Data

This functionality includes an option for System Administrators to import CSVs with bulk data to align Courses to Programs. Just as with new records, updates to Program Curriculum data can also be made through CSV import.

The table showing columns program_code, course_code, aligned_course, and required_course, with rows listing BS_Marketing courses and their aligned and required values.

The above shows the CSV import fields for Program Curriculum. A System Administrator is required to enter values for all fields. In the above example all three courses are aligned to the BS_Marketing Program, but only two of the courses are required for the program.

The Programs section showing a left navigation menu with Programs highlighted, a table listing program name, program code, program CIP code, parent organization, and curriculum, and a menu on the right side of a row showing options Edit Program, View Curriculum highlighted, and Delete Program.

In the above display, within System Administration, the Curriculum Column indicates the number of courses that are aligned with a Program. By clicking on the action button we see the below display. 

The View Curriculum panel showing BA.BIOLOGY (GENERAL OPTION) with a table listing the course Biology & Society and its required value set to No.

In this display all aligned courses will be listed, as well as indicate if the course is required or not within the program.

How to update alignment using CSV Import

It is possible to update alignment data through CSV import as well.

The table showing columns program_code, course_code, aligned_course, and required_course, with rows listing BS_Marketing courses and their aligned and required values.

To change whether a Course is required for a Program, change the previous TRUE to a FALSE in the required_course fields and then import the CSV to make the updates. 

In the below image, when the CSV is imported, Intro_MKT_101 and MKT_201 will: 

  1. remain aligned to the BS_Marketing Program
  2. no longer be a required course for the BS_Marketing Program

The table showing columns program_code, course_code, aligned_course, and required_course, with rows listing BS_Marketing courses and their aligned and required values, with required_course values showing FALSE for all rows.

To remove both a Course’s alignment and its requirement to a Program, change the previous TRUE to a FALSE in the required_course fields and also in the aligned_course fields. Then import the CSV to make the updates.

In the below image, when the CSV is imported, Intro_MKT_101 and MKT_201 will: 

  1. no longer remain aligned to the BS_Marketing Program
  2. no longer be a required course for the BS_Marketing Program

The table showing columns program_code, course_code, aligned_course, and required_course, with rows listing BS_Marketing courses and their aligned and required values, with aligned_course and required_course values showing FALSE for all rows.

Please also see:

CSV Import Guidelines

Was this article helpful?
4 out of 9 found this helpful

Articles in this section

See more
How to Contact Support
There are many ways to reach out! Click the icon above for our support options.
Watermark Academy
Click the icon above to access the Watermark Academy for consultation, training, and implementation companion courses.
Customer Community
Can’t find the answer? Ask fellow users how they’re making the most of Watermark in our Community!