This textbook was written for a community college introductory course in spreadsheets utilizing Microsoft Excel. While the figures shown utilize Excel 2016, the textbook was written to be applicable to other versions of Excel as well. The book introduces new users to the basics of spreadsheets and is appropriate for students in any major who have not used Excel before.
In this lesson, students will learn how to enter data and formulas into an Excel spreadsheet. They'll also learn how to use the data to create and format graphs and charts.
Introduces students to the basic tools in using data to make informed management decisions. Covers introductory probability, decision analysis, basic statistics, regression, simulation, and linear and nonlinear optimization. Computer spreadsheet exercises and examples drawn from marketing, finance, operations management, and other management functions. Restricted to Sloan Fellows.
This assignment is designed for a personal finance class. Students will be split up into groups and are to plan weddings for their assigned couple. There are four different customers that will need to be assigned. Students are to create a professional presentation using a spreadsheet application outlining their plans for their assigned customers. The purpose of the assignment is to visually see the different costs that are involved while planning for a wedding.
Suggested columns: Item description, photo of item, cost involved, and a running balance to visually show the grand total.
Business Applications and Digital Literacy course FREE teacher resources and trial access to online course solution as well as a correlation to WI state BIT standards for business applications. Resources mapped to MOS certification.
Use this spreadsheet after students have been taught the basics of spreadsheets: entering and editing data, formatting a spreadsheet, basic functions, sorting, creating and formatting charts. Students use Skittles (can also use M&Ms or another candy or type of food with different colors that can be sorted) to create a spreadsheet. They will sort the data, create functions to analyze the data, and insert a chart.
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.
- Atmospheric Science
- Earth and Space Science
- Material Type:
- Provider Set:
- AirWaterGas SNR Project Education and Outreach, College of Engineering, University of Colorado Boulder
- 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:
Students will have fun collecting data using the Coffee Shop Game. (1st resource) Then they will take the collected data and enter it on a spreadsheet and review how to graph on google spreadsheets! (2nd resource) Encourage students to problem solve how to make the best coffee and make the most money. Collaboration is encouraged!
Introductory exercise in Google Sheets for elementary students. This valentine reveal pixel art PDF lesson assumes some prior teaching in concepts like column name, row name, and cell name. Teacher will need to create Google Sheets template for younger elementary students. Could be adapted for MS Excel.