Lesson plans for Excel

Lesson 1

Students will be assigned to record a timeline of their day. They will collect the data for 1 week. The student will name the items: sleep, eat, play games, ride bikes, homework, etc. At the end of the week the students will place information in Excel. They will then create a graph and be able to compare and contrast the amount of time they spend doing each activity and see if they can change any of their schedule to maintain a more organized, healthy, happy life. Maybe they have lower grades than they would like but they play games apx. 20 hours a week. It would be possible to change that and see if their grades come up. This could go on for a month and the students would adjust their time spent and see what changes. Have the students report their excel data on power point. Choose the student of your choice and have them compile a class spreadsheet and compare the activities from student to student and see where the class as a whole could change. Make it a semester long project on self improvement.

Lesson 2
Have students discuss generation gaps and why they think the gaps are present. Have them come up with terms: music, cloths, age, food, etc. and use the generation gap as an independent variable and the dependent variable is the causes. Have the students collect the data utilizing sometimes, always, never type of questionnaire. Have them place the data in an Excel chart and make a graph. A student can form a hypothesis and collect all the data and see if the hypothesis they created is true or false based on the information. The student can then make a chart and show it to the class.

Lesson 3
Students would make a hypothesis about earthquakes and how locations, building, population, climate would effect the earthquake. Student would go to the earthquake simulation website and place in their information and get the answer to their hypothesis. Once all information is received they could place it in the Excel sheet and run a graph and see if any of the factors do in fact affect the earthquake.

Lesson 4
The students would play the Lemonade Stand Game. The students would receive a stipend of “$20.00” to start their business. The students would go to www.coolmath-games.com/lemonade/ and record decisions they make with their money. They would
utilize weather and other circumstances to see how well the lemonade stand does. They need to make a profit in order to win the game. If they are not able to make a profit they will go bankrupt. They will record money in an Excel spreadsheet and have labels like money spent, money earned, etc. to decide if a profit was made or not. They would be able to make a graph using the profit calculator and show the class the Lemonade stands success.

Lesson 5
The students would spend a month recording the true sunrise and sunset times of their areas. They would take and record the information in Excel to show the pattern in the area they are from. They could then use a graph to show their findings.