{"results":"
\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
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
Activity
\n
\n
\n
\n\"Spreadsheet\n\n
\n
\n
\n
\nHoward Hughes Medical Institute\n
\n

\nSpreadsheet Tutorial 5: Histogram\n

\n
\n\nFor Students\n\n9th - 12th\n
\n
\n
\nA professional-looking histogram is just a few clicks away. The last installment of a five-part Spreadsheet Data Analysis series focuses on histograms. Learners work through a tutorial to see how spreadsheets can help make frequency...\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n
\n\n
\n
\n
\n
Lab Resource
\n
\n
\n
\n\"The\n\n
\n
\n
\n
\nPingry School\n
\n

\nThe Water Lab – Spreadsheet Simulation\n

\n
\n\nFor Students\n\n9th - 12th\n\nStandards\n
\n
\n
\nMore than 70 percent of people and 90 percent of businesses use spreadsheets regularly. While many courses overlook the important skill, the simple water lab focuses on entering spreadsheet data, formatting it, and printing plots based...\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\"Parts\n\n
\n
\n
\n
\nCurated OER\n
\n

\nParts of a Spreadsheet\n

\n
\n\nFor Teachers\n\n9th - 12th\n
\n
\n
\nStudents create their own spreadsheet. They identify the different parts that make up a spreadsheet and organize their data. They practice using functions and formats.\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\"Parts\n\n
\n
\n
\n
\nCurated OER\n
\n

\nParts of a Spreadsheet\n

\n
\n\nFor Teachers\n\n7th - 9th\n
\n
\n
\nStudents experiment with the basic functions of a spreadsheet. They practice using headers, footers, functions and fonts. They also organize information.\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 4: t-Test\n

\n
\n\nFor Students\n\n9th - 12th\n
\n
\n
\nThe t-test tutorial will fit your needs to a T. After calculating the mean, sum of squares, standard deviation, and variance of two data sets on a spreadsheet, scholars learn to calculate the t-values. They then learn to use the TTEST...\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 3: Column Graphs, Error Bars, and Standard Error of the Mean\n

\n
\n\nFor Students\n\n9th - 12th\n
\n
\n
\nThere's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment...\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
Lesson Plan
\n
\n
\n
\n\"Dino-Myte\n\n
\n
\n
\n
\nCurated OER\n
\n

\nDino-Myte Spreadsheet\n

\n
\n\nFor Teachers\n\n4th - 8th\n
\n
\n
\nDo your learners like dinosaurs and theme parks? An ambitious lesson invites learners to put together a plan for supplying dinosaurs for a new theme park. Pupils work together in groups to come up with their plan, which must include a...\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
Instructional Video10:39
\n
\n
\n
\n\"Population\n\n
\n
\n
\n
\nBozeman Science\n
\n

\nPopulation Modeling\n

\n
\n\nFor Students\n\n9th - 12th\n\nStandards\n
\n
\n
\nAre you Excelent with spread sheets? Video begins with an explanation of populations and life cycles of both plants and animals. Then it walks through how to model generations of a population by using a spreadsheet. It is the...\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\"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 instructional activity, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data.  The directions...\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
\nLearners, 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
\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\"Entering\n\n
\n
\n
\n
\nEarth Watch Institute\n
\n

\nEntering Local Groundhog Data in an Excel Spreadsheet\n

\n
\n\nFor Teachers\n\n4th\n
\n
\n
\nHere is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...\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\"Class\n\n
\n
\n
\n
\nCurated OER\n
\n

\nClass Birthday Graph\n

\n
\n\nFor Teachers\n\n2nd - 3rd\n
\n
\n
\nStudents analyze the basics of an Excel spreadsheet. They highlight cells in a spreadsheet. They make a column graph. Students are introduced to X-axis and Y-axis. They play various address games on the 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
Instructional Video4:49
\n\n\n\n\n\n\n
1
\n\n\n\n\n\n\n\n1\n\n\n\n\n
\n
\n
\n\"Graphing\n\n
\n
\n
\n
\nBozeman Science\n
\n

\nGraphing Data by Spreadsheet\n

\n
\n\nFor Students\n\n9th - 12th\n
\n
\n
\nWatch your pupils Excel at using spreadsheets to graph data by watching a video that covers how to graph data in a scatter plot using Microsoft Excel. The video also covers how to change titles, scales, and labels, as well as how 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
Instructional Video5:44
\n
\n
\n
\n\"Excel\n\n
\n
\n
\n
\nGCFGlobal.org\n
\n

\nExcel 2016: Understanding Number Formats\n

\n
\n\nFor Students\n\n9th - Higher Ed\n\nStandards\n
\n
\n
\nWhat is the correct way to enter dates and percentages into an Excel spreadsheet? Learners discover the answer with an instructional video that teaches them how to apply and use number formats correctly and efficiently.\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\"Analyzing\n\n
\n
\n
\n
\nCurated OER\n
\n

\nAnalyzing Discrete and Continuous Data in a Spreadsheet\n

\n
\n\nFor Teachers\n\n6th - 12th\n\nStandards\n
\n
\n
\nYou are what you eat! Your statisticians keep a log of what they eat from anywhere between a day to more than a week, keeping track of a variety of nutritional information using a spreadsheet. After analyzing their own data, individuals...\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 \"Concrete\" Spreadsheet\n

\n
\n\nFor Teachers\n\n10th - 11th\n
\n
\n
\nStudents create a spreadsheet that calculate the amount of concrete needed to pour various concrete forms.\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
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\"What's\n\n
\n
\n
\n
\nCurated OER\n
\n

\nWhat's the Scoop?: Our Favourite Ice Cream Flavours\n

\n
\n\nFor Teachers\n\n6th\n
\n
\n
\nSixth graders create a spreadsheet on the favorite ice cream flavors of their peers. They interview their classmates, documenting their findings on a \"Favorite Flavors\" spreadsheet. Students graph and analyze the data.\n
\n
\n
\n\nGet Free Access\n\nSee Review\n
\n
\n
\n
\n\n
\n\n\n","pagination":"
\n
\n
\n"}