Written Instructions on how to fill out your Class Schedule Spreadsheet
Open the Class Schedule Spreadsheet using Microsoft Office Excel.
Below Instructions are for the Class Schedule Spreadsheet.
You must enable macros by clicking the security warning options button
at the top left corner of your screen, and then clicking 'enable content'.
You can also click the Office button in top left corner, and then click
Excel Options. From there click Trust Center, and then Trust Center
Settings. Click the macro tab, and then choose the enable macros option.
At the bottom left corner of your screen will be tabs which allow you to
choose between different pages in the workbook. The two tabs available to
you are the ‘Input’ and ‘Master’ tabs. You can switch between these at your
leisure. For now, select the input tab.
Once on the input page of the spreadsheet, you will see the ‘Student
User Interface’. At this point, fill out the cells with the corresponding
information for your selected class. If you want to look up class
information, consult the schedule course booklet, or look up class
information in Banner.
If you are taking an online class, list the time as ‘TBA’. If the course
is a Hybrid, provide both the scheduled time and a ‘TBA’. ‘TBA’ is the LCC
way of denoting an online component for scheduling purposes. To maintain
consistency, please do the same.
After all the data has been entered into the spreadsheet, use the key
combination Ctrl+Shift+M to update the spreadsheet. If you have followed the
instructions correctly up to this point, the fields you have entered data
into will become blank, and you will see a pop up box containing the text
‘Master Sheet Updated’.
If this does not work for you, most likely you have done one of two
things wrong. Either you left a field blank, in which case you will be
greeted with an error message, or you did not enable macros, which prevents
the underlying VB script from working. Double check that macros are enabled,
and that all data fields have been entered.
If the spreadsheet indicates a successful update to the Master Schedule,
you will now be able to click on the Master tab at the bottom left corner of
your spreadsheet, and see the added information. You can go back to the
Input tab, and add more classes as needed. Use the master schedule to keep
track of all your classes, and verify there are no overlaps in your
Once you have finished your scheduling, save the excel document using your name
and semester, email the excel document to your mentor.