Creating New Courses for Four Year Plans

** We strongly recommend designating just one or two people familiar with your district's student management software to maintain FYP course information. **

There are two required steps to adding and integrating a new course into Four Year Plans:

1. Create new courses in Data Admin (this page)
2. Link courses to credit graduation requirements

There are also two optional steps:

1. Assign Career Paths to courses
2. Assign Recommended Grade Levels to courses 

This article focuses on Step 1: Create new courses in Data Admin.

Method 1: Web Form

This method is best used when you want to quickly add one or two courses on the fly.

Click here to view an example of Method 1.

1. Log into Data Admin: https://[district_name].schooldata.net/admin
   • Note: Special permissions are needed to access Data Admin and the Four Year Planning Admin module within. You will need approval from an administrator (principal, program director, etc.) and your district's Homeroom data admin. For more information, contact your School Data Solutions representative or email support@schooldata.net. 
2. Go to "Four Year Planning Admin" and then "FYP Courses".
3. Click the "Add" button  at the bottom-left corner of the screen.
4. A web form will pop up asking you to fill out information about the new course. ALL fields are OPTIONAL except for "course subject area". Fill out/set any or all of the following fields (the more the better):
   • maximum homework hours per week: Make sure to only type NUMBERS - a half hour per week would be "0.5", three hours will be "3", etc.
   • credit type: Type in which graduation requirement(s) the course satisfies. If the course can count towards multiple requirements, just list them out with a comma between them ("CTE, World Language").
   • four year plan course is active: Click "true" if you want the course to be visible and useable in Four Year Plans. Click "false" if you want to make the course invisible and non-useable.
   • school: Type the ID number of the school offering the new course. Unnecessary if your district only has one high school.
   • available credits: Leave this field blank if the course earns 0.5 credits. If the course earns more or fewer credits (ex. an Advisory course that earns 0.25 credits), type in the appropriate number.
   • course code: Type in the course code.
   • course description: Type in the course name.
   • course subject area: Select the course's subject area.
   • course narrative: Type in the course summary.
   • four year plan course is all year: Click "false" if the course is scheduled by semester or trimester. Click "false" if the course term length is a year.
   • prerequisites description: Type in any course prerequisites.
   • minimum homework hours per week: Make sure to only type NUMBERS - a half hour per week would be "0.5", three hours will be "3", etc.
5. Click "submit"  in the top-right corner of the pop up window.

Method 2: Upload CSV (spreadsheet)

This method is best for adding several courses at once.

Click here for an example of Method 2.

1. Log into Data Admin: https://[district_name].schooldata.net/admin
   • Note: Special permissions are needed to access Data Admin and the Four Year Planning Admin module within. You will need approval from an administrator (principal, program director, etc.) and your district's Homeroom data admin. For more information, contact your School Data Solutions representative or email support@schooldata.net. 
2. Go to "Four Year Planning Admin" and then "FYP Courses".
3. Click "table actions"  at the bottom-left corner of the screen.
4. Click "download CSV template..."  in the pop up menu.
5. Open the downloaded CSV file. You are now ready to prepare your upload spreadsheet.
6. Fill out the columns for each course, one course per row. Do not change the column headers. ALL columns are OPTIONAL except for "course subject area". Fill out any or all of the following columns (the more the better):
   • CourseCode: Type in the course code.
   • CourseDescription: Type in the course name.
   • CourseSubjectAreaID: Type in the ID # of the course's subject area. To find this number, follow these instructions.
   • CourseNarrative: Type in the course summary.
   • FourYearPlanCourseIsAllYear: Type "FALSE" if the course is scheduled by semester or trimester. Type "TRUE" if the course term length is a year.
   • PrerequisitesDescription: Type in any course prerequisites.
   • MinimumHomeworkHoursPerWeek: Make sure to only type NUMBERS - a half hour per week would be "0.5", three hours will be "3", etc.
   • MaximumHomeworkHoursPerWeek: Make sure to only type NUMBERS - a half hour per week would be "0.5", three hours will be "3", etc.
   • CreditType: Type in which graduation requirement(s) the course satisfies. If the course can count towards multiple requirements, just list them out with a comma between them ("CTE, World Language").
   • FourYearPlanCourseIsActive: Type "TRUE" if you want the course to be visible and useable in Four Year Plans. Type "FALSE" if you want to make the course invisible and non-useable.
   • SchoolID: Type the ID number of the school offering the new course. Unnecessary if your district only has one high school.
   • AvailableCredits: Leave this field blank if the course earns 0.5 credits. If the course earns more or fewer credits (ex. an Advisory course that earns 0.25 credits), type in the appropriate number.
7. When you've filled out the column information for all of your new courses, you are ready to upload your spreadsheet! Go back to Data Admin and click "table actions"  again on the FYP Courses page.
8. Click "upload CSV..."  in the pop up menu.
9. Click "Choose File..."  and select your CSV file.
10. Click "Upload" . 
11. When your upload is complete, click "close" .