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

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, d_p= 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 R² 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

Our Service Charter

1. Professional & Expert Writers: School Assignment only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by School Assignment are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. School Assignment is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At School Assignment, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.