Exploring Google Sheets

Curriculum Area

Subject: Technology
Grade Level: 6th Grade
Alignment: This lesson aligns with the ISTE Standards for Students (International Society for Technology in Education), particularly focusing on "Empowered Learner" to use technology for learning and "Knowledge Constructor" for building knowledge using digital tools.

Lesson Goals

Objective: Introduce students to Google Sheets, focusing on basic skills to enter, organize, and format data in a spreadsheet.

Materials

• Computers or tablets with internet access
• Google accounts for each student
• Projector or interactive whiteboard for demonstration

Lesson Structure

Introduction (5 Minutes)

1. Access Prior Knowledge
   • Begin with a class discussion: “What types of software have you used before?”
   • Question Prompt: "If you wanted to track your grades, a list for a project, or a schedule for a sports event, what tool might you use to stay organized?"
   • Encourage students to think about different tools and their uses.

Typing Club (10 Minutes)

• Activity: Students log into Typing Club to practice typing skills. Focus on correct posture and accuracy to improve efficiency.
• Purpose: Strengthen typing skills needed for efficient data entry in Google Sheets.

New Information (10 Minutes)

1. Introduction to Google Sheets

   • Demonstration: Project Google Sheets interface onto the screen.
     • Highlight the toolbar, rows, columns, and cells.
     • Explain the function of each component.

2. Mini Activity:

   • Students open Google Sheets and explore navigating between cells using arrow keys and mouse.

3. Basic Operations

   • Demonstrate how to enter text and numbers into cells.
   • Show formatting options:
     • Bolding text
     • Adjusting font size
     • Changing cell color

Application (5 Minutes)

Activity: Creating a Simple Spreadsheet

• Instructions:
  1. Guide students to create a “Favorite Movies” or “Weekly Chores” spreadsheet.
  2. Step 1: Label columns in Row 1. Example: “Title” and “Genre” or “Day” and “Chore”.
  3. Step 2: Enter at least five entries. Suggestions: Movies with genres or chores for each day.

Formatting Practice

• Instructions: Format their spreadsheet headers to make them stand out.
  1. Step 1: Bold the headers in Row 1.
  2. Step 2: Change background color of Row 1 to a light shade.
  3. Step 3: Center-align text in each column.

Challenge (5 Minutes)

• Activity: Introduce a basic sorting exercise.
  • Demonstrate sorting the list alphabetically by “Title” or “Day.”
  • Discuss sorting options and how they help organize data.

Generalization (5 Minutes)

1. Reflection Activity: Engage in a discussion on potential everyday uses for Google Sheets.

   • Consider applications like managing expenses, study schedules, or planning projects.

2. Exit Ticket: Ask students to write one way Google Sheets can help them organize other areas such as tracking homework or creating a book list.

By integrating these interactive activities, students will gain foundational skills in using Google Sheets, fostering their ability to organize data effectively and enhancing their technological proficiency in a supportive educational environment.