Lab 2: Spreadsheets: MicrosoftExcel
I. Videos
At least one of following videos should be watched on Blackboard beforeyour lab period:
1. Introduction to the Excel User Environment. http://bit.ly/1NaGbzg
2. Formulas. https://www.youtube.com/watch?v=wqn7mxR2Xpk Additional information on formulas isat: https://www.youtube.com/watch?v=-kNiQGgTYK4 and https://support.office.com/en-us/article/Overview-of-formulas-in-Excel-ecfdc708-9162-49e8-b993-c311f47ca173
3. Functions and Graphs. https://www.youtube.com/watch?v=DM52xjSLGqs
Note that if you still havequestions about using Microsoft Excel, you could search YouTube (or otherwiseGoogle) for more how-to videos. This site:
https://www.youtube.com/user/simonsezittraining
has a good set of tutorials for allOffice products.
II. Assignment
This assignment should be submittedin an Excel file (Lab02_LastNameFirstInitial.xlsx)to Blackboard with four separate tabs, each corresponding to one question. Thetabs should be labeled accordingly and should include a presentation of the rawdata as shown in each question and of the graphics and informationrequested. Be sure to include anyexplanations as necessary (for example, what features of Excel were necessaryto get the job done?).
Question 1.
Graph the following enrollment data using a pie chart. Be creative with your pie chart. It should have a title, appropriate labelingand should be visually attractive while informative. The original tabular datashould also be attractively presented.
Question 2.
Graph the following income data using a column graph. As with the above graph, this graph shouldhave a title, appropriate labeling and should be visually attractive whileinformative. The original tabular data should also be attractively presented.
Question 3.
Create a table showing the relationship between D and V forthe following values: d = 0.25, n = 2, dp = 0.5, C = 5, and q = 45°, using the relationship shownbelow. Remember that you must convert toradians when using trigonometric functions in Excel. Also, create an xy plot of thisrelationship. Make sure to includeappropriate titles, labels, etc., and to make everything visually pleasing.
Question 4.
Using the rainfall data shown in the table shown below,create an xy plot then find a trendline that works best. You should submit your plot and theequation and R2 of your trendline.
III. Rubric
a) Watched at least one of the videos 5
b) A separate tab included for each problem 8
c) Input data and output data are both included 8
d) Accurate 8
e) Aesthetically pleasing 8
f) File named Lab02_LastNameFirstInitial.xlsx- 3