Students act as R&D entrepreneurs, learning ways to research variables affecting the …
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.
Students build on their existing air quality knowledge and a description of …
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.
No restrictions on your remixing, redistributing, or making derivative works. Give credit to the author, as required.
Your remixing, redistributing, or making derivatives works comes with some restrictions, including how it is shared.
Your redistributing comes with some restrictions. Do not remix or make derivative works.
Most restrictive license type. Prohibits most uses, sharing, and any changes.
Copyrighted materials, available under Fair Use and the TEACH Act for US-based educators, or other custom arrangements. Go to the resource provider to see their individual restrictions.