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 dispersed to competitors 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 getting ready contender 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 unique thought should up-and-comers be given the mistaken 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 bolstered Havering Whitecaps since their sweethearts played for the group. Their boyfriends’ professions and the adolescent sentiments are currently especially previously however their help of the group stays as solid as ever.Until 15 years back the Whitecaps were a battling non-class group with little help. There were times, on wet and cold November evenings, when Maddy and Katy were the main supporters. In 1999 a mystical thing happened to the Whitecaps. Around then the team’s position, both in football terms and monetarily, was risky without a doubt. Be that as it may, a money related supporter 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 vocation as a footballer to focus on what he was acceptable at, which was IT and science. He made a lot of cash by making an online bookkeeping site called lesstax. com. Harold was searching for things he could balance against a colossal duty bill and a misfortune making football club appeared to be a decent beginning. He purchased the Whitecaps from the past proprietors for ? 1 and promptly 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 gifted previous football class supervisor and with his recommendation, burned through cash on players who all ended up being wise speculations. The manner in which the administrator 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 monetary 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 Whiteca ps attempted to build up themselves, there followed an eriod of progressive 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 improvement, Maddy and Katy have been shouting urging words to their group (and the incidental disheartening one to the resistance) and they have scarcely missed a match. It was inescapable that as the Whitecaps’ two most committed supporters they would turn into the administrator and secretary of the supporters’ club.One of their primary errands is to arrange 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 enrolled supporters, sorting out the away outings isn't a simple assignment. With the chance of more than 400 mentors venturing out to an away ma tch, the quantity of transport firms the pair could utilize was constrained. Since the Whitecaps were elevated to the Championship Maddy and Katy have utilized ‘Rubicon Transport’ whose rates are sensible and who can flexibly enough mentors on a match day. 2 W41049ARubicon charge a fixed entirety of ? 350 for every mentor, in addition to a ? 1. 50 fuel overcharge for each 100 miles voyaged. What's more, Rubicon’s guidelines express that a driver can't be responsible for the mentor for over 9 hours every 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 change incredibly and Maddy has been provided a scope of cost estimates shifting between ? 30 and ? 54 by the Premier League clubs. Maddy and Katy don't have to make a general profit.Their fundamental point is to get however many fans as could be allowed to away matches. I n spite of the fact that they can stand to make a misfortune on singular outings, they can't bear to make a misfortune by and large. Accordingly an exact forecast of the quantity of individuals who will need to go to a specific match is fundamental. 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 review. This was finished by 94% of their enrolled supporters. To make information investigation simpler, Katy has ordered the groups as appeared in the table.EG Teams battling for European magnificence MT Mid-table groups RD Teams prone to be engaged with the transfer dogfight PR Newly elevated groups notwithstanding the characterization 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 instead of a Saturday (or Sunda y). The more drawn out the voyaging time, the less supporters were set up to travel. At last, the general expense of the bundle would debilitate 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 bear to make a misfortune. Maddy and Katy need a model to assist them with settling on costs. Thusly, 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. Shockingly, 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 propose 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 survey I have included data from different worksheets and have determined the all out costs, income and benefit. There is a benefit for each excursion and a complete benefit for the season. The worksheet will likewise ascertain the all out 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 conceivable help dependent on the teams’ grouping, the quantity of enrolled supporters and the ticket costs for the different clubs. Separations, Times These worksheets contain the separations bet ween the grounds and the normal occasions it would take a mentor to travel those journeys.I got these from an accommodating man at the RAC. Client This worksheet is deficient. When finished it will anticipate the quantity of supporters who might go to each away match. This depends on the quantity of enlisted supporters and afterward balanced by the host group order, at that point bundle cost lastly the movement time. I haven’t completed the examination 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 figure what number of mentors are required, the expense per mentor and the general vehicle cost for the outing. Transport Rates In this worksheet I have entered the vehicle rates as cited by Rubicon Transport. I trust you think that its straightforward my notes. Good karma finishing it. Kiera n Wright 4 W41049A Some cells in the model are secret word secured. Should you wish to explore different avenues regarding the model, the secret key is edexcel. Know that on the off chance that you change the substance of any ensured cell the model may not work. Kindly note that the Football League and Premier League alluded to in this situation are invented. W41049A 5