E-LITERACY
3rd
6-WEEKS ASSIGNMENTS
There are 22 Microsoft Excel assignments, 5 Microsoft Power Point assignments and an Internet Research Travel Project. Listed below are the Excel assignments. Students may work on these assignments in class, at home, or in the SHS library. Books may be checked out. Check the Dates and Deadlines link for lecture and due dates.
CHAPTER
|
UNIT/
ORIGINAL FILE
|
NEW
FILE NAME
|
JOB# |
POINTS |
|
Excel 2000 Unit A
|
|||||
|
Pages 146 - 161 |
Create a worksheet |
Product Order 6-30 (1) |
#1 |
|
20 |
|
Pages 163 - 165 |
Skills Review |
Shipping Ticket 7-30 (2) |
#2 |
|
20 |
|
Pages 165 - 166 |
Independent Challenges #1 |
August Order Summary (3) |
#3 |
|
20 |
|
Page 166 |
Independent Challenges #2 |
Items Comparison (4) |
#4 |
|
20 |
|
Pages 166 – 167 |
Independent Challenges #3 |
Quarterly Sales (5) |
#5 |
|
20 |
|
Handout |
Extra Independent Challenge #1 |
Order Form (6) |
#6 |
|
20 |
|
Handout |
Extra Independent Challenge #2 |
Senatorial Travel (7) |
#7 |
|
20 |
Excel 2000 Unit B
|
|||||
|
Pages 170 - 185 |
(XL B-1) (Print after Step #4, p. 184) |
Mountain Air Order (8) |
#8 |
|
10 |
|
Page 184 |
(XL B-1) (Print after Step #7, p. 184) |
Mountain Air Order (9) |
#9 |
|
15 |
|
Pages 188 -189 |
Skills Review 1 (XL B-2) |
August Sales (10) [fit to one
page] |
#10 |
|
20 |
|
Pages 190 - 191 |
Independent Challenge #3 (XL B-3) |
Art Trips 2001 (11) [fit to 1
page] |
#11 |
|
15 |
|
Handout |
Extra Independent
Challenge #1 (XL B-4) |
Expansion Analysis (12) |
#12 |
|
15 |
|
Handout |
Extra Independent
Challenge #2 (XL B-5) |
Grades (13) [2 pages] Copy & paste sorted answers
to Step 7 in a Word document. Print
Worksheet in Step 9 & staple together. |
#13 |
|
20 |
Excel 2000 Unit C
|
|||||
|
Pages 196- 209 |
XL C-1
|
Sales Chart (14) |
#14 |
|
10 |
|
Pages 212 - 213 |
Skills Review (XL C-2) |
Adventure Chart (15) |
#15 |
|
15 |
|
Page 214 |
Independent Challenges #1 (XL C-3) |
Card Chart (16) |
#16 |
|
10 |
|
Page 214 |
Independent Challenges #2 (XL C-4) |
Animal Chart (17) |
#17 |
|
10 |
|
Page 215 |
Independent Challenges #3 (XL C-5) |
Attendance Chart (18) |
#18 |
|
15 |
|
Page 216 |
Visual Workshop |
Sales Rep Chart (19) |
#19 |
|
15 |
|
Handout |
Extra Independent
Challenge #1 (XL C-6) |
Advertising Chart (20) |
#20 |
|
10 |
|
Page 168 |
Visual Workshop |
Ticket Sales Analysis (21) |
#21 |
|
15 |
|
Page 192 |
Visual Workshop |
Playhouse Analysis (22) |
#22 |
|
15 |