Excel 2007
Chapter 5:
Creating, Sorting & Querying a Table
All assignments on this page are due on 26 Apr, and may not be accepted for full credit past 30 Apr.
Chapter 5 Lessons |
eBook Lesson 5:
Creating, Sorting & Querying a Table
|
Files to turn in:
LN Silver Photography Accessories Sales Rep Table.xlsx
+ 3 printouts
(2 xlsx, 1 csv)
|
Rubric
|
20 points
|
|
Chapter 5
Review & Practice:
|
eBook Review Activities:
Apply Your Knowledge
Extend Your Knowledge
Make It Right
In the Lab
Lab 4-1
Lab 4-2
Lab 4-3
|
Files to turn in:
6 printouts
(print the results of each query)
LN Extend 5-1 Jensen Basket all Poles Complete.xlsx
+ 2 printouts
LN Make It Right 5-1 Van Dyl Kitchen Accessories Sales Rep List Complete.xlsx
LN Lab 5-1 Whitman Publishing Sales Rep Table.xlsx
+ 23 printouts
(Part1: 1, Part2: 12,
Part3: 7, Part4: 2, Part5: 1)
LN Lab 5-2 Consultant Specialist Table Final.xlsx
+ 12 printouts
(Part1: 3, Part2: 4,
Part3: 4, Part4: 1)
LN Lab 5-3 Do-Gooders' Student Club Table.xlsx
+ 7 printouts
(Part2: 3,
Part3: 4)
|
Rubric
Rubric
Rubric
Rubric
Rubric
Rubric
|
12 points
15 points
10 points
30 points
30 points
30 points
|
Chapter 5 Assessments
Complete as Homework!
|
Vocab Quiz 5 (Quia)
Review Worksheet 5 (Quia) |
15 points
36 points
|
Chapter 5:
Reflection Question
Complete as Homework!
|
Copy and paste the questions below into a new email message.
Add the subject line Excel RQ 5
Answer each question fully as directed in the RQ guidelines & Rubric page
Send the email to kerri.pangman@eu.dodea.edu
Which do you think would be more useful for database filtering in Excel: using a Criteria Range or using Advanced Filters?
|
15 points
|
|
