5th Grade Comparing Virginia Rivers

Fifth graders at Laburnum Elementary have been reviewing the rivers of Virginia (VS.2c) and watersheds (SOL4.9) in Social Studies and Science. They have also been multiplying decimals in Math (SOL5.5a). So today students in Mr. Hofilena’s class used those skills to compare Virginia Rivers. First we discussed ways to compare the rivers. Everyone agreed that we should compare the length, but I also suggested comparing the discharge. Discharge is the amount of water flowing through the river, measured in cubic feet per second. We discussed factors that influence discharge: river depth and width, rainfall, and the velocity of the current. Next I gave them a Google Sheets template that you can copy here. The students had to do their own research to find the length and discharge for each river (Google “River name length” and “River name discharge”). They entered the data into the correct cells on the spreadsheet (using only numbers, no units). Then I showed them how to highlight the data and analyze it using the new “Explore” button in the bottom right corner. We used the Insert Chart button (top toolbar) to create graphs of the data. It was interesting to see how the length compared with the discharge. For example, the Rappahannock River is almost 6 times the length of the York, but its discharge is only 1.5 times that of the York. What does that tell us about the two rivers? We didn’t have time to do further comparisons, but I’ve added them to the template. You could convert the discharge to gallons per second with a formula (CELL*7.48052) then convert that to bathtubs per second (the average bathtub holds 40 gallons) to help students visualize it better. You could also figure out how long it would take to drive the length of the river by dividing the total miles by 60 (assuming you are driving 60 MPH). You could even compare the rivers using the York as the unit. Take a look at a sample here.

This entry was posted in 5th Grade, graph, Math, Science, Social Studies, spreadsheet. Bookmark the permalink.