Lecture2_In_Class_Exercise

1. Task 1: Plot X and X^2
Type 'x' and 'x^2' as the names of the two columns. Then type '1' as the starting value


Use your mouse to drag (Press ctrl on your keyboard when you drag it) the right bottom corner of the cell until 16. So you 'autofill' the cells with numbers of 1-16.


Like this:


Then start autofill the column of 'X^2'. Select the first cell, and type the equation in the cell or in the function block above, then press 'Enter' on your keyboard.


Once the first result is done, drag it to autofill all the corresponding 'X^2'. This time, you don't need to press 'Ctrl'. You should see the following:


Go to 'Insert', insert a plot panel 'Line with Markers'.


Right click the empty area of the plot panel, go to 'select data', then click the marked button below and use your mouse to select the column of 'X^2'.

Like this:


Press 'Enter' to plot the data. Click the 'Cross Sign' on the top right of the plot panel, check the options shown in the figure below. Change the corresponding Axis titles and the title for the figure.


2. Task 2: Plot sinx and cosx. In this task, you will create a column of data called 'degree', then use excel to calculate and autofill the 'Radian', the 'Sinx', and the 'Cosx' of the degrees.

Autofill the degree first. You noticed that the increment of the steps are 10 degrees. You need to change the 'autofill' properties in the following options: Home-Fill-Series.


Change the 'Step Value' to 10, 'Stop Value' to 360.


Then autofill the radians. The equation to acquire the radians are:
Radian=degree*3.14159*2/360


Autofill Cosx and Sinx use the similar method. The only differences are the functions:




Insert two figures and plot the Sinx and Cosx in the two separate figures.
Make sure the axis label is in the middle. See instructions below to do this:



Change the Axis titles and the figure titles.

3.
Task 3: Plot the trajectory of the Cannon problem.
Create a column for 'delta t'. Notice the step size is 0.1 now, use the method mentioned above to change the step size.



Autofill column 'h' and column 'x', which are the height and the horizontal travel distance of the ball.
The example functions can be found below. Note that the '$ Sign' is used to freeze the constant from being changed when you doing the autofill. (Do not directly type what I had in the 'function block'. The location of your constant for '35 degrees', '10 m/s', and '9.81 m/s/s' probably are different).

'RADIANS()' is the built-in function to convert 'degrees' into 'radians'.


Then autofill the horizontal 'travel distance':


Plot h and x in one plot to show the trajectory:


4. Task 4: Change the initial degree, autofill all the data and plot them in the same figure: ('t' is created/autofilled first):


Plot 'x' and 'y' using the functions shown in the following figures:




Plot multiple lines in one figure by adding new series. Like this:


Complete all the tasks above in ONE excel file. Use different worksheets to separate these tasks.

Send your excel file (along with your HW2) to homeworkflc02@gmail.com

Due Monday