EdTech Musician 85 Intro To Excel

We have for you this week Classical and Pop music history, ETM news, and a Technology in the Classroom feature that introduces your students to Excel.

Homepage       Shownotes

Frappr Map          E-Mail

ETM NEWS

Rolling Stones year's top grossing act

Noises Off: Playgoers Sip, Munch and Crunch

Jobs, Dell deliver dueling keynotes

Telecom deal could spur 'net neutrality'

Curriki offers new world of course content

Are Kids More Responsible Than We Thought?

Six ed-tech trends to watch in 2007

Close ETM NEWS

Music

There She Goes by Brother Love on the Podsafe Music Network

Technology In The Classroom

Introduction to Excel by Making a Calendar

1. Open Microsoft Excel
2. Go to File and Page Setup and change the orientation to landscape.
3. Change the width of columns A-G to 15.
4. In cell A1 begin typing the days of the week starting with Sunday and ending with Saturday.
5. Change the font of your days to Arial.
6. Change the size of your days to 14pt.
7. Center the names of the days in the cell.
8. Using the border tool, create squares that are 1 column by 6 rows in dimension.  Create enough for the whole month.
9. In the first row of each square add the day number and make it bold.
10. Oops, we forgot to add the month and year.
1. Insert a row above the A row
2. In this new row type the month name and year.
3. Format the row to Text
4. Center the month/year across columns A-G (center across selection)
5. Make the Month/Year 20pt/Bold/Arial
6. Add a bold black border around the Month/Year cells
11. Change the background color of Month/Year cells.
12. Change the background color of the days of the week cells.
13.  Add a heart on February 14^th for Valentines Day.
14. Add these dates to your calendar
1. February 2-Groundhogs Day
2. February 14- Valentines Day
3. February 16- Friendship Parties
4. February 19- Presidents Day (No School)
5. Any other dates you may have for this month.

15. Save and print your calendar.

Send your comments and mp3 files to [e-mail]

Go to PODCAST ALLEY and vote for EdTech Musician

Thanks for listening

-Andy & Todd