HND IT1 试题.docx

1、HND IT1 试题Assessment task 2 Outcome(s) covered 2 and 3 USAP Assessment task instructions This assessment is based upon a case study for USAPITAS Ltd. You should receive a copy of this case study prior to the assessment event to allow you sufficient time to assimilate the details of it. During this p

2、eriod, you may ask questions or seek clarification on any matters included in the case study. The assessment will be carried out under supervision although you may wish to refer to on-line help facilities, notes, textbooks, other paper based sources of information and also the internet. You must ext

3、ract information from local and remote computer data sources. The local information in this instance is in the form of a series of files shown below: USAPITAS 1.xls USAPITAS 2.mdb USAPITAS 3.doc USAPITAS 4.doc You will find these files in a folder called USAPITAS LTD on your college intranet or from

4、 a location indicated by your tutor/assessor. The remote computer data sources will be found on the web. The file USAPITAS 1.xls provides you with a collection of web links, which will assist you in finding information on the web. You will have to access at least three sites on the web. In all cases

5、 where information is used from external sources you must clearly detail your sources in your bibliography at the end of each assessment. You will assess the information requirements of Mr Campbell, Sales Director of USAPITAS Ltd, and design solutions using IT. You will select appropriate software a

6、pplication packages to meet the identified information requirements of Mr Campbell. Four or more applications must be used and output should be in the form of at least two different data types. For the purposes of this exemplar you will use at least text, number and graphics. For the purposes of thi

7、s exemplar assessment, the following software applications will be used: database spreadsheet word processing and/or desk top publishing communications (internet, intranet and e-mail)Case study: USAPITAS LTD Background information USAPITAS is a food and beverage supplier. USAPITAS purchases various

8、different speciality beverages and foods from around the world. Currently the firm deals with up to 29 different suppliers from 12 countries. USAPITAS purchases up to 70 different products from these suppliers, and sell to 24 different firms in 10 different countries. The firm has been trading since

9、 1956 when it started selling bulk teas and coffees to the retail trade. The firm is a private limited company. USAPITAS is currently undergoing some structural changes and Mr Campbell, the Sales Director, is seeking to achieve efficiency gains in the area of sales within the organisation. Mr Campbe

10、ll wishes to increase the customer base of USAPITAS. Initially this will involve reviewing current countries that the firm is trading in, but eventually should lead to expansion into other countries. Mr Campbell wants to see improvements in communications between USAPITAS and all of its stakeholders

11、 including customers, suppliers, staff and shareholders. He would also like to introduce more products into the firms range of supplies. Mr Campbell sees ICT as a useful tool in his expansion plans. He wishes to make better use of current ICT facilities at USAPITAS, and he also wishes to harness the

12、 use of the internet to better effect for USAPITAS. The firm has recently lost its IT manager and you have been promoted into his post. Mr Campbell has asked you to look at the existing IT facilities in use at USAPITAS. He is unhappy with the information being provided to him and his staff. He would

13、 like you, as the new IT manager, to provide better data from existing data sources, and make better use of the internet in various areas within the firm. In part 1 of this task you will be expected to provide data from an existing database, which contains some sales information. The data contained

14、within the database is accurate but poorly presented. Your task will be to use the database provided to produce some queries and reports, which should be available for staff to use with the minimum level of IT expertise. In carrying out this task you should note that current sales staff have varying

15、 degrees of IT skills. In part 2 of this task you will be asked to use software to support analysis of the financial performance of USAPITAS. You will be provided with current data which should be used for test purposes. Again, as above, you must take account of the fact that staff using your soluti

16、ons may not be very familiar with IT. In part 3 of this task you will be asked to produce a newsletter for staff which will increase their awareness of the internet and its benefits for USAPITAS. This newsletter will also contain staff development and training information. In part 4 of this task you

17、 will be asked to complete a table recommending appropriate software applications which meet the needs of USAPITAS in a number of examples identified by Mr Campbell.Assessment task 2 Outcome(s) covered 2 and 3 USAP Assessment task instructions Task 2: Part 1 USAPITAS 2.mdb This file contains a datab

18、ase that Mr Off, the previous IT manager, had maintained. It includes information on all sales staff, all customers, all suppliers and details of the products, which the firm deals in. Activity 1 Mr Campbell is unhappy with the quality of information on the sales front and has asked you to provide t

19、he following information for him in printout form. a) Details of all products which have been discontinued this should include the product name, the suppliers we have used in the past and a contact name. b) Details of products for which we are currently holding levels of stock worth more than 2,000.

20、 This should detail product name, supplier, stock values and unit prices. c) A printout of our suppliers showing the details of all of our British, French and German suppliers. d) A report on our customers showing the names and contact details of all contacts where the contact is in fact an owner of

21、 the firm. e) A report on our sales staff showing those who started between 1st August 1998 and 13 August 2003. This report should detail names, start dates and job titles for each member of staff. Activity 2 Mr Campbell has carried out a review of all sales and has decided to cease trading with cus

22、tomers in Finland due to excessive costs being incurred in delivering to that country. He has decided to increase all unit prices by 1% and he has also decided to reward the good work of all sales representatives by giving them all a pay rise. Printouts must include either screen dumps of the design

23、 views of your queries or definitions of your queries. a) Use a delete query to remove all customers based in Finland. b) Use an update query to increase all unit prices by 1%. c) Increase all sales representatives salaries by 2%. Produce a report showing all salaries of sales staff, include within

24、this report new salary levels plus last years bonuses. Activity 3 Mr Campbell would also like you to provide him with a word-processed report explaining what databases are and how they work. This report should contain illustrations from the database provided (USAPITAS 2.mdb). This report should make

25、 a case for using database software, ie it should include the benefits and possible efficiency gains to be had from using database software. At some point in your report Mr Campbell would wish to see illustrations and explanations of relationships between tables using the USAPITAS 2.mdb file. You sh

26、ould make use of on-line help facilities and you should add sources of support from the web these may include references to justifications for using databases to on-line support from software manufacturers. A suggested layout for this report is shown on pages 1521 and is available in your USAPITAS L

27、TD folder; the file is called USAPITAS 3.doc. The report should be about 1,500 words long. Suggested layout for word processed report (Task 2: Part 1 Activity 3) 1 Insert a statement explaining the objectives or purpose of the report here. 2 An explanation of what databases are and how they work. Us

28、e USAPITAS 2.mdb to illustrate the structure of this database. Explain the relationships between tables in this database and highlight the benefits of setting up such structures. 3 An explanation of the general benefits of using databases. Expand upon these benefits by using examples within USAPITAS

29、 LTD. Illustrate your suggested benefits with examples of queries and reports from USAPITAS 2. mdb. 4 Conclusion. 5 Bibliography. Your submissions on this case study, ie your word-processed report and your final database including queries and reports should be attached to an email to be sent to your

30、 lecturer. INSERT YOUR NAME HERE BY SELECTING THIS LINE AND OVERTYPING INSERT LECTURER NAME HERE INSERT YOUR CLASS HERE INSERT YOUR REPORT TITLE HERE INSERT YOUR UNIT NAME AND DETAILS OF ASSESSMENT INSERT THE DATE ON WHICH REPORT IS PRODUCED HERE INSERT AN APPROPRIATE GRAPHIC HERERemember to remove

31、all template instructions from your final report. IF APPROPRIATE, INSERT A CONTENTS PAGE HEREINTRODUCTION 1 Insert a statement explaining the objectives or purpose of the report here. 2 Insert an explanation of what databases are and how they work here. Use USAPITAS 2.mdb to illustrate the structure

32、 of this database. Explain the relationships between tables in this database and highlight the benefits of setting up such structures. 3 Insert an explanation of the general benefits of using databases. Expand upon these benefits by using examples within USAPITAS LTD. Illustrate you suggested benefits w