Four to five sentences per video should suffice -- I should be convinced you watched the videos.
Due: Nov. 25
Monday:
Lab 21A. HCl Spectra uses HCl.xls (Don't just read
through it -- work through it)
Lab 21B. Extract and open the Excel file in AminoAcid.zip. Go to
the Data tab. Click on Sort. Specify (check) that the data has headers. Then sort the data
on two fields (simultaneously) -- first the Hydrophobocity Designation, then the name.
Also go to the Page Layout tab, go to the Page Setup dialog, make the orientation Landscape and
make sure the data is fit onto one page. Also add a custom header that includes your name.
(These will be easy points on the final but be sure you know what I want.)
Lab 21C. Use Excel to generate 500 random wind speeds between 74 and 200 miles per hour. Then look up the Hurricane
Classification system and create a VLookup that will determine the category of those values.
Lab 21D. Use the Excel CONVERT function to find how many:
grams in 1 ounce
meters in 1 mile
seconds in 1 year
Pascals in 1 atmosphere
dynes in 1 Newton
calories in 1 Joule
Watt-hours in 1 BTU
teaspoons in 1 cup
liters in 1 gallon
Due: Nov. 25
Wednesday:
Test 3 It covers Labs 14 - 18.
Excel
Fitting to functions not automatically provided by Excel (e.g. charging capacitor, Lorentzian peak)
Latitude-Longitude (uses mixed absolute addressing -- B7 versus $B7 versus B$7 versus $B$7)
R
Fitting data to non-linear functions (power-law, exponential, polynomial)
