integrated assignment

by | Jun 17, 2020 | Uncategorized

  

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 “” 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 “”, 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.

  

Why work with us?

Authenticity:

All of our papers are authentic, as each paper of ours is composed according to your unique requirements. Confidentiality: We value you data. Our company is extremely efficient in guarding the privacy of our clients. 100% Money Back Guarantee: In the event you cancel your order, you get your money back as soon as possible, we give a 100% refund. 24/7 Support: Our team members are available via email, live chat, and phone. Revision Policy: You can apply for a revision if you think your paper could be better. In this case, your paper will be revised either by the specialist assigned to you or by another writer.

How the Platform Works

  • Click on 'Place Your Order' tab on the menu or click on 'Order Now' tab at the bottom and a new order page will appear
  • Fill in your requirements depending on your needs under the 'PAPER DETAILS' area
  • In the next section, fill in the academic level, required number of pages, paper deadline as provided in the drop-down menus.
  • To enter your registration details, click on 'CREATE ACCOUNT & SIGN IN'. This step allows you to create an account with us for purposes of record-keeping. Click on 'PROCEED TO CHECK OUT' at the bottom of the page
  • The next section requires you to fill in the payment details. Follow the guided process and soon your order will be available for our team to work on.