M
O
D
U
L
E |
Skills in Microsoft Excel |
Lesson Plans/ Lesson Plan Ideas/ Teacher Tools
that Incorporate those Skills
|
Tutorials for those Skills (these
tutorials
cover a variety of versions of Word and you may have to adapt the
instructions to fit your version...and sometimes there are pieces that
are incorrect
because of the difference in versions)
|
A
S
S
E
S
S
(.5
hr.) |
Assessment |
Assessment
with a Twist (ppt)
Spinner
Substitute (xls)
Skill List |
Mathematicians
Are Good |
I
N
T
R
O
(1
hr.) |
Introduction |
M&M Math
intro
More
M&M Math |
|
1
(1
hr.) |
Basic
Data Entry
cell names
click, tab, or enter
Basic Formula Writing
=sum()
Chart
(Graph) Making
highlight cells and use Chart Wizard
bar graph
Formatting Cells
cell background color
color text
Printing
print area
print preview
gridlines
|
Lesson
Plans with Data Entry & Formula Writing
Do
Vampires Really Exist?
The
Big Allowance
Money
Changer
Magic
Squares
Lesson Plans with Data Entry,
Formula Writing, AND Chart
Making
How
Much Water Does Your Family Use?
1000
Lockers
Analyzing
Smoking and Lung Cancer
Analyzing
Birth Rates
Exploring
Sunspots
Sunspots
and Geomagnetic Disturbances
|
 This tutorial shows you the basics
of Excel (assumes very little prior
background) while making a gradebook (Bob Hope and Eddie Murphy will be
in your class!); so you'll learn many of the skills listed to the left
while learning how to make something useful in Excel
http://storywind.net/education/mccarthy/lessons/exceltutorial.html
For some fun "extras" to add to your gradebook, check out Help-->Sample Documents-->Data Analysis
A nice introduction to Excel with lots of screenshots
http://www.functionx.com/excel/Lesson01.htm
This brief introduction to Excel includes formulas, charts, and
formatting cells
http://www.bcschools.net/staff/ExcelHelp.htm
This introduction to Excel is based on 5th grade science standards
about weather. It's from Canada so all the measurements are metric but
the Excel is the same. ;-) You can download their sample Excel file so
that you can follow along on the tutorial.
http://www.quasar.ualberta.ca/edit202/tutorial/spreadsheet/ExcelBasics/ExcelBasics.htm
A
large collection of Excel tips and tricks (quick how-to's)
http://www.exceltip.com/se/10.html
All about printing
http://www.functionx.com/excel/Lesson03.htm
|
2
(1
hr.) |
More
Chart Making
modifying colors, backgrounds, titles, and more
adding text boxes, lines, and shapes "on top" of a finished chart
inserting your chart into Word . . . as a graphic or as a
spreadsheet
|
Ambidextrous
Graph
Full lesson plan for ambidextrous graph
http://math.rice.edu/~lanius/Algebra/rightleft.html
|
Using
Excel WordArt
http://www.smartcomputing.com/Editorial/daily/dailycontent.asp?guid=&did=970
How to insert clipart in Excel
http://www.techtrainteam.com/services/olt/office2000/xls-a7.html
To see some slick charts with graphics embedded in them, go to Help-->Sample Documents-->Charts
|
3
(1
hr.) |
Clip
Art
Word Art
Auto
Shapes |
Clip Art & Word Art
Single
Use Spreadsheets
Auto Shapes
See "Assessment with a Twist" above |
|
4
(1 hr.) |
Resize
Columns and Rows
format, manual change,....
Print
print area
borders
gridlines
header/ footer
page breaks
|
Make your own graph
paper/grid paper (see
M&M Math and
Ambidextrous Graph lesson plans above), make specialized paper
including music staff paper
Grid
Paper &
Scale Drawings
Plan
Your Garden
with Excel
|
Nice
tutorial with a simple example about
columns and rows (width, height, hide, unhide, format, etc.)
http://www.functionx.com/excel/Lesson02.htm
|
A
D
V
A
N
C
E
D |
Using
Excel as a Mini- Database
sorting
importing/ exporting data
Absolute
References in Formulas (vs. relative references)
Macros
Random Numbers
Drop Down Menus
Sliders
Pivot Tables |
Excel as a Mini-Database
Lesson
plan for using spreadsheet as database software
Absolute References ($A,$1)
Macros
- see "One Grain of Rice" above
Random
Numbers
Drop Down Menus
Sliders
Pivot Tables
|
Tutorial on sliders. You're not going to believe how easy they are to do. :-)
http://aitt.acadiau.ca/tutorials/Excel97/Sliderbars.htm
To learn about Pivot Tables, go to Help-->Sample Documents-->Pivot Tables
Article about generating names randomly to call on them in class using Excel:
http://www.eschoolnews.com/news/showStoryts.cfm?ArticleID=6341
|
N
E
E
D
TO
A
D
D |
|
- sorting
-
header rows
-
multiple sheets
-
referencing other sheets
-
data-->get external data-->import from Filemaker Pro
-
formatting text to be at an angle
-
formatting numbers ($, time, decimals,...)
-
wrap text
-
forced return within a cell
- make word search puzzles using random letter generator (module 4)
|
|
