As Ict

Edexcel GCE Applied Information and Communication Technology Unit 3: The Knowledge Worker January 2013 Scenario Paper Reference 6953/01 The situation ought to be appropriated to applicants in any event three working a long time before the assessment. Practice records: whitecaps_practice. xls, fixtures_practice. txt, haway_practice. txt This situation ought to be utilized for the motivations behind planning possibility for the assessment. This duplicate must not be taken into the assessment. The data contained in the situation will be remembered for the assessment paper.Further subtleties are in the Instructions of the Conduct of Examinations (ICE), accessible from the Edexcel site for this capability. Edexcel won't acknowledge any solicitation for extraordinary thought should applicants be given the wrong situation for the assessment they are sitting. Turn over W41049A Â ©2013 Pearson Education Ltd. 6/*W41049A* Scenario Havering Whitecaps Maddy Wright and Katy Parrish have upheld Ha vering Whitecaps since their sweethearts played for the group. Their boyfriends’ vocations and the high school sentiments are currently especially before however their help of the group stays as solid as ever.Until 15 years back the Whitecaps were a battling non-alliance group with little help. There were times, on wet and cold November evenings, when Maddy and Katy were the main supporters. In 1999 an enchanted thing happened to the Whitecaps. Around then the team’s position, both in football terms and monetarily, was dangerous no doubt. Nonetheless, a budgetary sponsor showed up as Harold Adenyi. Harold had learned at the nearby school and even played a couple of games for the Whitecaps. His advancement as a footballer was hampered by an absence of ability.He abandoned a profession as a footballer to focus on what he was acceptable at, which was IT and arithmetic. He made a lot of cash by making an online bookkeeping site called lesstax. com. Harold was searching for things he could counterbalance against an enormous assessment bill and a misfortune making football club appeared to be a decent beginning. He purchased the Whitecaps from the past proprietors for ? 1 and quickly began to burn through cash on it. Harold’s style for business implied that the misfortune making football club didn't remain misfortune making for long.Harold marked a capable previous football group director and with his recommendation, burned through cash on players who all ended up being wise ventures. The manner in which the director had the group playing before long began to expand its fan base, so Harold manufactured another arena. The group kept on being effective and the new arena was before long filled at each match, putting the club on a solid budgetary balance. Money related achievement and playing achievement went connected at the hip and, in 2001, Havering Whitecaps was chosen for the Football League. After a couple of seasons, when the Whitecaps attemp ted to set up themselves, there followed an eriod of continuous achievement including advancement to the first Division and after two years the Championship. Last season the Whitecaps won the Championship and are at present anticipating their first season in the Premier League. All through this time of advancement, Maddy and Katy have been shouting urging words to their group (and the intermittent demoralizing one to the resistance) and they have scarcely missed a match. It was inescapable that as the Whitecaps’ two most devoted supporters they would turn into the executive and secretary of the supporters’ club.One of their primary errands is to sort out away outings for fans. This includes purchasing the tickets, booking the mentors and choosing what to charge for the ticket and transport bundles. With 14,678 enlisted supporters, sorting out the away outings isn't a simple errand. With the chance of more than 400 mentors heading out to an away match, the quantity of t ransport firms the pair could utilize was restricted. Since the Whitecaps were elevated to the Championship Maddy and Katy have utilized ‘Rubicon Transport’ whose rates are sensible and who can gracefully enough mentors on a match day. 2 W41049ARubicon charge a fixed aggregate of ? 350 for every mentor, in addition to a ? 1. 50 fuel overcharge for each 100 miles voyaged. Furthermore, Rubicon’s guidelines express that a driver can't be responsible for the mentor for over 9 hours per day. Should the entire excursion last over 9 hours (counting the match time) a subsequent driver would be required. There is a charge of ? 75 for the subsequent driver. Chief League ticket costs differ enormously and Maddy has been provided a scope of cost estimates fluctuating between ? 30 and ? 54 by the Premier League clubs. Maddy and Katy don't have to make a general profit.Their principle point is to get however many fans as could be expected under the circumstances to away matche s. In spite of the fact that they can bear to make a misfortune on singular excursions, they can't stand to make a misfortune by and large. In this manner a precise forecast of the quantity of individuals who will need to go to a specific match is imperative. They are likewise mindful that more individuals will need to go to certain matches than others. To help discover what number of individuals are probably going to go to each match they ran an online overview. This was finished by 94% of their enrolled supporters. To make information investigation simpler, Katy has grouped the groups as appeared in the table.EG Teams battling for European brilliance MT Mid-table groups RD Teams liable to be associated with the assignment dogfight PR Newly elevated groups notwithstanding the order of the group, she found that different things influence the quantity of individuals liable to go to away matches. Less individuals would go if the match was played on a weekday as opposed to a Saturday ( or Sunday). The more drawn out the voyaging time, the less supporters were set up to travel. At long last, the general expense of the bundle would dishearten some from going to specific matches. W41049A 3 Turn over Description of the modelMaddy and Katy must be as precise as they can when setting the costs as they don’t need to make a benefit however can't stand to make a misfortune. Maddy and Katy need a model to assist them with settling on costs. Consequently, Maddy has convinced her sibling Kieran, who works in IT, to make a model. Kieran needed to make the model reusable with the goal that he could offer it to other supporters’ clubs. Lamentably, before he could complete the model, the organization Kieran worked for sent him to Dubai on a three-year contract. Maddy has requested that you complete the model and use it to recommend costs for the following season’s away matches.Kieran has left you these notes. Worksheet Description Teams This is the worksheet that will be utilized to set the bundle costs. I have recorded the groups in the Premier League alongside Katy’s groupings. For simplicity of review I have included data from different worksheets and have determined the absolute costs, income and benefit. There is a benefit for each excursion and an absolute benefit for the season. The worksheet will likewise figure the absolute number of supporters going to away matches. Cell B2 contains a drop-down box to pick the group you support. FixturesThis worksheet is a determined page which records the dates of the home and away installations. Queries This worksheet contains various query tables. There are two clear zones, these will contain the installation data gave by the Premier League. There are different tables to look into the day of the week, the reasonable help dependent on the teams’ grouping, the quantity of enlisted supporters and the ticket costs for the different clubs. Separations, Times These worksheets contai n the separations between the grounds and the normal occasions it would take a mentor to travel those journeys.I got these from an extremely accommodating man at the RAC. Client This worksheet is fragmented. When finished it will foresee the quantity of supporters who might make a trip to each away match. This depends on the quantity of enrolled supporters and afterward balanced by the host group order, at that point bundle cost lastly the movement time. I haven’t completed the investigation of the study yet so I can't place in formulae to consider the voyaging time and the general expense. A companion of mine is doing the examination for me and he will advance the outcomes to you when he has them. TransportIn this worksheet I compute what number of mentors are required, the expense per mentor and the general vehicle cost for the excursion. Transport Rates In this worksheet I have entered the vehicle rates as cited by Rubicon Transport. I trust you think that its straightforw ard my notes. Good karma finishing it. Kieran Wright 4 W41049A Some cells in the model are secret phrase ensured. Should you wish to explore different avenues regarding the model, the secret phrase is edexcel. Know that on the off chance that you change the substance of any ensured cell the model may not work. If you don't mind note that the Football League and Premier League alluded to in this situation are invented. W41049A 5