Complete Excel Module 1: Creating a Worksheet and a Chart, pages EX 1-1 – EX 1-65. Turn in a single screenshot of the worksheet and chart, each on a single page.

The purpose of this hands-on project is to give students an opportunity to create an electronic spreadsheet and a chart (CLO 4, MLO 4.1), and apply formulas and functions to an electronic spreadsheet (CLO 4, MLO 4.2). To do this, use the Technology for Success textbook, along with the video tutorial(s), to complete the Excel Project.

1. Complete Excel Module 1: Creating a Worksheet and a Chart, pages EX 1-1 – EX 1-65. Turn in a single screenshot of the worksheet and chart, each on a single page.

2. Complete Excel Module 1: Apply Your Knowledge, Changing the Values in a Worksheet (Delton Discount), pages EX 1-66 – EX 1-67. Be sure to follow the instructions as directed and turn in a single screenshot of the worksheet and chart, each on a single page.

3. Complete Excel Module 2: Formulas, Functions, and Formatting, pages EX 2-1 – EX 2-49. Turn in 3 screenshots (worksheet, worksheet section, worksheet formulas, each on a single page).

4. Complete Excel Module 2: Apply Your Knowledge, Cost Analysis Worksheet (Prontix Courier Service), pages EX 2-50 – EX 2-51. Be sure to follow the instructions as directed and turn in 2 screenshots in worksheet and worksheet formulas view, each on a single page.

5. Attach and submit your completed project (which should be a single Word document with word processing and/or screenshots of all assignment components, labeled and in order) by the assigned due date.
Customizations:
Module 1: Change “Frangold” to your last name
Module 1, Apply your Knowledge: Change “Delton” to your first name
Module 2: Change “Klapore” to the last name of a president
Module 2, Apply your knowledge: Change “Prontix” to the name of your favorite place to visit

Excel Project Assessment

Assignment Components Possible Points
Excel Module 1
Spreadsheet formatted correctly
Appropriate use of formulas
All totals are accurate
Chart formatted correctly
One page each

25
Excel Module 1,
Apply Your Knowledge

Spreadsheet formatted correctly
Appropriate use of formulas
All totals are accurate
Chart formatted correctly
One page total

25
Excel Module 2
Spreadsheet formatted correctly
Appropriate use of formulas
All totals are accurate
Worksheet, section, formulas views included, one page each

25
Excel Module 2, Apply Your Knowledge
Spreadsheet formatted correctly
Appropriate use of formulas
All totals are accurate
Worksheet and formulas views included, one page each

25
Total Points Possible 100

Last Completed Projects