Part of Lesson Plan: Time Cards

Activity Overview / Details

Open the Bi-Monthly Self Calculating Time Sheet.  The calculation spreadsheet in this workbook is where excel looks to get the dates to fill in for the time sheet.  The dates are set up for calendar year 2010, which you need to change, or teach your students how to change. To change the year, follow these steps:

1) Click on the calculation spreadsheet in the workbook.   

2)  Unprotect the worksheet.   

3) Rows 4 and 5 change the year from 2010 to 2011 (or current year).   DO NOT change anything else on this spreadsheet!!! If you do Excel will not be able to calculate the correct dates to fill in on the sheet.

Have the corrected version of the Bi-Monthly Self Calculating Time Sheet available for students.  Show them how the comments on the time sheet show up when you roll the mouse over them.  Point out that these comments are special instructions letting them know how to fill out those parts.   Have them fill out the worksheet for the current month with their information, when they start school, leave school, lunch in, and lunch out.

Save the filled out spreadsheet for use when students learn about gross pay.