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 

Wednesday, March 5, 2014

COSMOS: A SPACETIME ODYSSEY | Q&A Event with the COSMOS Brain Trust (March 4, 2014)

Session with COSMOS host Neil deGrasse Tyson, writer/executive producer/director Ann Druyan, executive producer Seth MacFarlane, executive producer Mitchell Cannold, executive producer/director Brannon Braga and co-executive producer Jason Clark

Wednesday, February 19, 2014

Engaging with Social Media | AAAS 2014 Meeting in Chicago

Presenters: Maggie Koerth-Baker (, Kim Cobb (Georgia Institute of Technology), and Danielle N. Lee (Cornell University)

Moderator: Dominique Brossard (University of Wisconsin)

Thursday, February 13, 2014

A Valentine's Day greeting to my biotech students

Happy Valentine's Day in a DNA profiling way...

Source: Mental Floss

And show your love for microbes...

And don't forget your #AcademicValentines!

Valentine's Day and a long holiday weekend - woohoo!

Thursday, February 6, 2014

Community Colleges as "Democracy's College"

An excellent conversation on Boston's WBUR On Point radio show with three community college leaders:

Pam Eddinger, president of Bunker Hill Community College
Bruce Leslie, chancellor of Alamo Colleges
Paul Brown, president of the Zane State College in Zansesville, Ohio

The three educators highlight the importance of community colleges for our nation.

Here's a sampling of some points from the show:

The audio and show notes are available for this program.

Monday, January 20, 2014

Some kind words about the ARC Accreditation Quiz Show at Convocation #ConvoARC

For the January 2014 ARC Convocation we used PollEverywhere to create an interactive, audience participation Quiz Show to kick-off the 2015 ARC Accreditation campaign. 
Interim President Pam Walker opens the Convocation.

During the Accreditation Quiz Show:

To answer the Quiz Show questions, the audience used their cell phones or other digital devices to enter the responses, which are displayed live. On the days leading up to Convocation, we emailed a series of survey questions to answer in order to get familiar with PollEverywhere.

And this is the question that everyone is talking about... 

Wednesday, January 15, 2014

Accreditation Kick-Off: Poll Everywhere for Friday Convocation

ARC's Accreditation is coming! We have a kick-off event at Friday's Convocation that features Poll Everywhere to do live audience polling. All you need is a web-enabled device (tablet, smartphone, computer) or a cell phone that can text...

So don't forget to bring your favorite mobile device on FRIDAY!

To get ready, there are a series of practice polls for you to try before Convocation.

First poll question: 

Do you ever use the Internet for Facebook?

You can use either a cell phone or web-enabled device to answer.

1. To answer the question on a cell phone, text to 22333 one of the responses below:

389821 for "Have done this"

389822 for "Have not done this"

389823 for "Don't know"

2. To answer the questions on a web-enabled device, just go to  and click on your answer.

For more instructions on how to respond using Poll Everywhere, here is a handout

Added notes:
Did you know that you can use Poll Everywhere with your classes? If you're interested, you can sign up for your own account and create your own polls for your students. Here's the easy user guide to get started:

Example: A poll from one of my classes