1 / 31

IAP Lecture

IAP Lecture. Part 1. Animation in PowerPoint Part 2. Some features in Excel by Jim Orlin. The slides are available on my website: web.mit.edu/jorlin/www/talks.html PowerPoint notes are available with many of the slides. Introductions.

ncrandall
Download Presentation

IAP Lecture

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IAP Lecture Part 1. Animation in PowerPoint Part 2. Some features in Excel by Jim Orlin The slides are available on my website: web.mit.edu/jorlin/www/talks.html PowerPoint notes are available with many of the slides.

  2. Introductions • How familiar are you with PowerPoint and what do you hope to learn?

  3. My Goal • Have some fun • Present some cool features • Help people out • Not a goal: focus on basic instruction in PowerPoint and Excel

  4. Animation Animation Animation Animation Animation Animation Why I Love PowerPoint • I have a poor memory • Ability to focus attention of class • Animation • Ability to organize a lecture (and help with timing)

  5. But Some People Hate PowerPoint PowerPoint Is Evil Power Corrupts.PowerPoint Corrupts Absolutely. By Edward Tufte

  6. Overview of Lecture • First Half: PowerPoint • basic techniques • More advanced algorithm animation • Second Half: Excel • cool effects for classroom presentations

  7. How to Illustrate Concepts (or not) Difficulty in illustrating PowerPoint: there are tons of PowerPoint Effects. Some can be entertaining the first time. But they quickly lose the effectiveness. And they can be distracting and/or boring. And clip art doesn’t substitute for ideas. And reading what is on the slide can irritate audiences.

  8. Algorithm Animation • Powerpoint has lots of animation tools that are useful for illustrating concepts. Colors and transitions can simulate movement. Boxes can appear, and disappear. And one can use real movement. And pictures can help.

  9. Using Custom Animation Step 1. Select Custom Animation from the Slide Show Menu. Step 2. Select the item(s) to be animated. Step 3. Click on the add affect button Step 4. Add the effect. Boxes can appear, and disappear.

  10. Adding Animation to Each Slide Easily • Select “Master” from the view menu. • Select Slide Master • Format title and other text styles • Add custom animation • Select Text Animation • Group text if desired

  11. On grouping text • This animation effect is a wipe from left • it is grouped by second level paragraphs • third level indents appear at the same time as second level ones. • fourth level appear at the same time as second level • Next: Illustrating some more advanced techniques

  12. What is the maximum number of diamonds that can be packed on a Chinese checkerboard? class exercise: how many can you pack? Each diamond covers 4 dots.

  13. Here is a best possible 27 diamonds.

  14. Computing an upper bound Assign each circle (or node) a “weight.” The weight of a diamond d is w(d) = the sum of its node weights. An upper bound: total weight such that for each diamond d, w(d) ≥ 1. Assigning ¼ to each circle gives a total weight of 30.25. Can you do better?

  15. Here are 27 diamonds .3 .2 .5 0 What is the weight of the circles covered by diamonds?

  16. Node Weight 18 1 1 24 1/2 6 1/3 1/6 0 Each diamond has weight at least 1. The number of diamonds is at most 27.

  17. A technique for animation creation • Select diamonds in the order that you want them to appear. • Animate them • Select the animated elements • Select “start after previous” or “start on click”

  18. Carrying out movement • Select the item. • Add a movement effect with custom animation

  19. 1 3 2 5 -1 6 1 0 1 0 1 4 5 3 0 5 Illustrating matrix operations. Adding a row of a matrix to another row Add row 1 to row 2. Have the answer appear by wiping down at medium speed. 0 9 3 5 Or speed it up, as in adding row 1 to row 3.

  20. Illustrating Binary Search • I am thinking of a number x between 1 and 64. You have 6 guesses. If you guess y, I will tell you if x  y or x > y.

  21. A cool macro for hiding things or possibly making them appear 1 2 3 4 5 6 7 8 9 10 11 12 Put back boxes

  22. Category Heading Category Heading Category Heading Category Heading MIT Course Numbers 100 100 100 100 100 200 200 200 200 200 300 300 300 300 300 400 400 400 400 400 500 500 500 500 500

  23. Chemical Engineering What is Course 10?

  24. Nuclear Science and Engineering What is Course 22?

  25. Linguistics and Philosophy What is Course 24?

  26. Biological Engineering What is Course 20?

  27. The two numbers from 1 to 24 that do not correspond to MIT Courses What are 19 and 23?

  28. Questions?

  29. Excel • How familiar are you with Excel and what do you hope to learn?

  30. Overview • Use of relative and exact positioning. • Conditional formatting • The family feud (appear and disappear) • Paste Special Command • The birthday problem, illustrating lots of things IAP Excel Spreadsheets Independent 1’s

  31. Questions? • Thanks for being a great audience.

More Related