Computer+Tools+for+Teachers

=COMPUTER TOOLS FOR TEACHERS= Instructor: Christina Hennessy (hennessyrtc@gmail.com) =A few things before we start:=
 * We will be completing "At-Home hours" this was't written in the original course description. I will discuss this the first day of class.
 * Each class will have questions that need to be discussed in the discussion area of this class wiki.
 * Feel free to work with a friend or colleague. Although we aren't at work right now, I know during the school year it is very difficult for colleagues to have time to collaborate. I encourage it in all my classes.
 * Make sure you save all your work. You will be submitting a packet the last day of class.
 * It is VERY important that you attend every class to meet the hourly requirements.

=__//GRADING//__ =
 * For an A, participants must complete all seat time, respond in the discussion area and complete all at home tasks.
 * Participants who are unable to complete the full seat time can be dropped to a B or a C depending on the amount of class hours missed.

- Complete paper work for RTC - Course Introduction - Participant Introductions
 * //__Day 1 - July 11, 2011__//**

//Introduction to MS Excel:// (1) Poll the class. Favorite Ice Cream Flavors and create a Pictograph (Pictograph Directions)

(2) Create a bingo card using MS Excel (MS Excel Bingo Card)

(3) Let's Spend some $$ (4) Did you know you can create a Concept Map in Excel. Make a sample.


 * At Home Assignment** - Read Article and comment in discussion area. "Excel" lent Math

__//**Day 2 - July 12, 2011**//__ MS Excel

1) Type date you are counting down to in cell A1, for example: 6/1/07 2) Type this formula in cell A2: =TODAY 3) Type this formula in cell A3: =A1-A2 4) With cell A3 selected, go to Format à Cells, then click the Number tab. Change the  number format to Number and choose 0 for decimal places. __**ASSIGNMENT #2: **__ Create a Timleline __**ASSIGNMENT #3: **__ Create a Word Find __**ASSIGNMENT #4: **__ Random Group Maker <span class="apple-style-span" style="color: black; font-family: 'Verdana','sans-serif'; font-size: 13px;">1. In cell A1 type this: =RAND Then press enter. You should see a random number.
 * __ASSIGNMENT #1:__**
 * <span style="font-family: 'Arial-BoldMT','sans-serif'; font-size: 16px;">Countdown to an Important Date! **

2. Starting with cell B1 type your kids' names down column B, one name per cell.

3. Back in column A again, click just once (don't double-click) on cell A1. Now left click and hold on the little square handle at the bottom right corner of the cell. Still holding the left click button down, pull down until you have highlighted column A down to the same row as the name of your last child in column B. Let go of the left click.

You should now see random numbers to the left of each child's name.

4. Now highlight all of the numbers and names in both columns.

5. In the top menu click on Data and select Sort Set to: Column A, no header row, ascending order. Click OK.

Ta...da! Your class has been organized into random groups!

Repeat steps 4 and 5. Ta...da! New random groups. __**<span class="apple-style-span" style="color: black; font-family: 'Verdana','sans-serif'; font-size: 13px;">ASSIGNMENT #5: **__ __**ASSIGNMENT #6: **__ __//**Day 3: July 13, 2011**//__ MS Publisher

Discussion Article: Bringing the Classroom Together Post your thoughts in the discussion area. Would a newsletter be helpful in your classroom?


 * ASSIGNMENT #1**
 * [|MS Publisher Newsletter]**

MS Publisher Postcard
 * ASSIGNMENT #2**

Microsoft Publisher Brochure
 * ASSIGNMENT #3**

__//**Day 4: July 14, 2011**//__ Today we are going to finish up our publisher projects and take a look at some information about websites.

Teachers Punished for Social Networking What are your feelings about this. Post a comment in the discussion area.
 * Assignment #1:**

Kathy Schrock's 5 W's of Website Evaluation Read Kathy's 5 W's of website evaluation. What criteria do you think is missing? Post in the discussion area.
 * Assignment #2:**

Jo Cool or Jo Fool for Teachers Check out the Jo Cool or Jo Fool teacher and student site on website evaluation. Which one is a hoax? Which one is real? Evaluate two websites below by Filling out a __**hoax form**__ explaining your answer. Also check out the Online Comprehension Strategies, A useful tool for evaluating websites.
 * Assignment #3:**





__**Sites:**__ [] [] [] [] [] [] [] [] [] Post your favorite educational website in the discussion area. I love sharing websites! It is great getting ideas from classmates. Type the website and description. Top 20 sites No Teachers Should Live Without Learn about some great sites that will help you differentiate instruction in your classroom!!
 * Assignment #4:**
 * Assignment #5:**


 * When assignments are complete spend the rest of the time in class working on your class pages. Now that you know what makes a good website make sure you have followed all the criterias listed by Kathy Schrock.**

__//**Day 5: July 15, 2011**//__ //**We made it**////**!**// //**Due Today:**// We will start presentations around 9:30AM. Either show using the projector or show using your hard copy by passing around the room. Mention the subject you teach, grade level and how your going to use it in the classroom. We are done! I have a fall class scheduled on my learning plan if you are interested. I will be posting grades later on today. Don't forget to complete the evaluation in my learning plan. **Have a great summer!!!!!!!!!!!**
 * Finish up your assignments.**
 * **One Excel project sample and lesson summary**
 * **One Publisher project sample and lesson summary**
 * **Hoax form(s)**
 * ***STAPLE AND HAND IN**
 * //Discussion Area://** Comment on TWO projects in the discussuion area.
 * //Presentation Time://**