The Extended Education planning form has been created to facilitate the course creation and contracting process for programs supported by Extended Education. The planning document contains formulas in calculated columns.
When inserting rows or deleting or changing information within a cell, the formula is often not transferred and the form calculations are incomplete. It may be necessary to copy a blank row of calculated cells to new lines/cells within a column. Please be aware of this possibility to keep the form as accurate as possible.
|Program||Enter program type:
|Location/Site||Enter location or site code for class location:
|CRN||Enter the Course Record Number (CRN) (e.g. 11234).
Note: CRNs begin with the term code YEARQT (e.g. Fall CRNs start with 4: 201940)
|Rubric||Enter the department course rubric (e.g. COMM, MIS).|
|Course #||Enter the numeric course number (e.g. 497) and enter course alpha (e.g. A), if applicable, in field next to Course #.|
|Title||Provide accurate course title consistent with that listed in the University Bulletin.
If this is a special course, please match this title with the one entered into Banner.
|Course Credits||Total course credits.
If a variable amount, please indicate. To enter variable credit amounts such as 1-15, click on the cell in the CR column in which you want to enter this information, click the Format tab at the top of the page, select Cells, then select the Number tab and finally select Text from the list and click OK. This will allow entry of the actual variable credit range. Alternately, enter a single quote [‘] prior to the credit range to prevent it from being converted into a date.
The credit value of any course must match that assigned in the general catalog.
|Variable Credit?||Enter “Yes” if students can register for variable credits, and “No” if they are unable to register for variable credits.|
|Department Approved?||Indicates if an offerings has been reviewed and is approved to be part of the upcoming schedule. By default, all courses are set to “No” and will be removed from Banner once the schedule is approved.
Enter “Yes” to have courses set-up and “No” to have courses removed for the upcoming year.
|WP Points||Enter Writing Proficiency points (e.g. 1, 2 or 3), if applicable.|
|Projected Enrollment||Enter the estimated enrollment. If your estimated enrollment for a course exceeds that of the previous year or if the course has not been recently offered, a justification for that estimate may be required. This field is also used to calculate Adjusted Tuition Revenue.|
|Maximum Enrollment||Enter the max enrollment for the course.|
|Projected SCH||Enter the max enrollment for the course.
Student Credit Hours (SCH) is auto-calculated as the product of Pay CR times Projected Enrollment.
For variable credit courses enter this value manually.
|Special Course Fees:||General Course Fee per Student: Fees that accompany general courses (e.g. lab fees)
Additional Course Fee per Student: Special course fees (e.g. Travel, Field Experience, Study USA, Global Learning)
|Special Course Dates:||Specify the course dates, if they deviate from the standard term dates.|
|Meeting Day(s)||Days of the week which the course meets, e.g. MWF, TR, MTWRF, Online.|
|Meeting Time(s)||Time period for which the course meets, e.g. 8-9:20, 1-1:50, online, etc.
Academic units should use guidelines established by the Registrar’s Office, ACC, and the College in establishing meeting times.
|Room||Enter specific room, if reserved and confirmed.|
|Notes||Enter special notes pertaining to course offering.|
|Contact Hours||Enter total contact hours. One contact hour is equivalent to 50 minutes. Refer to the descriptions provided by the Academic Coordinating Commission (ACC) and Block Schedule for contact hour calculations and assistance.
Credit hours are assigned to a class based on the amount and type of work expected from a typical student in class. Credit is awarded for courses only in the quarter in which the student is registered for the classes and completing the work.
Please see the ACC Policy on Credit Hours for additional information:
|Instructor Information||Enter W#, last name, and first initial of the instructor, co-instructor or teaching assistant.
Enter faculty rank in “Faculty Rank” field.
|This field is auto populated with the same information in the Course Credits field. If faculty pay will be based on a credit amount other than the actual course credits (e.g. two faculty co-teaching a 4 credit course and each receiving 2 pay credits), enter the number of credits in this field.|
|This is entered by the academic unit, following established departmental or college formula.|
|Faculty Compensation Method||Part of Load: Is this part of the faculty member’s contracted teaching load? If “yes,” a contract should have been issued to the faculty. If “no,” a contract will be issued by Extended Education.
Overload: Is this course an overload, in agreement with the CBA and the Provost’s Office’s definition?
Per Credit Rate: Established per credit rate.
Per SCH Rate: Established per SCH rate: Refer to the CBA for current calculations.
Correspondence or Contracted Independent Study Rate: Refer to section 184.108.40.206 of the CBA for specified rates.
Additional Stipend or Pay: Additional compensation and/or administrative pay for defined activities.
Any deviation from compensation methods outlined in the CBA requires the written consent of the dean and agreement with the United Faculty of Western Washington.
|Estimated Faculty Compensation||Auto-populated field based on Compensation Method and Projected Enrollment.|
|Benefits||Auto-populated field: Sum of Estimated Faculty Compensation x 30% – the standard average estimate for benefits (actual values vary by individual).|
|Additional Expenses||Other expenses for courses include specific high-cost supplies, mileage expense, publicity, etc., which are not covered by the department. The projected course enrollment must generate enough revenue to cover all expenses charged to the course.|
|Total Expense||Auto-populated field: Sum of all expense columns.|
|Tuition Revenue Minus Admin Expense||Auto-populated field: Sum of all revenue columns, minus mandatory administrative expenses.|
|Estimated Net||Auto-populated field of Total Revenue minus Total Expense.|