135 results
High school problem solving statistics resources for Microsoft Excel
Statistics Correlation and Regression Project for Movie "Moneyball" (5 day)
Prerequisite: Correlation and Regression (Linear). This is a project that divides a statistics class into 6 groups and students do ACTUAL data collection from given websites and they perform their OWN ANALYSIS. They will use computers/internet/excel/spreadsheets/graphing calculators to evaluate correlation. If you have interest in baseball and statistics, this is a great project to get the class interested, and covers about 5 days, plus you can watch the movie "Moneyball" afterwards as a reward.
Subjects:
Grades:
10th - 12th, Higher Education, Adult Education
Types:
12 Days of Christmas: A Computer Spreadsheet Activity
This great holiday activity shows students how to use a computer spreadsheet to calculate the cost of their true love's gifts in today's dollars.The simple step-by-step procedure will allow both beginning and computer-savvy students to experience success as they learn how to use spreadsheet software. Students will enjoy the engaging and entertaining activity. No computer? No problem! Use the activity master so students can calculate the costs themselves.
Grades:
5th - 9th
Types:
Engineering Design Process - CROSSWORD PUZZLE #2 STEM -Problem Solving -20 Clues
This 20 Clue Crossword puzzle covers the basics of the EDP steps. The answers can be found on the EDP graphic right there on the page!! Word bank & KEY included. SAMPLE CLUES:1 The thing that is causing trouble 4 To determine what something is, to describe it 7 To call out ideas in a group of people 9 To make something, especially something new. 10 To check a thing out, to see if it works right 11 A list of steps you decide on so you can reach a goalThe complete Word Bank:brainstorm
Subjects:
Grades:
7th - 9th
Types:
Also included in: STEM / Engineering Design Process BUNDLE
Screen Time Calculator or Video Game Time Calculator Excel sheet
Discover the power of time management with our "Video Game Time Experiment Calculator"! This interactive Excel tool is perfect for educators and parents looking to provide a practical lesson on screen time awareness. With a user-friendly interface, the calculator allows users to input the age they began playing video games and track the hours spent gaming each day. By projecting these figures up to the age of 18, it offers an eye-opening forecast on the total time dedicated to gaming, emphasizin
Subjects:
Grades:
4th - 12th, Higher Education, Adult Education, Staff
Types:
IB MYP Design Units Full Bundle
Full MYP Units Bundle which can cover the entire MYP 1 - 5 Design, representing a significant saving over buying units individually.In these outstanding, creative units, students are tasked with designing and making solutions in line with specific client-led briefs. With practical, written, and theory work closely related to the new MYP Design Specification and four assessment criteria.These units/projects have been designed for a term (12-14 weeks) or half-term (6-8 weeks) though each can be ex
Subjects:
Grades:
8th - 11th
Excel Projects for Statistics Frequency Distributions and Charts
This file contains three different projects with solutions and a quick reference card for students. It correlates to Bluman's Elementary Statistics textbook.
First is an Introduction to Excel. There is an example, guided practice and then 4 Projects. The instructions are on each sheet. The topics covered are: basic editing and formatting, beginning charts, beginning formulas, such as SUM and AVERAGE, and calculations. There is an editable grading rubric for this project. The Preview file
Subjects:
Grades:
8th - 11th, Higher Education, Adult Education
Types:
PAYROLL TAXES
Lesson will show students how to calculate:
1. Overtime Pay Rate
2. Regular and Overtime Earnings
3. Gross Earnings
4. Social Security Tax
5. Medicare Tax
6. Federal Income Tax Withholding
7. Net Pay
Also Includes answer KEY for all eight problems.
PAYROLL TAXES by ANGELO OCHOA is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Grades:
8th - 12th
Statistics Unit 9 Bundle - Hypothesis Testing (one sample) (18 days)
This is a unit plan bundle for a Statistics class. The plans include common core math standards, time frame, activities, enduring understandings, essential questions, and resources used. It is designed to last 18 days, depending on pacing. The plans include: 56-slide presentation, with annotated guide for reference5 Worksheets1 "Read & Respond" Article Worksheet2 Quizzes"Do Now" Entrance problemsSpreadsheet Activity - Hypothesis TestingReview slides (for peer presentations)Unit ReviewUnit Te
Subjects:
Grades:
10th - 12th, Higher Education
Types:
CCSS:
Bundle - Help with Science Fair Table, Graphs, Statistics using Excel.
This comprehensive 3-part bundle comprises a video tutorial, an informative handout, and an Excel file meticulously guiding students through a step-by-step process. The aim is to empower students with the skills to transform raw data into concise summative data tables and graphs, complete with standard deviation error bars. The tutorial covers the entire spectrum – from utilizing Excel for table and graph preparation to conducting statistical analyses using Anova tests, t-tests, or correlation m
Subjects:
Grades:
9th - 12th
Types:
Teaching Statistics with Spreadsheets (Self Grading)
You can see a video that describes the basics of this course at the following link: https://www.youtube.com/watch?v=uZFpltXWyw8This package is an entire statistics course designed for content to be delivered, taught, practiced, and assessed through spreadsheets. Students learn basic statistics and spreadsheet skills. This course is intended to allow for student collaboration and group work throughout the learning process. Each spreadsheet is automatically graded so students can see their progres
Grades:
9th - 12th
Types:
Spreadsheets Microsoft Excel Full Course
This file contains both the pupil workbook and the electronic files to accompany the task.This is aimed at pupils aged 11-15 This resource is used successfully at schools across my learning cluster.The booklet is instructional and tasks are progressive to continuously improve pupil skills and knowledge. Each task has a simple introductory task with the aim that pupils progress onto more difficult "boss tasks"I have themed this into a Music Management and pupils work for a company which manage th
Grades:
8th - 10th
Types:
Also included in: Ultimate Computer Science BUNDLE
Planning a Mutual Fund: Personal Finance Lesson Plan
This is a pretty engaging, hands-on way for students to learn about how a mutual fund (or ETF) works. It takes at least one full day, and you can turn it into something that you revisit several times during the semester. It's intended to be a partner project, but students could work alone if you wish.Students will work in partners to create a “mutual fund”, by picking stocks for their fund that share a common focus. Students pick stocks and adjust the number of shares to achieve a $1000.00 ass
Grades:
9th - 12th
Types:
VM Numeracy Unit 2 - Civics - Data and Uncertainty
VCE VM Unit 2 Numeracy book, Civic - Data and Uncertainty. This unit looks at odds, reading and interpreting data, probability and statistics. Includes many hands-on activities.
Subjects:
Grades:
10th - 12th
Types:
Also included in: Bundle 1
AICE Thinking Skills - Curriculum and Exam Breakdowns
(This product had originally been mistakenly uploaded incorrectly and then fixed but the negative review has never been taken down)This product includes a day-by-day breakdown of an entire First Semester, which covers all skills involved for AS level except the writing application needed in questions #2 and #5 on Paper 2. It includes all AS level Problem Solving Skills for Paper 1, as well as the AS level skills needed for questions #1, #3 and #4 (RAVEN, Main Conclusion, Intermediate Conclusion,
Grades:
8th - 12th, Higher Education
Types:
Making Money from Lemons--Microsoft Excel 2010 Project
This is an updated version of a previously posted project. This version is updated to reflect the Microsoft Office 2010 format. Students play a fun game that requires them to figure out how to make the most profit from their own "Lemonade Stand". Students will learn to create a spreadsheet that keeps track sales profit and loss. They will also create a graph that shows a sales report at the end of their "season".
Grades:
7th - 12th, Adult Education
Types:
Statistics Unit 8 Bundle - Confidence Intervals (19 days)
This is a unit plan bundle for a Statistics class. The plans include common core math standards, time frame, activities, enduring understandings, essential questions, and resources used. It is designed to last 19 days, depending on pacing. The plans include: 52-slide presentation, with annotated guide for reference5 Worksheets3 Quizzes"Do Now" Entrance problemsSpreadsheet Activity - T-DistributionReview slides (for review response system)Unit test (with review packet)Unit Project - Gather Data,
Subjects:
Grades:
10th - 12th, Higher Education
Types:
CCSS:
Real World Data for Statistical Analysis and Infographic Project
Give your students access to real world data for your statistical analysis unit or data literacy! Dive into statistics with Microsoft Excel™ or Google Sheets™ and years of data. Learn how to use standard deviation, mean or median to interpret data. Choose the best graphs to display conclusions in an infographic. Works great for science fairs! ✔ Includes an infographic project! (Template, expectations, and rubric). ✔ Everything is fully editable and you and your students can even use the images
Grades:
9th - 12th
Types:
CCSS:
Quiz Bowl/ Scholastic Bowl adaptive stat sheet
DISCLAIMER: Made for IHSA-Compliant Scholastic Bowl. 24 questions per round, 10 point toss-ups, 3 part bonus (each bonus worth 10 points).This is a stat sheet for Scholastic Bowl/ Quiz Bowl practices and games. It adapts in real-time to update the scoreboard and team totals when a name and category abbreviation is applied (see thumbnails for example) The sheet tracks math, science, social studies/history, literature, fine arts, and miscellaneous questions. It is incredibly useful and semi-autono
Subjects:
Grades:
9th - 12th
Printable Graph Paper 10 Squares Per Inch Cross Stitch
Printable Graph Paper 10 Squares Per Inch Cross Stitch - Grid paper is essentially the type of paper most commonly used for drawing and sketching purposes. It is widely used for making plan charts, designing websites, developing home ideas and so forth. A great deal of businesses who need to produce a company card, business brochures, catalogues, brochures, and so forth need this kind of graph paper.
Subjects:
Grades:
5th - 12th
Presidential Data Analyst Math Project | Excel | Presentations | Presidents Day
Elevate your Presidents' Day lesson plans with this comprehensive Presidential Data Analysis Math Project, designed to engage students in a deep exploration of U.S. presidential history through mathematical analysis. This invaluable resource provides educators with everything they need to guide their students through a dynamic and informative project that combines historical research with mathematical concepts.**Key Features:**1. **Thematic Relevance:** - Aligned with Presidents' Day, this o
Subjects:
Grades:
7th - 10th
Water Balloon Catcher Project - Data and Graphing - Mathematics
Transform your maths classroom into a dynamic hub of learning with this captivating data and graphing project! Designed for upper primary/middle school students, this hands-on and inquiry-based activity ensures an immersive experience in mastering data interpretation, chart creation, and understanding the role of data and graphs in advertising.In this engaging project, students will: Explore Data: Collaborate in teams to design and construct a Water Balloon Catcher using recycled materials, each
Subjects:
Grades:
5th - 9th
Types:
RTI: SMART Student Expectations Rubric
A dynamic rubric in Excel format that allows support teams to screen the needs of students based on a set of five criteria:
* Social/Emotional
* Measured Outcomes
* Academics
* Respect/Responsibility
* Timeliness
The results are then graphed on a spiderweb graph to show the targets for student intervention. The visual allows users to better understand the interaction of those expectations on the student's performance.
The rubric can support positive behavioral supports, Response to Intervention
Grades:
6th - 12th
Microsoft Excel Functions Workbook, Volume 2 (BUSINESS MATH)
NOTE: Check out Microsoft Excel Functions Workbook, Volume 1!This is an Excel 97-2003 workbook collection of 15 project-based, problem solving spreadsheet exercises (with complete keys - SEE PREVIEW) that help students learn to use the following powerful Microsoft Excel functions:SUMAVERAGEIFCOUNTIFCOUNTBLANKEach exercise generally takes between 1 and 2 full class periods to complete. I take 10-15 minutes to explain the problem, the deliverable, and the tools, and then let the students work inde
Grades:
8th - 12th, Higher Education, Adult Education, Staff
Types:
Statistics Spreadsheet Activity - Binomial, Geometric, Poisson (2 days)
Statistics Spreadsheet Activity - Binomial, Geometric, Poisson (2 days) This is a 1-2 day spreadsheet activity for a Statistics class. It uses spreadsheets as a walkthrough to allow students to explore the Binomial, Geometric, and Poisson distributions, as well as create graphs of the distributions. The product includes: 6.3 Spreadsheet Activity (Also included in " Statistics Unit 6 Bundle - Discrete Probability (12 days)" and in " A Mountain of Statistics Curriculum - One Full Year Bundle")Exce
Subjects:
Grades:
9th - 12th, Higher Education
Types:
CCSS:
Showing 1-24 of 135 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands