9 results
Computer science simulations for Microsoft Excel
Making Money from Lemons--Microsoft Excel 2010 Project
This is an updated version of a previously posted project. This version is updated to reflect the Microsoft Office 2010 format. Students play a fun game that requires them to figure out how to make the most profit from their own "Lemonade Stand". Students will learn to create a spreadsheet that keeps track sales profit and loss. They will also create a graph that shows a sales report at the end of their "season".
Grades:
7th - 12th, Adult Education
Types:
(Supplement) My Best Life Scenario Game - Automated Spreadsheet
My Best Life Scenario Game's automated spreadsheet removes much of the budget calculation hassle. This improves the speed and accuracy of the players, allowing the focus to be on decision making instead of tabulating. For each year, players will create a balanced budget, then simulated events will occur and they have to determine how to re-balance their budget. At the end of the game, players will have learned how to budget as well as gain insights into how purchasing decisions and unforeseeabl
Grades:
9th - 12th, Higher Education
Types:
Stock Market -Finance -Excel -Gains -Losses -Quote
This is the second module in a financial literacy unit. The 1st unit covered checking accounts. This unit is an introduction into the stock market. Students will be able to identify the different parts of a stock quote. Students will learn how to read a stock quote, calculate gains and losses and create Excel spreadsheet to track the stocks they choose for a stock simulation that can be turned into a competition.
Grades:
10th - 12th
Types:
Cookie Mining-Natural Resources Google App Sheet
In this Google Sheet simulation students mine "ore," chocolate chips from a chocolate chip cookie to demonstrate real mining operations and the environmental price. Students complete the cost analysis google sheet choosing mining equipment, mining operation time, and reclamation methods. The google sheet can be used as is with the included formulas, or students can create the formulas using computer application skills. Two short essay responses are included. STEM ReadyReal-World ApplicationG
Grades:
6th - 9th
Types:
Life Simulation Spreadsheet
Some of your students may spend hours tinkering with this macro-assisted, life-simulating Excel spreadsheet to study and appreciate ecology, and to see how the spreadsheet program achieves complex purposes. The product is best used as an exploration opportunity for single students or pairs of students. Mathematician John Conway’s simple rules for simulating a life form (1970) are the starting point for the spreadsheet. Multiple enhancements let the student create, compare, and contrast up to f
Grades:
6th - 12th
Coding for Physics - Projectile Motion
A spreadsheet template that teaches simple mathematical coding in order to solve equations of motion. Includes a video demonstration of how to write all code. Once complete, students may input initial conditions and computer will auto-calculate displacement in two axis (x-axis or range, y-axis or height) and velocity in both axis and then graphs results.
Teacher's Edition is hidden on each page with additional video resources, and link to Google Sheets version of this activity. To find open
Grades:
7th - 10th
Types:
Digital Yahtzee
This digital version of Yahtzee is a Microsoft Excel spreadsheet and is an easy way to integrate ICT and fun into any maths classroom!Scorecards can automatically calculate totals, or students can calculate manually themselves. The spreadsheet contains the 5 dice, hold functions and calculations all within the sheet. The digital dice themselves can be used for any activity beyond Yahtzee, and you can even use this sheet to teach students about the capabilities of Excel using macros. Give it a wh
Subjects:
Grades:
4th - 10th
Types:
Cost of Sales Project
This project is meant to help students apply knowledge in several areas including spreadsheets, such as Excel and a major business topic, Inventory Control and Cost of Sales.
This is not a full lesson, but an activity meant to stretch the students' understanding and ability to apply skills that are learned in classes dealing with spreadsheets or general business.
Cost of Sales Sheet
The cost of sales is essentially how much it cost for the inventory. A major factor of the sheet was determin
Grades:
9th - 12th
Types:
For Here or To Go?
This is a spreadsheet activity in which the students create and test a usable customer order form to be used at a diner. Sheet 2 displays the formulas to be used. Sheet 3 has printable student directions and teaching suggestions.
Grades:
5th - 12th
Types:
Showing 1-9 of 9 results
TPT is the largest marketplace for PreK-12 resources, powered by a community of educators.
IXL family of brands