Saturday, May 10, 2014

Amylase lab: How to make an Excel graph

Jennifer, the Excel whiz student in BIOT312, demonstrated during class how she constructed a graph in Excel using her maltose data set from the amylase laboratory experiment.
1. This is a sample data set from absorbance measurements from various maltose standards.

2. To create a graph, select the maltose data in the table. Then go to Insert in the Excel menu and choose the Scatter plot (points only) as shown in the screenshot

3. The graph appears on the Excel sheet

4. Modify the graph title and delete the graph legend if desired.

5. To insert a trendline, right-click a data point and select the Add Trendline menu item.

6. Choose the desired options for the trendline. In this example: Linear trend, Set Intercept = 0, and Display Equation on chart.

7. This is the graph with the trendline. Drag the equation to a better location if desired.

8. The next task is to the use the trendline equation to determine the maltose level (mg) from absorbance measurements in the test samples. The test sample in the example below has an absorbance = 0.763.

9. Use the trendline equation to calculate the maltose level. You can use Excel to perform the calculation.

10. This example adjusts the resulting number to contain to two decimal places.

11. To add this data point to the trendline, right-click the trendline in the chart and choose Select Data in the menu.

12. Choose Edit in the pop-up window to add more data points to the graph

13. Extend the series of data point by changing the cell value in the Series X values and Series Y values. $A$7 in the X value and $B$7 in the Y value extends the data set to include the test sample.

14. Result: The graph has the new data point included.

Wednesday, April 30, 2014

Video in Progress: One night in BIOT312 with Stevenson Media

Stevenson Media visited the evening BIOT 312 lab class to work on a new American River College video project to promote Career Technical Education (CTE) programs. We captured some of the classroom fun on Twitter.

Fish protein profiling lab 

Phage and PAGE

Saturday, April 5, 2014

My presentation proposal for LRCCD Innovate 2014: Feedly and Pocket

I submitted a presentation proposal for LRCCD Innovate 2014. Below is a short bio and session description for the proposal. I did a presentation on Twitter at LRCCD Innovate 2013 and decided to pursue a different topic this year.

Short Bio (This bio will be included in the conference schedule. Please aim for no morethan 4-5 sentences.)
Ken Kubo teaches biotechnology at American River College and works with the North Valley Biotechnology Education Collaborative, a program for biotechnology outreach to regional high schools and community colleges. Ken is also the Faculty Co-Chair for Accreditation at ARC.  A social media enthusiast, Ken experiments with this technology in the classroom - follow him on Twitter at @kmkubo.

Title of your presentation
Manage Web Information Overload with Feedly and Pocket

Session description (Please describe your program as you would like it to appear in our conference materials. This should be no longer than 4-5 sentences and in paragraph form.)
Do you feel overwhelmed by the news and research resources on the web? The news aggregator Feedly and save-for-later service Pocket may be your solution for information overload. After attending this session, you will learn how to set up and use your own Feedly and Pocket accounts to find and manage web materials for classroom use and professional development. 

How will students or the college benefit? How does your presentation support student success or organizational effectiveness, either directly or indirectly?
After completing this session, participants will be able to find and save current relevant web articles and resources for professional development and classroom use to foster critical thinking and lifelong learning.

Monday, March 24, 2014

Some ARC Biortechnology Data

The ARC Biotechnology Program and North Valley Biotechnology Center is collecting data about its biotechnology education activities. Some data is compiled here:

Student survey data

Thursday, March 13, 2014

A Twitter Office Hour

I did not expect this, but today I had a Twitter Office Hour!

Another question:

And still more questions:

Nevertheless, test anxiety still remains...

But a teacher can always be hopeful...

Monday, March 10, 2014

Your perspective needed! Los Rios Community College District Employee Perceptions Survey

The Los Rios Community College District is now conducting its Employee Perceptions survey. Check your campus email for a message from Betty Glyer-Culver (District Office) with a link to the online survey.

The survey is confidential and easy to complete. It doesn't take much time to answer the survey questions, and with the myriad of issues facing our college and district, your perspective is important.

Here are examples of the questions

And I like the opportunity to provide comments at the end to explain my ratings.
Comments: Please use the box below to clarify any of your responses to the questions above and to add any comments that you believe reflect other important information about how the District is doing or about your level of satisfaction as an employee of Los Rios Community College District.

Disclosure: Because I am involved in the ARC Reaffirmation of Accreditation process, the college also needs your perspectives to help us with the Self-Evaluation Report. So please participate!

Why you should watch COSMOS

March 9 was the world premiere for the new COSMOS series with Neil deGrasse Tyson. In case you missed the episode, you can watch the first episode now on Amazon Instant Video

And you can view the episode online at COSMOSOnTV...I'm watching the episode here on FOX

Some reasons why I like COSMOS:


Explore the Universe

Science and Religion

Some other views on the COSMOS coverage of Church history