Applications of rates, percentages and use of spreadsheets
14 hours
-
Understand the meaning of rates and percentages.
-
Calculate weekly, fortnightly or monthly wages from an annual salary, and wages from an hourly rate, including situations involving overtime and other allowances and earnings based on commission or piecework.
-
Calculate income support payments based on government allowances and pensions.
-
Prepare a personal budget for a given income, taking into account fixed and discretionary spending.
-
Compare prices and values using the unit cost method.
-
Apply percentage increase or decrease in various contexts, e.g. inflation of costs and wages, percentage mark-ups and discounts, percentage profit and loss, GST, simple interest.
-
Use currency exchange rates to convert between the Australian dollar and foreign currencies.
-
Calculate the dividend paid on a portfolio of shares, given the dividend yield or dividend paid per share, and compare share values by calculating a price-to-earnings (P/E) ratio.
-
Use a spreadsheet to display examples of the above computations when multiple or repeated computations are required, e.g. preparing a wage sheet displaying the weekly earnings of workers in an organisation, preparing a budget, investigating the potential cost of owning and operating a car over a year.