2013 HSC Information Processes and Technology
Contents
1. Participants Data information Information technology Employees Customer data File server Order details Communication equipment Geographical data Boundary a Describe the information process of collecting in this coffee house information system b Describe TWO different software applications used in this information system c Explain what hardware is needed to ensure the uninterrupted availability of the system during periods of high demand 10 Question 23 11 marks Use the Question 23 writing booklet A website is to be created for a travel agency to answer customer enquiries a b c The following tasks and suggested time frames have been identified for the development of this website e Requirements Gathering will begin immediately and continue for three weeks e Cost Benefit study will follow for two weeks e Design will begin one week into the Requirements Gathering stage and end one week after the Cost Benefit study e Building and testing the website will follow the Design stage and continue for three weeks Create a Gantt chart showing the minimum time required to complete the above tasks In the user manual of the proposed website the following example is used to show how to locate tourist information for a customer who wishes to visit Ha Long Bay Da Nang Na Trang Vinh Long and Vinh Thuan Long or xang or Vinh Explain how this search works The homepage of this websit2. Off Closed Acti i gt 50 Medium On Off Closed ctions 15 30 Bi n 50 Medium Off Off Open s e 50 Low Off Off Open lt 50 Medium Off On Closed Using examples of facts and if then rules explain how a method of chaining could be applied in this system e Question 27 Automated Manufacturing Systems 20 marks Use a SEPARATE writing booklet a i Describe an application that uses a movement sensor 2 ii What are the disadvantages for workers of an automated manufacturing 3 system b i Distinguish between discrete and continuous processing giving an 3 example of each ii Using an example describe how RFID Radio Frequency Dentification 4 tags can assist in inventory tracking c A smart house has an automated drip watering system for indoor plants similar to an agricultural irrigation system A central controller accepts input from sensors in the pot plants and turns the water on when the sensors indicate a low moisture level When the moisture reaches a suitable level for the plants the drip system is turned off Nutrients for the plants are added to the water automatically i What are the benefits for residents of the automated drip watering system 3 over a manual system ii This diagram shows an incomplete block diagram of the system that 5 maintains moisture levels in the sma
3. i How could the visually based multimedia interface be adapted to cater 3 for the needs of residents with sight impairment ii Design a storyboard showing screens of the central controller that 5 control THREE aspects of the smart house that make good use of the multimedia capabilities of the touch screen tablet Label the key features of each screen End of paper 16 Board of Studies NSW 2013
4. marks Use the Question 21 writing booklet A legal firm is planning to implement a file storage and sharing system This system will allow employees in different locations to communicate and work together simultaneously Depending on the position they hold different staff members have access to different documents Employees in this firm are inexperienced in the use of information technology and are not comfortable with the introduction of the new system a Outline a method that could be used to provide different employees with 2 different levels of access to the documents b Compare the use of printed user manuals with providing face to face training 3 classes to prepare employees for the introduction of the new system c Describe technologies needed for employees in different locations to view 3 discuss and edit shared documents Question 22 9 marks Use the Question 22 writing booklet An information system in context diagram is shown for an online coffee house Users Environment Travelling public Online Coffee House Information Purpose system The system will allow commuters to purchase coffee using a mobile device The coffee is ordered and paid for electronically and can be picked up at the coffee shop closest to their location Information processes Collecting processing analysing displaying transmitting receiving organising storing retrieving
5. DER BY Products Quantity ASC Which list would be produced as a result of this query A All products in alphabetical order B Products due to be delivered in order of urgency C Products sold in the last month in order of popularity D Products that need to be reordered based on stock levels A large insurance company wishes to integrate all data in its current information systems to create an enterprise wide system within the next three months Research into similar companies indicates that there are already successful systems available although they do not fulfil all the specific needs of the company Which of the following would be the most appropriate solution for this company A Identify a developer who can apply agile methods to develop the new enterprise wide system B Use prototyping to show the modifications that the company requires of their new enterprise wide system C Use a traditional approach to develop the new enterprise wide system in house to meet the company s specific needs D Identify an appropriate supplier purchase an enterprise wide system from them and have the system customised to meet the needs of the company Section II 40 marks Attempt Questions 21 24 Allow about 1 hour and 10 minutes for this section Answer each question in the appropriate writing booklet Extra writing booklets are available If you include diagrams in your answer ensure that they are clearly labelled Question 21 8
6. SS BOARD OF STUDIES NEW SOUTH WALES 2013 HIGHER SCHOOL CERTIFICATE EXAMINATION Information Processes and Technology General Instructions e Reading time 5 minutes e Working time 3 hours e Write using black or blue pen Black pen is preferred e Draw diagrams using pencil 2480 Total marks 100 Pages 2 8 20 marks e Attempt Questions 1 20 e Allow about 40 minutes for this section Section II Pages 9 12 40 marks e Attempt Questions 21 24 e Allow about 1 hour and 10 minutes for this section Section III Pages 13 16 40 marks e Attempt TWO questions from Questions 25 28 e Allow about 1 hour and 10 minutes for this section Section I 20 marks Attempt Questions 1 20 Allow about 40 minutes for this section Use the multiple choice answer sheet for Questions 1 20 1 An organisation employs a project team to update a system Which of the following techniques could the team use to understand the needs of the organisation A Testing the solution B Refining the prototype C Interviewing the participants D Scheduling the tasks to be completed 2 This context diagram represents an online retailer Order Order details details Online Purchasing System gt Warehouse lt 3 Customer gt D Transaction receipt Invoice Which row in the table identifies a process and an external entity in the diagram Process External en
7. d of payment for purchases requires customers to simply place an enabled credit card close to a terminal at the checkout Which of these is used to transfer data from the credit card to the EFTPOS terminal A B C D 3G Infrared NIC Radio In a transmission system when the message TOP MARKS was sent as a secured message it appeared as XSTDQEVON Which security measure was used A B C D Checksum Encryption Modulation Synchronisation Use this email to answer Questions 10 11 To Patricia Jones JamesNguyen KevinWang ast ai i s s s C Ce Kerrin Jacobson o aw Bce Fred Stevenson i i sss lt i lt CO Subject Meeting Notes From Brian Clarkson 0 Dear All Please find attached a copy of the meeting notes from our 10 00am meeting Regards Roberto Meeting Notes 24 6KB 10 Who would receive this email without all the other recipients knowing 11 12 A B D Patricia Jones James Nguyen and Kevin Wang Kerrin Jacobson Fred Stevenson Brian Clarkson What may raise concerns as to whether the email message is legitimate A B C D The attachment may contain a virus The message is being sent to three recipients There are obvious spelling mistakes in the message It is signed by a person who does not own the email account A prospective employer asks a job applicant for their social network login deta
8. e needs to allow travel agents to collect customers travel details for flight bookings and to provide links to information about destinations travel insurance and safety advice Draw a labelled diagram that identifies the main features of this homepage 1 Question 24 12 marks Use the Question 24 writing booklet A wholesale lighting company has three sales staff that travel to various businesses to sell their products When a purchase occurs the sales staff enter the sale into a central database via a wireless network The company then prepares the order and ships it to the customer The table shows part of the data and how it is linked to other tables within the database Invoice table Primary key fields Foreign key fields Other fields Date Date Invoice No Order ID Customer ID Employee ID ordered required 10121345 73826 JAPE A4 19 05 13 19 06 13 10121346 93825 KING C6 26 05 13 16 06 13 10121347 93836 MOTO A2 10 06 13 29 06 13 10121348 87465 KING B9 12 06 13 01 07 13 10121349 43528 LOVE C6 18 06 13 08 07 13 a Draw a labelled diagram to represent the communication technologies required for this system In your diagram include the communication media and hardware devices b Construct a schema representing the invoice table and the three related tables Show primary keys foreign keys and relationships c The company is considering outsourcing the hosting o
9. f its database However this will have financial and technical implications and will affect the ownership and control of data Discuss the issues associated with this outsourcing proposal aio Section III 40 marks Attempt TWO questions from Questions 25 28 Allow about 1 hour and 10 minutes for this section Answer each question in a SEPARATE writing booklet Extra writing booklets are available If you include diagrams in your answer ensure that they are clearly labelled Question 25 Transaction Processing Systems 20 marks Use a SEPARATE writing booklet a i Identify a strength and a weakness of an online ticketing system ii Using an example explain the importance of data quality in a transaction processing system b i Describe how batch processing and real time processing are applied in an automatic teller machine transaction ii Explain why the alternative procedures for a transaction processing system need to be periodically tested c A smart house with a semi automated kitchen includes a smart refrigerator The residents scan the food and drink items before placing them in the refrigerator The item s barcode identifies product details which are recorded in the refrigerator s database As each item is used it is scanned again and the database is updated A weekly order is automatically placed by the refrigerator to a supermarket based on quantities remaining or a resident can cho
10. fice and connected to a network of thin clients in remote offices Which of the following backup options is the most appropriate A Daily backup of the main server B Daily backup of the thin clients C Weekly backup of the thin clients D Weekly backup of the main server A business employs a project team to develop a new system The development approach they use is represented in the diagram below Understanding the initial requirements Y Planning a solution Y m gt Refining the solution gt Developing and testing the solution Y User testing and evaluating Y Yes _ ls another feature requested Y No y System completed Which development approach is used by the business A Agile B Traditional C Participant development D Participant customisation Which of the following is an example of live data testing A A programmer reviewing the code of a game prior to releasing it B A business offering free goods to customers who order from an online store in its trial period C A web designer requesting feedback about a website from the company for which it was developed D A data entry operator investigating the maximum number of records that can be stored in a database 19 20 Janice entered the following SQL command to retrieve information about the products in her store SELECT Products ProductNumber FROM Products WHERE Products Quantity lt minimum stock OR
11. ils The applicant should consider this request as A B C D an invasion of privacy the employer s legal right a freedom of information request a breach of the applicant s ownership of data 5 13 A database developer would create different data views for users to show A the metadata B the data structures C data relevant to their work D data in response to their queries 14 This is part of the PRODUCT table in a relational database PRODUCT Product_ID Product_Name Price Supplier_ID SB1296 Cheese grater 4 55 SX43 SB1297 Salad spinner 11 25 SX43 SB1298 Knife block 45 00 SD18 Which of the following would be valid data types for the fields Price and Supplier_ID Price Supplier _ID A Boolean Text B Text Real C Real Text D Currency Real 15 This HTML code is found in the source of a web page lt html gt lt head gt lt title gt Cinema Releases of 2013 lt title gt lt meta name description content the best movies that were released in 2013 gt lt meta name keywords content pictures films videos gt lt head gt lt html gt Which of the following words would NOT locate this web page when entered into a search engine A 2013 B films C movies D title 16 17 18 A company is designing backup procedures for very important data The main server is located in the head of
12. ose to send an order to the supermarket Purchases are debited from the resident s bank account i Describe the shifting of workload for both residents and supermarket 3 staff as a result of the smart refrigerator system GD Construct a data flow diagram that represents the ordering of food and 5 drinks by the refrigerator my i Question 26 Decision Support Systems 20 marks a b c Use a SEPARATE writing booklet i What are the advantages of using graphs to represent data in spreadsheets ii Describe the effects on the participants when their decision making is automated i Distinguish between structured and unstructured decision making giving an example of each ii Discuss the role of the expert in the development of an expert system A smart house has an expert system that controls the temperature and comfort levels within the house This expert system monitors the internal areas of the building and informs the controller how to adjust the temperature in the house using fans air conditioning and heating units The controller can also open and close windows i Describe the effects on the residents of the house if the smart house experiences a power failure ii This decision tree shows part of the expert system s logic Inside temperature Humidity Fan Cooling Heating Window wee 50 High On Off Closed gt 30 C lt 50 Medium On
13. rt house s pot plants Incomplete section of block diagram Required moisture Programmable level turn water on or H O ON controller off to maintain moisture levels Using a refined block diagram explain the technical problems that could occur with this continuous monitoring system Please turn over 15 Question 28 Multimedia Systems 20 marks a b c Use a SEPARATE writing booklet i Identify different devices that are used to display multimedia 2 ii How can a developer ensure that a multimedia project does not breach 3 copyright i Describe the process of converting analog sound to digital data 3 ii Explain the role of a multimedia system designer when developing 4 a system A smart house allows the residents to adjust settings of the many different services in the eight rooms of the house including e lighting on off and dimming e shutters and curtains open or closed e watering system for indoor plants e air conditioning and heating e smart refrigerator in the kitchen e home entertainment system e security system e fire safety sprinklers The central controller is a wall mounted touch screen tablet that uses multimedia formats in the display The display includes the use of text sound graphics animation and live video feeds Residents can also use their smart phones as an alternative remote controller in other rooms
14. tity A Online purchasing system Warehouse B Order details Transaction receipt C Online purchasing system Transaction receipt D Order details Warehouse A company is considering implementing a new system Which of the following should be included in the feasibility study A An operation manual B Results from testing the new system C A working model of the new system D Risks associated with the new system A worker uses a hand held device to scan the barcodes of items in a warehouse Which information process best describes the activity of scanning A Collecting B Displaying C Storing D Transmitting The diagram shows a household network Broadband modem to internet connection 2 Computer 1 Ethernet router qd amp Wireless access point Printer NS y Z E gt o 5 Computer 2 Games console Smartphone Which network topology is represented in this diagram A Bus B Hybrid C Star D Wireless Which of the following converts analog sound into digital data A B C D OLAP RSS TCP VOIP Which of the following would be LEAST effective in identifying problems in an existing system A Surveying users B Interviewing participants C Observing participants using the system D Writing a troubleshooting guide for users A new EFTPOS metho
Download Pdf Manuals
Related Search