Lab 2: Spreadsheets: Microsoft Excel, computer science homework help

Lab 2: Spreadsheets: Microsoft Excel, computer science homework help

Lab 2:  Spreadsheets: Microsoft Excel

I. Videos

At least one of following videos should be watched on Blackboard before your 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 is at: 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 have questions about using Microsoft Excel, you could search YouTube (or otherwise Google) for more how-to videos. This site:

https://www.youtube.com/user/simonsezittraining

has a good set of tutorials for all Office products.

II. Assignment

This assignment should be submitted in an Excel file (Lab02_LastNameFirstInitial.xlsx) to Blackboard with four separate tabs, each corresponding to one question. The tabs should be labeled accordingly and should include a presentation of the raw data as shown in each question and of the graphics and information requested.  Be sure to include any explanations as necessary (for example, what features of Excel were necessary to 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 labeling and should be visually attractive while informative. The original tabular data should also be attractively presented.

Question 2.

Graph the following income data using a column graph.  As with the above graph, this graph should have a title, appropriate labeling and should be visually attractive while informative. The original tabular data should also be attractively presented.

Question 3.

Create a table showing the relationship between D and V for the following values: d = 0.25, n = 2, dp = 0.5, C = 5, and q = 45°, using the relationship shown below.  Remember that you must convert to radians when using trigonometric functions in Excel.  Also, create an xy plot of this relationship.  Make sure to include appropriate 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 the equation 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