Excel Portfolio - Bar Chart Mapping - Portfolio Assignment Help

Assignment Task:

1. A class activity was conducted and students received grades. You have been hired to assist the teacher. 9 students failed, 35 received a pass, 40 students received a credit, 6 students received a distinction and 16 received a high distinction. Last year 16 students failed 40 passed, 30 received a credit, 9 received a distinction and 7 received a high distinction.
a. Convert results in percentages
b. Use column graph to present your answers for both years and compare them

2.a. Using a formula calculates a total of all medals for top 20 countries
2.b. Calculate the average number of total medals for the first 20 countries (using a formula). 

3. Create a bar chart mapping the 7 top countries and their medals. 

4. Add a column and name it good scores. Click in the cell under the title (in the same row as the entry for the first country and add IF statement. 
IF “Gold” – add a reference to a cell is greater than “>” 20 add text good score (hint: good score info should be displayed in a new column). 

5. Add Conditional Formatting – you will find it in Styles under Home. Select “Gold Column” – add Conditional Formatting and colour all Gold medals < then 5 red. 

6. It is expected that each country should improve by 9% next time games are run. Create a new column and identify how many medals each country will receive if they were to improve for 8%.  

7. create a separate Excel document containing the names of the IOC Executive Board members. 

8. Using Word write a letter of appreciation to each one of them. 

9. Do a mail merge – your document should start with the greeting ie. “Dear Full Name

10. Undertake myIT activities and complete my Excel test (check views for details). Please note Chapter activities can be done many times. Excel test can be done only once. Copy the screen of your test result and paste it under question 10 answer.

This Portfolio Assignment has been solved by our Portfolio Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.