Integration Assignment
Data Files needed for this assignment: Report.docx, Team.xlsx
Scenario:
The FSCJ Blue Wave Marathon team has an enrolled membership of more than 100 students participating in several events of racing. The team supports all of our students, including freshman to senior levels. The club is controlled by a board of directors and is funded through event fees, club dues, races, and fundraisers. At the end of each season, the club committee writes a short report for the board of directors summarizing the team’s racing season.
You are responsible to add a chart from an Excel file that shows the total number of the club members participating in each racing event. Complete the following steps:
Open the Word document Report and then save it as Board Report in the location where you are saving your files. Also, open the Excel workbook Team and then save it as Team Info in the location where you are saving your files.
Copy the chart on the Demographics Chart worksheet. Switch back to the Board Report document, delete the text “<Pie Chart>” between the two full paragraphs in the body of the report, and then embed the pie chart in that paragraph using the destination theme.
Modify the embedded chart so that the legend doesn’t show, and change the data labels so they are formatted as callouts (i.e., speech bubbles). Keep the default chart style.
Resize the chart so that it is 3.5 inches high and 6 inches wide, and then use the Center button in the Paragraph group on the HOME tab to center the chart horizontally.
Switch to the Team Info workbook, and then copy the range A4:F9 in the Marathon Events worksheet. Switch back to the Board Report document, delete the text “<Excel Data>”, and then link the copied data in that paragraph using the destination styles.
Switch back to the Marathon Events worksheet in the Team Info workbook, and then add the number of Advanced skiers for each race as follows, starting in cell E5: 15, 5, 3, 8, 4. Save your changes, and then close Excel.
Switch back to the Board Report document, and then update the link.
In the Board Report document, choose one of table styles and apply it to the table.
In the last paragraph in the document, type your name. Save the document, and then
close Word.
Upload both the Board Report Word document and Team Info Excel spreadsheet to
Blackboard.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more