07 Excel 1 Demo-School Store
- Due Nov 2, 2022 by 11:59pm
- Points 10
- Submitting a file upload
Assignment Overview
You will be creating, importing data, formatting and adding formulas and a chart to an Excel Workbook
- Watch and follow along with the demonstration video to complete the assignment.
- You will then submit the requested files showing your completed work.
Guidelines
To insure full credit for your assignment, make sure to compare it to the demo files and then once uploaded to Canvas, double check your submission.
Turn In: Turn in your completed .xlsx document as directed in the video demo
Video: Excel 1 Demo School Store
Links to an external site.
OneDrive Link for files needed for assignments
Links to an external site.
Technical Support
Need help using Canvas Assignments? If so, please review the following guide:
Rubric
Find Rubric
Please include a title
Keep in mind that 1 student has already been assessed using this rubric. Changing it will affect their evaluation.
| Criteria | Ratings | Pts | ||
|---|---|---|---|---|
|
Excel file submitted .xlsx
threshold:
pts
|
|
pts
--
|
||
|
3 sheets in file: Orders, Formulas, & chart
threshold:
pts
|
|
pts
--
|
||
|
Row 1 heading entered and formatted
threshold:
pts
|
|
pts
--
|
||
|
Data imported/entered
threshold:
pts
|
|
pts
--
|
||
|
Days of week generated above data
threshold:
pts
|
|
pts
--
|
||
|
Cell styles applied to row and column headings and total row
threshold:
pts
|
|
pts
--
|
||
|
Correct number formats applied-Currency
threshold:
pts
|
|
pts
--
|
||
|
Formulas entered and sheet copied and named formulas
threshold:
pts
|
|
pts
--
|
||
|
Sheets ordered correctly with chart at end
threshold:
pts
|
|
pts
--
|
||
|
Chart created and formatted correctly
threshold:
pts
|
|
pts
--
|
||
|
Total Points:
10
out of 10
|
||||