Computer
Applications I
Competency 4
SPREADSHEETS
4.00 Understand spreadsheets, charts, and graphs used in business.
4.01 Understand spreadsheets used in business.
4.02 Understand charts and graphs used in business.
Unit Outline
Unit
F Vocabulary
Class Notes
PowerPoint Presentations
Activities
Demonstrate basic spreadsheet concepts and functions.
- Design, Create, Edit, and Save Spreadsheets
- Create, Enter Labels and Values, Make Simple Corrections, and Save Spreadsheets
- Enter Labels and Values, Format the Worksheet, Enter Simple Calculations, Save, and Print
Explain advanced spreadsheet concepts and functions.
Demonstrate advanced spreadsheet concepts and functions.
- Use Formulas; Format and Enhance Data
- Excel Spreadsheet for Activity F603-01.xls
- Use Formulas; Format and Enhance Data; Copy Formulas; Align Data
- Excel Spreadsheet for Activity F603-02.xls
- Use Functions; Absolute Reference; Conditional Formatting; Sort
- Use What-If Analysis
- Excel Spreadsheet for Activity F603-04.xls
- Excel Spreadsheet for Activity F603-05.xls
- Object Linking and Embedding
Design and create charts and graphs.
- Charting Vocabulary Crossword Puzzle
- Create Column and Pie Charts
- Create a Spreadsheet and Chart
- Spreadsheet for Activity F604-05.xls
- Create Charts and Graphs From a Spreadsheet
- Spreadsheet for Activity F604-06.xls
- PivotTable and PivotChart
Resources
Resources
Reveiw
Practice
Tests
Review Games
Rags to Riches - 6.05 Charting Vocabulary
Matching and Flash cards - 6.05 Charting Vocabulary
Battleship - 6.00 Spreadsheet Vocabulary
Columns - 6.00 Spreadsheet Vocabulary
Rags to Riches -- Spreadsheet Review
Rags to Riches - CTE Spreadsheet
Matching, Flashcards, Concentration - Excel Terms
| Back to Computer App. I |