Comments for Oakwood University Faculty Institute

Comment on 2009 Resources by admin

admin — Mon, 10 Aug 2009 17:36:27 +0000

This morning we looked at linear, semi-log, and log-log data displays. We used Gapminder to review global data graphics. In order to better understand how to present and interpret data, our students will need to consider graphical data carefully. They can export data to Excel, but they will benefit from considering how to display their data. Correlations between variables can be examined by looking for relationships.

Here are some of the highlights of the In Class Activity 5a Notes for Excel:

Entering Equations
To graph (a) in Cell B5, type =2*A5^3
To graph (b) in Cell C5, type =2.5*3^A5

To automatically fill a column, select B5 and grab the lower right corner. Drag the box from B5 to B24. Repeat for C5.

Creating a Graph
Select A4 to A24 and B4 to B24.
Go to the Insert tab at the top of the page, then select Scatter from the list of Chart formats.
Select the “Scatter with only Markers” option.
Click on the chart title to select it, then click on it again and select the text (the letter “y”). Type in the new title “Power Function”.

Then repeat for the second equation. After selecting A4 to A24, you will need to hold down the Control key before selecting C4 to C24. Name this new graph “Exponential Function”.

Exploring Functional Relationships
You can view this scatterplots to get a straight line by:
- changing X axis and/or Y axis from linear to log
- fit a trendline to your points by choosing linear, exponential, logarithmic, etc.
- calculating function and R squared values

(a) is a power function
(b) is an exponential function

Now you are ready to examine real data such as Plantain, Monk Parakeets, and the Health Mashup Data.

Comment on 2009 Resources by Oakwood University Faculty Institute » New Focus on Quantitative Reasoning

Oakwood University Faculty Institute » New Focus on Quantitative Reasoning — Fri, 31 Jul 2009 15:18:47 +0000

[...] Dr. Claudia Neuhauser and Dr. Tony Weisstein will be joining us for the first time. We will be using online resources from Gapminder, CDC, WHO, Wolfram Alpha, NCBI, Biology Workbench, and GenBank. You can find these and other resources on the 2009 Resources page. [...]

Comment on New Focus on Quantitative Reasoning by admin

admin — Sun, 26 Jul 2009 18:26:41 +0000

Note: You may wish to review the Cassava module that was submitted in the Project Groups pages.

Comment on Schedule 2009 by Oakwood University Faculty Institute » New Focus on Quantitative Reasoning

Oakwood University Faculty Institute » New Focus on Quantitative Reasoning — Sun, 26 Jul 2009 18:16:28 +0000

[...] Schedule 2009 [...]

Comment on Protected: Drs. Otieno, Schmidt & Patel by Onesimus

Onesimus — Fri, 12 Jun 2009 13:13:24 +0000

Comment on Protected: Drs. Penrod, Randriamahefa & Smith by Shushannah

Shushannah — Thu, 11 Jun 2009 02:28:59 +0000

Comment on Protected: Project Help by Shushannah

Shushannah — Thu, 11 Jun 2009 02:27:18 +0000

Comment on Malaria Problem Space by dcp511

dcp511 — Fri, 27 Feb 2009 18:40:39 +0000

Really good read, nice to read a good blog at last!

Comment on Protected: Drs. Penrod, Randriamahefa & Smith by alexandrine

alexandrine — Sun, 15 Feb 2009 22:26:04 +0000

Comment on Protected: Drs. Penrod, Randriamahefa & Smith by Ravina

Ravina — Tue, 21 Oct 2008 14:22:01 +0000