yoze's picture
From yoze rss RSS  subscribe Subscribe

Informat Tech 01 

 

 
 
Views:  284
Published:  January 05, 2010
 
0
download

Share plick with friends Share
save to favorite
Report Abuse Report Abuse
 
Related Plicks
Software Engineering - 01. Introduction

Software Engineering - 01. Introduction

From: anon-558499
Views: 140 Comments: 0
Software Engineering - 01. Introduction
 
KSOU Examination Datesheet Jan 201

KSOU Examination Datesheet Jan 201

From: edudivya
Views: 152 Comments: 0

 
basketball powerpoint

basketball powerpoint

From: kaka01728
Views: 55 Comments: 0

 
basketball powerpoint

basketball powerpoint

From: kaka01728
Views: 52 Comments: 0

 
ncca

ncca

From: more01716
Views: 85 Comments: 0

 
Community Informatics : Shaping Computer-Mediated Social Relations

Community Informatics : Shaping Computer-Mediated Social Relations

From: anon-391004
Views: 324 Comments: 0
Community Informatics : Shaping Computer-Mediated Social Relations ,erin bell library and infiormation science, carroll county library, library bid rigging, free cad plumbing and electrical library
 
NCAA Football powerpoint

NCAA Football powerpoint

From: anis01728
Views: 99 Comments: 0

 
See all 
 
More from this user
progressive mreport-04/08

progressive mreport-04/08

From: yoze
Views: 452
Comments: 0

640-821 Exam Questions & Answers

640-821 Exam Questions & Answers

From: yoze
Views: 578
Comments: 0

Consumer Brochure- Medical Tourism New Zealand

Consumer Brochure- Medical Tourism New Zealand

From: yoze
Views: 799
Comments: 0

23204995

23204995

From: yoze
Views: 1300
Comments: 0

2010 Toyota Venza Concord

2010 Toyota Venza Concord

From: yoze
Views: 383
Comments: 0

energy future holindings  txu2006ar

energy future holindings txu2006ar

From: yoze
Views: 521
Comments: 0

See all 
 
 
 URL:          AddThis Social Bookmark Button
Embed Thin Player: (fits in most blogs)
Embed Full Player :
 
 

Name

Email (will NOT be shown to other users)

 

 
 
Comments: (watch)
 
 
Notes:
 
Slide 1: 2001 H I G H E R S C H O O L C E R T I F I C AT E E X A M I N AT I O N Information Technology Total marks – 80 Section I General Instructions • Reading time – 5 minutes • Working time – 2 hours • Write using black or blue pen • Board-approved calculators may be used • Write your Centre Number and Student Number at the top of pages 9, 13 and 17 Pages 2–7 15 marks • Attempt Questions 1–15 • Allow about 15 minutes for this section Section II Pages 9–18 35 marks • Attempt Questions 16–19 • Allow about 45 minutes for this section Section III Pages 19–20 30 marks • Attempt TWO questions from Questions 20–22 • Allow about 1 hour for this section 379
Slide 2: Section I 15 marks Attempt Questions 1–15 Allow about 15 minutes for this section Use the multiple-choice answer sheet. Select the alternative A, B, C or D that best answers the question. Fill in the response oval completely. Sample: 2+4= (A) 2 A (B) 6 B (C) 8 C (D) 9 D If you think you have made a mistake, put a cross through the incorrect answer and fill in the new answer. A B C D If you change your mind and have crossed out what you consider to be the correct answer, then indicate the correct answer by writing the word correct and drawing an arrow as follows. correct A B C D –2–
Slide 3: 1 When a document is printed from a word-processing package, what controls the margins? (A) The printer driver (B) (C) The printer driver and the word-processing software The printer driver, the word-processing software and the printer port (D) The printer driver, the word-processing software, the printer port and the processor speed 2 The following table shows a spreadsheet. A 1 2 3 4 5 6 Cost Comparison CPU speed 866 1000 1400 Brand W $3,095 $3,595 $4,495 Brand X $3,195 $3,695 $4,495 Brand Y $2,095 $2,595 $3,995 Brand Z $3,295 $3,995 $4,995 Average =AVERAGE(B3:E3) B C D E F Which formula will be stored in cell F5 if the formula at F3 is copied down column F using a relative copy command? (A) =AVERAGE(B3:E3) (B) (C) =AVERAGE(B5:E3) =AVERAGE(B3:E5) (D) =AVERAGE(B5:E5) 3 Which component of a database is used for sorting? (A) Field (B) (C) Form Record (D) Table –3–
Slide 4: 4 An employee who is inexperienced with an application package written specifically for your company approaches you for help to learn to use the package. As a member of the IT support staff, what is the most effective advice you could give? (A) Use the online help facility in the package. (B) (C) Read the technical manual supplied with the package. Complete the online tutorial provided with the package. (D) Ring the help desk of the company that wrote the package. 5 You wish to save the changed version of a document that was originally located on a standard CD-ROM. What is the best method to do this? (A) Read the document from the CD-ROM, modify the document, then save it to the hard disk. (B) (C) Read the document from the CD-ROM, modify the document, then save it back to the CD-ROM. Rename the document on the CD-ROM, read and modify the document, then save it to the hard drive. (D) Copy the document from the CD-ROM to the hard drive, read the document, modify it and save it back to the CD-ROM. 6 You wish to install a hardware device that is NOT Plug and Play. Which of the following is commonly the first instruction given to install this device? (A) Install the driver. (B) (C) Install the device. Turn the power off. (D) Disconnect the monitor. –4–
Slide 5: Use the table to answer Questions 7 and 8. It contains specifications for black and white printers of the same print quality. Purchase price Printer 1 Printer 2 Printer 3 Printer 4 $159 $299 $499 $3 995 Pages per minute 3 4 4 28 Running cost per 100 pages $5.20 $3.60 $4.00 $0.50 7 Which printer would be the most economical to purchase for printing 100 000 pages of business documents per year for five years? (A) Printer 1 (B) (C) Printer 2 Printer 3 (D) Printer 4 8 Which printer would be the most economical to purchase where a single user prints 1000 pages per year for five years? (A) Printer 1 (B) (C) Printer 2 Printer 3 (D) Printer 4 9 Which of the following is the safest way to supply power to a printer? (A) Power board (B) (C) Extension lead Double adapter (D) Standard power outlet –5–
Slide 6: 10 What is the purpose of compressing a file? (A) To encrypt the data (B) (C) To occupy less storage space To increase transmission time over a network (D) To allow the file to be read by a variety of applications 11 You wish to include a graphic from another application into a word-processed document with the aim of automatically keeping the graphic up-to-date. What is the best method of doing this? (A) Link the graphic. (B) (C) Embed the graphic. Copy and paste the graphic. (D) Import the graphic as a GIF file. 12 From: To: Subject: Ahmed Habib Lee Nguyen Chris Bradley Untitled CC: BC: Steve George, Kim Jones Barbara Thompson Send Message Please find attached the CV for Chris Bradley Cancel Address & Attach Print Message ChrisBradleyCV.doc Attach How many people will receive copies of the attachment? (A) 2 (B) (C) 3 4 (D) 5 –6–
Slide 7: 13 Which of the following contains the essential elements for dealing with client requests? (A) Polite and courteous manner, effective verbal communication, use of questioning and passive listening (B) (C) Rapid turnaround of requests, use of questioning and active listening, effective verbal communication Rapid turnaround of requests, use of questioning and passive listening, effective non-verbal communication (D) Polite and courteous manner, effective verbal and non-verbal communication, use of questioning and active listening 14 You have just taken delivery of a new printer for your company. What steps should you complete before connecting and installing the printer? (A) Register the warranty, enter the serial number into the equipment inventory (B) (C) Register the warranty, enter the serial number into the equipment inventory, check the contents of the box against the packing list Register the warranty, enter the serial number into the equipment inventory, install the device driver and check operation (D) Register the warranty, check the contents of the box against the packing list and unscrew the outer casing to check that all components are present 15 Which of the following would be included in a daily partial backup of a hard disk? (A) All files (B) (C) All files changed in the past day All data files changed in the past day (D) All program files changed in the past day –7–
Slide 8: BLANK PAGE –8– © Board of Studies NSW 2001
Slide 9: 2001 HIGHER SCHOOL CERTIFIC ATE EXAMINATION Information Technology Section II 35 marks Attempt Questions 16–19 Allow about 45 minutes for this section Answer the questions in the spaces provided. Centre Number Student Number Question 16 (7 marks) (a) Define the following: Style guide ............................................................................................................ ............................................................................................................ Template ............................................................................................................ ............................................................................................................ Macro ............................................................................................................ ............................................................................................................ 3 Question 16 continues on page 10 380 –9–
Slide 10: Marks Question 16 (continued) Use the material below to answer part (b). Both documents use 12 point text. Raw Document The 'qualified assessor' may consist of an assessment team in which one partner has assessor qualifications and knowledge and the other has technical competence in information technology. The Information Technology Training Package is accompanied by a non-endorsed component. This resource contains suggested delivery strategies, including case studies and sample assessment instruments. In addition, the non-endorsed component of the training package includes a resource database. Non-endorsed components of the training package are available from Australian Training Products. Finished Document The ‘qualified assessor’ may consist of an assessment team in which one partner has assessor qualifications and knowledge and the other has technical competence in information technology. The Information Technology Training Package is accompanied by a non-endorsed component. This resource contains suggested delivery strategies, including case studies and sample assessment instruments. In addition, the non-endorsed component of the training package includes a resource database. Non-endorsed components of the training package are available from Australian Training Products. Information Technology Curriculum Framework Stage 6 Syllabus Page 32 (b) List FOUR formatting changes needed to convert the raw document to the finished document. ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... End of Question 16 – 10 – 4
Slide 11: Marks Question 17 (7 marks) Use the diagram to answer Question 17. (a) Identify FOUR ergonomic problems or occupational health and safety (OH&S) concerns. ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... 4 Question 17 continues on page 12 – 11 –
Slide 12: Marks Question 17 (continued) (b) Explain the possible health effects of NOT correcting ONE of the problems or concerns identified in part (a). ............................................................................................................................... ............................................................................................................................... (c) Outline TWO modifications that could be made to the workstation that would help to bring it into line with OH&S standards. ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... 2 1 End of Question 17 – 12 – © Board of Studies NSW 2001
Slide 13: 2001 HIGHER SCHOOL CERTIFIC ATE EXAMINATION Information Technology Section II (continued) Centre Number Student Number Question 18 (10 marks) Please turn over 381 – 13 –
Slide 14: Question 18 (10 marks) Use the tables to answer Question 18. Table: Contacts Title Firstname Lastname Ms Mr Dr Ms Mr Ms Judy Fred Isaac Tranh Ahmed Bianca Lee Lake McGrath Nguyen Smith Lee Address GPO Box 93991 300 Main Rd 600 Victoria Rd Town Sydney State Postcode NSW 2001 2987 7117 2034 4222 2034 Email jlee@eop.com.au lake.fred@supersys.com.au macca@pcc.com.au t.nguyen@cruz.com.au a.smith@Itcon.com.au b.lee@cruz.com.au Riverfront NSW Gosford TAS NSW 88 Cumberland Hwy Gore Hill 12 Sussex St Cammeray QLD NSW 88 Cumberland Hwy Gore Hill Data dictionary for Table: Contacts Field name Title Firstname Lastname Address Town State Postcode Email Type Text Text Text Text Text Text Text Text Width 4 12 20 40 16 3 4 40 Comment Enter Mr, Ms, Dr, Rev, Sir, etc. Enter the first name Enter the last name Enter the company address Enter the name of the city Enter NSW, QLD, VIC, etc. Enter the postcode Enter the e-mail address Question 18 continues on page 15 – 14 –
Slide 15: Marks Question 18 (continued) (a) If a query were made of Contacts with postcodes between 2000 and 2030, how many records would be listed? ............................................................................................................................... (b) If all postcodes consist of four digits, why is the field TYPE set to ‘Text’ instead of ‘Numeric’? ............................................................................................................................... ............................................................................................................................... (c) If the database were sorted in ascending alphabetic order on Lastname, which Lastname would appear first? ............................................................................................................................... (d) What are the advantages of splitting the contact’s complete address into four fields (Address, Town, State, Postcode) rather than using a single field? ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... (e) The following SQL statement is used to generate an e-mail contact list: FROM Contacts WHERE State = “NSW” SELECT Firstname, Lastname, Email ORDER Lastname, Firstname Write the expected output, in correct order, in the space provided. ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... End of Question 18 – 15 – 5 2 1 1 1
Slide 16: BLANK PAGE – 16 – © Board of Studies NSW 2001
Slide 17: 2001 HIGHER SCHOOL CERTIFIC ATE EXAMINATION Information Technology Section II (continued) Centre Number Student Number Marks Question 19 (11 marks) As a member of the company’s help desk you have received a phone call from a receptionist at one of the branch offices. The receptionist, who has a stand-alone computer, is unable to print documents. (a) Explain ONE software problem that may be causing the receptionist to be unable to print. ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... (b) Identify THREE essential categories of information that must be recorded when logging the call. ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... (c) Explain the benefits to your company from logging help desk calls. ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... Question 19 continues on page 18 382 2 3 2 – 17 –
Slide 18: Marks Question 19 (continued) (d) Evaluate the effectiveness of questioning and listening techniques to support client requests and enquiries. ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... ............................................................................................................................... 4 End of Question 19 – 18 – © Board of Studies NSW 2001
Slide 19: 2001 HIGHER SCHOOL CERTIFIC ATE EXAMINATION Information Technology Section III 30 marks Attempt TWO questions from Questions 20–22 Allow about 1 hour for this section Answer each question in a SEPARATE writing booklet. Extra writing booklets are available. In your answers you will be assessed on how well you: ■ demonstrate relevant knowledge and understanding ■ communicate ideas and information, using precise industry terminology and appropriate workplace examples ■ organise information in a well-reasoned and cohesive response ■ solve proposed issues or problems Question 20 (15 marks) Your manager has asked you to draft a memorandum to staff explaining the company’s policy and procedures for minimising the risk of computer virus infection and transmission. Assuming that the company has only stand-alone computers, draft this memorandum. Question 21 (15 marks) You work in the IT support section of a large organisation with several branch offices. Head Office is implementing a new policy for archiving financial data. You are responsible for sending a Financial Archiving Kit to each branch office. The Kit will include: • a high-capacity, removable media storage device that connects to a USB port • a USB cable • a floppy disk containing drivers for the storage device • five blank high-capacity disks • a floppy disk containing a customised archiving utility • a user guide. The archiving utility includes a function to verify correct installation. Draft the user guide, outlining the essential steps that the user must take to successfully install and test the Financial Archiving Kit. Please turn over 383 – 19 –
Slide 20: In your answers you will be assessed on how well you: ■ demonstrate relevant knowledge and understanding ■ communicate ideas and information, using precise industry terminology and appropriate workplace examples ■ organise information in a well-reasoned and cohesive response ■ solve proposed issues or problems Question 22 (15 marks) The structure of an organisation is outlined in the hierarchy diagram. General Manager Personal Assistant to General Manager Sales Department Accounts Department Marketing Sales Representatives Accounts Receivable Accounts Payable Financial Management Government Corporations Retail The organisation is seeking to improve data management. Write a report that proposes good file-management procedures. Include a simple sketch of a directory/folder structure for the Sales Department using information from the hierarchy diagram. Explain and justify your proposals in relation to audit requirements, file attributes, incremental backup and file and folder passwords. End of paper – 20 – © Board of Studies NSW 2001

   
Time on Slide Time on Plick
Slides per Visit Slide Views Views by Location