U4 Make an Excel Video
- Due Apr 14, 2017 by 11:59pm
- Points 10
- Submitting a website url or a file upload
- Available until May 12, 2017 at 11:59pm
MAKE A VIDEO ABOUT EXCEL
Requirements
- 2-5 minutes
- Explains each step
- At start outlines skills the video will cover
- At the end summarizes skills
- Include image of a text box or power point slide that lists skills
- Publish on youtube
Topics: Pick one and use the following data set for the video: Data for video.xlsx
- How to get on and do basic excel without a mouse: keyboard shortcut documents Links to an external site.
- Pivot tables (advanced)
- Regression: residual graph (you need to learn how to do this first), slope, intercept, correlation, R-squared, how to put information on graph and what that information tells you
Resources to Look at BEFORE making the video:
- Screen-casto-mati Links to an external site.c: one person in the group should join so you can use this to make the video (tutorial Links to an external site.)
- Excel Videos on your topic: watch a few videos on your topic so you can get an idea of how to make the video and what information to give. You can learn from both good and bad videos – the bad ones help point out things to avoid.
- Research through websites or videos, how exactly to do the skill you are teaching
Before Making the Video
- Write a script.
- Make a very short practice video on any topic to be sure you know how to use screen-casto-matic