Specific Objectives:
- Define a spreadsheet.
- Describe the components of a spreadsheet.
- State the application areas of a spreadsheet.
- Create and edit a worksheet.
- Explain different cell data types.
- Apply cell referencing.
- Apply functions and formulas.
- Apply data management skills.
- Apply charting and graphing skills.
- Print a worksheet and graph.
Content Covered:
- Definition of a Spreadsheet.
- Components of a spreadsheet: worksheet, database, and graphs.
- Application areas of a spreadsheet: statistical analysis, accounting, data management, forecasting (what if analysis), and scientific application.
- Creating a worksheet/workbook: getting started, worksheet layout, running the program, creating a worksheet, editing a cell entity, saving, retrieving, closing a worksheet, and exiting from the spreadsheet.
- Worksheet formatting: text, numbers, rows and columns, and global formatting.
- Data Management: sorting, filtering, total/subtotals function, and forms.
- Charts/graphs: types, data ranges, labels, headings and titles, and legends.
- Printing: print preview, page setup, print options, and printing.
- Cell Data types: labels, values, formulae, and functions.
- Cell referencing: cell addressing, absolute referencing, and relative referencing.
- Basic functions and formulas: statistical functions (average, count, max, min), logical functions (if, count-if, sum-if), mathematical functions (sum, product, div), and arithmetic formulas.
This course outline covers a comprehensive range of topics related to spreadsheets, including the definition and components of a spreadsheet, application areas, creating and editing worksheets, data management, charting and graphing, printing, different cell data types, cell referencing, and basic functions and formulas. By the end of this course, learners will have a solid understanding of spreadsheet concepts and be able to apply them effectively in various scenarios.
