Graphing and the Common Core, Pt. 2

I've recently jumped onto the DropBox bandwagon, and cannot even begin to describe how much I LOVE this file sharing technology tool. Now, I can grade assignments from home as opposed to logging onto each individual netbook to assess my students' work.

Below is the continuation and conclusion of the Microsoft Excel lesson that I began blogging about last month. Keep in mind that these lessons are designed for 30 to 40 minute long class periods, and that the complete lesson of creating a data table and graphing it could easily be accomplished within a 60-minute class period.

Graphing in Microsoft Excel

Phase One 
The first step in this lesson is to have students open their saved files. Based on the operating system and technology platform this could be a simple task, or it could be extremely time-consuming. In my situation, it was the latter primarily due to the lack of a clearly defined "Start" button on the Windows operating system. 

Students become so comfortable with the process of clicking something once to get it to open, so its important that you practice opening files on their computers in order to clearly direct them to click or double-click to access and open their file.


Phase Two
The actual process of generating a graph will vary based on your operating system and the version of Microsoft that you are using. My classes use Microsoft 2010. [Yet my work laptop uses Microsoft 2007 and my personal Mac uses Microsoft 2011]

Once the students have their data table files open, have them select the data by one of two methods:

1.   Click, hold and dragging through the cells with data 

or, my professional preference 

2.   Have them select the cell containing data in the upper-left corner of the table. Hold the 'shift' key 
      and use the arrows on the keyboard to select the cells containing data in the table.

Regardless of the process used, once the table is selected (all except for the starting cell, which will remain white), the mouse clicker or the 'shift' key can be released.

When the table is highlighted, all of the selected cells will be blue with the exception of the first one selected, as is shown in the image above.

Proceeding to Phase Three without properly completing Phase Two will lead to a blank graph as is shown below:

 


Phase Three
**Reminder:  The following directions apply to Microsoft 2010. Every version varies slightly. 

With the table selected, you will choose the 'Insert' option in order to create a graph. When teaching this, correlate the word 'Insert' with the action of including something on the spreadsheet.

Before allowing students to choose a graph, lead a brief 3 to 5 minute discussion on what type of data could be displayed in each type of graph. Make sure that students understand that a pie graph displays percentages or parts of a whole, as this is a concept that will surely be taught in their math classes and that will definitely be seen on standardized exams. 

Once the students demonstrate an understanding of the uses for the different types of graphs, allow them to graph. 

***When discussing the different types of graph, direct students to choose graphs where the colors in the graph don't touch. More often than not, the graphs with touching colors will generate graphs that do not properly replicate the data found in the data table. See the example below:

 

From here, the students will undoubtedly have fun exploring the many different graph colors, designs and so much more. 


Phase Four
For assessment purposes, I laid out the following guidelines for students:

1.   Choose a graph that relates to the information being graphed.
2.   Include a Chart Title.
3.   Include an axis label that describes what the numbers represent.

With the great quantity of time in this particular lesson committed to student exploration, I waited until everyone had made a graph prior to explaining the process of making titles and labels.

In this portion of the lesson, it is important to explain to students that the button below the 'down' button is referred to as the 'more' button, and that if they choose that option then they will see ALL of the options of that particular category.

It is also important to explain that the cursor must be blinking before they press 'backspace', because if not the text box will disappear altogether, as can be seen in the following example:

 

And, last, but not least...YES...you can type sideways.


Below are some of the end products from this lesson. Let's see if you can figure out who earned an A+.

1

2

3

4

5

6

7

8

9

 10

   

Graphing and the Common Core, Pt. 1

In the Common Core, the ability to interpret and create graphs is something that is introduced as early as second grade. By third grade, students are expected to interpret and create bar graphs and pictographs (3.MD.3). By fourth grade, students are expected to interpret and create line plots (4.MD.4).

Being more of an analytical thinker, I have found myself becoming more fully indulged in math than in any other subject. Ever since learning how to do long division back in the fourth grade, I've found myself creating and solving long division problems whenever I'm bored or waiting in a long line. In the last five years, I've found myself getting sucked into the whole Sudoku phenomenon, and feel all the more intelligent for it. I'm not trying to knock other subjects (as I'm also keen on writing poetry), I'm simply saying that math has always held a special place in me. And, this special connection is one that I consistently work towards passing on to my students.

At my last school, I used Microsoft Excel to teach 2nd, 3rd and 4th grade students how to graph the typing test scores that they had been recording for a total of 10 weeks. The students loved seeing how their scores had changed over time, and they especially loved learning how to graph their very own scores on Microsoft Excel.

That same year, I also led a Professional Development session for teachers on the ways in which one could use Microsoft Excel. Having spent a previous work life dabbling in data analysis, I've become very aware of the many functionalities, and as a teacher I realize that there are only a handful of ways in which Microsoft Excel proves to be more useful than any other tool out there.

Ways in which Microsoft Excel is useful for teachers

1. Creating rubrics
2. Maintaining grades
3. Organizing classes

Currently, I use Microsoft Excel as a way to maintain and update students' grades prior to entering them into the GradeBook program.

Below is a list of some of the many ways in which Microsoft Excel can be used in teaching students.

1. Creating data tables from surveys.  (3.MD.3)
2. Graphing data.  (3.MD.3)
3. Creating pictographs.  (2.MD.10)
4. Finding area. (4.MD.3)
5. Finding perimeter. (4.MD.3)
6. Evaluating and generating patterns. (4.OA.5)
7. Interpreting and creating line plots.  (4.MD.4)
   

Phase One
This week, I began a two-lesson project on creating graphs in my fourth grade classes (after Thanksgiving break, I will begin the same lesson for my third grade classes). Since the vast majority of our fourth graders are unfortunately addicted to television, I decided to start with a survey that they could relate to. To begin the lesson, we started with an impromptu survey of their favorite TV shows. Once we had united to compile a list of four TV shows, we polled the class on the shows that they watched. I explained to the students that unlike the voting that transpires in Presidential elections, they could actually vote on more than one TV show, as this was a data project that was based on the shows they watched, not their favorite show.

My current fourth grade classes are very small, with only 8 to 13 students. So, needless to say, our data tables were not very large.

Phase Two
In any Microsoft Excel lesson, it is important to review the very basic vocabulary: worksheet, cell, column, and row.

worksheet = the large area in which all of the cells are located
cell = a rectangular on a worksheet; cell name is based on where the column and row 
          intersect,   e.g.: 'D4'.
column = goes up and down on the worksheet; vertical line of cells that is represented by a 
                 letter 
row = goes from left to right on the worksheet; horizontal line of cells that is represented by 
           a number

Phase Three
After reviewing the vocabulary we played a brief, speed game of "Name that cell". In the game, I would click on a cell and the students would have to yell out the correct cell name. The game would continue until everyone said the correct cell name 5 times in a row. By this point, I knew that they knew how to identify a cell name.

Phase Four
Next, I showed and explained to the students that any information that you typed into a cell would also appear in the formula box at the top of the menu bar. It's important to also highlight the fact that pressing 'Enter' moves you down to the next cell, as using the area keys while actively altering a cell produces no results.

I modeled for students how they would type one TV show name into each cell and press 'Enter' after each. Once the students had completed this step, we were able to move onto the fun step of expanding columns.

Phase Five
This is the part that confuses most adults who are new to Microsoft Excel. When information in a cell exceeds the size of the cell, it is easy to tell where the information starts, but hard to tell where it ends. Thus, it's important to note that the cell the information is contained in is based on the cell where the information is first seen. Below are some screenshots to show examples of this concept.

 

In the image above, it looks as though 'Hannah Montana' is contained in cells C3 and D3. It also looks as though 'Spongebob Squarepants' is contained in cells C5 and D5.

 The image above shows the reality of 'Hannah Montana' being maintained in cell C3 as is depicted by the fx (formula) bar. The same applies for 'Spongebob Squarepants'.

Phase Six
The ability to expand rows and columns was definitely the jaw-dropping moment of this lesson. To aid in clarifying the exact cell location for each piece of data, I taught the students how to expand the effected columns.

Much like adults, students are also fooled by what they see in Microsoft Excel. Thus, teaching individuals how to expand columns is a necessary step in any Microsoft Excel lesson.

Below is an image that depicts this process.

In the above image, the mouse appears as a line with an arrow on either side. This tool only appears when you move the mouse in between two numbers or two letters. When the tool appears, simply click and drag out to expand the column.

Phase Seven
Once the column with the TV shows is expanded, it is time to enter the votes for each TV show. In this step, it is important to explain that the numbers appear are right-aligned simply because they are numbers. Had they been words instead, they would be left-aligned.

The image above shows the words as being left-aligned, while the numbers are right-aligned.

Phase Eight

The next step is all about selecting the specific cells to add a border to. This can be done in one of two ways. 

1. Click on the first cell of the group. Click and drag so that only the appropriate cells are highlighted. 

***Explain to students that highlighting on Microsoft platforms means that the information turns blue. It DOES NOT mean that you change the background color to yellow.

     2.  Use the arrow keys to navigate to the first cell of the group. Hold the 'shift' key down to
           highlight the appropriate cells.

The above image shows a highlighted group of cells.

Once the proper cells are selected, a border can be applied. To apply a border, you must select the border option in the main menu. Then, you must choose 'all borders'.

Once the borders are added, the final image will look like the picture shown below.

The above steps merely cover the first of two lessons on graphing in Microsoft Excel. The second lesson will deal with labeling the data as well as creating and editing the graph.


The belief is that students learn by doing. Thus, if students are given the opportunity to create and interpret their own graphs, then they'll likely be able to replicate the same process on a standardized test. This is a skill that is not just applicable to testing environments, it is also applicable to high school and college math courses as well as many different career functions.





After Thanksgiving Break, I'll be sharing a blog on my students' success with creating graphs on Microsoft Excel.

Hope you enjoyed.