Teaching Schedule

Prepared by:

DATE

DATE

DATE

DATE

DATE

TIME

Monday

Tuesday

Wednesday

Thursday

Friday

9:00-9:30

9:30-10:30

10:30-10:45

Break

Break

Break

Break

Break

10:45-11:15

11:15-11:45

11:45-1:15

Lunch

Lunch

Lunch

Lunch

Lunch

1:15-1:45

1:45-2:15

2:15-2:30

Break

Break

Break

Break

Break

2:30-3:00

3:00-3:30

3:30-3:45

Break

Break

Break

Break

Break

3:45-4:15

4:15-4:45

4:45-5:00

Open the VBA editor and create a new module named DateStamp. Create a procedure named InsertDate. Insert the comment Inserts weekly dates, then enter the following code Range("C3:G3") = Array(Date, Date + 1, Date + 2, Date + 3, Date + 4) and exit the VBA editor.

Assign the InsertDate macro to the Insert Dates form control button.

Test both macros and then open the VBA editor. Locate the module containing the ClearSchedule macro. Copy the code and paste it starting in cell B2 in the Code worksheet.

Locate the module containing the InsertDate macro. Copy the code and paste it starting in cell D2.

Check the document for compatibility with Excel 2016 and 2019. Note: Mac users, skip this step.

Save EXP22_Excel_CH12_Cumulative_Assessment_Variation_TeachingSchedule as a macro-free workbook and close it. Exit Excel. Submit the file as directed.