
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

GCE MAY 2008 : (A2 7) Investigating Systems

22 pages, 30 questions, 0 questions with responses, 0 total responses,

	gce	+Fave Message
	Profile Timeline Uploads Q & A

Home > gce >

Instantly get Model Answers to questions on this ResPaper. Try now!
NEW ResPaper Exclusive!

Formatting page ...

Centre Number 71 Candidate Number ADVANCED General Certificate of Education 2008 Applied Information and Communication Technology A6J11 Assessment Unit A2 7 assessing Unit 7: Investigating Systems [A6J11] FRIDAY 16 MAY, MORNING TIME 2 hours. INSTRUCTIONS TO CANDIDATES Write your Centre Number and Candidate Number in the spaces provided at the top of this page. Answer all eleven questions. For Examiner s use only Marks Question available ADVICE TO CANDIDATES You are advised to take account of the marks for each part question in allocating the available examination time. A6J1S8 4528 2 3 3 8 4 9 5 18 6 17 7 5 8 9 7 10 16 11 6 Total The total mark for this paper is 100. Quality of written communication will be assessed in all questions. Figures in brackets printed down the right-hand side of pages indicate the marks awarded to each question or part question. This paper is accompanied by a Case Study. You must not use your own annotated copy of this Case Study. 3 8 INFORMATION FOR CANDIDATES 1 100 Marks Remark BLANK PAGE A6J1S8 4528 2 [Turn over 1 John Davis has decided that LUNCH EXPRESS should now install a computer-based system. Examiner Only Marks Remark Suggest three reasons why this should be the case: (i) _________________________________________________________ _________________________________________________________ _________________________________________________________ ______________________________________________________ [1] (ii) _________________________________________________________ _________________________________________________________ _________________________________________________________ ______________________________________________________ [1] (iii) _________________________________________________________ _________________________________________________________ _________________________________________________________ ______________________________________________________ [1] 2 John Davis feels that, as the new system is going to be an integral part of his business, he would like to employ a technician to have responsibility for system maintenance and staff support. In the table below, identify with a tick ( ) three skills which would be most important for a technician to have: Hardware knowledge Detailed programming skills Maintenance experience Project management skills Troubleshooting ability Entrepreneurial skills A6J1S8 4528 [3] 3 [Turn over 3 John Davis has recently read an article about software development and has asked the Consultants to clarify a few issues relating to different development methodologies. Examiner Only Marks Remark Complete the table below by entering either true or false in the final column. SSADM generates very little documentation. Prototype systems are very useful as they let the users see how the new system will work. DSDM is generally favoured in situations where a solution is required quickly. DSDM involves building a prototype. SSADM is generally favoured by smaller organisations. Both DSDM and SSADM allocate similar timescales to analysis. Algorithms are useful as they explain to users what the new system will do. DSDM involves the use of data flow diagrams. A6J1S8 4528 [8] 4 [Turn over 4 SMART SOLUTIONS has recently employed a new analyst, Greg Friel, who is shadowing Sarah Brown during her work at Lunch Express. Examiner Only Marks Remark Greg has asked for an overview of responsibilities for the project. In the table below, identify with a tick ( ) the person who should be allocated to each task. Note that each task can only be assigned to one person. Task People Analyst Programmer Technician John Davis Interviewing users Writing code Installing hardware Program testing Defining project budget System testing Training users Defining requirements System backups [9] A6J1S8 4528 5 [Turn over 5 John has asked the Consultants to provide a breakdown of all planned investigation activities and expected timescales. Activity Predecessor Description Duration (hours) A 6 Interview John Davis A 3 C Interview Secretary A 3 D Review Documentation (obtained during interviews) B, C 6 E Design Questionnaire F Administer Questionnaire E 4 G Analyse Questionnaire Data F 5 H Observe Lunch Express Staff I Document Findings J 4528 B A6J1S8 Create Interview Plan Present Findings 7 6 D, G, H I 6 7 2 [Turn over (a) Using the table opposite, complete the following network diagram: A Create Interview Plan 0 6 1 6 hrs B Interview John Davis 6 9 7 7 3 hrs 10 D Review Documentation 6 hrs C Interview Secretary 6 7 hrs 16 10 7 16 F Administer Questionnaire 7 G Analyse Questionnaire Data 11 7 4 hrs 23 7 hrs 0 0 I Document Findings 9 7 E Design Questionnaire 10 11 5 hrs 11 23 J Present Findings 16 25 2 hrs 23 25 H Observe Lunch Express Staff 6 hrs 0 10 Examiner Only Marks Remark [10] (b) Which activities in this project are on the critical path? _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ ______________________________________________________ [5] A6J1S8 4528 7 [Turn over (c) What is the shortest time for completion of this project? Examiner Only Marks Remark ______________________________________________________ [1] (d) Identify two activities in which float occurs. Activity 1: ______________________________________________________ [1] Activity 2: ______________________________________________________ [1] A6J1S8 4528 8 [Turn over 6 Based on investigation activities carried out to date, the following items of data have been listed and Elizabeth wants to categorise them before she starts the data modelling process. Examiner Only Marks Remark (a) Identify with a tick ( ) the correct category for each data item listed. Categories Data Item Data Flow Entity Process File Secretary Van driver Completed order form Cheque for supplier Produce summary orders Calculate weekly profit Staff details [7] (b) Which one of the above categories should not appear on a context diagram? ______________________________________________________ [1] A6J1S8 4528 9 [Turn over Elizabeth will start by drawing a context diagram to provide an overview of the main process being examined. Examiner Only Marks Remark She has listed several data flows which need to be included on the context diagram. (c) Complete the following table by entering a tick ( ) to show whether data is either coming in or going out of LUNCH EXPRESS. In the final column, enter the name of the entity which sends or receives the data. Data Flows: Coming in Going out Customer payment Sender/ Recipient Customer Stapled to pay order forms Batched order payments Completed Lunch Express orders Receipt Organisations Telephone order Business Lunch Express Order forms [9] A6J1S8 4528 10 [Turn over 7 Sarah has decided to set up a database to store order processing data. She has discovered that John uses several suppliers but buys only one type of product from each supplier. For example, bread products are only bought from Northern Bakeries and meat products are only bought from Belfast Meats. Examiner Only Marks Remark (a) Identify with a tick ( ) which of the following structures shows the correct relationship between STOCK and SUPPLIER: STOCK SUPPLIER STOCK SUPPLIER [1] Sarah is now ready to add a SUPPLIER table to the database. (b) Identify with a tick ( ) the fields which should be stored in the SUPPLIER table. Supplier name Stock number Telephone number Order date [2] (c) Sarah realises that she has not assigned a primary key to the table. Explain the purpose of a primary key within the SUPPLIER table. _________________________________________________________ _________________________________________________________ _________________________________________________________ ______________________________________________________ [1] (d) Suggest a field which could be added as a primary key for the SUPPLIER table. _________________________________________________________ ______________________________________________________ [1] A6J1S8 4528 11 [Turn over 8 As an analyst, Sarah is always conscious of the importance of reports within a business. John has asked for sales reports showing daily, weekly and monthly sales figures for all products. Sarah has produced the following sample: Quantity sold Number of customers served White Brown Granary Panini Baguette Bap Daily Sales Total 01/05/2008 120 110 95 58 41 95 1200 510 02/05/2008 110 95 80 40 65 90 1350 470 03/05/2008 110 90 20 50 85 70 1100 405 04/05/2008 90 85 45 56 40 32 1050 328 Date Sarah needs to check that her proposed database design, part of which is shown below, can fulfil this requirement. makes CUSTOMER places ORDER consists of PAYMENT STOCK appears in ORDER ITEM Examiner Only (a) The data necessary to produce the report can be found in the following tables. Identify with a tick ( ) which report fields should come from each table. Marks Remark Note: it is possible to have a tick in more than one table. Tables Stock Order Order item Date Quantity sold each day Sandwich type White/ Brown etc. Number of customers served Daily Sales Total [5] A6J1S8 4528 12 [Turn over (b) How could the report opposite be modified to show weekly data? Examiner Only Marks Remark _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ ______________________________________________________ [3] A6J1S8 4528 13 [Turn over 9 At regular intervals throughout the project, Sarah reviews the documentation produced. The following data dictionary has been created for the PAYMENT table. Examiner Only Marks Remark (a) Complete the missing information: Field Name Payment Ref Data Type/Size Comments Text, 5 P-05 Text, 3 Foreign key here links to SUPPLIER table. Date medium date Date Sample Data 07 The date on which a payment was made. Payment method Can only be cheque or cash. Cheque Amount Must be >0 2.50 [5] (b) It is important that the data dictionary is always kept up to date. If changes are made to the structure of a system, who should update the data dictionary? ______________________________________________________ [1] (c) The data dictionary is finalised during the implementation phase of the system life cycle. Name another document produced at this stage. ______________________________________________________ [1] A6J1S8 4528 14 [Turn over 10 A test plan is needed to test all data within the new system. Sarah must test inputs, calculations and outputs. Examiner Only Marks Remark On testing data input, the following record is rejected: Order No. Customer No. Date Product No. Quantity 0007 FRED 31/04/2008 24 0 (a) Give two possible reasons for the above record being rejected: (i) ______________________________________________________ ______________________________________________________ ______________________________________________________ ___________________________________________________ [1] (ii) ______________________________________________________ ______________________________________________________ ______________________________________________________ ___________________________________________________ [1] A6J1S8 4528 15 [Turn over (b) Sarah has created some sample data files which should be used to complete the test plan below: Date Order No. Customer No. 01/06/08 1009 09 01/06/08 1010 07 01/06/08 ORDER 1011 56 Order No. Product No. Quantity 1009 1 1010 10 1 1010 14 2 1010 15 1 1011 ORDER ITEM 11 12 2 Product No. Description Price 10 2.40 11 Ploughman s Bap 2.95 12 Chicken Salad on White 1.95 13 Prawn Salad on Granary 2.20 14 Coronation Chicken on White 2.10 15 STOCK Ham, Cheese and Pineapple on Granary BLT on Brown 2.25 TEST PLAN ORDER ENTRY expected results Order No. Total due Money tendered 1009 5.00 1010 20.00 1011 Change required 3.90 Examiner Only Marks Remark [6] A6J1S8 4528 16 [Turn over The following screen has been designed for entering order details, design annotations have also been included. Note Test order being entered on 01/06/2008 Examiner Only Marks Remark (c) Based on the sample data files shown previously, identify four fields on the ORDER screen shown above which are not working properly. Field Possible cause of error 1. 2. 3. 4. [8] A6J1S8 4528 17 [Turn over 11 During a planned progress review, John Davis has again raised the issue of a web presence for Lunch Express. Examiner Only Marks Remark The new analyst, Elizabeth, intends to use a storyboard to help design a possible new website. John Davis has never heard of storyboarding. (a) Give two advantages of using storyboarding in this design process. (i) ______________________________________________________ ______________________________________________________ ______________________________________________________ ___________________________________________________ [1] (ii) ______________________________________________________ ______________________________________________________ ______________________________________________________ ___________________________________________________ [1] (b) Complete the following table by entering a tick ( ) to show which of the following functions should not be available on the website: Place an order Contact LUNCH EXPRESS via email Return items Register complaint Change the order entry form Pay by cash View staff records [4] THIS IS THE END OF THE QUESTION PAPER A6J1S8 4528 18 [Turn over Applied Information and Communication Technology Case Study Assessment Unit A2 7 assessing A6J11CSI ADVANCED General Certificate of Education 2008 Unit 7: Investigating Systems [A6J11] FRIDAY 16 MAY, MORNING You must use this clean copy of the Case Study in the examination and not your own annotated copy. A6J1S8 4528.02 CSI LUNCH EXPRESS LUNCH EXPRESS is a small company with big prospects. It is the brainchild of John Davis, owner of a popular restaurant in Belfast City Centre. While managing his restaurant John began to see an opportunity for a different type of lunch time service for customers. He realised that there were customers who liked to come in and sit down to eat at lunchtime and those who came to the restaurant to buy lunch to take away. The sit down customers were generally not daily customers and clearly had lots of time to have leisurely lunches. John recognised that the take away customers were fairly regular daily customers and although a good source of business for the restaurant, they inevitably presented a huge drain on staff resources causing some of the sit down customers to complain about poor service. The take away customers tended to come from shops and offices as well as local educational establishments. John noticed that these customers were always in a hurry, looking at their watches and trying to see how many people were in the queue in front of them. He also noted that the whole procedure involved in processing the take away customer orders was very rushed, not very efficient and between the hours of 11.30 am and 2.30 pm everyone was under extreme pressure. John realised that there might be an opportunity to satisfy both his sit down customers and his take away customers. After considering the situation very carefully, he had a solution in mind and took some advice from business colleagues. He also liaised with relevant agencies able to advise on the development of his business plan as well as sources of funding. John s idea was to set up an order and delivery service which would cater for the same type of take away customer he had observed in his restaurant. By doing this he would protect the sit down aspect of his business while at the same time developing a new streamlined service for customers that he already knew as well as for others that would want to use the service. He decided to find suitable premises outside the city which he would fit out with state of the art kitchens and office facilities. This whole process took him almost a year and resulted in the opening of LUNCH EXPRESS five years ago. The concept of ordering and delivering personalised lunches has proved to be extremely successful, much more so than even John expected. By marketing his idea to the customers he already had, John had a ready-made outlet for his idea. His take away customers were delighted to have their orders delivered for a small additional cost or to at least collect their lunches without wasting their valuable lunch break queuing and waiting for their order to be made up. Once the word got around, other people in a whole range of organisations wanted to use the service. When the company opened, John employed a manager to oversee the whole order, production and delivery process. He also employed seven catering assistants to make the orders and two van drivers to ferry the food around Belfast as well as a secretary to manage the office and to receive telephone orders, In the last year John has developed the business even further and now accepts business lunch buffet bookings. This means that an organisation can buy in a ready made lunch for groups of people who may be attending meetings, training days or talks and lectures. It is an easy and quick solution for any organisation and is a lot cheaper than providing a sit down meal. In order to cope with the very growing demands of the business, John now employs an additional five A6J1S8 4528.02 CSI 2 [Turn over catering assistants, another secretary and has increased his driving staff and eet of vans to six in total. LUNCH EXPRESS provides a comprehensive menu for both individuals and groups. Customers can choose from hot or cold menus that include soups, sausage rolls, vol-au-vents, quiches, kebabs, sandwiches (which may be toasted) and rolls of all varieties, lled bagels, pitta breads and a range of salads. The choice of llings and spreads is comprehensive and John always responds to new ideas whenever possible in order to satisfy all demands. Although all aspects of the business are expanding, John s administrative procedures are causing problems. The way orders, pricing and billing worked when he started the business was ne but John recognises that this is no longer the case and problems are arising in all sorts of areas which will affect the success of the business if they are not addressed soon. Orders can be made by individual customers through the restaurant, by telephone or through the van driver. Telephone orders must be received no later than 11am each day. Customers are supposed to use the LUNCH EXPRESS ORDER FORM which they ll in and leave in to the restaurant at least one day in advance of the required order. They can pay at the restaurant or wait and pay the delivery man when their order is delivered. If a customer wishes to pay, the order is priced using the LUNCH EXPRESS PRICE LIST and the order form is marked PAID otherwise it is priced and marked TO PAY . The orders are stacked beside the till and a delivery man collects them at around 4.30 in the afternoon so that they are ready for processing rst thing in the morning. Payments for PAID orders are supposed to be kept separately and sent to LUNCH EXPRESS with the order forms at the same time. When the orders are received at LUNCH EXPRESS, the secretary must check that the total amount of money matches the total value of the orders marked PAID . Unfortunately this is not always the case since mistakes are frequently made because the staff at the restaurant are so busy. Orders received later than 4.30 have to wait until the next time a delivery man is in the area the next morning to collect them. If a member of staff in the restaurant remembers in the morning they will ring and ask for a delivery man to collect additional orders or if they are not too busy, they will ring them through to LUNCH EXPRESS. This can be very time consuming and on several occasions these orders have been overlooked and customers have been very annoyed. Orders can also be telephoned into the of ce by the customer. When a telephone order is received, the secretary notes the required items on a telephone order form which is really the same as the ordinary order form but is titled TELEPHONE ORDER FORM on behalf of the customer. The order is priced using the LUNCH EXPRESS PRICE LIST and the order is again marked PAID if the customer uses a credit card or TO PAY with the amount recorded. Unfortunately sometimes the restaurant staff, delivery men and even the secretary receiving the order forget to mark the order as PAID and there have been a few unpleasant instances that are not good for business. Sometimes a customer insists that the order has already been paid although nothing has been written on the order form. John obviously prefers customers to pay in advance since this method guarantees payment. The delivery men also accept future orders from customers when delivering lled orders. Customers are supposed to complete an order form to give to the delivery man, but sometimes they just give brief details of their requirements. On many occasions important information about A6J1S8 4528.02 CSI 3 [Turn over orders is left out. When the delivery men bring any orders not recorded on an order form into the office, the secretary will fill out an order form on behalf of the customer. This is again time consuming and not always accurate. When orders come in to the office, whether on LUNCH EXPRESS ORDER FORMS, TELEPHONE ORDER FORMS, or from the delivery men, they are stacked in order of arrival so that the earliest order placed is filled first. Since the secretary only receives these orders in the late afternoon or early in the morning, there is quite a work load to get through. As the number of orders is increasing all the time, this process is becoming quite pressured. John has tried to streamline procedures at LUNCH EXPRESS. He decided that the orders should be sorted as far as possible so that similar orders were grouped together. His idea was to speed up the production process. This process again takes up a lot of time and has not really improved matters. When lunches are ready the order form is stapled to the brown bag that contains the lunch and these are sorted by delivery area. This sorting process is not done by postcode but by the drivers knowledge of the area. Sometimes this doesn t work out that well and lunches are placed in the wrong delivery batch. For the delivery men, collecting payment isn t straightforward either. Some customers say they have paid when they have not, others complain that the amount they have to pay is incorrect and since the order form does not carry a price list, the delivery men have to write CHECK on the order form. It is then returned to the secretary for recalculation and a further visit by the delivery man. Orders from organisations for business lunch buffets must be recorded on a separate BUSINESS LUNCH EXPRESS ORDER FORM. These must be received by LUNCH EXPRESS at least three days before the event so that all the required food items are in stock. The organisation is sent an invoice for the service and when payment is received a receipt is issued. Because of the increasing variety of choices on offer it is becoming impossible to batch orders. John also realises that he has no real idea of how he can make sure that he has sufficient supplies to fulfil the orders and on occasions he has run out of fillings or special types of bread because of demand. He has also introduced vegetarian and children s lunch menus to his range and is now struggling to stay on top of the whole business. John has considered the possibility of employing another secretary and investing in some proper computer resources that would speed up the procedures which are entirely manual. He would also like to have some way of accepting internet orders. John realises that he needs expert advice and has decided to employ the services of a consultancy firm. A6J1S8 4528.02 S 12/07 529-021-2 A6J1S7 3873.02 CSI [Turn over 4 [Turn over

Formatting page ...

Additional Info : Gce Applied ICT May 2008 Assessment Unit A2 7 - Investigating Systems
Tags : General Certificate of Education, A Level and AS Level, uk, council for the curriculum examinations and assessment, gce exam papers, gce a level and as level exam papers , gce past questions and answer, gce past question papers, ccea gce past papers, gce ccea past papers

gce chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: