Before importing courses, set up your Departments and Programs. After your Departments and Programs of Study are set up, you can build an import file to add/update/delete courses within your ACP Courses Library
Create Import File
Make a copy of the ACP Course Import Template Google Sheet or if you already have courses in your library, "Download Full Library" to generate a file that contains your current course information.
*Indicates required fields for a course
- *Column A - course_number: Enter the Course Number
- *Column B - course_name: Enter the Course Name
- Column C - course_description: Enter the Course Description
- Column D - course_type: Enter the Course Type
- Column E - credit_type: Enter the Credit Type
- Column F - required_course: Enter 0 if the course is not required (no). Enter 1 if the course is required (yes)
- *Column G - department: Enter the course's department
Note: The department will need to match the names of a department in your Departments to be able to import courses.
- Column H - employment_type: Enter the Employment Type
- *Column I - pathway_id: Enter the Pathway ID
Note: The ACP Course Import Template Google Sheet has a Pathway IDs field that you can use to identify the ID for each primary pathway.
- *Column J - program_of_study: Enter the course's program code
Note: The program code will need to match the code of a program in your Programs to be able to import courses.
- Column K - college_credit: Enter 0 if the course doesn't offer college credit (no). Enter 1 if the course does offer college credit (yes)
- Column L - certification_available: Enter 0 if the course doesn't offer a certification (no). Enter 1 if the course does offer a certification (yes)
- Column M - accrediting_college_credit_institution: If the course offers college credit, enter the name of the accrediting college/university.
- *Column N - course_sequence_level: Enter the course sequence level
- *Column O - suggested_grade_level: Enter the suggested grade levels separated by a comma. For example, 9,10,11,12
- Column P - school_year: Enter the school year that the course will next be available
- Column Q - isactive: Enter 0 if the course isn't active (no). Enter 1 if the course is active (yes) and should display on your ACP site
After adding your course information in your Google Sheet, under File select Download > Tab-separated values (.tsv, current sheet) to download the file.
From the ACP Courses Library page, select Upload File.
- Choose your .tsv import file
- Select if you would like to replace existing course data or update current course information
Select Upload Course File to complete the import.
This video tutorial will walk through how to complete the Course Import file for the Academic and Career Planning Guide module in CMS4Schools.