Teaching with Office - tools & tips to embed content
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
311 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Teaching with Office - tools & tips to embed content to your Wishlist.

Add to Wishlist

Teaching with Office - tools & tips to embed content

Use MS Office in a Windows environment to improve your lessons. Simple, functional techniques to add video and audio.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
311 students enrolled
Created by Anthony Hill
Last updated 5/2013
English
Price: Free
Includes:
  • 1 hour on-demand video
  • 6 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
What Will I Learn?
  • Make simple customizations to Office to use extra tools
  • To be able to embed various kinds of content within the standard Office range of files
  • To introduce examples of customized files
View Curriculum
Requirements
  • A Windows computer with MS Office, (2007 or later)
Description

We use Office products like Word, Excel and PowerPoint  in our classrooms for teaching, but usually we are not making the most of them. Here we will look at some modifications that take our use to a new level. This course shows simple practical techniques to enhance your use of these programs.

This course is designed for those who are teaching at any level in the education environment.

The course will be divided into sections dealing with the three main programs in Office (Word, Excel, & PowerPoint) although there is a certain degree of overlap as some tips will work in more than one program.

Who is the target audience?
  • General use by those involved in presentations
  • Teachers and Lecturers = educators
Students Who Viewed This Course Also Viewed
Curriculum For This Course
20 Lectures
01:09:59
+
Word
6 Lectures 20:45
Watch the video for the explanation of how to embed a video. Try this with a new word document or download the example and try with that. 

Remember the key changes are: Delete watch? Then replace = with /

Don't forget to untick Design mode to see the result.

Embed a Youtube document in Word
02:37

FAQ
Troubleshooting your embedding
00:39


Embed YouTube
10 questions

Use the Developer tab to use .swf shockwave files on your computer, network or the internet within your Word Document.
How to Embed Shockwave Animations and Videos from other file sources
08:33

Embedding an audio MP3 file or a quicktime movie in the Word document is relatively simple and very similar to the procedure with Shockwave. However, the Word document will cause a security warning, and the content must be enabled for it to work. The sample document given here is the same as from the video and links to audio and video content on the Internet.
Embedding a quicktime video in Word
03:44

We can also use a Windows Media Player Control to embed material. The attached document gives an example and a brief comparison of the functions of the three player controls.
Comparison of Embedded Players
00:07

  1. This explanation is about using the hyperlink screen-tip to display a message above words or phrases in your document. 
Pop up boxes to explain parts of your Word document.
05:05
+
Excel
3 Lectures 17:44
Use Excel to create an interactive poster. By moving the mouse over the picture pop up comments provide an added description. This video will show you how to do that.
Using Excel to make an Interactive Poster
05:34

Specify the time that data was entered in a cell and make it stick so that it is not updated by other operations in the spreadsheet. Using the NOW() function in a circular reference lets us make unique time stamps for cells within our spreadsheet.
Time stamp by iteration
04:19

With the timestamp function we can create an attendance spreadsheet to display student names based the Student ID or barcode.
An attendance spreadsheet with time stamping
07:51
+
PowerPoint
5 Lectures 24:25
A simple built feature of PowerPoint that is often overlooked in presentations.
Pen tools
01:20

Make an interactive game with PowerPoint and some extra mice. All the mice connect to the one computer using the Microsoft free Multiple Mouse addition to PowerPoint. 
Multiple mice quizzes with Mouse Mischief
12:35

Simple branching with yes and no responses to question slides.
Branching PowerPoint
09:57

If you take the branching program as your basis, you can make a fun competitive quiz game on an interactive whiteboard. Just set up two sides on the board with identical answers but differentiated by colour. Then with two individuals from teams you can swat the whiteboard. The first person to hit an answer gets hyperlinked to either the correct or incorrect page for their colour. Try the example then make your own variation. 
Interactive quizzes with PowerPoint on your eWhiteboard
00:18

If you find that the answer flicks back to the question too quickly when the second person strikes the board you might like to look at the show and return version. However show and return requires you to set up Custom shows. Then you can have the answer slide return after a preset time rather than via the board touch.

A video demonstrating this will be included shortly. The principle is much the same. You can deconstruct the attached example to see how it works.

Interactive whiteboard Quiz with show and return
00:15
+
Setting up your programs - supplementary written and visual guides for the above
5 Lectures 04:37

The Developer Tab is an essential component of many of the modifications that are shown in this course. Make sure you have the Developer Tab visible.
Turn on the Developer Tab in Word 2007
01:21

Speak Cells on enter is a useful quick launch button which lets the computer read the content of each cell. This is very useful when you are entering data, to get an audio verification. It also provides a useful tool for some extra features which we will look at when making a spelling test.

Speak cells - getting Excel to talk to you
02:05

Turn on Iterative calculations to permit the time stamping function.

Enable Iterative Calculations
01:06

Turn on Developer Tab in Excel
00:03

Turn on the Developer Tab in PowerPoint
00:02
+
The End
1 Lecture 00:00
Attached is a Macro Enabled Excel spreadsheet that you can use for recording points in a class. It can score individual, teams/groups and also has an overall class mood smiley face. You can modify it and copy as you wish. However, as it is macro enabled you will always have a security warning when you open it. 
Bonus
2 pages
About the Instructor
Anthony Hill
3.9 Average rating
6 Reviews
1,461 Students
2 Courses
Educational Technology & ICT specialist

Professional Educator and teacher trainer. Experienced teacher at Primary (elementary), Secondary, and Tertiary levels in New Zealand, Japan and the UAE.  Educational Technology specialist and innovator. Currently lecturing ICT in  a Teachers' Training College. I have a background in Film and Media which has made me prefer to use animated characters for many of my video presentations.