No 32

Based on Figure 10 : (Refer to the question booklet)
a)  State the type application software in (ii) and describe its usage 

Answer:

Type of application software is Spreadsheet (Lembaran kerja)
Usage:  (choose one answer)

• Can make a query in spreadsheet software to retrieve data
• Can produce worksheets that require repetitive calculation, budgeting, maintaining a grade book, balancing account, tracking investment, calculating loan payments, estimating project cost, and preparing financial statements
• Containing formulas which can perform calculation on the data in the worksheet
• Making charts, which depicts the data graphically such as column chart or pie charts.

b)  Hanim needs to email a presentation file to her lecturer.  The file includes many pictures and videos and its cause the transmission process takes a long time and slow.
(i)  Suggest a type of utility software that can be used to overcome the problem above.
(ii)  Justify your answer and give one example of the software.
Answer:
(i)  File compression (pemampatan fail)
(ii)  This software is a system software that we use to shrink the size of files, so they require less storage space and reduce transmission time if we send them over internet.
Example is Winzip / WinRar / PKZip (choose one example)