Data/Analysis/Stats - 2062MB1-S8-mschraer
U4 Make an Excel Video
Skip To Content
Dashboard
  • Login
  • Dashboard
  • Calendar
  • Inbox
  • History
  • Help
Close
  • My Dashboard
  • Data/Analysis/Stats - 2062MB1-S8-mschraer
  • Assignments
  • U4 Make an Excel Video
Archived 2016-2017
  • Home
  • Modules
  • Textbook
  • Excel
  • Stats Textbook
  • Tutor.com: 24/7 Online Tutoring
  • Writable
  • VitalSource Course Materials
  • DBQ Online
  • Lucid (Whiteboard)
  • TeachTCI LTI 1.3
  • Visible Body (LTI 1.3)
  • Canva for Education
  • Gale Power Search
  • Credentials

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
This assignment was locked 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

    1. How to get on and do basic excel without a mouse: keyboard shortcut documents Links to an external site.
    2. Pivot tables (advanced)
    3. 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
1492239540 04/14/2017 11:59pm
Please include a description
Additional Comments:
Rating max score to > pts
Please include a rating title

Rubric

Find Rubric
Please include a title
Find a Rubric
Title
You've already rated students with this rubric. Any major changes could affect their assessment results.
 
 
 
 
 
 
 
     
Can't change a rubric once you've started using it.  
Title
Criteria Ratings Pts
This criterion is linked to a Learning Outcome Description of criterion
threshold: 5 pts
Edit criterion description Delete criterion row
5 to >0 pts Full Marks blank
0 to >0 pts No Marks blank_2
This area will be used by the assessor to leave comments related to this criterion.
pts
  / 5 pts
--
Additional Comments
This criterion is linked to a Learning Outcome Description of criterion
threshold: 5 pts
Edit criterion description Delete criterion row
5 to >0 pts Full Marks blank
0 to >0 pts No Marks blank_2
This area will be used by the assessor to leave comments related to this criterion.
pts
  / 5 pts
--
Additional Comments
Total Points: 5 out of 5
Previous
Next
U4 Lab 12 Trendlines U4 A Quick Write on Errors in Research