Spreadsheet II

Computer Science J.S.S 3 Second Term

Sub-theme: Basic knowledge of Information Technology

Week 7

Spreadsheet II

Performance Objective

Student should be able to:

1. State the uses of spreadsheet packages

 

Content

 

COMMON USES FOR SPREADSHEETS?

The three most common general uses for spreadsheet software are to create budgets, produce graphs and charts, and for storing and sorting data. Within business spreadsheet software is used to forecast
future performance, calculate tax, completing basic payroll, producing

charts and calculating revenues.

The list of uses for spreadsheet software is endless. However, here is a shortlist of uses:

1. Modelling and Planning
2.  Household Finance Planning
3. Business Accounts and Budgeting
4. Invoices
5. Wages
6. Predictions / Simulations
7. Calculations e.g. Adding, Subtracting, etc.
8. Break-even analysis
9.  Statistical analysis

10.…