3.14 - Pre-Lab Spreadsheet Set-up

3.14 - Pre-Lab Spreadsheet Set-up

Monday, December 7, 2020

Agenda

• Review of pre-lab calculations

• Spreadsheet set-up

Multiple Choice

What concentration of FD&C Blue #1 will yield an absorbance of 1 at 629 nm?

• 1 x 10^-6 M

• 1 x 10^-5 M

• 1 M

• 100,000 M

Open Ended

What concentration of FD&C Blue #1 will yield an absorbance of 0.1 at 629 nm?

Open Ended

What volume of stock solution will you need to dilute to 25.0 mL to make a standard with a concentration of 1 x 10^-5 M Blue #1?

Open Ended

What volume of stock solution will you need to dilute to 25.0 mL to make a standard with a concentration of 1 x 10^-6 M Blue #1?

Learning Objectives

• Set up a data table in Google sheets

• Use formulas in Google sheets for calculated cells

• Generate and format an x-y scatter plot in Google sheets