ACP Course Import – 4Schools Help Center

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 (max 255 characters)
*Column B - course_name: Enter the Course Name (max 255 characters)
Column C - course_description: Enter the Course Description
Column D - course_type: Enter the Course Type (max 255 characters)
Column E - credit_type: Enter the Credit Type (max 255 characters)
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 (max 255 characters)
*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 (max 255 characters)
Column N - course_sequence_level: Enter the course sequence level (max 255 characters)
*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.