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)

Gmetrix.net

GCFLearnFree.org

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


Return to top