Unit 4 Spreadsheet Basics

UNIT OBJECTIVES:

1. Identify the components and common uses of a spreadsheet program.
2. Perform spreadsheet tasks.
3. Identify and demonstrate use of formatting icons and dialog boxes in a spreadsheet program.
4. Differentiate between and develop formulas and functions in a spreadsheet.
5. Edit and format text in worksheets.
6. Generate tables and charts from spreadsheet data.
7. Work with language tools i.e. spellcheck.
8. Analyze data using spreadsheet technologies.
9. Compare the user interface and formatting options offered online and offline to spreadsheet users on various platforms (desktop/laptop computer, tablet, cell phone).
10. Create and edit with a shared spreadsheet using Google Docs or a similar tool.

RESOURCES:

• Google Docs
• Open Office
• GCF Learning Tutorials
• Explanation of Excel Cursors
• Exercise 1, Basic: Entering Information
• Exercise 1: Entering Information
• Exercise 2, Basic: Making Lists
• Exercise 2: Making Lists
• Exercise 3, basic: Budgets
• Exercise 4: Adding Totals
• Exercise 5: Making Charts
• Exercise 6: Budgets
• Execise 7: Making Charts