The students will use ACC basketball statistics to practice the process of converting fractions to decimals then to percents and will learn how to create and edit a spreadsheet. They will then use this spreadsheet to analyze their data. This unit is done during the basketball season which takes approximately 15 weeks from the middle of November to the middle of March. Teachers must have Clarisworks to open the sample spreadsheet in the lesson, but may recreate it in another spreadsheet program.

This introductory class of computer skills is comprised of units that focus on basic computer hardware and the following applications: Word 2010, Excel 2010, PowerPoint 2010, Photo Gallery, and Audacity. Most units begin with YouTube overviews or 'how to' presentations followed by step by step guides to using aspects of the application and then have assessment exercises and conclude with a final project for evaluation.

Students create a spreadsheet to quantify, analyze and determine the experiences and views towards technology of the Computer Commuter users.

Students create the layout of the spreadsheet that best suits the data in the survey. Questions are in different formats: multiple choice and short answer. The student must determine how to set up the spreadsheet to make the data easy and efficiently understandable.

Students utilize data tables culled from the US DOE Energy Information Agency to create graphs that illustrate what types of energy we use and how we use it. An MS Excel workbook with several spreadsheets of data is provided. Students pick (or the teacher assigns) one of the data tables from which students create plots and interpret the information provided. Student groups share with the class their interpretations and new perspectives on energy resources and use.

Students will be using real-life energy use data to learn how to use spreadsheets and create graphs to better organize and view data. Discussions can then follow to analyze the data and explain the usage. Real rates are then provided, and students can use the electricity consumed data to create a utility bill for the consumer and compare the standard Residential Service charges to if the member were instead billed by the “Time of Use” rate.

This intensive micro-subject provides the necessary skills in Microsoft® Excel spreadsheet modeling for ESD.71 Engineering Systems Analysis for Design. Its purpose is to bring entering students up to speed on some of the advanced techniques that we routinely use in analysis. It is motivated by our experience that many students only have an introductory knowledge of Excel, and thus waste a lot of time thrashing about unproductively. Many people think they know Excel, but overlook many efficient tools, such as Data Table and Goal Seek. It is also useful for a variety of other subjects.

This paper presents real-world data, a problem statement, and discussion of a common approach to modeling that data, including student responses. In particular, we provide time-series data on the number of boys bedridden due to an outbreak of influenza at an English boarding school and ask students to build a mathematical model, either discrete or continuous, of this epidemic, and to estimate the parameters in their model and validate it against the data. Students will need access to a computer or computer lab with spreadsheet software, a computer algebra system, or a sufficient statistical analysis system such as R.

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.

List of topics and related resources for OIT 110, Communications and Editing, at Springfield Technical Community College. Taught by Professor Eileen Cusick.

Cryptids, creatures of questionable existence, are used as a source of data to guide students into the creation of their own GIS data layer in Google Earth. The activity serves the purpose of a tutorial to teach students how to make data layers with a simple subject. Then they use that skill on other topics such as plastics in their neighborhood.

The goal of this lesson is for students to work with conditional formatting in a spreadsheet program. Conditional formatting is a useful tool in spreadsheets, and this allows students to see three applications of it, including using it on their own grades. It also reviews functions and formatting concepts of spreadsheets.