Academic Calendar Template - Excel

					                June 2010                                                       June 2010
    Sunday                     Monday                       Tuesday                     Wednesday                    Thursday                           Friday                 Saturday
                                                  31                              1                         2                                3                            4               5
                        City Track Meet @ CCHS          School Book Fair ends
                        9 AM




                   6                              7                               8                         9                              10                             11              12
                        St. Patrick Junior Golf                                                                  Gr. 6 DARE Grad 1 pm            All Library Books Due
                        10 AM
                                                                                                                 Grade 1 Dress Rehearsal         Grade 1 Spring Concert
                                                                                                                 1 pm                            1 pm


                   13                             14 Staff Meeting              15                          16                             17                             18              19
                                                       Early Dismissal 11:40 AM       Gr. 6 LA PAT Part B        Gr. 3 Math PAT Part B           Gr. 6 PAT Science
                                                                                      9:00 - 10:00               9:00 - 10:00                    9:00 - 10:00
                                                       Gr. 3 PAT LA Part B                                       Gr. 6 Math PAT Part B
                                                       Gr. 6 PAT Social                                          9:00 - 10:00
                                                       9:00 - 10:00 am
                   20                             21                            22                          23                             24                             25              26
                                                       Parent Council Meeting7 pm                                Newsletter goes home
                                                       at Doughboys                                              Year End Mass 9:30 AM @
                                                                                                                 St. Francis Xavier Church



                   27                             28                            29                          30
                        Last Day for Students          Last Day for Teachers


                        Celebration of Learning
                        2:15 pm


                                                                                      Notes:
School Web Site:        http://www.stpatscamrose.com                                                                                             St. Patrick Catholic Elementary School
                                                                                      First Day for Students for the 2010/2011:                  School Office Ph#     (780) 672-2177
District Web Site:      http://www.eics.ab.ca                                         Monday. August 30, 2010                                    School Fax#           (780) 672-1818
(See "Using the Calendar as a template" in the Help worksheet.)
       Help
Enabling Macros ...

       In order for the spreadsheet to work properly, you will need to enable the macros.
       In Excel, go to Tools -> Macro -> Security... and select the "Medium" option
       in the "Security Level" tab. The next time you try to open the spreadsheet,
       it should give you the option to enable macros.

Using the Calendar as a Template

       In order to add events to the calendar and use the spreadsheet for more than just one month,
       first make a copy of the current month and paste it into the Planning worksheet.

       1) Delete the graphics in the header of the calendar so that the calendar looks like this:

                            April 2004

                   Sunday       Monday       Tuesday       Wednesday       Thursday       Friday
                                                                                      1




                            4            5             6               7              8




       2) Copy the Whole Calendar
                a) Select cells A8:N47
                b) Press Ctrl+c or select Edit -> Copy

       3) Paste the Calendar into the Planning worksheet
                The planning worksheet has been formatted so that the column widths
                are the same as the Calendar worksheet.
                a) Select cell A1 in the Planning worksheet
                b) Press Ctrl+v or select Edit -> Paste

       4) Convert Formulas to Static Dates
               After pasting the calendar, you will need to make the dates static so
               that when changing the month on the Calendar worksheet, you don't
               also change the dates in the Planning worksheet.
               Immediately after pasting the calendar …
               a) Select Edit -> Paste Special …
               b) Choose the "Values" option, and select OK


       Printing:
                   After creating a copy of the calendar, you may
                   want to print one of more of the calendars.
                   a) Go to File -> Print Area -> Set Print Area …
                   b) Select the range of cells you want to print.
                   c) Go to File -> Page Setup
                   d) In the Page tab, select the "Fit To: …" option
                   e) Select print preview and change other options as needed.
Enabling Macros ...

       In order for the spreadsheet to work properly, you
       will need to enable the macros. In Excel, go to
       Tools -> Macro -> Security... and select the "Medium"
       option in the "Security Level" tab. The next time
       you try to open the spreadsheet, it should give you the
       option to enable macros.

Copying Colors into a New Workbook

       If you copy and paste the calendar into a new workbook, the color scheme you
       have created will not be the same in the new workbook. However, you can easily
       copy the colors from this Excel calendar template into another workbook.

       In the New Excel Workbook …
       1) Go to Tools -> Options…
       2) Choose the "Color" tab
       3) In the "Copy colors from" field, choose this file (the excel calendar template).
       Note: You can only copy colors from a file that is already open.

       In order to make this process a little easier, we have included a macro that will
       create a new workbook, copy the current calendar values and formats into the
       new workbook, and modify the color scheme.

Hiding / Showing Cell Gridlines

       To toggle the cell gridlines on and off in Excel, go to Tools -> Options -> View
       then check or uncheck the Gridlines option.

       If you find yourself doing this frequently, you can add a button to your toolbar
       that will toggle the gridlines on and off.
       1) Go to Tools -> Customize …
       2) In the Commands tab, choose the Forms category
       3) Scroll down the list of Commands until you see the Toggle Grid button
       4) Drag and drop the toggle grid button into one of your toolbars
       A convenient place for the grid button is next to the zoom dropdown box.
ust one month,


looks like this:
           Settings and Formulas

8 14 18        #NAME?   42 79 98   #NAME?    77 144 178   #NAME?   157 194 213   #NAME?   237 244 247     #NAME?   Color Scheme Settings
080E12                  2A4F62               4D90B2                9DC2D5                 EDF4F7        Light
18 11 8        #NAME?   98 61 42   #NAME?    178 110 77   #NAME?   213 176 157   #NAME?   247 241 237     #NAME?
120B08                  623D2A               B26E4D                D5B09D                 F7F1ED        Light
    text        text       text       text      text       text       text        text       text           text


Today's Date            Month Names                         month     6
######                  January                                year 2010
   11                   February                       monthName June
November                March                             startDate 6/1/2010
  2010                  April                      startDayOfWeek          3
                        May
                        June
                        July
                        August
                        September
                        October
                        November
                        December


 WeekNo         Sun        Mon        Tue       Wed        Thu         Fri        Sat
                 1          2          3         4          5           6          7
     1                                 1          2         3           4          5
     2           6           7         8          9         10         11          12
     3           13         14         15        16         17         18          19
     4           20         21         22        23         24         25          26
     5           27         28         29        30
     6
Compatibility Report for May 2009.xls
Run on 8/31/2008 20:12

The following features in this workbook are not supported by earlier versions of
Excel. These features may be lost or degraded when you save this workbook in
an earlier file format.

Minor loss of fidelity                                                              # of occurrences

Some cells or styles in this workbook contain formatting that is not supported by          3
the selected file format. These formats will be converted to the closest format
available.

				
DOCUMENT INFO
Description: Academic Calendar Template document sample