Search Resources

12 Results

View
Selected filters:
  • Spreadsheets
Beginning Excel
Unrestricted Use
CC BY
Rating

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.

Subject:
Computer Science
Material Type:
Textbook
Provider:
OpenOregon
Author:
Barbara Lave
Diane Shingledecker
Julie Romey
Mary Schatz
Noreen Brown
Date Added:
01/01/2017
Communicating With Data, Summer 2003
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

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.

Subject:
Business and Information Technology
Marketing, Management and Entrepreneurship
Statistics and Probability
Material Type:
Full Course
Provider:
M.I.T.
Provider Set:
M.I.T. OpenCourseWare
Author:
Carroll, John S.
Date Added:
01/01/2003
Learning How to Use Microsoft Excel 2016.pdf
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

Complete introductory text for Excel 2016.This book has been updated and remixed from How to Use Excel by Manzo. The topics covered include: Fundamental Skills, mathematical computations, logical and lookup functions, charts, and tables and PivotTables. Updated and re-mixed by Kaaren McGlynn from the Saylor Academy's "How to Use Microsoft Excel: The Careers in Practice Series"

Subject:
Computer Science
Material Type:
Textbook
Author:
Kaaren McGlynn
Date Added:
10/10/2017
Planning a wedding - Personal Finance - Spreadsheets
Conditional Remix & Share Permitted
CC BY-NC
Rating

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.

Subject:
Business and Information Technology
Material Type:
Activity/Lab
Author:
Randi Stanley
Date Added:
08/02/2019
Shelly Cashman, Technology for Success and Microsoft Office 365 & 2019 Teacher Resources and Trial Online Access with BIT Standards Correlation (Cengage)
Only Sharing Permitted
CC BY-ND
Rating

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.

Subject:
Business and Information Technology
Material Type:
Activity/Lab
Assessment
Curriculum Map
Learning Task
Lesson Plan
Module
Reading
Rubric/Scoring Guide
Teaching/Learning Strategy
Textbook
Author:
Abigail Hess
Date Added:
07/31/2020
Skittle Spreadsheet Project
Rating

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. 

Subject:
Career and Technical Education
Business and Information Technology
Information and Technology Literacy
Material Type:
Interim/Summative Assessment
Provider:
Jessica Miller
Author:
Jessica Miller
Date Added:
03/28/2018
Understanding the Air through Data Analysis
Read the Fine Print
Educational Use
Rating

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.

Subject:
Atmospheric Science
Material Type:
Activity/Lab
Provider:
TeachEngineering
Provider Set:
TeachEngineering
Author:
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:
10/13/2017
Using Spreadsheet and the Coffee Shop Game
Restricted Use
Copyright Restricted
Rating

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!

Subject:
Career and Technical Education
Business and Information Technology
Material Type:
Game
Interactive
Learning Task
Simulation
Provider:
Coolmath.com LLC
Date Added:
04/21/2016
Valentine Pixel Art in Google Sheets
Conditional Remix & Share Permitted
CC BY-NC-SA
Rating

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.

Subject:
Business and Information Technology
Material Type:
Lesson Plan
Author:
Jane Strong
Date Added:
06/10/2019