WEBVTT

00:00:07.570 --> 00:00:09.550
We are going to learn about an experiment

00:00:09.550 --> 00:00:11.610
conducted by Dr. Keenan Amundsen,

00:00:11.610 --> 00:00:13.200
who is an associate professor

00:00:13.200 --> 00:00:16.020
at the University of Nebraska-Lincoln.

00:00:16.020 --> 00:00:18.930
And so here are the learning objectives for the lessons,

00:00:18.930 --> 00:00:21.760
and I'm not gonna go over each objective with you,

00:00:21.760 --> 00:00:24.090
but I do suggest taking the time to read them,

00:00:24.090 --> 00:00:26.710
so you are prepared and aware of what the lessons

00:00:26.710 --> 00:00:27.913
will be focusing on.

00:00:29.230 --> 00:00:30.630
So there will be two lessons

00:00:30.630 --> 00:00:34.620
that go with Dr. Amundsen's buffalograss greenup project.

00:00:34.620 --> 00:00:36.910
For this first lesson, we're going to learn

00:00:36.910 --> 00:00:39.520
about the buffalograss greenup project.

00:00:39.520 --> 00:00:41.890
We'll view a small section of the plots,

00:00:41.890 --> 00:00:42.940
and we'll score those

00:00:42.940 --> 00:00:46.260
using the National Turfgrass Evaluation Program,

00:00:46.260 --> 00:00:48.210
also called NTEP.

00:00:48.210 --> 00:00:51.110
And then we use NTEP scoring data to create a table

00:00:51.110 --> 00:00:52.633
and bar graph in Excel.

00:00:54.290 --> 00:00:56.600
So here's Dr. Keenan Amundsen.

00:00:56.600 --> 00:00:57.960
And as stated before,

00:00:57.960 --> 00:00:59.510
he is an associate professor

00:00:59.510 --> 00:01:02.310
at the University of Nebraska-Lincoln,

00:01:02.310 --> 00:01:05.070
and he specializes in turfgrass genetics.

00:01:05.070 --> 00:01:07.180
His primary research objective

00:01:07.180 --> 00:01:10.900
is to develop improved cultivars of buffalograss.

00:01:10.900 --> 00:01:12.620
And so the buffalo greenup project

00:01:12.620 --> 00:01:15.650
was conducted to find a genotype of buffalograss

00:01:15.650 --> 00:01:17.940
that greens up earlier in the spring,

00:01:17.940 --> 00:01:20.253
and stays green longer into the fall.

00:01:21.853 --> 00:01:23.940
Buffalograss being a warm season grass

00:01:23.940 --> 00:01:25.510
is a popular turf choice,

00:01:25.510 --> 00:01:27.600
because it doesn't go dormant in the summer,

00:01:27.600 --> 00:01:29.800
and it's also drought tolerant.

00:01:29.800 --> 00:01:31.440
So you can see in the summer,

00:01:31.440 --> 00:01:33.140
our buffalograss is green,

00:01:33.140 --> 00:01:34.640
while our cool season grasses

00:01:34.640 --> 00:01:37.210
like the tall fescue is dormant.

00:01:37.210 --> 00:01:38.610
And so in the spring and fall,

00:01:38.610 --> 00:01:40.550
our buffalograss is dormant,

00:01:40.550 --> 00:01:44.273
while our cool season grasses like tall fescue are green.

00:01:45.660 --> 00:01:48.307
So here is the buffalograss research area,

00:01:48.307 --> 00:01:52.170
and it consisted of 192 different plots.

00:01:52.170 --> 00:01:56.780
And the buffalograss was planted on June 12th, 2012,

00:01:56.780 --> 00:02:01.360
but data was not recorded until the spring of 2014.

00:02:01.360 --> 00:02:03.590
And this was to simply allow the buffalograss

00:02:03.590 --> 00:02:05.203
time to establish.

00:02:06.330 --> 00:02:09.140
So there were 192 different plots,

00:02:09.140 --> 00:02:12.090
however, only 64 genotypes were used.

00:02:12.090 --> 00:02:15.650
And so there was in each repetition one, two and three,

00:02:15.650 --> 00:02:19.020
the same 64 genotypes were planted.

00:02:19.020 --> 00:02:21.160
And they were planted at random.

00:02:21.160 --> 00:02:24.150
So in each rep they were in a different location,

00:02:24.150 --> 00:02:28.180
and we will look at some examples of those in lesson two,

00:02:28.180 --> 00:02:31.190
and this was to avoid problems with the slope, soil,

00:02:31.190 --> 00:02:33.563
and other environmental factors.

00:02:35.060 --> 00:02:39.890
So to start, we're going to look at just these 15 genotypes

00:02:39.890 --> 00:02:42.880
that are in this red box for repetition one,

00:02:42.880 --> 00:02:45.830
so we can start turning this visual data

00:02:45.830 --> 00:02:47.483
into numerical data.

00:02:48.530 --> 00:02:51.290
So the National Turfgrass Evaluation Program,

00:02:51.290 --> 00:02:54.890
which from now on we'll just refer to as NTEP,

00:02:54.890 --> 00:02:58.690
is the most widely known turfgrass evaluation program

00:02:58.690 --> 00:02:59.750
in the world.

00:02:59.750 --> 00:03:02.180
And NTEP provides growers with guidelines

00:03:02.180 --> 00:03:04.030
on how to rate turfgrass.

00:03:04.030 --> 00:03:05.800
So for the buffalograss project,

00:03:05.800 --> 00:03:07.520
we're gonna look at spring green-up,

00:03:07.520 --> 00:03:09.900
and that's on a rating of one to nine,

00:03:09.900 --> 00:03:12.820
one being straw brown and nine being dark green.

00:03:12.820 --> 00:03:13.840
And so in the fall,

00:03:13.840 --> 00:03:16.440
we want this seasonal color retention,

00:03:16.440 --> 00:03:19.550
which is also on a scale of one to nine,

00:03:19.550 --> 00:03:22.683
one being straw brown and nine being dark green.

00:03:24.940 --> 00:03:28.470
And so as stated before, here is that small section

00:03:28.470 --> 00:03:31.330
for the repetition that I showed you.

00:03:31.330 --> 00:03:34.050
So it's just that, I've just enlarged it.

00:03:34.050 --> 00:03:35.890
And this is what we're going to use

00:03:35.890 --> 00:03:40.023
to apply the NTEP evaluation guidelines on.

00:03:41.240 --> 00:03:45.300
And so we just have one photo here from June 22nd.

00:03:45.300 --> 00:03:47.480
However, we want to be able to compare

00:03:47.480 --> 00:03:51.170
how the genotypes are doing each different time.

00:03:51.170 --> 00:03:54.593
So we are actually going to compare two photos.

00:03:55.680 --> 00:03:59.140
So we're going to compare June 22nd,

00:03:59.140 --> 00:04:01.430
which is the photo you have been seeing,

00:04:01.430 --> 00:04:05.340
we're gonna compare that to May 26, 2015.

00:04:05.340 --> 00:04:08.080
So let's look at genotype A.

00:04:08.080 --> 00:04:13.080
If in May I gave this genotype a three, a score of a three,

00:04:14.300 --> 00:04:17.000
however, in June, it greened up quite a bit,

00:04:17.000 --> 00:04:19.670
so I ended up giving it a six.

00:04:19.670 --> 00:04:23.110
And so with genotype B, it was pretty green in May,

00:04:23.110 --> 00:04:25.120
so I gave it a seven.

00:04:25.120 --> 00:04:27.870
In B, I thought it looked just about the same,

00:04:27.870 --> 00:04:30.000
so I gave it the same score.

00:04:30.000 --> 00:04:33.480
C, genotype C, I gave a one in May,

00:04:33.480 --> 00:04:37.160
and in June, I thought it greened up quite a bit,

00:04:37.160 --> 00:04:39.473
so I ended up giving it a five.

00:04:42.190 --> 00:04:43.850
And so you're going to score,

00:04:43.850 --> 00:04:46.200
so label each of,

00:04:46.200 --> 00:04:49.220
I labeled each of my genotypes at the two different dates,

00:04:49.220 --> 00:04:51.030
and then I gave them a score.

00:04:51.030 --> 00:04:53.420
And so then the next thing we're gonna have to do

00:04:53.420 --> 00:04:56.960
is take these numbers and put it into a graph,

00:04:56.960 --> 00:05:00.853
so it's easy for us to see the comparison over time.

00:05:02.750 --> 00:05:05.160
So with the scores I gave each genotype,

00:05:05.160 --> 00:05:07.900
I created a table in Excel.

00:05:07.900 --> 00:05:10.920
And you'll see I have the buffalograss genotypes,

00:05:10.920 --> 00:05:14.160
A through O, and I have their green-up scores,

00:05:14.160 --> 00:05:19.120
the score I gave them in May and in June of 2015.

00:05:19.120 --> 00:05:22.180
And once I created this nice, organized table,

00:05:22.180 --> 00:05:25.540
I then created a bar graph in Excel.

00:05:25.540 --> 00:05:27.680
So you'll see the spring green-up score,

00:05:27.680 --> 00:05:30.130
buffalograss genotype,

00:05:30.130 --> 00:05:33.850
and always make sure to have a title for any graph

00:05:33.850 --> 00:05:34.803
that you create.

00:05:35.660 --> 00:05:40.070
And you'll see that A is, genotype A here,

00:05:40.070 --> 00:05:41.450
we'll just look at that.

00:05:41.450 --> 00:05:45.230
So the blue bar is the score it was given in May,

00:05:45.230 --> 00:05:47.450
and the orange bar is the score

00:05:47.450 --> 00:05:50.520
I gave that genotype in June.

00:05:50.520 --> 00:05:52.660
So it's easy for me to compare,

00:05:52.660 --> 00:05:56.230
to see how it changed from May to June.

00:05:56.230 --> 00:05:59.060
And so I can tell if there's a big variation,

00:05:59.060 --> 00:06:01.040
or it stayed the same.

00:06:01.040 --> 00:06:05.490
And so this graph is a nice, easy way for me to see that.

00:06:05.490 --> 00:06:09.400
And it's also important with any table and graph

00:06:09.400 --> 00:06:13.230
that you create to have a caption.

00:06:13.230 --> 00:06:16.670
And so charts are always considered figures.

00:06:16.670 --> 00:06:21.450
In tables, we always say, we always title them as a table.

00:06:21.450 --> 00:06:26.450
And so my caption tells that this table and graph are scores

00:06:27.240 --> 00:06:31.360
for buffalograss between May and June for one repetition,

00:06:31.360 --> 00:06:34.963
but it also tells how I scored the genotypes.

00:06:36.130 --> 00:06:40.630
I showed you how I scored my genotypes in May and June

00:06:40.630 --> 00:06:44.020
using the NTEP evaluation guidelines.

00:06:44.020 --> 00:06:47.830
Then I created a table and bar graph in Excel.

00:06:47.830 --> 00:06:49.070
So for your assignment,

00:06:49.070 --> 00:06:51.050
you're going to score a small section

00:06:51.050 --> 00:06:52.820
for one of the repetitions

00:06:52.820 --> 00:06:56.630
using the NTEP evaluation guidelines.

00:06:56.630 --> 00:06:58.230
And you're going to use that data

00:06:58.230 --> 00:07:01.100
to create a table and bar graph in Excel

00:07:01.100 --> 00:07:05.280
to compare the greenness score for May 26th, 2015

00:07:05.280 --> 00:07:08.640
and June 22nd, 2015.

00:07:08.640 --> 00:07:11.460
And I do have a link here for you

00:07:11.460 --> 00:07:14.350
to the NTEP evaluation guidelines,

00:07:14.350 --> 00:07:16.830
and a link to a video presentation

00:07:16.830 --> 00:07:19.723
on how to make a bar graph in Excel.

00:07:20.930 --> 00:07:25.930
So last time I scored this area here for repetition one,

00:07:26.640 --> 00:07:31.190
and so you'll be scoring this area for repetition one.

00:07:31.190 --> 00:07:33.690
And here are the two photos of that area

00:07:33.690 --> 00:07:36.830
in May and June of 2015.

00:07:36.830 --> 00:07:40.000
And you will also have access to the PowerPoint,

00:07:40.000 --> 00:07:42.163
so you are able to score these.