Sherry+Fletcher


 * Teach-in Lesson Plan #1 **
 * Topic:** how to add narrative to power point

- Take music, sounds or their own voice to add audio to their power point on their pc. - Explain how this can be used in their teaching practice and incorporated in a lesson. -  **Environment:** In a computer lab with pcs
 * Outcomes:** When students are completed this lesson they will be able to:


 * Audience:** 3 university students


 * Time:** 20 minutes

What power point is and why adding narrative can be a useful tool in future lesson plans. Power Point is: - PowerPoint is widely used by business people, educators, students, and trainers and among the most prevalent forms of persuasive technology. It consists of slides that can consist of words, narrative and/or pictures. Examples of narrative in teaching lessons could include: - Useful when teaching another language to hear proper pronunciation. (could even make a story and have each student say a page) - Sounds from animals, noises that objects make (sound relating to objects). - Vocabulary and proper pronunciation - Have a lesson of instructions that each page is in point form and there is narrative to explain the steps. - Students can go in groups and put together their own story or research power point. - Other possible sources: http://www.graves.k12.ky.us/powerpoints/elementary/
 * Lesson (2 minutes): **

- Begin by going onto the power point 2003 version How to add a song from a file: - Go to the top of the screen and look under ‘insert’. From here scroll down to ‘movies and sounds,’ move to the right and click on ‘play song from file’. - Double click on recording - Next, choose whether the sound will start automatically or on demand. - Double click on microphone if chose on demand. Click once more to stop the sound. How to record narrative: - Go to the top of the screen and look under ‘insert’. From here scroll down to ‘movies and sounds,’ move to the right and click on ‘record sound’. - name the sound recorded or title - Press the ‘record’ button and speak into microphone - Press the ‘stop’ button once finished. Can press ‘play’ to listen and make sure recording sounds as desired. - Press the ‘Ok’ button to insert onto page. - Double click to listen to sound and click once more to shut it off.
 * Demonstration (8 minutes): **

- Work together in a group from the beginning of the lesson in attempts to add narrative. Students will add their own narrative as well as music from a saved folder.
 * Student Activity (8 minutes): **

- Students should be able to demonstrate how to add different types of narrative and state what they would use it for. They should also be able to make the narrative begin automatically or begin only once selected. - The instructor will monitor and assist students.
 * Assessment: **

- Students will be able to ask any questions that were previously unclear or that they are unsure of.
 * Questions (2 minutes): **

**Teach-in Lesson Plan #2** **Topic:** How to create a basic electronic grades book on excel **Outcomes**: When students have completed this lesson they will be able to: - Rename the tab sheet - Have heading columns placed vertically - Add up the total sum of the row with an equation **Environment:** In a computer lab with pc’s **Audience:** 3 University students **Time:** 20 minutes **Lesson (4 minutes):** What excel is and how it can be a useful tool in and out of the classroom: - Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data - When you look at the Excel screen (refer to the example on this page) you see a rectangular table or grid of rows and columns - The horizontal rows are identified by numbers (1,2,3) and the vertical columns with letters of the alphabet (A,B,C) - Spreadsheets offer formulas and functions, which make excel useful for: Performing basic mathematical operations such as summing columns and rows of figures. finding values such as profit or loss, calculating repayment plans for loans or mortgages, finding the average, maximum, or minimum values in a specified range of data, graphing or charting data to assist users in identifying data trends, sorting and filtering data to find specific information - Useful to keep track of assignments handed in and not handed in, total count of students marks in each subject and finding a class average **Demonstration (6 minutes):** - Begin by going on to excel 2007 How to rename the tab sheet to the appropriate grade or subject type: - Go to the top of the screen and click on the ‘Format’ menu, click on the ‘Sheet’ menu, and then the ‘Rename’ button - Add in the appropriate grade/subject for each tab How to add names/headings to the excel spread sheet: - Click under the A1, B1. . . rows and add the headings such as ‘Student name,’ ‘Assignment #1,’ and end with the last column ‘Total’ How to do the heading rows vertically at the top: - Select on column, or all columns, and then click ‘Cells’ on the ‘Format’ menu. Next, on the ‘Alignment’ tab, drag the red diamond under ‘Orientation’ upward so that the text will print at a 90 degree angle, and then click ‘Ok’ How to add the total points of the row: - To find the total amount of points for each student, enter the formula ‘=sum(B2:D2)’ How to find a class average: - Can find the average for either each assignment or for the class total at the end of the term - Go to the bottom of vertical row to get the average for each assignment, and put in the formula ‘=average(D2:D5)’ **Students Activity (8 minutes):** - Students will each go on their own computer and attempt to make their own electronic grade book while I am circulating around and helping those that have questions **Assessment:** - Students should be able to demonstrate how to use certain formulas to make an electronic grade book. This will allow them to use this effective information into their own classrooms **Questions (2 minutes):** - Students will be able to ask any questions that they were previously unclear or that they are unsure of