Chapter Demonstrable Skills
After completing the Excel Supplemental Content portion of the Excel & Data Analysis unit, students will be able to:
| Demonstrable Skill |
Learning Activities
& Informal Assessments |
Formal Assessments
(excluding Exams) |
|
Download data from websites.
|
- Access: Access Basics Participation Project
- Access: Database Creation Participation Project
- Access: Database Design Participation Project
- Access: Fields & Keys Participation Project
- Access: Forms Participation Project
- Access: Queries I Participation Project
- Access: Queries II Participation Project
- Access: Queries III Participation Project
- Access: Queries IV Participation Project
- Access: Reports Participation Project
- Access: SQL Participation Project
- Excel: Charts Participation Project
- Excel: Excel Basics Participation Project
- Excel: Formatting Participation Project
- Excel: Formulas & Functions I Participation Project
- Excel: Formulas & Functions II Participation Project
- Excel: Formulas & Functions III Participation Project
- Excel: PivotTables Participation Project
- Excel: Solver Participation Project
- Excel: Tables Participation Project
- Excel: What-If Analysis Participation Project
- PowerPoint: Layout & Formatting Participation Project
- PowerPoint: Presentation Techniques Participation Project
- Word: Layout & Pagination Participation Project
- Word: References & Workflow Participation Project
- Word: Styles & Illustrations Participation Project
|
- Homework #1
- Homework #2
- Homework #3
- Homework #5
- Old Homework #2
- MyLab Extra Credit Project #1
- MyLab Extra Credit Project #2
- MyLab Extra Credit Project #3
|
|
Extract data from ZIP archive files.
|
- Access: Access Basics Participation Project
- Access: Database Creation Participation Project
- Access: Database Design Participation Project
- Access: Fields & Keys Participation Project
- Access: Forms Participation Project
- Access: Queries I Participation Project
- Access: Queries II Participation Project
- Access: Queries III Participation Project
- Access: Queries IV Participation Project
- Access: Reports Participation Project
- Access: SQL Participation Project
- Excel: Charts Participation Project
- Excel: Excel Basics Participation Project
- Excel: Formatting Participation Project
- Excel: Formulas & Functions I Participation Project
- Excel: Formulas & Functions II Participation Project
- Excel: Formulas & Functions III Participation Project
- Excel: PivotTables Participation Project
- Excel: Solver Participation Project
- Excel: Tables Participation Project
- Excel: What-If Analysis Participation Project
- PowerPoint: Layout & Formatting Participation Project
- PowerPoint: Presentation Techniques Participation Project
- Word: Layout & Pagination Participation Project
- Word: References & Workflow Participation Project
- Word: Styles & Illustrations Participation Project
|
- Homework #1
- Homework #2
- Homework #3
- Homework #5
- Old Homework #2
|
|
Apply and analyze chart trendlines to project future values.
|
- Excel: Charts Participation Project
|
- Old Homework #2
- MyLab Extra Credit Project #1
|
|
Group PivotTable data.
|
- Excel: PivotTables Participation Project
|
|
|
Use spreadsheet data to solve analysis questions.
|
- Excel: Charts Participation Project
- Excel: Formatting Participation Project
- Excel: Formulas & Functions I Participation Project
- Excel: Formulas & Functions II Participation Project
- Excel: Formulas & Functions III Participation Project
- Excel: PivotTables Participation Project
- Excel: Solver Participation Project
- Excel: Tables Participation Project
- Excel: What-If Analysis Participation Project
|
- Homework #1
- Homework #2
- Homework #5
- Old Homework #2
|
