Excel homework #1- Basic Skills DUE: Thursday, Feb. 11

READING: Scan chapters 1,2, and 3 of your Excel textbook. Most of this material was covered in last week's training sessions.

PROBLEMS: From your book, solve (1)3.8,(2)3.12, (3)3.15. Submit plots and spreadsheets via e-mail AND hard copy using the format described below.

(4) Create the following spreadsheet and submit by the last class period next week.

Solve the following equations:

Where A_x is 10 meters, A_y is 10 meters, w is 5 rad / s, and c = 0.5. Use a time interval of 0 to 7 seconds with a 0.25 second increment. A_x, A_y, w , c, and the time increment must all be referenced blocks (equations reference a cell with the appropriate value). These values must also be identified and have appropriate dimensions. Your output columns must also be labeled and dimensioned.

Determine the polar coordinates for each point. R in meters, q in degrees.

Note: you will have to make sure angles greater than 180° are displayed as such.

Determine the average, median, standard deviation, maximum, and minimum for X, Y, and R. You may use Excel internal functions to compute each of the above quantities.

Create two plots: One of X and Y vs. time, the other of X vs. Y. All plots are to have appropriate labels and be plotted full size (print plot separately, NOT as a spreadsheet window).

Print out plots and spreadsheet. All data should fit on one page along with your name, section, etc. Print Row and Column headings on the sheet along with the grid lines. Finally, e-mail me your excel file: IT MUST HAVE THE FOLLOWING FORMAT FOR CREDIT. File name should carry the first 6 letters of your last name, then the first letter of your first name, then a 1 (for first assignment), the a - followed by the problem number, then .xls. So Joe Student's file for problem 4 above would be named StudenJ1-4.xls This file name should also appear at the top of your print out that you submit in class.

The following is an example format: