Day+5+Screencasts+(Active)

toc =Introduction= media type="custom" key="13947298" Click here for a text version of this introduction. =Audience= The audience for this topic is any teacher who would like to create screencasts. There is a concentration on teachers who use Microsoft Excel in the classroom and who wish to educate learners about advanced formulas. Teachers of high school and adult students are the optimal audience, however topics may be scaled back for lower grade levels.

Prerequisite
Participants should have a strong intermediate understanding of Microsoft Excel. If you need to refresh your skills refer to the Resources page in this support wiki. =Objectives=
 * Create screencasts to use as a technology teaching tool.
 * Use screencasts to teach advanced formulas in Microsoft Excel.
 * Learn about different publishing options for screencasts.

**Activity 1**
View the following video media type="custom" key="13952270" (Created by Chrissy Waldron)

Questions

 * 1) How can you use screencasts in your classroom?
 * 2) Can you think of ways to use screencasts outside of your classroom?
 * 3) Would you consider allowing students to create screencasts as part of their assignments?
 * 4) Do you have any concerns about screencasts?
 * 5) What other questions do you have about screencasts? Feel free to post questions on the Discussion page and I will be happy to respond.

**Activity 2**
> media type="custom" key="13986038" > (Created by Chrissy Waldron)
 * 1) View the following video

Practice
> If you need help, review the video and use pages one and two of the tutorial.
 * 1) Download the Advanced Formulas workbook and tutorial.[[file:Advanced Formulas.xlsx]][[file:Advanced Formulas Tutorial.pdf]]
 * 2) Based on what you learned from the video, complete the first three sheets in the workbook.

**Activity 3**
> media type="custom" key="13990944" (Created by Chrissy Waldron)
 * 1) View the following video

Practice
> If you need help, review the video and use pages three through five of the tutorial.
 * 1) Based on what you learned from the video, complete the Books and Final Grades sheets in the workbook.

Follow-up Practice

 * 1) Create a screencast using Screen-o-Matic for a subject in your area of expertise
 * 2) Using the Embed Code, add the screencast to your website, wiki, or blog.
 * 3) Complete the bottom portion of the Final Grades sheet.
 * 4) Using the feedback from the online survey of your Workshop Support Wiki, calculate the percentages of responses based on returned statistics.
 * 5) Create a worksheet that incorporates a Nested If statement.
 * 6) Calculate the difference between your water bill from last year to this year as a percentage.

Comments on Day 5 Screencasts
Go to the Discuss this Wiki page in this wiki and answer the following:
 * 1) Were you able to complete the activities?
 * 2) Did you find viewing the videos helpful?
 * 3) Provide one example of how you can use one of the advanced formulas.
 * 4) Any other comments are welcome.

Overall Evaluation
Go to the Overall Evaluation page to complete an evaluation of this wiki.