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

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

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

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:

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