TechnoSales

In this session, students are introduced to Microsoft Excel and spreadsheet terminology. To learn about the program, students play "You Found my X-Cell". This game has students identify cell references, navigate in a worksheet, enter data, fill cells with color, format the appearance of text, change the alignment, apply borderlines, and select multiple cells. It is a fun way to learn essential spreadsheet skills.

In this session, students learn how to use Microsoft Excel to make decisions about their upcoming bake sale. To make this fundraiser a success it is essential that the dessert sold is a popular item. To answer the question "What desserts do students prefer?" students conduct a survey. The results are organized into a worksheet and then placed into a column graph. The data is then analyzed to determine the dessert item that students prefer. Will it be cupcakes, muffins, or cookies?

In this session, students continue to analyze the results of the Dessert Preference Survey. To answer the question, "Are there differences between desserts girls and boys prefer?" a double column graph is used to compare the types of desserts both like to eat. This graph will help students to select a bake sale item that everyone will enjoy. By studying the graph, they will be able to make a decision that will ensure success.

In this session, students must decide the flavors of dessert to have at the bake sale. This information is important because there need to be plenty of items that people like. To answer the question, "What Flavor of Dessert do Students Like?" they conduct another survey. The results are organized into a worksheet and then placed into a pie graph. The data is then analyzed to determine the flavor students should sell. Will it be chocolate, vanilla, or strawberry?

In this session, students calculate the number of desserts required for the sale. This information is important because there must be enough items to sell to raise a certain amount of money. To answer the question, "How many Dessert Items do you Need?" past sales are studied. The sales information is organized into a worksheet and placed into a line graph. The data is then analyzed to estimate the average money earned in previous sales. This information is used to set a financial goal. Afterwards, formulas are created to calculate a fair price, amount of baked goods needed, and the number of items each student needs to bake. By using math to collect information, students can make good decisions that are sure to make the bake sale a success!

In this session, students produce a report about how to make the bake sale a success. Using Microsoft Word, they explain their decisions about the sale. They describe the purpose of the sale, the item to be sold, financial goal, price of each item, total number of baked goods needed, and the amount each student in the class will need to bring to the sale. Afterwards, the report is edited to correct spelling and grammar errors. Upon completion, it is sent to the printer for publication.

• Add Pictures into a Bar Graph: Transform each data point into a picture.
• Change the Chart Type: Explore ways to visually present the data.
• Formatting Tips for Pie Graphs: Sort data and explode a pie.
• Different Formulas, Same Result: Calculate values in cells
• About the Sale: Reflect on the results of the sale.

The lessons in TechnoSales are based on a problem-solving model, with each session targeting a series of questions or problems to solve. The activities connect mathematics to a real-world situation that is simplified to make it understandable to children. This project can be used to develop critical thinking, teach inquiry and analytic research methods, and build problem solving strategies. Spark student interest in STEM with fun Excel and Google lessons!

 Write a Review

5.0

You guys are the best! My students that used your lessons 5 years ago still talk about them and how much more computer literate they are than their fellow college students because of them. Keep up the good work!