Description
In this lesson, students will be guided through learning how to format a data table on Microsoft Excel using a Mac while following a guided, step-by-step procedure using a provided dataset. See below for more details:
WHO is this resource for? This lesson is intended for high-school students.
WHAT is included in this resource?
- ✅ 30-min lesson including...
- Step-by-step directions
- Rubric
- Answer key
- Teacher tips
- ✅ 5 pages
WHEN would be ideal to use this resource? This lesson plan is intended to be used any time during the year, though it would be best after a short lab in which students collect data. They can then use this lesson to help enter that data into Excel and create a data table.
Where: This lesson plan works in a classroom or homeschool setting.
Why: Use this lesson to introduce students to using Excel on a Mac to create a data table—essential skills that will support their success in future science classes and college-level coursework. This lesson is also...
- ✅ EASILY GRADED – A simple 5-point rubric is provided at the end for easy assessment.
- ✅ EASY TO FOLLOW – Includes clear student notes and teacher tips for customization.
- ✅ EDITABLE – The lesson is in Google Doc format, allowing easy customization for your class.
- ✅ LOW PREP – Just have internet access, and you're set to go.
- ✅ STUDENT SKILL FOCUSED – This lesson emphasizes essential student skills such as learning how to graph using Google Sheets, which is a crucial skill in many college-level science classes.
- ✅ STUDENT FACING – With embedded instructions, students can independently navigate the lesson.
BUT WAIT! THERE'S MORE!
If you'd like to see other similar resources, click on the links below:
- How to Format a Data Table in Excel
- How To Calculate Averages and Standard Deviation in Excel
- How To Create a Bar Chart with Standard Deviation Bars in Excel
CONNECT
Feedback | Shop | Subscribe | Website
SUPPORT
Questions? Comments? Concerns? Send them my way! I'm always happy to help any way I can - please email me: annemarie@instructivatescience.com
TERMS OF USE AND LICENSING
Each purchase grants one license for use by one teacher or classroom (more detailed terms of use are located at the very end of the resource itself). If you know of another teacher that would also like to use this product, please purchase additional licenses at a discounted rate of 50% off. To do this…
- Click “Add to Cart,”
- Select “Buy Licenses to Share”
- Enter the number of discounted licenses you need.
UPDATES
I’m always updating my products to keep them fresh and effective! To ensure you have the latest version, there is no need to repurchase - just follow these steps:
- Go to the TpT homepage and click "MY TpT" (top right).
- Select "MY PURCHASES."
- Find the product—if you see “NEWLY REVISED RE-DOWNLOAD,” that means there’s an updated version ready for you. Just click the link and you’re golden
© 2025 Instructivate Science LLC
[Updated 5/21/26]
Highlights
Save even more with bundles
Description
In this lesson, students will be guided through learning how to format a data table on Microsoft Excel using a Mac while following a guided, step-by-step procedure using a provided dataset. See below for more details:
WHO is this resource for? This lesson is intended for high-school students.
WHAT is included in this resource?
- ✅ 30-min lesson including...
- Step-by-step directions
- Rubric
- Answer key
- Teacher tips
- ✅ 5 pages
WHEN would be ideal to use this resource? This lesson plan is intended to be used any time during the year, though it would be best after a short lab in which students collect data. They can then use this lesson to help enter that data into Excel and create a data table.
Where: This lesson plan works in a classroom or homeschool setting.
Why: Use this lesson to introduce students to using Excel on a Mac to create a data table—essential skills that will support their success in future science classes and college-level coursework. This lesson is also...
- ✅ EASILY GRADED – A simple 5-point rubric is provided at the end for easy assessment.
- ✅ EASY TO FOLLOW – Includes clear student notes and teacher tips for customization.
- ✅ EDITABLE – The lesson is in Google Doc format, allowing easy customization for your class.
- ✅ LOW PREP – Just have internet access, and you're set to go.
- ✅ STUDENT SKILL FOCUSED – This lesson emphasizes essential student skills such as learning how to graph using Google Sheets, which is a crucial skill in many college-level science classes.
- ✅ STUDENT FACING – With embedded instructions, students can independently navigate the lesson.
BUT WAIT! THERE'S MORE!
If you'd like to see other similar resources, click on the links below:
- How to Format a Data Table in Excel
- How To Calculate Averages and Standard Deviation in Excel
- How To Create a Bar Chart with Standard Deviation Bars in Excel
CONNECT
Feedback | Shop | Subscribe | Website
SUPPORT
Questions? Comments? Concerns? Send them my way! I'm always happy to help any way I can - please email me: annemarie@instructivatescience.com
TERMS OF USE AND LICENSING
Each purchase grants one license for use by one teacher or classroom (more detailed terms of use are located at the very end of the resource itself). If you know of another teacher that would also like to use this product, please purchase additional licenses at a discounted rate of 50% off. To do this…
- Click “Add to Cart,”
- Select “Buy Licenses to Share”
- Enter the number of discounted licenses you need.
UPDATES
I’m always updating my products to keep them fresh and effective! To ensure you have the latest version, there is no need to repurchase - just follow these steps:
- Go to the TpT homepage and click "MY TpT" (top right).
- Select "MY PURCHASES."
- Find the product—if you see “NEWLY REVISED RE-DOWNLOAD,” that means there’s an updated version ready for you. Just click the link and you’re golden
© 2025 Instructivate Science LLC
[Updated 5/21/26]
