{"results":"
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"Data\n\n
\n
\n
\n
\nCurated OER\n
\n

\nData Analysis and Probability: Graphing Candy with Excel\n

\n
\n\nFor Teachers\n\n5th - 8th\n
\n
\n
\nCollect and graph data using Microsoft Excel with your math class. They will make predictions about the number of each colored candy in a bag of M&M's, then sort, classify, count, and record the actual data before using Excel to...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Activity
\n
\n
\n
\n\"Spreadsheet\n\n
\n
\n
\n
\nHoward Hughes Medical Institute\n
\n

\nSpreadsheet Tutorial 1: Formulae, Functions, and Averages\n

\n
\n\nFor Students\n\n9th - 12th\n
\n
\n
\nSpread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"Using\n\n
\n
\n
\n
\nCurated OER\n
\n

\nUsing Computer for Statistical Analysis\n

\n
\n\nFor Teachers\n\n9th - 12th\n
\n
\n
\nStudents use the computer and S'COOL data for statistical analysis.\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Activity
\n\n\n\n\n\n\n
1
\n\n\n\n\n\n\n\n1\n\n\n\n\n
\n
\n
\n\"Understanding\n\n
\n
\n
\n
\nTeach Engineering\n
\n

\nUnderstanding the Air through Data Analysis\n

\n
\n\nFor Teachers\n\n9th - 12th\n\nStandards\n
\n
\n
\nIs there a correlation or causation relationship between air pollutants? Groups develop a hypothesis about the daily variation of air pollutants, specifically ozone and CO2. Using Excel to analyze the data, the groups evaluate their...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Activity
\n
\n
\n
\n\"Spreadsheet\n\n
\n
\n
\n
\nHoward Hughes Medical Institute\n
\n

\nSpreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation\n

\n
\n\nFor Students\n\n9th - 12th\n
\n
\n
\nIf 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,...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Assessment
\n
\n
\n
\n\"Broken\n\n
\n
\n
\n
\nConcord Consortium\n
\n

\nBroken Spreadsheet I\n

\n
\n\nFor Students\n\n8th - 11th\n\nStandards\n
\n
\n
\nThere is power in spreadsheet formulas and learners use this power to model quadratic data. Given a scatterplot of a parabola, pupils create formulas in a spreadsheet to populate the data. The formulas they use lead to an understanding...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"Creating\n\n
\n
\n
\n
\nCurated OER\n
\n

\nCreating a Spreadsheet and Graph\n

\n
\n\nFor Teachers\n\n4th - 5th\n
\n
\n
\nStudents create graphs in Excel.  In this spreadsheet lesson plan, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data.  The directions to create...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"Back-To-School\n\n
\n
\n
\n
\nCurated OER\n
\n

\nBack-To-School Shopping\n

\n
\n\nFor Teachers\n\n5th\n
\n
\n
\nFifth graders estimate the prices of items to be bought for back to school. They use catalogs and/or advertisements to research the cost of each of the items. They use problem solving strategies and a spreadsheet template to determine...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Instructional Video3:39
\n
\n
\n
\n\"Excel\n\n
\n
\n
\n
\nGCFGlobal.org\n
\n

\nExcel 2016: Intro to Formulas\n

\n
\n\nFor Students\n\n9th - Higher Ed\n\nStandards\n
\n
\n
\nHow do techies use formulas in an Excel spreadsheet to calculate numerical data?  A short instructional video teaches scholars about cell references, mathematical operators, and models how to create, copy, and edit formulas. \n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"Credit\n\n
\n
\n
\n
\nCurated OER\n
\n

\nCredit Cards: The Good, the Bad, and the ugly\n

\n
\n\nFor Teachers\n\n10th - 12th\n
\n
\n
\nStudents study how dangerous credit cards can be. They see why it is important to pay off credit card bills as soon as they can. They use MS Excel to display and understand the data. They fill out questions using the data from their...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Assessment
\n
\n
\n
\n\"Broken\n\n
\n
\n
\n
\nConcord Consortium\n
\n

\nBroken Spreadsheet II\n

\n
\n\nFor Students\n\n11th - 12th\n\nStandards\n
\n
\n
\nWork in reverse with the product becoming the given. Using a spreadsheet image of the graph of a trigonometric function, young scholars investigate methods of creating spreadsheet data that results in the given graph. The catch? The data...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"Digital\n\n
\n
\n
\n
\nAmerican Institutes for Research\n
\n

\nDigital Smiles\n

\n
\n\nFor Teachers\n\n4th - 6th\n
\n
\n
\nExplore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"Sea\n\n
\n
\n
\n
\nCurated OER\n
\n

\nSea Level Trends ~ Ocean Front Property: An \"Immerging\" Market\n

\n
\n\nFor Teachers\n\n7th - 12th\n
\n
\n
\nYoung oceanographers take a look at sea level data from several cities over a few centuries. They use the data to fuel a discussion about what kind of changes are taking place and the impact they are having on the coastal ecosystems....\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n\n\n\n\n\n\n
1
\n\n\n\n\n\n\n\n1\n\n\n\n\n
\n
\n
\n\"Micro-GEEBITT\n\n
\n
\n
\n
\nChicago Botanic Garden\n
\n

\nMicro-GEEBITT Climate Activity\n

\n
\n\nFor Teachers\n\n5th - 6th\n\nStandards\n
\n
\n
\nA truly hands-on and inquiry based learning activity bridges all the lessons in the series together. Beginning with a discussion on average global temperatures, young meteorologists use real-world data to analyze climate trends in order...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"How\n\n
\n
\n
\n
\nAlabama Learning Exchange\n
\n

\nHow Big Can a Bee Be?\n

\n
\n\nFor Teachers\n\n7th - 10th\n\nStandards\n
\n
\n
\nMathematicians analyze the relationships between surface area and volume. They conduct Internet research, conduct various experiments, record the data in a spreadsheet, and graph the results and compare the rate of increase of surface...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"Using\n\n
\n
\n
\n
\nCurated OER\n
\n

\nUsing Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions\n

\n
\n\nFor Teachers\n\n7th - 12th\n
\n
\n
\nStudents improve data entry in a spreadsheet.\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"M&M\n\n
\n
\n
\n
\nCurated OER\n
\n

\nM&M Graphing\n

\n
\n\nFor Teachers\n\n4th\n
\n
\n
\nFourth graders name colors of M&Ms and record answers. They estimate number of M&Ms of each color found in a typical package of M&Ms on piece of paper.They record information on sheet of paper and create a spreadsheet. paper.\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Instructional Video4:59
\n\n\n\n\n\n\n
1
\n\n\n\n\n\n\n\n1\n\n\n\n\n
\n
\n
\n\"How\n\n
\n
\n
\n
\nstatisticsfun\n
\n

\nHow to use Excel to Calculate Confidence Interval\n

\n
\n\nFor Students\n\n11th - 12th\n\nStandards\n
\n
\n
\nUtilize Excel software to analyze a set of data by making statistical calculations. The instructor shows how to find the standard deviation, mean, minimum, maximum, margin of error, confidence intervals, and range using Excel commands....\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
eBook
\n
\n
\n
\n\"Beginning\n\n
\n
\n
\n
\nOpen Oregon Educational Resources\n
\n

\nBeginning Excel\n

\n
\n\nFor Students\n\n9th - Higher Ed\n\nStandards\n
\n
\n
\nHow can Microsoft Excel help manage data in people's personal and professional lives? Using the Beginning Excel eBook, scholars learn the basics of creating, editing, and using spreadsheets. They explore spreadsheet design, formulas,...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"Bones\n\n
\n
\n
\n
\nCurated OER\n
\n

\nBones and Math\n

\n
\n\nFor Teachers\n\n5th - 12th\n
\n
\n
\nyoung scholars identify and explore the connection between math and the bones of the human body. Students collect data about bones from their classmates and from adults, apply formulas that relate this data to a person's height, and...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Instructional Video5:16
\n
\n
\n
\n\"Excel\n\n
\n
\n
\n
\nGCFGlobal.org\n
\n

\nExcel 2016: Functions\n

\n
\n\nFor Students\n\n9th - Higher Ed\n\nStandards\n
\n
\n
\nWhen working with numerical data in a Microsoft Excel spreadsheet, which is better: formulas or functions? Pupils discover the answer through a short, instructional video.  First, scholars learn about the parts of a function and...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"Graphing\n\n
\n
\n
\n
\nCurated OER\n
\n

\nGraphing Data from the Chemistry Laboratory\n

\n
\n\nFor Teachers\n\n9th - 12th\n
\n
\n
\nStudents graph and analyze data using a spreadsheet.\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"Pythagorean\n\n
\n
\n
\n
\nCurated OER\n
\n

\nPythagorean Theorem Spreadsheet\n

\n
\n\nFor Teachers\n\n6th - 8th\n
\n
\n
\nStudetns use a spreadsheet to organize data on the sides of a triangle. They use the Pythagorean Theorem and the If then spreadsheet function to decide whether the three sides determine a right triangle. Students work individual...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lesson Plan
\n
\n
\n
\n\"Spreadsheet\n\n
\n
\n
\n
\nCurated OER\n
\n

\nSpreadsheet formulas\n

\n
\n\nFor Teachers\n\n6th - 8th\n
\n
\n
\nStudents, while in the computer lab, practice using formulas, print options, functions and adjusting column widths while interacting with a spreadsheet program. They modify and use spreadsheets, after being given a scenario, to solve...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n","pagination":"
\n
\n
\n"}