contact us

Use the form on the right to contact us.

You can edit the text in this area, and change where the contact form on the right submits to, by entering edit mode using the modes on the bottom right.

           

123 Street Avenue, City Town, 99999

(123) 555-6789

email@address.com

 

You can set your address, phone number, email and site description in the settings tab.
Link to read me page with more information.

Lemonade Stand Part VI

Step 1:

Retrieve the spreadsheet you completed from Parts I-V from your email. You should log in, go to your "sent" folder, open the email you sent to DrydenAssignments@uaglobalcommerce.org, download the file, and open the file.

Step 2:

Today you are going to learn how to use Excel to turn spreadsheet data into graphs. Graphs are very useful in translating raw data into a visualization that allows others to draw conclusions based on your data. You will be using this to draw conclusions based on your Lemonade Stand Game performance.

Step 3:

Watch this video and create a graph to show the relationship between Total Cost and Total Profit. Total Profit is what we have left after we subtract Total Cost from our Revenue. Remember to pause the video after each step and complete the step in your spreadsheet.

Step 4:

Watch this video and create a graph to show the timeline of your Total Income. This graph will help you communicate your business's successes and struggles over time. Remember to pause the video after each step and complete the step in your spreadsheet.

Step 5:

Watch this video to create a graph to show the cost associated with Inventory. We discussed many of the expenses related to inventory in class and now is your opportunity to create a visualization that could teach others about these costs. Remember to pause the video after each step and complete the step in your spreadsheet.

Step 6:

Click "file" and "save as" to save this updated Excel Workbook as "Firstname Lastname LS 6". Go to your email and send this file as an attachment to "DrydenAssignments@uaglobalcommerce.org".