Lesson Planet
Search educational resources
  • Sign In Try It Free
  • AI Teacher Tools
    • Discover Resources Search reviewed educational resources by keyword, subject, grade, type, and more
    • Curriculum Manager (My Content) Manage saved and uploaded resources and folders To Access the Curriculum Manager Sign In or Join Now
    • Browse Resource Directory Browse educational resources by subject and topic
    • Curriculum Calendar Explore curriculum resources by date
    • Lesson Planning Articles Timely and inspiring teaching ideas that you can apply in your classroom
    • Our Story
    • Frequently Asked Questions
    • Testimonials
    • Contact Us
  • Pricing
  • School Access
    • Your school or district can sign up for Lesson Planet — with no cost to teachers
      Learn More
  • Sign In
  • Try It Free
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation ActivitySpreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation Activity
Publisher
Howard Hughes Medical Institute
Resource Details
Curator Rating
Educator Rating
Not yet Rated
Grade
9th - 12th
Subjects
Math
6 more...
Resource Type
Activities & Projects
Audiences
For Teacher Use
1 more...
Duration
45 mins
Instructional Strategies
Direct Instruction
1 more...
Technology
Database & Spreadsheet
Usage Permissions
Fine Print: Educational Use
Activity

Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation

Curated and Reviewed by Lesson Planet
This Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation activity also includes:
  • Autofill Data, Cell References, and Standard Deviation Worksheet (.xlsx)
  • Autofill Data, Cell References, and Standard Deviation Worksheet (Google Sheets)
  • Join to access all included materials

If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range, standard deviation, and variance using the spreadsheet's built-in formulas.

16 Views 13 Downloads

Concepts

data, data analysis, standard deviation, range, technology resources

Instructional Ideas

  •  Assign the exercise sheet as homework

Classroom Considerations

  • Pupils should have some familiarity with spreadsheets (this is the second of five tutorials in the Spreadsheet Data Analysis unit)
  • Learners must have knowledge of range, standard deviation, and variance

Pros

  • Instructions are clear and easy to execute
  • Includes an exercise for scholars to complete on their own

Cons

  • None

View 41,189 other resources for 9th - 12th Grade Math

© 1999-2026 Learning Explorer, Inc.
Teacher Lesson Plans, Worksheets and Resources

Sign up for the Lesson Planet Monthly Newsletter

Open Educational Resources (OER)

  • Health
  • Language Arts
  • Languages
  • Math
  • Physical Education
  • Science
  • Social Studies
  • Special Education
  • Visual and Performing Arts
View All Lesson Plans

Discover Resources

  • Our Review Process
  • How it Works
  • How to Search
  • Create a Collection

Manage Curriculum

  • Edit a Collection
  • Assign to Students
  • Manage My Content
Contact Us Site Map Privacy Policy Terms of Use