Updating search results...

Search Resources

10 Results

View
Selected filters:
  • excel
Applying Statistics to Nano-Circuit Dimensions in Fabrication
Read the Fine Print
Educational Use
Rating
0.0 stars

Measuring the dimensions of nano-circuits requires an expensive, high-resolution microscope with integrated video camera and a computer with sophisticated imaging software, but in this activity, students measure nano-circuits using a typical classroom computer and (the free-to-download) GeoGebra geometry software. Inserting (provided) circuit pictures from a high-resolution microscope as backgrounds in GeoGebra's graphing window, students use the application's tools to measure lengths and widths of circuit elements. To simplify the conversion from the on-screen units to the real circuits' units and the manipulation of the pictures, a GeoGebra measuring interface is provided. Students export their data from GeoGebra to Microsoft® Excel® for graphing and analysis. They test the statistical significance of the difference in circuit dimensions, as well as obtain a correlation between average changes in original vs. printed circuits' widths. This activity and its associated lesson are suitable for use during the last six weeks of the AP Statistics course; see the topics and timing note below for details.

Subject:
Mathematics
Statistics and Probability
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
TeachEngineering
Author:
Cunjiang Yu
Miguel R. Ramirez
Minwei Xu
Song Chen
Date Added:
02/24/2020
Big Data, What Are You Saying?
Read the Fine Print
Educational Use
Rating
0.0 stars

Students act as R&D entrepreneurs, learning ways to research variables affecting the market of their proposed (hypothetical) products. They learn how to obtain numeric data using a variety of Internet tools and resources, sort and analyze the data using Excel and other software, and discover patterns and relationships that influence and guide decisions related to launching their products. First, student pairs research and collect pertinent consumer data, importing the data into spreadsheets. Then they clean, organize, chart and analyze the data to inform their product production and marketing plans. They calculate related statistics and gain proficiency in obtaining and finding relationships between variables, which is important in the work of engineers as well as for general technical literacy and decision-making. They summarize their work by suggesting product launch strategies and reporting their findings and conclusions in class presentations. A finding data tips handout, project/presentation grading rubric and alternative self-guided activity worksheet are provided. This activity is ideal for a high school statistics class.

Subject:
Mathematics
Statistics and Probability
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
Activities
Author:
Tom Falcone
Date Added:
05/03/2017
Flood Analysis
Read the Fine Print
Educational Use
Rating
0.0 stars

Students learn how to use and graph real-world stream gage data to create event and annual hydrographs and calculate flood frequency statistics. Using an Excel spreadsheet of real-world event, annual and peak streamflow data, they manipulate the data (converting units, sorting, ranking, plotting), solve problems using equations, and calculate return periods and probabilities. Prompted by worksheet questions, they analyze the runoff data as engineers would. Students learn how hydrographs help engineers make decisions and recommendations to community stakeholders concerning water resources and flooding.

Subject:
Engineering and Information Technologies
Hydrology
Physical Science
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
TeachEngineering
Author:
Emily Gill
Malinda Schaefer Zarske
Date Added:
09/18/2014
Latex Tubing and Hybrid Vehicles
Read the Fine Print
Educational Use
Rating
0.0 stars

The learning of linear functions is pervasive in most algebra classrooms. Linear functions are vital in laying the foundation for understanding the concept of modeling. This unit gives students the opportunity to make use of linear models in order to make predictions based on real-world data, and see how engineers address incredible and important design challenges through the use of linear modeling. Student groups act as engineering teams by conducting experiments to collect data and model the relationship between the wall thickness of the latex tubes and their corresponding strength under pressure (to the point of explosion). Students learn to graph variables with linear relationships and use collected data from their designed experiment to make important decisions regarding the feasibility of hydraulic systems in hybrid vehicles and the necessary tube size to make it viable.

Subject:
Engineering and Information Technologies
Functions
Mathematics
Physical Science
Physics
Material Type:
Unit of Study
Provider:
TeachEngineering
Provider Set:
TeachEngineering
Author:
Carleigh Samson
Erik Bowen
Date Added:
09/18/2014
Linear Models and Latex Explosion!
Read the Fine Print
Educational Use
Rating
0.0 stars

Students use latex tubes and bicycle pumps to conduct experiments to gather data about the relationship between latex strength and air pressure. Then they use this data to extrapolate latex strength to the size of latex tubing that would be needed in modern passenger sedans to serve as hybrid vehicle accelerators, thus answering the engineering design challenge question posed in the first lesson of this unit. Students input data into Excel spreadsheets and generate best fit lines by the selection of two data points from their experimental research data. They discuss the y-intercept and slope as it pertains to the mathematical model they generated. Students use the slope of the line to interpret the data collected. Then they extrapolate with this information to predict the latex dimensions that would be required for a full-size hydraulic accumulator installed in a passenger vehicle.

Subject:
Algebra
Mathematics
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
TeachEngineering
Author:
Carleigh Samson
Date Added:
02/24/2020
Mathematically Designing a Frictional Roller Coaster
Read the Fine Print
Educational Use
Rating
0.0 stars

Students apply high school-level differential calculus and physics to the design of two-dimensional roller coasters in which the friction force is considered, as explained in the associated lesson. In a challenge the mirrors real-world engineering, the designed roller coaster paths must be made from at least five differentiable functions that are put together such that the resulting piecewise curving path is differentiable at all points. Once designed mathematically, teams build and test small-sized prototype models of the exact designs using foam pipe wrap insulation as the roller coaster track channel with marbles as the ride carts.

Subject:
Algebra
Engineering and Information Technologies
Mathematics
Measurement and Data
Physical Science
Physics
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
Activities
Author:
Miguel R. Ramirez
Date Added:
08/31/2017
Statistical Analysis of Flexible Circuits
Read the Fine Print
Educational Use
Rating
0.0 stars

Students are introduced to the technology of flexible circuits, some applications and the photolithography fabrication process. They are challenged to determine if the fabrication process results in a change in the circuit dimensions since, as circuits get smaller and smaller (nano-circuits), this could become very problematic. The lesson prepares students to conduct the associated activity in which they perform statistical analysis (using Excel® and GeoGebra) to determine if the circuit dimension sizes before and after fabrication are in fact statistically different. A PowerPoint® presentation and post-quiz are provided. This lesson and its associated activity are suitable for use during the last six weeks of the AP Statistics course; see the topics and timing note for details.

Subject:
Mathematics
Statistics and Probability
Material Type:
Lesson
Provider:
TeachEngineering
Provider Set:
TeachEngineering
Author:
Cunjiang Yu
Miguel R. Ramirez
Minwei Xu
Song Chen
Date Added:
02/24/2020
Statistical Analysis of Methods to Repair Cracked Steel
Read the Fine Print
Educational Use
Rating
0.0 stars

Students apply pre-requisite statistics knowledge and concepts learned in an associated lesson to a real-world state-of-the-art research problem that asks them to quantitatively analyze the effectiveness of different cracked steel repair methods. As if they are civil engineers, students statistically analyze and compare 12 sets of experimental data from seven research centers around the world using measurements of central tendency, five-number summaries, box-and-whisker plots and bar graphs. The data consists of the results from carbon-fiber-reinforced polymer patched and unpatched cracked steel specimens tested under the same stress conditions. Based on their findings, students determine the most effective cracked steel repair method, create a report, and present their results, conclusions and recommended methods to the class as if they were presenting to the mayor and city council. This activity and its associated lesson are suitable for use during the last six weeks of the AP Statistics course; see the topics and timing note for details.

Subject:
Mathematics
Statistics and Probability
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
TeachEngineering
Author:
Botong Zheng
Miguel R. Ramirez
Mina Dawood
Date Added:
02/24/2020
Statistical Analysis of Temperature Sensors
Read the Fine Print
Educational Use
Rating
0.0 stars

Working as if they are engineers aiming to analyze and then improve data collection devices for precision agriculture, students determine how accurate temperature sensors are by comparing them to each other. Teams record soil temperature data during a class period while making changes to the samples to mimic real-world crop conditions—such as the addition of water and heat and the removal of the heat. Groups analyze their collected data by finding the mean, median, mode, and standard deviation. Then, the class combines all the team data points in order to compare data collected from numerous devices and analyze the accuracy of their recording devices by finding the standard deviation of temperature readings at each minute. By averaging the standard deviations of each minute’s temperature reading, students determine the accuracy of their temperature sensors. Students present their findings and conclusions, including making recommendations for temperature sensor improvements.

Subject:
Mathematics
Statistics and Probability
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
Activities
Author:
Keith Lehman
Northern Cass
Trent Kosel
Date Added:
06/28/2017
Understanding the Air through Data Analysis
Read the Fine Print
Educational Use
Rating
0.0 stars

Students build on their existing air quality knowledge and a description of a data set to each develop a hypothesis around how and why air pollutants vary on a daily and seasonal basis. Then they are guided by a worksheet through an Excel-based analysis of the data. This includes entering formulas to calculate statistics and creating plots of the data. As students complete each phase of the analysis, reflection questions guide their understanding of what new information the analysis reveals. At activity end, students evaluate their original hypotheses and “put all of the pieces together.” The activity includes one carbon dioxide worksheet/data set and one ozone worksheet/data set; providing students and/or instructors with a content option. The activity also serves as a good standalone introduction to using Excel.

Subject:
Atmospheric Science
Physical Science
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
TeachEngineering
Author:
Ashley Collier
Ben Graves
Daniel Knight
Drew Meyers
Eric Ambos
Eric Lee
Erik Hotaling
Hanadi Adel Salamah
Joanna Gordon
Katya Hafich
Michael Hannigan
Nicholas VanderKolk
Olivia Cecil
Victoria Danner
Date Added:
02/24/2020