Information Technology I Create and manage worksheets and workbooks
Lesson Topic:
Create, navigate, and format worksheets and workbooks
Learning Goals/Outcomes:
- Create a Blank Workbook
- Add Data to a Worksheet
- Copy a Worksheet
- Insert a Hyperlink
- Change Worksheet Tab Color
- Rename a Worksheet
- Change Workbook Themes
- Adjust Row Height and Column Width
- Insert Headers and Footers
- Hide Columns and Rows
Nebraska Standards:
CIS.HS.4a.4 Organize and manipulate data using spreadsheet applications.
CIS.HS.4a.4.a Enter, modify worksheet data, structure, format data, and problem solve in a worksheet.
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.
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