Transcript IAP Lecture - MIT Sloan Faculty - James B. Orlin

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.
1
Introductions
• How familiar are you with PowerPoint and what
do you hope to learn?
2
My Goal
• Have some fun
• Present some cool features
• Help people out
• Not a goal: focus on basic instruction in
PowerPoint and Excel
3
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)
Animation
Animation
Animation
Animation
Animation
Animation
4
But Some People Hate PowerPoint
PowerPoint Is Evil
Power Corrupts.
PowerPoint Corrupts Absolutely.
By Edward Tufte
5
Overview of Lecture
• First Half: PowerPoint
– basic techniques
– More advanced algorithm animation
• Second Half: Excel
– cool effects for classroom presentations
6
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.
7
Algorithm Animation
• Powerpoint has lots of animation tools that are
useful for illustrating concepts.
Boxes can
appear, and
disappear.
Colors and transitions
can simulate movement.
And one can use real
movement.
And pictures can help.
8
Using Custom Animation
Boxes can
appear, and
disappear.
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.
9
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
10
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
11
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.
12
Here is a best possible
27
diamonds.
13
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.
Assigning ¼ to each circle
gives a total weight of
30.25.
Can you do better?
An upper bound: total
weight such that for each
diamond d, w(d) ≥ 1.
14
Here are 27 diamonds
.3
.2
.5
0
What is the
weight of
the circles
covered by
diamonds?
15
Node
Weight
18
1
1
1/2
24
6
1/3
1/6
0
Each diamond has
weight at least 1.

The number of diamonds is at most 27.
j
w j  27.5
16
A technique for animation creation
1. Select diamonds
in the order that
you want them to
appear.
2. Animate them
3. Select the
animated
elements
4. Select “start after
previous” or
“start on click”
17
Carrying out movement
1. Select the
item.
2. Add a
movement
effect with
custom
animation
18
Illustrating matrix operations.
Adding a row of a matrix to another row
1
3
2
5
-1
0
6
9
1
3
0
5
0
1
1
4
3
5
0
5
Add row 1 to row 2.
Have the answer
appear by wiping
down at medium
speed.
Or speed it up, as in adding row 1
to row 3.
19
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.
1 2 3 4 5 6 7 8
9 10 11 12 13 14 15 16
17
25
33
41
18
26
34
42
19
27
35
43
20
28
36
44
21
29
37
45
22
30
38
46
23
31
39
47
24
32
40
48
49 50 51 52 53 54 55 56
57 58 59 60 61 62 63 64
20
A cool macro for hiding things or possibly
making them appear
Put back
boxes
1
2
3
4
5
6
7
8
9
10
11
12
21
MIT
Course
Numbers
Category
Heading
Category
Heading
Category
Heading
Category
Heading
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
22
Chemical Engineering
What is Course 10?
23
Nuclear Science and Engineering
What is Course 22?
24
Linguistics and Philosophy
What is Course 24?
25
Biological Engineering
What is Course 20?
26
The two numbers from 1 to 24 that
do not correspond to MIT Courses
What are 19 and 23?
27
Questions?
28
Excel
• How familiar are you with Excel and what do you
hope to learn?
29
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
30
Questions?
• Thanks for being a great audience.
31