2173 Salk Avenue, Suite 250 Carlsbad, CA

support@assignmentprep.info

Your project must be submitted as an Excel workbook (.xlsx, .xls). Your project

July 8, 2024

Your project must be submitted as an Excel workbook (.xlsx, .xls). Your project will be individually graded by your instructor and therefore may take up to seven days to grade.
To submit your graded project, proceed to the Lesson Assignment page in the course. Follow the instructions provided to upload the file and submit it for grading.
Be sure to keep a backup copy of any files you submit to the school!
After your assignment has been graded, feedback will be available on the Lesson Assignment page within the course. It will have an option to download the feedback from the instructor.
Introduction
This project requires you to develop a spreadsheet that tracks the cost of elementary school supplies distributed to teachers over a two-month period. You’ll assume the role of Office Manager, who has multiple responsibilities, including distributing and maintaining classroom supplies. For this project, you must prepare an Excel spreadsheet and chart that will be sent to the school District Manager.
Instructions
Create a Spreadsheet
Start Excel and create a blank workbook.
Enter the data shown in the following table and then format, sizing columns as necessary and right-aligning all number values. Save your file, naming it School Supplies.
Any Town Elementary School              
School Supplies Distribution              
Classroom Supplies Cost/Unit Sept. Units Sept. Cost % of Grand Total Oct. Units Oct. Cost % of Grand Total
Copy Paper 3.99 40     32    
#2 Pencils 0.75 29     12    
Pens 4 22     8    
Highlighters 3.29 12     10    
Markers 4.79 35     22    
Crayons 3.1 15     7    
Colored Pencils 2.29 60     28    
Staples 1.89 12     4    
Tissues 1.49 22     9    
Hand Sanitizer 2 16     7    
Merge and center cells A1 through H1. Format the school name as Title style.
Merge and center cells A2 through H2. Format the label as Heading 1 style.
Bold the labels in row 4 and right align the labels above the numeric values.
Format the Cost/Unit values as Currency with 2 decimal places. Your spreadsheet should look like the figure below.
In column D, enter appropriate formulas to calculate the September costs for each school supply. Your formulas must use cell references. Format the calculated values as Currency with 2 decimal places.
In cell A16, enter the label “Grand Total” and format it as bold.
In cell D16, enter a formula that uses a function to calculate the total of the column.
In column E, enter formulas that calculate the percentage of the grand total for each type of school supply (total cost of each item divided by the grand total). Your formulas must use appropriate absolute cell references. Format the calculated values as Percentage with 0 decimal places.
In cell E16, enter a formula that uses a function to calculate the total of the column (it should total 100%).
Repeat the process you used in steps 7–11 to calculate values for October.
Sort the school supplies alphabetically. (Be sure to select cells A5:H14 to sort the entire row of data.) Your spreadsheet should look similar to the figure below.
Save the modified spreadsheet.
Create a Chart
Create a chart by first selecting the cell ranges for the chart. Drag from cell A4 to A14 to select the range and then press and hold the Ctrl key while you drag from cell D4 to D14. Continue to press and hold the Ctrl key while dragging from cell G4 to G14. Your selected cells should look like the figure below.
Insert a 3-D Clustered Column chart.
Change the chart title to read “Cost of Supplies.”
Position the chart with the upper-left corner in cell A18 and then size the chart until it extends to column H, as shown in the figure below.
Save and close the workbook.
Scoring Guidelines
Rubric
Skill/
Grading Criteria Exemplary
(4) Proficient
(3) Fair
(2) Poor
(1) Not Evident
(0) Percentage
(%)
Enter data The correct data has been entered into the appropriate cells. Most of the correct data has been entered into the appropriate cells. Some of the correct data has been entered into the appropriate cells. Minimal correct data has been entered anywhere. No attempt has been made to enter data into the spreadsheet. 5
Format spreadsheet
All columns are sized appropriately to display labels and values.
All cells are in the indicated style.
Labels in rows 1 and 2 have been merged and centered above the appropriate cells.
The appropriate labels have been formatted as instructed.
Some columns are sized appropriately to display labels and values.
All cells have a style applied, but they’re in the wrong style.
The label in one row has been merged and centered.
Some of the appropriate labels have been formatted as instructed.
Few columns are sized appropriately to display labels and values.
One cell has an applied style in the indicated style.
The label in either row 1 or 2 has been merged without centering.
Appropriate labels have some formatting but may not be formatted as instructed.
Only one column is sized appropriately to display labels and values.
One cell has an applied style, but it’s the wrong style.
An attempt has been made to center labels above the data.
Some labels have been formatted.
No attempt has been made to change column width.
No attempt has been made to apply Excel styles.
No attempt to merge cells or center labels has been made.
No attempt to format labels has been made.
5
Cells formatted
The appropriate values have been formatted as currency with two decimal places.
The appropriate values have been formatted as percentage with no decimal places.
The appropriate values have been formatted as currency without two decimal places.
The appropriate values have been formatted as percentage with decimal places.
The appropriate values display a $ symbol but haven’t been formatted as currency.
The appropriate values display a % symbol but haven’t been formatted as percentage.
The wrong values have been formatted as currency.
The wrong values have been formatted as percentage.
No attempt has been made to format values as currency.
No attempt has been made to format values as percentage.
5
Use formulas with relative cell references All cost values have been calculated using two relative cell references. Cost values have been calculated using one relative cell reference.  N/A N/A Cost values don’t use any cell references. 10
Use formulas with absolute cell references The % of grand total values have been calculated with a formula that includes an absolute cell reference. Some % of grand total values have been calculated with a formula that includes an absolute cell reference. N/A N/A The % of grand total values haven’t been calculated using absolute cell references. 20
Use formulas with functions All grand total values have been calculated using a SUM function. N/A Grand total values have been calculated using a SUM function but without including all cell references. N/A Grand total values have been calculated using a SUM function but without including all cell references. 10
Sort data Supply data (rows 5 through 14) has been sorted alphabetically by supply name. Supply data (rows 5 through 14) has been sorted in reverse alphabetical order or by something other than supply name. N/A Only the supply data in column A has been sorted, making the spreadsheet data inaccurate. No attempt has been made to sort the data. 5
Create a chart A 3-D Column chart has been created using the correct data.  A chart of any type has been created using the correct data. A chart has been created using some of the correct data.  An attempt to create a chart has been made. No attempt has been made to create a chart. 30
Format and place the chart
The chart title has been changed appropriately.
The chart has been moved and sized to the specified location and dimensions.
The chart title has been changed to unspecified text.
The chart has been moved to the specified location or sized, but not both.
N/A N/A
No attempt has been made to change the chart title.
No attempt has been made to move or size the chart.
10
Submission Checklist
Before submitting your project, make sure you’ve correctly completed the following:
Create, save, and name an Excel file.
Enter data and labels.
Format labels with indicated styles.
Merge and center labels.
Format data with Currency and Percentage formats to the correct number of decimal places.
Size columns appropriately.
Use formulas that include cell references and a function where applicable.
Use relative and absolute cell references in formulas.
Sort data.
Create a chart from nonadjacent data.
Edit a chart.

Struggling With a Similar Paper? Get Reliable Help Now.

Delivered on time. Plagiarism-free. Good Grades.

What is this?

It’s a homework service designed by a team of 23 writers based in Carlsbad, CA with one specific goal – to help students just like you complete their assignments on time and get good grades!

Why do you do it?

Because getting a degree is hard these days! With many students being forced to juggle between demanding careers, family life and a rigorous academic schedule. Having a helping hand from time to time goes a long way in making sure you get to the finish line with your sanity intact!

How does it work?

You have an assignment you need help with. Instead of struggling on this alone, you give us your assignment instructions, we select a team of 2 writers to work on your paper, after it’s done we send it to you via email.

What kind of writer will work on my paper?

Our support team will assign your paper to a team of 2 writers with a background in your degree – For example, if you have a nursing paper we will select a team with a nursing background. The main writer will handle the research and writing part while the second writer will proof the paper for grammar, formatting & referencing mistakes if any.

Our team is comprised of native English speakers working exclusively from the United States. 

Will the paper be original?

Yes! It will be just as if you wrote the paper yourself! Completely original, written from your scratch following your specific instructions.

Is it free?

No, it’s a paid service. You pay for someone to work on your assignment for you.

Is it legit? Can I trust you?

Completely legit, backed by an iron-clad money back guarantee. We’ve been doing this since 2007 – helping students like you get through college.

Will you deliver it on time?

Absolutely! We understand you have a really tight deadline and you need this delivered a few hours before your deadline so you can look at it before turning it in.

Can you get me a good grade? It’s my final project and I need a good grade.

Yes! We only pick projects where we are sure we’ll deliver good grades.

What do you need to get started on my paper?

* The full assignment instructions as they appear on your school account.

* If a Grading Rubric is present, make sure to attach it.

* Include any special announcements or emails you might have gotten from your Professor pertaining to this assignment.

* Any templates or additional files required to complete the assignment.

How do I place an order?

You can do so through our custom order page here or you can talk to our live chat team and they’ll guide you on how to do this.

How will I receive my paper?

We will send it to your email. Please make sure to provide us with your best email – we’ll be using this to communicate to you throughout the whole process.

Getting Your Paper Today is as Simple as ABC

No more missed deadlines! No more late points deductions!

}

You give us your assignments instructions via email or through our order page.

Our support team selects a qualified writing team of 2 writers for you.

l

In under 5 minutes after you place your order, research & writing begins.

Complete paper is delivered to your email before your deadline is up.

Want A Good Grade?

Get a professional writer who has worked on a similar assignment to do this paper for you