ZIMBABWE MINISTRY OF HIGHER AND TERTIARY EDUCATION, SCIENCE AND TECHNOLOGY DEVELOPMENT HIGHER EDUCATION EXAMINATIONS COUNCIL MASHONALAND WEST AND CENTRAL REGION COURSE: COMPUTER OPERATIONS AND PACKAGES COURSE CODE: 115/20/C0/0.Theory Assignment 1 QUESTION 1 a. With aid of examples briefly define the following terms as they are used in computing, i. Output (a) ii, Computer (1) il, Assembler (2) iv, Dumb terminal (2) v. Character (2) vi. Storage device Q] b. What do the following abbreviations stand for as used in computers? i HTML ( i, LCD (1] iii, OMR. (1) iv. GIGO 1] v. HD (1) vi. MODEM a) QUESTION 2 ° State the device used for the following i. Printing using heat a ii. Used for fast clearance of cheques in banks a ili, An input device that is sensitive to touch (1) iv. Used in playing games (1) v. Its contents can be erased only by exposure to ultra violet light [1] vi. Can be used to determine name of product,supplier,size,price and quantities left at apoint of sale system (a) vii. It squirts/sprays droplets of ink that are directed by the electric field to paper and form characters when printing (ay vili. Is responsible for interpretation of instructions and regulates the flow of signals to hardware components a] x. Detects pencil or ink marks made on certain locations of a document and is mainly used for marking multiple choice exam papers by Zimsec, questionnaires and lotto[1] xi. A drive used to read an optical disk but cannot write onit [1] xii, A machine that can transmit documents containing both text and graphics overtelephone lines aa]QUESTION 3 a.Though computer networking has a number of advantages such as speed in transfer of files, minimized costs due to resource sharing, centralized control and monitoring of computer resources use which is easier and more convenient. There are a number of drawbacks of networking computers.Outline any four such disadvantages [4] b, Matika group of Companies is planning to change their secretarial department equipment. As 2 ‘computer expert you have been consulted on the use of electronic databases as a good move than their traditional filling system. Outline three advantages of electronic database over traditionalfilling system. [3] QUESTION 4 a. Differentiate between a transaction file and a master file. Explain their relationship [4] b. Differentiate the following: i. Data and information [4] Main memory and Backing storage [4] ili, Online data processing and batch data processing [4] 50 MarksTheory Assignment 2 QUESTION 1 ©. Computer software can be divided into two sections operating system and application software State any two examples of operating system and two examples of application software [5 marks] b). List any five (5) features of a good word processing package [5 marks] ¢). Explain briefly the meaning of the following word processing terms (i). Indentation (ii). Orphan (ii). Orientation (ii). Page break [5 marks] 4d). Explain the meaning of the DOS commands: (i). cD (ii). MD (ii). Copy (iv). Delete (v). Rename [5 marks] e. Outline the difference between: i, backspace and delete keys (4 Marks} Ji, Data and Information [4 marks] iii, Simplex and Full duplex transmission models [4 Marks] f. Draw and label a mouse [3 Marks]QUESTION 2 a. Name any three spreadsheet program you are familiar with [3 marks ] b. Madzima Stores has several departments, below is an abstract from their salaries department. Employees have just received a salary increase and bonus this month. A B Gi [> E F G 7 | SALARY REVIEW 2 FIRST | SURNAME BRANCH | GRADE | SALARY | SALARY | BONUS | NEW NAME 3) | INCREASE | (5) | SALARY (s) 3 [Nakai [Chimwaura | Bindura_ | D 800 iso__| 4 |Tatenda | Muneri Muzaraban | B 1700 350 | i S| Maita | Kufa [Nyanga _[c 950 200 6 _| Thandeka | Ndlovhu | Masvingo_| C 950 200 | 7_| Xandaier_| Manzunzu Mahuwe | A 1800 450 | Byron _| Nhengu [Harare [D ‘800 150 9 | Lameck | Chigaro Gweru 8 1700 350 | 1 | Vimbiso | Chiwandamira | Chinhoyi | A 1800 450 | 0 | | 1 | Proud | Chibaya | Harare c 950 200 1 | 1 [Mary | Gwaindepi | Masvingo | A 1800 450 2 1 |Givemor |Mangadze | Hwata 8 1700 350 3 le | 1 [Kuda | Mutashu |Mutare— [C 950 200 4 | 1 | Alexio Mashayamom | Centenary | D ‘800 150 | 5 be | 1 | Total | | 6 | 1 | Average 7 | | 1 | Maximu | | 8 |m | 1 | Mimimu | 9 |m 2 | Count 0Salary increase is 15% of the total salary New salary is salary + salary increase + bonus How much is the new salary for: Mary Gwaindepi Byron Nhengu GivemoreMangadze State the formula for: Average salary being paid currently Total new salary paid by the company 50 marks [2 marks} [2 Marks] [2 Marks} [3 marks] [3 marks]PRACTICAL 1 Question 1a: WORD PROCESSING Type and print the following passage as it is using Times New Roman font type. (SMARKS) How Can | Avoid Dangers on the internet? ittle wonder, then that some expects that over 320 million people will be using the internet by the ‘end of this year. Use of the Internet is thus becoming common place in many parts of the world. With schools and libraries aggressively promoting its use, millions of young people have access to it. In the United States, nearly 65% of youth between the ages of 12 and 19 have already used or subscribed to on-line services. Properly used the internet can be a source of helpful information on the weather, travel, and other subjects. Through it you can buy books, car parts and other things. Many use it for school work Although the internet can be useful, it can also seem like a library without a librarian or other observers. One can browse it with the feeling that no one else is around. But this is one of the greatest dangers of using the internet. Why? Because countless Web sites contain material that is morally corrupt and destructive. “Some Web sites are shocking. They can pop up without warning” 1(b) Insert a header of your school name and footer of your name? (2marks) (c) Insert a column break it {to two to the passage above (2marks) (a) Center the heading (2marks) (e)Insert a special character to the bottom of the page (2marks) (f) Print the passage in landscape orientation (1mark) (g) Insert a watermark of your first name? (1mark) (h) Create a table below? (LOmarks)[ ‘OUR SCHOOL GARDEN ‘ORANGES PLANTS NAMES Plantation A Good | ¢ | ees 8 5 2 = 26 6 6 Plantation B Dy No |Yes [Yes [No | Mike Plantation C Wet Yes | Yes [Yes [No | John Plantation D Very wet [No [No |Yes [No | Ashton TOTAL (25 Marks) QUESTION 2 MICROSOFT EXCEL Below is a spreadsheet Aceh aie Ouse | é sack 1 aly stock Min order Qty Minre-orderlevel PriceexcVAT 2| 2 5 0 mS 2 5 5 7 a 4 a 0 8 5 5 0 5 3 8 6 % rt rt 5 1 x 5 0 38 5 a 0 15 ei 2a) Name the spreadsheet package you are using (1mark) [remanee] (b) Name the cells that we can find the following data 325, 7.5 and 23.99? 3marks) (C) Calculate the total min order Qnty from the spreadsheet above and display the formula you have used? (3marks)(4) Subtract 03 from €3? (2marks) {e) Find 17.5% of cell F4? (2marks) (F)Find the average of cells C3 to C9 inclusive? (2marks) (g) Add the cells F2 and F3 and then divide the total by cell e5? (2marks) (h) Create a bar graph to display all prices exc VAT? (3marks) (i) Format the columns of Price exc VAT to currency? (3marks) (i) Print the bar graph in landscape? (1mark) (0) Multiply cells €5 and F5 (2marks) (00) add the total of min order quantity (2marks) TOTAL (30 MARKS)Question 3 Database A large second hand car company keeps details of all its cars in stock using a series of records held in a filing cabinet. It is decided that the data should be transferred to a database held on a computer. Here is part of the file: (a) Create and save database called CARSALEDATABASE(Smarks) MAKE [MopeL [PRICE | YEAR _ TYPE MILEAGE Nissan Sunny 14t | $45000 93 saloon 24000 Nissan Sunny1.4G $24500 92 Saloon 35000 | Ford Mondeo $72000 97 saloon 34000 [Ford Escort $35000__—*| 95 saloon 56000 [Nissan | 200sx_ $5 i 95 sports 6600 an 3002x $56800 96 sports 56070 Honda Civic $88000. 96 saloon 10000 Mercedes 230 $200000 cy Saloon 7600 Nissan micra $330000 94 saloon | 14000 (b) Reload your database and make the following amendments: * the Nissan sunny for $24500 is actually a Nissan sunny 1.4GLX 91 (1mark) + The Mercedes 230 needs price reducing to$129000 (1mark) © Honda Civic is a 99 model (Imark) * Nissan 3002x needs price increase to $7885600(1mark) (c)The following cars have been sold so their details need deleting from the database. * Nissan 200sx $556000 95 sports 6600 (amark) * Ford escort $35000 95 saloon 56000 (1mark) © Nissan micra $330000 94 — saloon 14000 (1mark) (d) The following cars have come in so their details need to be added to the database. Make amendments and print the sheet. (Smarks) Nissan elegant $34089 98 saloon 5600 Ford bantam $435000 99 saloon Nissan primera $345600 93 saloon Toyota chaser $678900 95 sports(e) Create a form of Nissan models (3marks) Total 25 marks QUESTION 3 DESKTOP PUBLISHING (a) Using a DTP software package of your choice create an advertisement of a hardware selling company selling computer accessories. The advertisement should contain the following information Y Name of the company (2marks) Y Picture of some computer hardware (2 marks) Y Suitable marketing language (3marks) Y Use Times New Roman font type (1mark) Print the advertisement (2marks) TOTAL 10 MARKS : QUESTION 4 POWERPOINT Imagine you have been asked to make a presentation of selling cars .You will need the following four slides Introduction Types of cars Model of the cars Costing (a) Create an introductory first slide with the title of the presentation, your name and a suitable picture .All of the other slides should have a title taken from the above list (b) On slide 2 add bullets to the list of cars you are selling (c) Save and print a copy of all slides. TOTAL 10 MARKSPRACTICAL2 QUESTION 1: WORD PROCESING [30 MARKS] (i) Use a word-processing package to type the passage below, using font type Comic Sans, size 14 and double line spacing. [4] (ii) Save as ‘Coursework 1’ and print a copy [5] CCTV cameras Electronic security cameras have helped cut down violent crime and robberies in many of our city centres. Sometimes these cameras are visible and act as a deterrent, whereas others are hidden and are used during police surveillance. Although most people feel safer in city centres with the Use of these cameras, some people feel that they are an infringement of privacy. Cameras are also used for traffic control at busy junctions and on motorways. Information technology in the supermarket Most large stores now use barcode readers, which are commonly called laser scanners, to input product details into the computer system. The objectives of the scanning system are to improve the service to customers and to increase company productivity and profits. The picture below shows the scanning system used to scan in a barcode. The scanning system uses a laser beam to read the bar code on the goods. The bars contain the same information as the numeric code at the bottom of the barcode without the likely inaccuracies of typing the number in. As the barcode is passed across the scanner this number is read and the price and description of the goods are obtained from the computer, the sale registered and an itemized receipt produced (iii) Display the question number and your full name as aleft aligned header. [2] {iv) Insert a diagonal watermark “NFC COURSEWORK 2021” fey] (v) Insert any relevant picture at the bottom right of the document. fed} (vi) Divide the second paragraph into two columns with line between. Ql (vii) Use any word art style to insert a centered heading “Computer Applications” to the document, (21 (viii) Put an art page border to the whole document, fet) (ix) Save as Coursework 2 and print ac) Create the table below as it is, (10) Gea eeeet ee re coreceee eee ‘SHAPES, ] ee ooo | Square | Horizontal scroll a This way > iQUESTION 2: SPREADSHEET [25 MARKS] a. i) Type the name of the spreadsheet package you are using to answer this question. (1] li) Create a spreadsheetbelow, as itis and save it as Results. [2] iil) Put borders to the spreadsheet but do not include the two headings in rows 1 and 3 f iv) Merge and centre the headings. (2) v) Put Grey shading in rows one and three (a) eae) Microsoft Excel re come (A | (eH ener ne Bo, (mm A+ mB MAAR) newe cote |= Wak Sp resucrs 7 A ® c Dials ‘ eal ou 1 4 1. |ABC ACADEMY ACADEMY (PVT) LTD zZ ausiness . 7 |rarat 6s 8s 8 JANE « 4 6890 9 sue 8 eo 3 8 2 cc 2 15 b. i) Create a columnnamed ‘TOTAL’ in cell FS ta ii) In cells A11 to A14 type the following headings: CANDIDATURE, AVERAGE, HIGHEST and LOWEST (4) ©. Use formula to calculate the i) Total number of candidates for SHORTHAND fet} ii) Average mark for each subject ta iii) Highest mark per subject 1]iv) Lowest mark per subject ret) d. i) Sort the data in ascending order of name t] ii) Format all the average marks to 1 decimal place a) ill) Insert a header ‘YOUR NAME AND CLASS’ then print ty €. I} Create a column graph to show all the students’ marks per subject (2 ii) Add a chart title ‘SECRETARIAL STUDIES RESULTS’ 1) ill) Label the vertical and horizontal axis appropriately 2 iv) Show data labels on inside end a QUESTION 3: DATABASE [25 MARKS] a) Create a database calledCAR STOCK LISTand in tableCARSenter the following data: Verify the data by proofreading and then save and print a copy. (4 MAKE MODEL | PRICE [YEAR _| TYPE MILEAGE Honda Legend | $17,000 _| 2009 Saloon 23,000 Ford Focus $9,800 | 2007 Estate 30,000 Chrysler__| Sebring | $5,600 _| 2006 Saloon 25,000 | ‘Audi Aa $2,300 | 2009 Sports 65,000 Volvo 70 $14,000 _| 2010 Saloon 15,000 Peugeot | 307 $3,900 | 2004 Saloon 27,000 | Ford Focus $12,000 [2009 _| Estate 13,000 Ford Mondeo _| $10,000 _| 2008 Saloon 45,000 Porsche | 911 $45,000 [2009 _| Sports [30,500 Bmw. 325 $29,000 _| 2009 Sports 23,000 Vauxhall__| Corsa $6,000 | 2010 Saloon 35,000 Fiat 500 $5,000 [2010 _| Saloon 11,000 Volkswagen | Golf $8,000 | 2009 Saloon 15,000 | Ford focus $11,950 _| 2010 Estate 12,000__| BMW x5 $32,650 | 2010 Estate 8,000 _| Bmw x5 $34,500 | 2009 SUV [3,000 | SUZUKI__| Swift $7,999 | 2010 Saloon | 13,000__| NISSAN Micra $3,600 __| 2007 Saloon [45,000 | Ford Max $14,000 [2009 | MPV 24,000 | Citroen | Picasso __| $15,750 _| 2008 MPV 30,000 Toyota Yaris $10,000 _[ 2009 Saloon | 38,000 b) Reload the database and make the following amendments and printi) The Nissan Micra for $3,600 is actually a Nissan Note (1) ii) The Citroen Picasso needs its price reducing to $14,995 a ©) The following cars have come in, so they should be added to the database: [2] [ Nissan Micra [$25,500 2003 | Saloon [72,000 [Ford Mondeo _| $3,560 2003 Saloon [55,000 ‘Save the database d)_ The following cars have been sold so their details need deleting from the database: Chrysler__| Sebring $5,600 2003 [Saloon Opel Corsa $6,000 2003 [Saloon After deleting these records, save the database. e) Sort the CARS file i) Alphabetically according to make, with the As at the top of the file. (2) il) Numerically according to price, with the most expensive car at the top [2] Produce a printout for each one, f) Search for i) Details of all cars costing more than $5,000 fea} il) Details of all Ford cars costing less than $13,000 a) ili) Details of all cars costing between $5,000 and $8,000 aR iv) Details of all sports cars 2 g) Print a tabular report of all cars in the database grouped by Type fe} QUESTION 4: DESKTOP PUBLISHING [10 MARKS] a. Create an advertisement using THE WORKS classic design template RI b. i) Use copperplate gothic font scheme for the advertisement heading. You can use various fonts of your choice for other parts of the advertisement. 2] ii) Use the rectangle page size option. al iii) Customize the template text to suite the title of your advertisement [5] QUESTION 5: POWERPOINT [10 MARKS} @. Your school head has asked you to create a presentation for the whole school about the 2020 results. Your presentation should have following slides i) Title slide ‘YOUR SCHOOL NAME 2020 ‘0’ results’ fet) ii) Slide 2: The following table13) (O’ LEVEL RESULTS SUBJECT [mai ENGLISH a 56 / MATHS 75 INTEGRATED SCIENCE 80 GEOGRAPHY 95 ANY INDIGENOUS LANGUAGE _| 84 HISTORY [88 iil) Slide 3: The following Column graph 3) Male FEMALE iv) Slide 4: Your photograph as the overall best candidate. Put a label at the bottom of the photo OVERALL BEST 2020 . Write your name in a text box inserted at the top right corner of your photograph. 2] b. Print all the slides on one page (a)* Practical Test TERM 2 QUESTION 1 Qta) Type the passage below as it is and save it as comp1 and print (4) Computer graphics Computer graphics is the generation of images through computer. It includes simple text displays as well as images that appear to be in three dimensions. An important part of the computer graphics is computer visualization, which attempts to pictorially display data in a way that is most understandable for the user. For instance, visualization can allow surgeons to preview a surgical procedure before actually performing it. Other forms of visualization involve data that have no natural pictorial form. As a result, these must be displayed in a form that tells a story or makes a point. If you've seen a graph or chart with a computer program that seemed to have no clear meaning, you know why this area is important. Like many areas in computer science, computer visualization is as much human psychology as machine capability. The computer visualization expert asks, ‘How do we as human beings process visuals?” As computer graphics become more advanced, they terminate at a point called virtual reality, in which graphics and sensory feedback are all-encompassing. This can be seen, for example, a room in which every surface is covered with synchronized computer displays. It's important to note that virtual reality does not promise an experience understandable from the “real world’, although that may be a goal for ‘some researchers. Rather, it is an experience in which the outside world is temporally blocked from our senses. Retrieve comp! and do the following b) Centre the heading and underline it. 2] c) Insert a border covering the heading only ial d) Insert a drop cap on paragraph 2 and 4 dropped to 4 lines 2 e) Fully justify the document, save it as comp2 and print 2] f) Puta watermark with text on the heading of the document a) 9) Apply an art page border of your choice 3] h) Below the last paragraph put a word art (3) i) Insert a picture below the heading of a clip art relevant to the heading 1 i) Replace the occurrence of the word ‘computer graphics” with the word ‘PC art” excluding the heading. (3)k) Change the line spacing of the document to 1.5, format the whole document to italics. Save it as. comp3 and print. 4) QUESTION 2 Part of a spreadsheet below holds a table of product details. Selling price= Cost Price + Mark up (Mark up = 1.2%) a) Enter the details shown in a spreadsheet and print. 5) CHIMUT! COMPUTER ACCESSORIES. Product. Part Cost Mark | Selling Profit number _ Price up price Bar Code Reader 1000 BCR123 | 105 I CD ROM DRIVE 12 speed _|CD1286__| 210 Color Scanner 24/600 CS24600_| 450 Ink Jet Printer 100 1P100 120 | Keyboard 11 KB185 43 | LaserWriter 4040 Lw4040__| 675 | Total b) Use appropriate formulae to calculate the following - i) Mark-up for each product. 8] ii) Selling Price for each Product. Bl iii) Profit for each Product. B) iv) Totals for Cost Prices, Selling Price and Profit. 2) ©) Format all values except Mark-up to currency with 2 decimal places. BI 4d) Create a pie chart for the columns product and profit 6] QUESTION 3 Show manufacturing company wishes to keep records of its customers and type of shoes purchased. Design a database and a form with the following fields: Date of purchase, Type of shoes, Colour of shoes, Quantity bought and Customer name. Save and print the database 5) (a) Print a tabular form sorted by type of shoes in descending order for the database 6) 12 June 1999 Tommy Brown 300 ™ 13 July 1999 Tommy Black | 250 OK 01 May 1999 Moccasin Black [200 Express 22 April 1999 Moccasin Brown | 300 Edgars 17 August 1999 Tommy Brown 250 Express 21 October 1999 Weinbrener Black 275 ™ 17 September 1999 Weinbrener Tan 400 OK 04 September 1999 Weinbrener Brown 500 Express. 03 August 1999 Marie Clair Black 450 Edgars 14 October 1999 Marie Clair White 425 Edgars 13 June 1999 Marie Clair Brown 430 OK 10 July 1999 Tommy Black 290 ExpressALL REPORTS SHOULD BE ON LANSCAPE (b) Giving appropriate tiles, print: i) A report of all brown shoes from Express Stores (5) ii) Alist of all Moccasin shoes 6) iii) A report of all Edgars orders made after July 1999 ) QUESTION 4 Your school is having an inter house competition. You have been tasked to create a brochure to be distributed to special invited guests as well as parents. The brochure should show the following and some items of your choice Include the following i) Message about the event ii) Relevant image iii) Programme of events iv) Record set before by sporting houses vy) Officials and duties/responsibilities (a) Correct publication style and template 1} (b) Appropriate image placement (3) (c) Correct order B] (d) Eye catching creativity [3] (e) Use of text or other formatting styles 3) QUESTION 5 (a) You are a mentor at a COMPUTER college. You are required to create a presentation entitled, “BUSINESS TODAY”. (3) (b) Create a second slide with a clip art in relation to business. (3) (c) Display the following information on a relevant slide 44] Manual System Automated system Slow on data retrieval fast Reauires a lot of labour requires less labour Prone to errors high level of accuracy (d) Insert a centre aligned footer of your name (2) (e) Print all slides on one page in portrait 3]THEORY TEST TERM 2 4.(a) Explain the following terms as they are used in computers giving examples. i data 2] ii. Information 2] ii, Storage (2) iv. Input device 2) v. output device (2) b. Distinguish between the following i. RAM and ROM a} ii Primary storage and secondary storage a) 2. Put the following devices in their correct groups as Input, Output or Storage devices ‘Scanner, light pen, magnetic tape, daisy wheel, paper tape, barcode reader, actuator(6] 3. Define the following terms i. Internet tt) ii. E-commerce (t] li €-banking {] iv.e-mail tt] 4. State any three advantages of using E-mail 3] 4, Explain the following file organization methods i, Serial file 2) ii, Sequential file ay i, Direct) Random file 2 5. Classify the following printers as either impact or non impact printers Thermal printer, dot matrix printer, inkjet printer, daisy wheel printer, drum printer, laser jet printer 66. State the difference between physical security and software security ii, What is computer virus il List any three ways how viruses can be avoided 7. Write the following in full i OCR ii, MICR iil, OMR 8. Name the packages that you use for the following applications i. Word processor ii, Spreadsheet Total 50 marks (2) (1) {3] ft] t] (t] 1] ft]