Prepare a spreadsheet to show the results from round 20 of the AFL 2013 season.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Q1 Question 1

The following AFL football scores were recorded for round 20 in AFL season 2013.

Team	Goals	Points	Total	Vs	Team	Goals	Points	Total
Collingwood	20	13	133	Vs	Essendon	7	12	54
Adelaide	15	13	103	Vs	Port Adelaide	17	5	107
Bulldogs	15	9	99	Vs	Sydney	11	11	77
Carlton	12	8	80	Vs	Fremantle	17	14	116
West Coast	20	10	130	Vs	Gold Coast	17	11	113
Hawthorn	9	12	66	Vs	Richmond	16	11	107
Greater Western Sydney	19	10	124	Vs	Melbourne	12	15	87
North Melbourne	15	6	96	Vs	Geelong	13	8	86

 

Each goal is worth six points.

1. Prepare a spreadsheet to show the results from round 20 of the AFL 2013 season.
2. Use a formula to calculate the total score for each team and extend that formula to all teams in the column.
3. Create the main heading for the spreadsheet in merged cells across the page.
4. Adjust the size of columns and rows so that it prints well on an A4 page. You may choose landscape or portrait printing.
5. Use cell styles to colour the winning team’s cells green.
6. Add a comment ‘Winner’ in the cell of the name of each winning team.

Q2 Question 2

You may need to rearrange the data, to have all the data in one column in order to make the following charts:

1. Present the football scores (total only) as a Bar Chart and a Column Chart.
2. Make sure the chart looks good and has all the appropriate titles and labels

 

Q3 Question 3

Use the following Collingwood and Essendon scores as the basis for a Pie Chart.

Team	Goals	Points	Total	Vs	Team	Goals	Points	Total
Collingwood	20	13	133	Vs	Essendon	7	12	54

 

1. Present a Pie Chart for the total of each teams score as a percentage of the total score of both teams combined. 
2. Show a label with the % of the combined score for each team 
3. Make sure the chart looks good and has all the appropriate titles and labels 
4. Insert a picture or logo of both football teams in the chart (you will find a logo quite easily in an images search in google) 

 

Q4 Question 4

Using the same football scores create a spreadsheet and calculate the following information using formula:

1. The average score of all the teams from that round. 
2. The total number of goals scored that round. 

 

Q5 Question 5

Create a sales report for the month of June 2013 for the six hardware stores in you group.

Sales were:

Bankstown                           $78 526

Penrith                                  $96 333

Foster                                    $32 200

Redfern                                 $41 880

Dubbo                                   $102 300

Tamworth                             $36 500

1. Create a spreadsheet with the sales information. 
2. Create a Column Chart with the sales of each store.
3. Create a pie chart to show the sales of each store as a % of the sales of the group as a whole. 
4. Show the total sales of the group.
5. Show the average sales of the group.
6. If new renovations to the Foster store produce a 50% increase in sales. Show the new pie chart to show the sales of each store as a % of the sales of the group as a whole. Assuming all the other sales remained the same. 
7. Add a footer to the page showing ‘Sales June 2013’ 
8. Format the document to ensure it looks professional. 

Q6 Question 6

A publisher has the following book sales for July 2013

Book	Sale price Hard copy	Number hard copies sold	Sale Price E book	Number of E books sold
Winter Soups	$22.99	360	$12.99	39
Growing lemons for profit	$18.99	290	$9.99	100
2012 What a year	$19.99	586	$9.99	325
Behind the scenes of football	$29.99	1250	$12.99	856
Mmm Coffee	$22.99	563	$7.99	233

 

Create a spreadsheet that uses a formula to calculate the following with the following 

1. Show the total sales from each book.
2. Show the revenue for each book in hard copy. 
3. Show the revenue for each book in eBook. 
4. Show total revenue for all books. 
5. If the author of the book is to be paid 10% then what is the payment to the author? 
6. Create a line chart showing payments for each author. 
7. Add a footer to the page showing ‘Book Sales July 2013’. 
8. Format and label the document and charts so they are professional.

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme