How to Approach UNEB UACE SUB ICT Practical ITEM 2 SAMPLE PAPER 2026| Using xlsx, and accdb.

Access support files here: https://drive.google.com/drive/folder... ITEM 2: ICT UNEB SAMPLE ITEM 2 2026 A - LEVEL Katama market is the largest market in Rwango Town Council. Traders from neighbouring villages bring produce such as tomatoes, beans, cassava, onions, maize and vegetables to sell in the market. The market is supervised by a market manager whose responsibility is to monitor the traders’ activities, collect daily market dues and ensure proper record keeping of the goods sold in the market. The market management uses counter books and calculators to record and compute daily returns: • Total quantity of produce sold per item • Total revenue earned per trader • Daily tax per trader (2% of daily revenue) The tax collected from the traders is submitted to the town clerk daily. To ease tax collection, the management wishes to design receipt books for different categories of traders depending on total revenue. These receipt books will also be managed by different tax collectors who will be given the names of traders for respective categories: • Blue receipt book for traders whose revenue is 600,000 and above. • Green receipt book for traders whose revenue is between 400,000 and 600,000. • Red receipt book for traders whose revenue is 400,000 and below. An organisation that supports women entrepreneurs has approached the market management requesting statistics about female traders and their daily revenues. The market management has a model of rewarding the best performing trader of the day based on daily revenue statistics. Due to increase in the number of traders, it has become difficult for the market management to quickly and accurately calculate the daily returns from the market. This has raised concerns from the town clerk’s office and they therefore need assistance. Task: Organize the data provided in the support file market vendors.docx and provide information needed to guide the market management in decision making.