Select Page

## GEOL 388 West Virginia University Aqueous Systems Worksheet Answering the questions in the word document and complete the excel sheet. The red columns in t

GEOL 388 West Virginia University Aqueous Systems Worksheet Answering the questions in the word document and complete the excel sheet. The red columns in the excel sheet is what needs filling. Assignment #4 Aqueous Systems
GEOL 388 Spring 2020
DUE Friday 4/24/20. E-campus
Please review the guidelines regarding graphs & spreadsheets (orange handout from earlier in
the semester – also found on eCampus). Unless noted otherwise, all calculations should be done
Turn in copies of your spreadsheet tables & graphs along with your hand calculations.
For this assignment you will use data from central PA springs (we reviewed some of the graphs in class) to do
some basic calculations, make graphs, and interpret geology and chemistry.
1. Download the excel spreadsheet of data for the 5 springs and save it with file name
LastName_Assign4excel_GEOL3882020
2. Example Hand Calculations: For Tippery Cave on 12/15/67 do the following calculations by hand:
a. Ca and Mg concentrations in mol/L
b. Alkalinity in mol/L HCO3c. Hardness as mg/L CaCO3
d. Ionic Strength
e. Ca/Mg Molar Ratio
f. logPCO2 – see notes at end of this document
3. Excel Calculations:
a. On the spreadsheet, complete the calculations for all springs on all dates. I’ve set up the sheet for
you, you simply need to enter the equations and drag down. Be sure to pay attention to significant
figures.
4. Graphs:
a. Plot hardness (y-axis) as a function of IS (x-axis) and fit a trend line through the data.
b. In 1-2 sentences, explain the relationship between hardness and IS.
c. Plot hardness as a function of Ca/Mg molar ratio, give each spring a different symbol.
d. What are some connections you may between Ca/Mg ratio and hardness? Are any of the springs
more likely to be dominated by calcite or dolomite?
e. I’ve given you the saturation indices for calcite and dolomite, graph each as a function of logPCO2.
f. What relationship (if any) do you see? Are any springs undersaturated or oversaturated? How do
you know? What does this mean?
5. Redox: Please balance the following redox reactions.
. 2 + 3 4 ⇔ ( )3
. 2 + 2 ⇔ 3+ + 4
1
. 4 − + ( )2 ⇔ 2
. ⇔ 2 − + 2
. 2 7 + 3 2 ⇔ 3+ + 3 2
TO TURN IN
1. A single document (PDF preferred but Word ok if you can’t convert) named
“LastName_Assign4_GEOL3882020” – we’ve been through this naming thing a lot. I don’t want to send
work back. Again. Make sure your document is in THIS LISTED ORDER. This is important. A grade
penalty may be enacted if your work is too disorganized to read.
• Your hand calculations for 1a – 1f. Please neatly label each question, ie: 1a. Ca molar
concentration; Mg molar concentration; 1b. Alkalinity and so on.
• Graph of 4a plus the answer to the question. Please label it 4a,b.
• Graphs for 4c plus the explanations. Please label it 4c,d.
• Graphs for 4e (2 graphs) plus explanation/answer to questions. Please label it 4e,f.
• Your step-by-step solutions to 5a-d. Please label each question appropriately.
2. Your excel spreadsheet with your work named in the way I described above.
So to review, you’re turning in 2 DOCUMENTS. Document 1 is all of your work/answers; document 2 is the
Useful Equations and Notes:
Alkalinity: 1 meq alk = 61 mg/L HCO3-
= 50,000 ([ ] + [ ] )
1
= Σ[ ] 2
2
2 =
[ + ][ 3− ]
[ 1 ][ 2 ]
But remember I asked for log PCO2…
Since this is real-life data, the K1 and KCO2 from the notes won’t work because those values are for ~25C. Let’s
assume an equilibrium temp of 10C, in that case K1 = 10-6.46 and KCO2 = 10-1.27
2
Spring
Arch Spring
Near Tippery
Rock Spring
Spruce Creek
Tippery Cave
Arch Spring
Near Tippery
Rock Spring
Spruce Creek
Tippery Cave
Arch Spring
Near Tippery
Rock Spring
Spruce Creek
Tippery Cave
Date
4/10/1967
4/10/1967
4/10/1967
4/10/1967
4/10/1967
7/26/1967
7/26/1967
7/26/1967
7/26/1967
7/26/1967
12/15/1967
12/15/1967
12/15/1967
12/15/1967
12/15/1967
Temp, C
8,70
9,00
7,80
10,40
9,00
12,90
9,80
12,30
10,40
11,40
6,90
8,10
6,80
10,20
7,60
Ca2+, mg/L
24,8
36,4
23,4
44,8
36,8
33,4
46,4
26
45,3
38,4
33,4
36
29,2
47
34,2
Mg2+ mg/L
7,3
8,5
4,2
23,3
2,9
7,3
9,9
2,9
23,2
2,9
8,6
7,5
4,4
23,1
2,6
HCO3- mg/L
82
120
65
208
98
115
190
74
209
109
111
117
84
214
92
pH
7,62
7,64
7,34
7,87
7,53
7,27
7,38
7,14
7,62
7,35
7,72
7,52
7,52
7,99
7,62
[H]+
Ca 2+ mol/L
Mg2+ mol/L
Alk mol/L HCO3-
Hardness
Ionic Strength
Ca/Mg Molar Ratio
log(PCO2)
SIC
-5,40E-01
-1,88E-01
-9,46E-01
3,71E-01
-3,81E-01
-6,41E-01
-1,43E-01
-1,04E+00
1,28E-01
-4,96E-01
-1,79E-01
-3,24E-01
-5,58E-01
5,22E-01
-3,50E-01
SID
-1,50E-01
-9,00E-01
-2,53E+00
5,66E-01
-1,76E+00
-1,78E+00
-8,49E-01
-2,93E+00
-7,28E-02
-2,01E+00
-8,40E-01
-1,22E+00
-1,83E+00
-8,43E-01
-1,71E+00
Assignment #4: Revised Redox
5a. New Problem
Fe2+ + Mn04
Fe3+ + Mn2+
5e. New Problem
Cr20,2- + HNO2 Cr3+ + NO3-

Pucat att
16 words
English (United States)
Focus
MacBook Air

Purchase answer to see full
attachment