Software Tutorials and Teacher Resources

 

PowerPoint

Excel

Where to find tutorials:
WikiVid: http://wikivid.com/index.php/PowerPoint
Microsoft Training site: (scroll down to find applications)http://office.microsoft.com/en-us/training/default.aspx
Microsoft Tutorials (Baycom Group): http://www.baycongroup.com
Atomic Learning: http://www.atomiclearning.com

Books: PowerPoint Workshop for Teachers, by Janet Caughlin, Tom Snyder Productions
Make It with Office, by Vicki Sharp, Visions
Software Charts, PowerPoint, www.softwarecharts.com

Presentation Tips
How to Avoid PowerPoint Poisening: http://www.wiredsafety.org/wiredlearning/toc.html
Presentation Advice: http://www.cob.sjsu.edu/splane_m/PresentationTips.htm
Creating an Effective PowerPoint Presentation: http://people.csp.edu/saylor/effective_powerpoint.htm
Scoring PowerPoints: http://www.fno.org/sept00/powerpoints.html

PowerPoint Activities
Game Examples: http://teach.fcps.net/trt10/PowerPoint.htm

Guiding Questions

  1. Who is my audience?
  2. What do I want to communicate?
  3. What are the key ideas?
  4. Is this a self-contained presentation?
  5. Or, is it complementary to my verbal presentation?
  6. Where will it be seen (classroom, large room, gym)?

Tips for better presentations:

  • Keep a simple, consistent design throughout (background, fonts, etc.)
  • Minimize the number of words on a slide – essential information only. Follow the Rule of 6 (6 lines of information per slide, maximum).
  • Use plenty of ‘white’ space.
  • Keep text readable – large size, contrasting color to background. Use sans-serif fonts (Arial, Helvetica) for titles, and serif (Times, Times New Roman) for longer text, like paragraphs.
  • Limit use of special effects – animations, sounds, etc.
  • Don’t just read your slides. This content is to help your audience note key ideas, not for your notes.
  • Face the audience, not the screen.

Where to find tutorials:
WikiVid for Excel: http://wikivid.com/index.php/Excel
BayCon Group Excel tutorial: http://www.baycongroup.com/el0.htm
MrExcel video tutorials: (and Podcasts) http://www.mrexcel.com/podcast/2005_10_01_archive.html
Atomic Learning: http://www.atomiclearning.com Internet4Classrooms: http://www.internet4classrooms.com/on-line_excel.htm

Books: Excel Workshop for Teachers, by Janet Caughlin, Tom Snyder Productions
Make It with Office, by Vicki Sharp, Visions
Software Charts, Excel, www.softwarecharts.com

Teacher Resources
EXCEL-lent Middle School Math Lessons! http://www.educationworld.com/a_tech/tech/tech079.shtml