Instructions: Developing the Master Schedule of Classes

Overview

Please use these instructions when making modifications to the Schedule of Classes spreadsheet provided by the Office of Institutional Research and Effectiveness.

Instructions

• Open the excel spreadsheet that is provided by IR&E.
• SAVE a new working copy of the spreadsheet using the original file name followed by REVISED and date.
• TO ADD A NEW CLASS
  1. Insert a new row in the excel spreadsheet.
  2. Complete as many of the data fields as are known at the time.
  3. Highlight the new row in Yellow.
• TO CANCEL A CLASS
  1. Use strike through to mark the row as cancelled.
  2. Change text color to Red.
• TO MOVE A CLASS FROM FALL TO SPRING OR FROM SPRING TO FALL
  1. Insert a new row.
  2. Copy the schedule data from the row you plan to cancel.
  3. Paste the data into the newly created row.
  4. Make the changes necessary for the new data row.
  5. Highlight the new row in Yellow.
  6. Use strike through to mark the old row as cancelled.
  7. Change the text color of the old row to Red. 
• TO EDIT AN EXISTING CLASS'S DETAIL (e.g. Instructor, Modality, Time)
  1. Select the cell(s) on the original class row where the edit(s) will be made.
  2. Enter the new detail(s) into the appropriate cells.
  3. Highlight the cells containing new details in Green.
• Once all modifications have been made and notated as described above, SAVE your file, ATTACH it to your open IR&E ticket, and send.

Questions? Need Help?

If you have questions or need some help with how to make the requested notations to your file, please let IR&E know by submitting a comment on the current ticket.