Tuesday, March 27, 2012
Excel in Class
My five ideas for using Excel in the classroom are as follows: #1. A List of expenses and materials for each project to determine a price range for selling the work. -This would require keeping a budget of expenses such as the price of paint or canvas when making a painting. -Another thing I would have my students factor in is the amount of time spent and tell them to give themselves a base rate of about $8 to $9. -As mentioned before this will help them determine a price range as well as teach them how to manage their own time and money on projects. -NETS-S Standard: 4. Critical Thinking, Problem Solving, and Decision Making c. Collect and Analyze data to identify solutions and/or make informed decisions. Since art supplies are incredibly expensive and often times field trips are cut from budgets, I would use excel for encouraging fundraising. I would probably introduce this into art club and there are several different things I could use excel for in this case. #2. If we were to have a t-shirt sale at the school with an original design from one of the students, excel could be used to organize and tally up the data received from the voting process. -A chart could be used to sum up and present the data. -NETS-S Standard: 3. Research and Information Fluency d. Process data and report results. #3. A set goal in mind could be put in place so that the students can figure out how many shirts they will need to sell in order to get the correct amount of money. This could help them strategize and plan ahead as well as teach them to once again make a budget. They could also allocate certain amounts of money collected in different ways if they were doing several fundraisers here. -NETS-S Standard: 1. Creativity and Innovation d. Identify trends and forecast possibilities. #4. Another way that the students could use this is by organizing the information received by the people who bought tee shirts. They could use excel to create a list of the names, sizes, amount of shirts bought by each individual, and forms of payment used. This is a great way to teach students how to organize information so that there are no horrible mix ups and everything is clearly organized. This is an important skill to have because everyone takes money very seriously and if something goes wrong the consequences could be very bad. -NETS-S Standard: 3. Research and Information Fluency b. Locate, organize, analyze, evaluate, synthesize, and ethically use information from a variety of sources. #5. This one is specifically geared towards my curriculum and it is supposed to demonstrate the change of worth in artwork over time. The project would ask the question of how a painting sold in the 1600's for 12 American dollars might increase in price by present day. It would ask specific numbers and require a certain formula to increase the currency amount in excel. By using excel as a tool, they would not have to do too much math, but would still get the idea that time increases the worth of an item by a lot! They would also be asked to compare and they would have to give specific reasons why something might increase in price over time and do research to find famous works of art on www.sothebys.com so that they can compare it to the standard prices of artwork during the time the work of art was made. -NETS-S Standard: 4. Critical Thinking, Problem Solving, and Decision Making c. Collect and analyze data to identify solutions and/or make informed decisions.