Griffin | Computer Apps II
 
Resume Table of Contents  

Computer Apps II
Excel - Project 5

Project 5
Creating, Sorting, and Querying a List

 
1. Excel Project 5 Assignment
Duration: 3 Periods
  Read the Case Perspective, Objectives, Intro, and Project Preview. p. 305- 365
 

Chapter 5 Power Point

Objectives:

  • Create and manipulate a list
  • Delete sheets in a workbook
  • Validate data
  • Add computational fields to a list
  • Use the VLOOKUP function to look up a value in a table
  • Use the Toggle Total Row in a list
  • Print a list
  • Use a data form to display, add, and delete records and change field values in a worksheet list
  • Sort a list on one field or multiple fields
  • Display automatic subtotals
  • Use Group and Outline features to hide and unhide data
  • Query a list
  • Apply database functions, the SUMIF function and the COUNTIF function to generate information from a list
  • Save a workbook in different file formats
2.

Complete Project 5. Type your name and date in the left header. Print the worksheet (with and without formulas) and hand into the instructor. Also print the CSV File with your name at the bottom of the document in Notepad.

Project 5 Soccer Gear Sales Rep List (without formulas)
Project 5 Soccer Gear Sales Rep List (with formulas)
Project 5 Soccer Gear Sales Rep List CSV (Notepad)

small

Grading:
1. Soccer Gear Sales Rep List  ___ 10 points
Total  
 ___ 10 points
p.305 - 365
3. Excel AYK 1 Assignment
Duration: 1 Period
p. 368
 

Complete the Apply Your Knowledge 1 Assignment. Type your name and date in the left header. Print the linked word document, fill it in and hand it into the instructor.

Apply 5-1 Querying a List

Grading:
1. Apply 5-1 Querying a List  ___ 10 points
Total  
 ___ 10 points
 
4.

Excel ITL 1 Assignment
Duration: 1 Period

p. 369 - 370
 

Complete the In The Lab 1 Assignment. Follow instructions Parts 1 - 3. Type your name and date in the left header. Print four pages: the list from Part 1(with and without formulas) and Part 3, Step 7 (with and without formulas) and hand into the instructor.

Lab 5-1-1 Apothecary Sales Rep List
Lab 5-1-3 Apothecary Sales Rep List

Lab 5-1-1 Apothecary Sales Rep List Part 1 without formulas
Lab 5-1-1 Apothecary Sales Rep List Part 1 with formulas
Lab 5-1-1 Apothecary Sales Rep List Part 3 without formulas
Lab 5-1-1 Apothecary Sales Rep List Part 3 with formulas

Grading:
1. Lab 5-1-1 Apothecary Sales Rep List  ___ 5 points
2. Lab 5-1-3 Apothecary Sales Rep List  ___ 5 points
Total  
 ___ 10 points
5.

Excel ITL 2 Assignment
Duration: 1 Period

p. 371 - 374
 

Complete the In The Lab 2 Assignment. Type your name and date in the left header. Print and hand into the instructor.

Lab 5-2

Grading:
1. Lab 5-2  ___ 10 points
Total  
 ___ 10 points
6.

Excel ITL 3 Assignment
Duration: 1 Period

p. 374 - 375
 

Complete the In The Lab 3 Assignment. Type your name and file name in the lower left footer. Print four pages: Printouts #1 and #4 with and without formulas and hand into the instructor.

Lab 5-3-1 Enviro Student Club List
Lab 5-3-6 Enviro Student Club List

Grading:
1. Lab 5-3-1 Enviro Student Club List  ___ 10 points
2. Lab 5-3-6 Enviro Student Club List  ___ 10 points
Total  
 ___ 10 points
7.

Excel Cases and Places Assignment
Duration: 2 Periods

 
 

 

Grading:
1.    ___ 10 points
Total  
 ___ 20 points
 
8. CH5 Quiz Optional – Complete the Online Practice Test  

top