**Question 1(e) (i): Complete the Microsoft Excel worksheet** Kofi's expenditure: * **Monday:** 4 exercise books for Ghc 60.00 * **Tuesday:** 6 pens for Ghc 40.00 We need to fill in the table: | Days | Items | Quantity | Amount Gh¢ | | :------ | :------------- | :------- | :--------- | | Monday | Exercise books | 4 | 60.00 | | Tuesday | Pens | 6 | 40.00 | | Total | | | | To complete the "Total" row for "Amount Gh¢", we sum the amounts from Monday and Tuesday. Total Amount = Ghc 60.00 (Monday) + Ghc 40.00 (Tuesday) = Ghc 100.00 So the completed table is: | Days | Items | Quantity | Amount Gh¢ | | :------ | :------------- | :------- | :--------- | | Monday | Exercise books | 4 | 60.00 | | Tuesday | Pens | 6 | 40.00 | | Total | | | 100.00 | **Question 4 (e) (ii): Write a formula in Microsoft Excel to compute Kofi's total amount spent for the two days at the stationery shop.** Based on the table structure (Figure 1), let's assume: * Amount Gh¢ for Monday is in cell D2. * Amount Gh¢ for Tuesday is in cell D3. * The total amount will be in cell D4. To sum the values in D2 and D3, the Excel formula would be: `=SUM(D2:D3)` or `=D2+D3` **Question 2 (a): Explain the concept of perceptual computing to colleagues in the computing club.** Perceptual computing refers to a type of human-computer interaction that aims to make computers understand and respond to human senses and natural behaviors, similar to how humans perceive and interact with the world. It involves technologies that allow computers to "perceive" and interpret information from the real world through various inputs, such as: * **Vision:** Recognizing faces, gestures, objects, and scenes using cameras. * **Speech:** Understanding spoken language, commands, and emotions through microphones. * **Touch/Haptics:** Sensing physical contact, pressure, and providing tactile feedback. * **Biometrics:** Identifying individuals based on unique biological characteristics (e.g., fingerprints, iris scans). * **Contextual awareness:** Understanding the user's environment, activities, and intentions. The goal is to create a more intuitive, natural, and immersive user experience, moving beyond traditional keyboard and mouse inputs. For example, instead of typing a command, you might speak it, or instead of clicking a button, you might use a hand gesture. **Question 2 (b): Most companies use data entry devices that capture machine-readable data directly into the computer system without using the keyboard. List three of such data entry devices.** These devices are often called direct data entry devices or source data automation devices. They reduce errors and speed up data input. Three examples of such devices are: (i) **Barcode Reader/Scanner:** Used to read barcodes (e.g., on products in a supermarket) and input product information and prices directly into a system. (ii) **Magnetic Ink Character Recognition (MICR) Reader:** Used primarily by banks to read special magnetic ink characters on checks (e.g., account numbers, bank codes). (iii) **Optical Mark Recognition (OMR) Reader:** Used to detect marks on paper, often for processing multiple-choice tests, surveys, or lottery tickets. (iv) **Optical Character Recognition (OCR) Reader:** Converts scanned images of text into machine-readable text data. (v) **Point of Sale (POS) Terminal:** Often includes a barcode scanner, card reader, and touch screen, allowing direct input of sales data. (vi) **Smart Card Reader:** Reads data stored on smart cards (e.g., credit cards, ID cards). (vii) **Biometric Devices:** Such as fingerprint scanners, iris scanners, or facial recognition systems, used for identification and authentication.