February 2009
Sunday
1
February 2009
Thursday
5
Monday Power Hour Pool Tournament Art Netsmartz
8
Power Hour Pool Tournament Art Netsmartz
15
No School!! Power Hour Pool Tournament Art
22
Netsmartz Power Hour Pool Tournament Art Netsmartz Power Hour Pool Tournament Art
Tuesday Wednesday Woodland Park 3 4 Healthy Habits in the AMDaily Challenge AM Photo Tech Street SMART Image Makers Torch Club Netsmartz Netsmartz 9 10 11 Healthy Habits in the AMDaily Challenge AM Photo Tech Street SMART Image Makers Torch Club Netsmartz Netsmartz 16 17 18 Daily Challenge AM Healthy Habits in the AMStreet SMART Photo Tech Torch Club Image Makers Newsletter Pen Pal Day! 23 24 21 Healthy Habits in the AMDaily Challenge AM Photo Tech Street SMART Image Makers Torch Club Netsmartz Netsmartz
2
Friday
Date SMART 1-3 6
Saturday
7
Caviety Free Zone Music Makers SMART Girls Power Hour Caviety Free Zone Music Makers SMART Girls Power Hour
Post Test Comptuer Lab V-Cards Fine Art 12 Date SMART 1-3 13 Post Test Valentine Day Celebration!!
14
Healthy Habits in the AM/ aily Challenge AM D Post Test Street SMART Photo Tech Torch Club Image Makers Netsmartz
Reading Club 19 Date SMART 1-3 20 Daily Challenge AM Post Test Street SMART Passport to Manhood Torch Club Fine Art Reading Club 26 Date SMART 1-3 23 Daily Challenge AM Post Test Start SMART Passport to Manhood Black History Scavenger Hunt Art Fine Netsmartz Video Game Tournament 29 Date SMART 1-3 30 Daily Challenge AM Post Test Start SMART Passport to Manhood Torch Club Fine Art Netsmartz Balloon Volley Ball
21
28
31
Special Events:
Feb. 13th: Valentine's Day Celebration at the Club 4:30-6:00 Feb. 16th: Movie Field Trip Time TBA Pink Panther 2 PG
Holidays: Feb. 14th Valentine's Day
(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
1
Friday
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.
Settings and Formulas
23 15 56 170F38 48 56 15 30380F #NAME? #NAME? 65 43 156 412B9C 133 156 43 859C2B #NAME? #NAME? 132 111 216 846FD8 195 216 111 C3D86F #NAME? #NAME? 185 173 233 B9ADE9 221 233 173 DDE9AD #NAME? #NAME? 238 235 250 EEEBFA 247 250 235 F7FAEB #NAME? Light #NAME? Light
text
text
text
text
text
text
text
text
text
text
Today's Date 7/1/2009 7 July 2009
Month Names January February March April May June July August September October November December
month 2 year 2009 monthName February startDate 2/1/2009 startDayOfWeek 1
WeekNo
1 2 3 4 5 6
Sun 1
1 8 15 22
Mon 2
2 9 16 23
Tue 3
3 10 17 24
Wed 4
4 11 18 25
Thu 5
5 12 19 26
Fri 6
6 13 20 27
Sat 7
7 14 21 28