CSC 152: The Week beginning Dec. 7

Homework:

NONE.
Monday:

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
Enter the numbers 0, 1, 2, 3, ... , 360. Use the Excel RADIANS functions to convert degrees to radians. Then use the formula DEGREES to convert those radian values back to degrees.

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.
Wednesday:

The final for the 2:00 section is on Monday at 2:00
The final for the 3:30 section in on Wednesday at 2:00

Calculation.xls Calculate the students' homework average, lab average, test average (with a drop test). Calculate the weighted average for their overall average. Use VLOOKUP to assign a letter grade.

Make a PowerPoint presentation that includes at least two screen captures that explains how to compress a folder and how to uncompress (extract the files from) a folder.