ZZZ+Engineering+Computing+lab

=In addition to the Excel Help (?) function, try the website [|www.excelfunctions.net] for help!= =**LAB #1: Complete by TUESDAY SEPTEMBER 7, 2010:**= Go through the TUTORIAL for Microsoft Excel entitled:

Demo: Up to speed with Excel 2007
You can find this TUTORIAL by bringing up Excel 2007. You MUST use a computer with audio capabilities! With Excel 2007 open on your computer, click on the question mark button (?) in the upper right hand corner of your screen. Select the video entitled "Demo: Up to speed with Excel 2007" After you watch the video, scroll down to the ONLINE TRAINING and in the UP TO SPEED WITH EXCEL 2007 select the TEST YOURSELF option. After you have completed this option, email me to tell me that you have finished; tell me HOW MUCH TIME the video took, how you did on the TEST YOURSELF, and tell me AT LEAST three things you learned.

=LAB #2: Complete by TUESDAY SEPTEMBER 14, 2010:= Go through the following two Microsoft charting items entitled:

Charts I: How to Create a chart in Excel 2007 (Online Course)
Both are accessible from the question mark button (?) in the upper right hand corner of your screen. After you have finished, select the TEST YOURSELF option in **Charts I: How to Create a chart in Excel 2007 (Online Course**) After you have completed both, items and the TEST, email me to tell me that you have finished; tell me HOW MUCH TIME the items took, how you did on the TEST YOURSELF, and tell me AT LEAST three things you learned.

=﻿LAB #3: Complete by TUESDAY SEPTEMBER 21, 2010:= Conduct an internet search for data in a technical field of interest to you that can be graphed by Excel. Step 1.Find a data set (or sets) of a size that would be difficult to enter by hand (50 or more data points). Step 2. Download the data, and directly enter them into Excel. Step 3. Prepare a graph in Excel that follows engineering graphing standards, as discussed in class. Step 4. Explain and interpret the data; include an equation of a good trendline through the data. Step 5. Reference the source of your data.

=﻿LAB #4: Complete by TUESDAY SEPTEMBER 28, 2010:= In irrigation systems, a weir is used to measure the flow rate of water in an open channel. Different shaped weirs measure flow rate differently based on the geometry of the weir. For a rectangular weir the expression can be written: Q = 288.8LH^1.5 where Q= Discharge (flow rate) in gal/h L= length of weir opening parallel to liquid, inches H= height of fluid above crest, in inches USING EXCEL do the following problems...if you are unfamiliar with irrigation systems, it may be helpful to find a picture of a rectangular weir on the internet and read about how they work. a. As the channel becomes larger,what constant would be required to express Q in cubic feet per second instead of gal/h? b. Prepare a spreadsheet resulting in tables of values of Q in both of these units, with L and H in inches. Use values of L that range from 1 to 16 inches in one inch increments and let H range from 2 to 32 in two-inch increments. =﻿LAB #5: Complete by TUESDAY OCTOBER 5, 2010:= 1. Read the following essay from American Scholar: @http://webboard.northwestcollege.edu:2048/login?url=http://search.ebscohost.com/login.aspx?direct=true&db=aph&AN=51389391&site=ehost-live&scope=site (if you are not able to access this link, EMAIL ME and I will send the article to you directly) 2. Read the following article from Newsweek: [] 3. OPTIONAL:Find and watch THE LAST 20 MINUTES of the episode of Bill Maher including a panel discussion of the Newsweek article referenced above, if possible: much of the content of this episode may be offensive to you, and I am ONLY interested in having you watch the last 20 minutes after Ann Druyan joins the panel. I am NOT asking you towatch the first 40 minutes of the episode at all. If the content is offensive to you, don't watch it 4. Write a paper that compares and contrasts these two or three views of the issue; express your opinions in a well reasoned fashion based on scientific reasoning. =﻿LAB #6: Complete by TUESDAY OCTOBER 12, 2010:= From the data given for homework set #7 (problem 6.6 in the text book) use EXCEL to create a histogram showing the distribution of this data. =﻿NO LAB DUE TUESDAY OCTOBER 19, 2010 because of midterms...=

**﻿LAB #7: Complete by THURSDAY OCTOBER 28, 2010:**
=**﻿NO LAB DUE TUESDAY November 1, 2010 because of class time devoted to ENGINEERING ETHICS...**=
 * Do the Independent Challenge 1 on the last page of the Planning a Macro handout that Lori Austill gave us in class.....**