Information Technology I Manage Data, Cells, and Ranges
Lesson Topic:
Manage Data, Cells, and Ranges
Lesson Description:
Students will create visual representations of data which includes sparklines and conditional formatting.
Learning Goals/Outcomes:
- AutoFill
- Merge
- Modify Cell Alignment
- Wrap Text
- Apply Number Formats
- Apply Cell Formats
- Apply Cell Styles
- Insert Sparklines
- Outline Data
- Create Subtotals
- Apply Conditional Formatting
Nebraska Standards:
CIS.HS.4a.4 Organize and manipulate data using spreadsheet applications
Create visual representations of data (e.g., charts, pivot tables, sparklines, and conditional formatting)
Teacher Planning:
Equipment/Materials/Software Needed:
Computers/GCFLearnFree or LearnKey or curriculum of your choosing/Project Instructions/Microsoft Excel
Time Required for Lesson:
Teach/Train/Practice the skills/concepts(60 Minutes)
Complete the project(60 Minutes)
Assess/Retrain/Reassess(30 Minutes)
Diagram/Setup:
NA
Technology Use:
Software:
Microsoft Office
Hardware:
Computers
Instructional Plan:
Anticipatory Set/Pre-Activity:
NA
Benefits/Explanation/Real-World Connection:
Excel can be used for stats, grades, budgets, track sales, company information, etc. You can extract information quickly and easily by manipulating the data.
Activities (i.e. instructions, warm-up, lesson, cool-down):
Bell Ringer
Teach/Train/Practice the skills/concepts(60 Minutes)
Complete the project(60 Minutes)
Closure:
Assess/Retrain/Reassess(30 Minutes)
Assessment :
I test using GMetrix. However, the project itself could be used as an assessment.
Supplemental Information:
Modifications:
NA
Safety Precautions:
NA
Comments (adaptations for various grades/ages, teaching styles, etc.)
NA
Resources:
Microsoft Office Excel
GCFLearnFree
GMetrix
LearnKey