Rank the teams and identify 1st, 2nd and 3rd

Assignment Help Other Subject
Reference no: EM13328807

Problem description

Eight clubs compete in a tenpin bowling competition. There are ten frames (sets of pins) and two balls are available if required by each competitor in each frame to knock down all pins. A "strike" is when all pins are knocked down with the first ball. A strike counts as 10 (there are ten pins) but also is affected by the scoring for the next two balls bowled. For example if a strike is bowled in the first frame and then a spare the score for the first ball is 20 (10 plus 10). If two strikes are bowled consecutively then 8 and 1 the score on the first strike ball is 28 (10 plus 10 plus 8) and on the second strike ball 19 (10 plus 8 plus 1). If a strike occurs in the last frame the competitor gets another frame and two more balls. Therefore a perfect game is 12 strikes (10 frames plus two more). If all pins are not knocked down with the first ball the remaining pins may be knocked down with the second ball. If this occurs it is referred to as a "spare". A spare is also affected by the score of the next ball bowled in that if a 7 follows the spare the score for the spare (2nd ball) is 17 (10 plus 7). If a spare is bowled in the last frame then the competitor gets another frame and one ball. If all pins are not knocked down by the two balls bowled for any given frame then the score is simply the number of pins knocked down. The maximum possible score in a game is 300.

There is an individual competition and a team competition. Teams consist of 4 competitors plus two reserves. Teams can be "mixed" i.e. have both men and women.

There are two categories of competitor: men and women. This could change in the future so it is best to allow for other options. One way of doing this is to list the categories on another sheet in the spreadsheet.

Individual competition

Competitors take turns for each frame. As each competitor is selected their score to that point should come up on screen preferably frame by frame not just a single number. For individual competition results the program must identify the 1st, 2nd and 3rd men and 1st, 2nd and 3rd women.

Team Competition

For each team drop the worst member's score then add all the remaining individual scores. Rank the teams and identify 1st, 2nd and 3rd.

Solution design

Competitor entry is ideally to be via a MS Word document which the clubs would submit. One document corresponds to one club's entries. The name of the club should be in the first table. The Word document should then contain a table where each row consists of the competitor's name and sex.

The data in the Word document is to be imported into MS Excel. The Excel component should be forms-based. User entry into the worksheets themselves is not desirable and will lose marks. A new competition should be able to be started in a user-friendly manner eg "Bedrock Tenpin Bowling Competition". The competition date and time will need to be entered. The Word data import will need to occur for each of the 4 teams. In Excel each competitor should be assigned a unique number. There should be provision for on-screen correction of competitors' details: name, sex and number entered. Teams may also need to be corrected. For team events competitors may be scratched and reserves promoted into their place. Competitors need to be identified by club also.

Results should be produced on screen in a convenient easy to read format including the competitor's name, sex, club and total score. Placings from first to third should be highlighted in some fashion. There should be provision for the results to be exported back to MS Word in tabular form and also to PDF files.

Warning

Avoid attempting too much and not completing a solution which works to some extent. Build your solution in stages, for example get individual competitor processing working first before attempting team results.

Data

Some sample competitor data will be available on vUWS. Use this to test your program.

Reference no: EM13328807

Questions Cloud

Determine the electric field strength in the solution : In an electrolysis experiment a current of 0.10 A flows through a solution of conductivity k= 0.010?^-1 and cross sectional area 10 cm^2. Find the electric field strength in the solution.
How fast was the ball travelling : A 70.0 kg football player leaps straight up into the air (with no horizontal velocity) to catch a pass. how fast was the ball travelling
Market price of the company''s stock : Is the market price of the company s stock going up or down- is the earnings per share increasing or decreasing - Current assets consist of cash, accounts receivable, and inventory
How much internal energy was generated in crossing : A 67.0kg skier is moving at 6.70m/s on a frictionless, horizontal snow-covered plateau when she encounters a rough patch 3.55m long. How much internal energy was generated in crossing the rough patch
Rank the teams and identify 1st, 2nd and 3rd : For each team drop the worst member's score then add all the remaining individual scores. Rank the teams and identify 1st, 2nd and 3rd.
Designed to be used by both experienced and first time users : How can a system be designed to be used by both experienced and first time users?
State rank the elements by electron affinity : Rank the following elements by electron affinity, from most positive to most negative EA value. Tellurium, Bromine, Arsenic, Sodium and Neon
Calculate the amount that total benefits : Calculate the amount that total benefits are projected to increase annually as a result of switching to a cellular manufacturing operation - What is the minimum acceptable price at which overall profit will not change?
Prepare separate statement of comprehensive income for 2013 : O'Reilly Beverage Company reported net income of $820,000 for 2013. In addition, the company deferred a $95,000 pretax loss on derivatives and had pretax net unrealized holding gains on investment securities of $45,000.

Reviews

Write a Review

Other Subject Questions & Answers

  Focused primarily on restorative justice

Assume you are an experienced judge who is delivering a lecture to first-year judges. Take a position for or against this claim: Criminal justice would be far more effective it focused primarily on restorative justice. Support your position with exam..

  How do civil penalties differ from criminal punishments

Name and discuss 3 types of remedies available in civil court. How do civil penalties differ from criminal punishments? Are there any you feel are ineffective?

  Incomplete proteins to achieve protein complementation

Which of the following is an example of combining two incomplete proteins to achieve protein complementation?

  A magnesium-lead alloy of mass

A magnesium-lead alloy of mass 7.5 kg consisting of a solid ? phase that has a composition just slightly below the solubility limit at 300 oC (570 oF).

  Processes of muscular movement-bone growth

Create a power point presentation of 10-12 slides that summarizes the processes of muscular movement, bone growth, and nerve transmission.

  What can you do to exert some self-control also stick plan

If you just declined an invitation to go out with friends so that you can study also n another friend offers you a beer, according to research in this chapter, what can you do to exert some self-control also stick with your study plan

  Reimbursement changes associated with medicare advantage

Healing Hands Hospital is preparing financially for the many different reimbursement changes associated with Medicare Advantage Plans. You and your financial team have been asked to evaluate your current billing and operations workflow processes to i..

  ASM diagram for a controller of a system

Show the ASM diagram for a controller of a system that has a 16-bit register, A and a 4-bit register, N. When a signal of 1 appears on the input line s, the register A is shifted right the number of places (0 to 15) as specified by N (with 0's put in..

  What does the law of demand state

What does the law of demand state?

  How do we implement TQM

How do we implement TQM? Where do we begin? What key areas do we need to address first? Please be sure to include a url or a citation to any sources used for this post.

  Program evaluation type and conducting a program evaluation

Select the above program evaluation type and conduct a program evaluation on the program you designed.

  Define market research

Define market research.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd