Best Ideas For Student Use Of Spreadsheets
Here is where to list you ideas you generated about student uses of spreadsheets.
List at least three ideas for student use of spreadsheets below, with a sentence or two explaining how the students will benefit from the spreadhsheets' incorporation into their learning.
Also, after listing three ideas, pick one and make a sample spreadsheet using your idea. Fill out at least one row or cell. Make this sample spreadsheet either in Excel, or on an online spreadsheet. Excel documents can be uploaded to online spreadsheets. Note-If using an online spreadsheet exclusively, I have found Google docs to be much easier. But, it too takes a little practice.--Brent Reese
Brent Reese's Ideas for Student Use of Spreadsheets
1. GDP analysis for two separate countries- Students will analyze two countries' Gross Domestic Products. They will do so by region. Also, covered in this analysis will be per capita GDP, or the spread of this wealth among the people as a whole. ''' 2. Major Sources of Silver in the World- Explored in this spreadsheet will be the top ten silver producing nations of the''' world, what applications the silver is used for (photography, jewelry, electrical, etc.), methods of extraction, income of miners, GDP of nations, and how far back major lodes are known for the country through history.
3. Class I Railroads of the U.S.- Students will analyze railroads that make at least $250 million. These railroads will be explored in greater depth. Among topics delved into will be: principle products hauled, line end points, revenue, predecessor roads, and rail mileage. To see an example of this spreadsheet go to the following link: http://spreadsheets.google.com/pub?key=p5ehcbO7prxiJbZXRwW4NSw
(J.J.) Judy Hutton's Ideas for Student Use of Spreadsheets: Math and Consumer Math-7th and 8th grades-real life connection:
1. Monthly School Apparel Sales - Students will analyze the sales each month of school apparel. They will compare what months are the best month's for sales in various types of clothing. They will project how many of each type of clothing will need to be ordered for this year versus last year's sales. To view my Excel sample spreadsheet of this activity, go to: http://docs.google.com/Doc?id=dcs47g65_13cvssp5sf J.J. Judy Hutton
I am providing the actual spreadsheet sample below for this spreadsheet activity of Monthly School Apparel Sales by J.J. Hutton:
'The headings below were aligned properly on Excel but it will not align when copied here.
School Apparel Sales Sept. Oct. Nov. Dec. Jan. Feb. March
Polo shirts with collar 375 275 125 225 150 225 325 Sweatshirts-with hood 425 325 375 550 250 225 0 Sweatshirts-no hood 100 175 225 425 150 75 0 Tshirts-short sleeves 275 0 0 0 0 125 225 Tshirts-long sleeves 0 125 175 175 75 50 50 Warm up jacket 275 450 525 550 325 0 0 Warm up pants 275 450 500 550 300 0 0 Total Monthly Sales 1725 1800 1925 2475 1250 700 600
2.Comparison of various gasoline prices in Tennessee, California, Florida, Texas, Washington, New York, and Minnesota. Students will list the various cost of gas per gallon for regular unleaded, mid-grade, and premium gas. They will use the Internet to find these prices. J.J. Hutton
3. The Mean, Median, and Mode -Two spreadsheets of the height and weight of each student in the 7th grade class and then two other spreadsheets could be created to compare the height and weight of the 8th grade class. They could also create another spreadsheet on the mean, median, and mode of the weight of each student in the 7th grade class compared to the 8th grade class. They could calculate in the spreadsheet the percentage of growth of students in the 7th grade to the 8th grade; comparison of female and male data will be noted. J.J. Hutton
4. The Best Vehicles for Gas Mileage - Students will analyze and create 4 spreadsheets that compare the following top five of these four types of vehicles: economy cars, luxury cars, sportcars and SUV's that are rated the most energy efficient of each type of vehicle. They will search the Internet for data and list the vehicles in each category that rank the highest in miles per gallon. J.J. Hutton
Clay Bounds, Spreadsheet Ideas for Middle School Student
1. The average tempature at the four corners of the home room @morning, noon, end of day. the students will measure the temperature of a home room from each corner of the room @ morning, noon , and end of the day, Noteing the average temperature thoughout the day.
2. The average price of a gallon of gas over the course of the last month in Memphis Take the price of a gallon of gas from at least 4 different gas stations in Memphis.
Emily Lowry (Ideas for high school German students)
- Charting city data: The students would chart information about weather, population, founding date, etc for different cities throughout Germany to gain a better understanding of how the country developed.
- Charting vocabulary: The students could list their German vocabulary words and English translations in a spreadsheet and use the sort function to mix up the order so that they didn't only memorize the words in the order presented but learn the words in a context.
- Charting historical information: Students could create timelines based on cultural developments, composers, authors, historical events, etc. This would help them understand the atmosphere of different time periods better. Example
Kelly Wilkerson's Ideas for Student Use of Spreadsheets
1. Students can track how many hours a day they work on homework to get average hours by subject and take averages and totals for week, month, year, make charts with data. Medium difficulty, grades 5 and up. See example here.
2. Have students chart their weekly height and weight and check back at year-end for yearly growth. Easy, best for lower grades (kindergarten +) where rapid growth spurts may occur.
3. Have students make a budget for student council or other extracurricular sport or club. Difficult, best for higher grades (grade 9+).
Veronica Lemock's ideas for student use of spreadsheets
1. Students can make a classroom birthday chart so that everyone will notice when their classmates birthday's are approaching
http://sheet.zoho.com/public/vlemock/untitled-2 example
2. Students can use spreadsheet to keep up with their grades/progress per subject or class that way they will know where they need to improve.
3. Students can use a spreadsheet to chart how much water they are drinking to see if they are drinking the recommended 8 glasses of water per day.
Tina Heindel's Ideas for Student Use of Spreadsheets
1. After studying a nutrition unit, students will create a survey in Word for fellow students on their favorite cafeteria food. After the survey, students compile the data they gathered on the survey and create a graph depicting the survey results.
2. Students will use Excel to map out their "dream vacation" going to six different United States cities. They will graph the mileage driving between the 6 locations. To go even further, the students could compare which student is going the farthest from home, the least far, travelling through the most states, etc.
3. Each student will write down how they spent each hour of a specific Saturday. They will bring in the data, input it into Excel, and then make a pie chart of how they spent each part of their day. Comparisons, contrasts, etc. can be derived from the data. See an example here: [http://public.sheet.zoho.com/public/christina55/24-hr-activities]
Haley Armstrong's Best Ideas for 1st grade
1. Each student will list the days of the week down one side and if it was sunny, cloudy, rainy, or snowy across the other side. They will fill in the cell for the day of the week and what the weather was like.
2. List the name of every student in the class down the row. The title across would be letters in each name and they would then have to fill in the number of letters in each students name. They could then sort ascending or descending. Example http://sheet.zoho.com/public/haley77/untitled
3. List each student's name down the side of the row and across the top have the months of the year. Have the students color code the month of their birthdays. <<<<<<<
Matt Bell's Spreadsheet Ideas
1. Students can use a spreadsheet as an easily editable list of contact information for the other students in the class. Example
2. Students can use spreadsheets to plan their weekly homework schedule. The rows can represent classes or hourly time slots, and the columns can represent the days of the week.
3. Students in a health or physical education class could use a spreadsheet to easily keep track of what they eat each day, and the corresponding nutritional values. The layout and formulas used would be similar to our nutritional spreadsheet activity, but the project would be more relevant for students because it could keep a long-term record of what was actually eaten, rather than just creating hypothetical meals.
Chris Goodell's Spreadsheet Ideas
1. Compare six different local gas stations' prices for Regular Unleaded gasoline, and list the mean, median, and mode price. They can use this exercise to learn about decision making in a consumer capacity, and to learn the mean, median and mode calculations. (example)
2. Find the mean, median, and mode ages of all the students in the classroom. This can be used by the students to learn the concepts of mean, median and mode, as well as demonstrating an example of our classroom diversity.
3. Compare our city's weather for the last six months to the last six months' weather of five of your favorite cities.
Julie Hasuly's Best Ideas for Secondary Math
1.) Students can chart the increase in national population. They can then use this information to estimate the population in some future year, say 2020.
2.) Students can set up a spreadsheet to solve equations by guess and check. They can quickly calculate the different values for their guesses.
3.) Students can use a spreadsheet to analyze the limits of equations as an introduction to calculus. A spreadsheet can quickly and easily calculate the value as the point gets closer and closer to the limit.
4.) Students can analyze two or more situations that can be represented numerically and compare them. An example is, say a video rental store rents movies for $2.95. However, you can pay an annual fee of $20 for a membership. Members pay only $1.50 per video. Here's an example spreadsheet. Students can figure out when one is better than the other, and which one they would choose and why.
My best idea was for a social studies class where students can use spreadsheets to build on information pertaining to different states. For instance, students can learn about things like:
- the state bird
- the state flower
- the sate capital city
- the states rivers
- the states indigenous populations
- the state governor
Margie Christie
JAMEKA SANDERS ROBERTS
1. SPREADSHEETS AND TE SOLAR SYSTEM 2. DINOSAUR SPREADSHEET. NAME 3 DINASAURS THEIR HEIGHT LENGTH AND WHAT CLIMATE THEY LIVE IN
--- Jessica Martin 1. Chart weather patterns for a week 2. Chart population differences among the southern states 3. Create a timeline of the Salem witch trails
Here are several ways you can use spreadsheets in your class.
1.Sort southern and northern states. 2.Multiplication Charts 3.Time lines (Social Studies) 4.List Parts of Speech 5.How I got to school