Home > Group D Workspace > Learning Activity 5-D-1

Maggie, Katie, & Scott - Screencasts with Excel and PowerPoint


Subject: Information Technology
Lesson: Screen Recordings
Grade Level: 8th Grade
Length of Assignment: 2 class periods.

Pennsylvania Standards:
15.4.8.G: Create an advanced digital project using appropriate software/application for an authentic task.
15.4.8.K: Create a multimedia project using student-created digital media.
15.4.8.D: Create projects using emerging input technologies.

Learning Objective:
  1. Students will demonstrate their mastery of Microsoft Excel and PowerPoint components.
  2. Students will articulate their process for creating different presentations.
  3. Students will collaborate and evaluate student work with peers.

Directions:
1. Open a blank Excel workbook on your computer. This is what you will use for your screen recording mini-lessons.
2. Create a New PowerPoint with the Dividend Theme. Save to your student directory as Screen Recordings.
3. Slide 1
  • Insert the title “Excel Screen Recordings”.
  • Insert your name as the sub-title.
4. Slide 2
  • Insert a Title Only slide. Add the title “Using the Font Category”.
  • Insert your first Screen Recording.
    • Pin the Toolbar so that it is visible during the recordings.
    • Make sure the Pointer is also recording.
    • Use the toolbar to Select the Excel Window as your screen area.
  • Record the following mini-lesson: Add one word of text to cell A1 and make 7 different changes to the text using the font category commands.
  • Stop the recording when done. Watch the video to make sure it captures your lesson objectives. Re-do if necessary. Re-size the video on the slide.
5. Slide 3
  • Insert a Title Only slide. Add the title “Finding Custom Margins”.
  • Record the following mini-lesson: Show the viewer how to get to the Custom Margins settings in Excel.
  • Stop the recording when done. Watch the video to make sure it captures your lesson objectives. Re-do if necessary. Re-size the video on the slide.
6. Slide 4
  • Insert a Title Only slide. Add the title “The Segmented Pyramid”.
  • Record the following mini-lesson: Show the viewer how to insert a Segmented Pyramid Smart Art onto the spreadsheet.
  • Stop the recording when done. Watch the video to make sure it captures your lesson objectives. Re-do if necessary. Re-size the video on the slide.
7. Slide 5
  • Insert a Title Only slide. Add the title “Finding an Average”.
  • Record the following mini-lesson (this slide using Audio): Show the viewer how to use the Average formula. Use the data from the previous mini-lesson. You can average the Wins column.
  • Describe what you are doing in the lesson so that Audio is recorded.
  • Stop the recording when done. Watch the video to make sure it captures your lesson objectives and your audio. Re-do if necessary. Re-size the video on the slide.
8. Add a 1 ½ point black border around all 4 video recordings.
9. View the show to make sure the videos play when clicked.
10. Save your changes.

Assessment:
Students will be assessed for completion and for accuracy with the assignment. Since the lesson presumes students have already had extensive work with PowerPoint and Excel and have had a mini-lesson on screen shots, students should be able to complete the task with minimal difficulty.
  1. Teacher will walk around room to monitor progress and address any issues.
  2. Students will pair with one another to view/review each other's slides - following the information exactly as it is told to them during the videos.
    1. Doing this will help students get a better idea on how to best edit or script out their screen casts to make them easy to follow;.

Do you need a refresher on how to create a screencast? If so, watch one of the videos below:






Screencast Software . . .