Explain three uses of spreadsheets in business, three advantages of using email in communication, and four positive impacts of ICT in society.

Here are the solutions to the assignment questions:

a) Explain three uses of spreadsheets in business.

1. Financial Management: Businesses use spreadsheets for budgeting, tracking expenses, and creating financial statements like profit and loss reports.
2. Data Analysis: Spreadsheets allow businesses to organize, sort, filter, and analyze large datasets to identify trends, patterns, and make informed decisions.
3. Inventory Management: They are used to track stock levels, manage orders, monitor sales, and calculate reorder points for products.

b) State three advantages of using email in communication.

1. Speed and Efficiency: Emails are delivered almost instantly, allowing for rapid communication across geographical distances.
2. Cost-Effectiveness: Sending emails is generally free or very low cost, making it an economical communication method.
3. Record Keeping: Emails provide a written record of communication, including timestamps, which can be useful for reference and accountability.

c) Outline four positive impacts of ICT in society.

1. Improved Communication: ICT enables instant global communication through various platforms, connecting people and facilitating information exchange.
2. Enhanced Education: It provides access to vast online learning resources, virtual classrooms, and tools that support remote learning and research.
3. Economic Growth: ICT drives innovation, creates new industries and job opportunities, and improves productivity across various sectors.
4. Healthcare Advancements: It facilitates telemedicine, electronic health records, and advanced diagnostic tools, improving healthcare delivery and access.

d) State four career opportunities in ICT.

1. Software Developer
2. Network Administrator
3. Cybersecurity Analyst
4. IT Support Specialist

e) State how data is represented in:

i) CD-ROM
Data on a CD-ROM is represented by microscopic pits and lands on its reflective surface. A laser reads these physical variations, where pits scatter light and lands reflect it, translating them into binary 0s and 1s.

ii) Magnetic Media
Data on magnetic media (e.g., hard drives, floppy disks) is represented by the polarization of tiny magnetic particles on the surface. Each particle can be magnetized in one of two directions, corresponding to binary 0s and 1s.