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".