Whether you are a manager in charge of creating employee schedules at a small business or an employee who desires to keep a record of your schedule and time worked, you will need a reliable and consistent method of recording work schedules. Most work schedules consist of a simple table with columns and rows for the date and hours scheduled. However, some schedules can be made more complex by adding sections or spaces to keep track of additional items such as work locations or work partners for different days of the week. Creating a blank schedule template will save you time and energy in performing weekly or monthly scheduling duties.
Items you will need
- Pen or pencil
- Ruler (optional)
- Computer with Microsoft Word or Excel (optional)
- Printer (optional)
Using Pencil and Paper
Choose paper and a pen or pencil for your schedule. Your paper can be either lined or unlined. If you are working with unlined paper, it might be helpful—but not necessary—to use a ruler or other straight edge for drawing straight lines.
Plan your design. Consider how many days or weeks you wish to publish on each work schedule sheet. A typical schedule consists of one or two weeks, but you may wish to provide for an entire month. Also, if you will be creating a more complex schedule that will include sections for work location, equipment assignments, mileage or time spent off-duty for breaks and lunch, plan for adding additional sections in your schedule template to accommodate such items.
Create your blank work schedule template. Use your initial design plan as guidance. To create a basic "time worked" schedule, draw seven columns across your sheet and list the day of the week (e.g., Monday) and date in ascending order across the top. To create a template that will allow for the scheduling of more than one week, draw an additional row that intersects your columns for each additional week that you wish to allow for. Your columns and rows should create a series of unfilled boxes.
To create a more complex schedule with added details, create a separate row for each date. Count the number of additional details that you must add. For example, if your daily schedule will contain details on "hours worked," "location" and "mileage," draw three intersecting columns for each date row.
Using Microsoft Word or Excel
Identify which version of Microsoft Office you are using. Most software applications in use today will likely be either the 2003 or 2007 version.
Choose a template that will work with your version of Microsoft Office. Check if your version of Microsoft Office came with preloaded templates to create a blank schedule. Open the Office application, click in the "File" tab on the menu bar at the top of your screen and choose "Project Gallery" from the drop-down menu. This should produce a list of available preloaded templates.
If you can not find a preloaded "schedule" template, download one from an outside source. Locate an external template that is compatible with your version of Microsoft Office; most templates list whether they are compatible with Office 2003 or 2007.
Microsoft Office Online is a reliable source of schedule templates. See "Resources" for a link. To download a template from Office Online, click the "Download" button that corresponds with the template. A dialog box will open and provide you with the option to save or open the template. If you choose "Save," pick a location to store the saved template to retrieve later. The "My Documents" folder is a common place to save files.
Open your blank template to enter information into the schedule template. Alternatively, you can print the blank template and write on it.
- agenda image by Ludovic LAN from Fotolia.com