Here is Part I and III of Week 5 COMP 101 assignment. Thank you.
Part I Week 5 DB assignment:
Required Discussion Board assignment.
You will often create or use compound MS Office documents. Using the library and the Internet (use only legitimate research sources), find the definition of a compound document. Also, research object linking and embedding.
Please write and cite your findings about the definitions you find, then briefly explain why the following items are or are not compound documents within the Microsoft Office framework (or environment):
- An external Excel spreadsheet linked into a Word document
- A Web page
Remember to provide your answers in terms of the question so that when the answer is read, anyone will know what you are answering. You may also include the questions with the answers beneath them.
This assignment’s grade is based on the quality of the Discussion Board posts. Be sure to read the Discussion Board assignment requirements. In most situations, you are required to post a specific number of paragraphs or words. Your postings should include proper grammar and spelling. References are required, so be sure you cite your references in correct APA style.
Part III Week 5 Individual Project (Due Sunday 4.27.14):
In this assignment, use the information from the previous unit’s Individual Project to create an expanded worksheet with a summary area and a chart showing this summary area.
- Open your old Unit 4 IP assignment, and save it as “Expense Report 3” in your working folder on your computer.
- In this exercise, you are going to create a chart showing the expenses in the categories listed below. You first need to calculate the data in a summary section of your spreadsheet. The data in the summary section will be used to create the chart.
- First, in cells O16–O21, enter the following labels (headers): “Summary,” “Travel,” “Meals,” “Entertain,” “Phone,” and “Other.” Do not include the quotes when entering the labels in your worksheet.
- Cells P17–P21 will hold the data you will calculate to get the total expense for each category. For example, if you went on a business trip, you would need to enter the amount you spent on travel in one cell, the amount you spent on meals in another cell, and so on. Then, you would use the Sum function to get a total of your expenses for the trip. Put the totals for each category next to the labels you have created. These formulas go in cells P17–P21.
- For Travel, include expenses for Ground, Air, Lodging, and Mileage $. Be sure to only include dollars in your formula. Enter the formula in cell P17.
- For Meals, include expenses for Brkfast, Lunch, and Dinner. Enter the formula in cell P18.
- Do the same for Meals, Entertain, and Other. If a category does not require the addition of one or more totals, do not use Sum or any other built-in functions. Use cell references for the data rather than entering the actual amount for each category.
- Finally, in cell P22, enter a function to show the total of cells P17–P21.
- After selecting the range O17-P21, create a pie chart to show the graphical representation of the expenses, using the figure below as a guide. Move the chart on its own chart sheet named “Pie Chart.” Include category names and percentages for data labels on your chart. Using the O17: P21 range will include your data labels and the data series to be charted.
- Add line callouts as shown in the figure. (Click the Insert menu and then the Shapes icon)
- Travel consists of Air + Ground + Lodging + Mileage $.
- Meals consist of Brkfast + Lunch + Dinner.
- Rename the sheet tab for the data spreadsheet as “Expense Report.”
- Save your final report as your “First initial Last name Expense Report 4.” Example: J Doe Expense Report 4.
- Submit your report.
Please submit your assignment.