Introduction
Users and Pushers. . . "I can use Excel, but I can't use
Excel."
Word? PowerPoint? FrontPage?
general purpose with specialized
functions
Publisher?
special needs for specific situations
Excel?
general purpose with specialized
functions (hold data for manipulation)
"Something for everybody. . ., but not everything for everybody."
What do you need?
What are you ready for?
"Be comfortable with ignorance-- not stupidity."
Exercises:
1) Enter basic table data into Excel:
|
name |
S |
O |
N |
T |
|
b |
3 |
6 |
5 |
(auto sum) |
|
d |
5 |
2 |
3 |
|
|
f |
7 |
4 |
5 |
|
|
a |
3 |
6 |
3 |
|
|
c |
5 |
2 |
5 |
|
|
e |
7 |
4 |
9 |
|
|
total |
(auto sum) |
2) format cells options (right click on cell): border,
number, font size/ color, row/ column width
Participation Rubric
weekly lesson format
3) formula: auto sum (average, subtract, divide, multiply, etc.)
Oregon Trail Purchases
4) sort by criteria (be sure to select only a single cell before sorting)
5) graph wizard (bar graph and many other types are available)
6) Select sheet 2 tab at bottom of open sheet.
Flash cards
math
spelling
url
Flash card data file
Can be posted to the web:
http://www.district87.org/staff/wetzelw/yeartoyear/0304supportmaterials/0001conststgd.htm
Can be pasted into Word document to
make a test.
7) Organize information: (materials file) (Find function =
Control -F)
Course materials
8) Sorting data:
Sorting data file
copy and paste student information to a new sheet (field trip)
change the 'Y' to a 1 with Find and replace function (Control -F)
auto sum the column to determine how many are going
sort to make lists of who is staying back
Remember: class lists and other student information can be put together from Skyward.
9) Student input:
Posted input form (FrontPage)
Data collection (Access) (file not linked—must export as Excel file)
10) Templates: (Linn McDonald)
http://www.district87.org/staff/mcdonaldl/using_excel.htm