Technology Integration within the ELA Common Core State Standards

While developing my school's Technology Plan, much conversation has been centered on the Common Core State Standards and their linkage with technology. So, I took it upon myself to go through all of the ELA Standards to find every Standard that deals with Technology. Below is a compilation of the results. Throughout the course of the next several months, I plan to provide posts that aid fellow teachers in ways in which Technology Tools can be integrated to properly meet the Common Core State Standards.

**These Standards were pulled directly from the Common Core State Standards


-->
Elementary (K-5) ELA Standards

Kindergarten
W.K.6:  With guidance and support from adults, explore a variety of digital tools to produce and publish writing, including in collaboration with peers.

SL.K.2:  Confirm understanding of a text read aloud or information presented orally or through other media by asking and answering questions about key details and requesting clarification if something is not understood.


First Grade
W.1.6:  With guidance and support from adults, use a variety of digital tools to produce and publish writing, including in collaboration with peers.

SL.1.2:  Ask and answer questions about key details in a text read aloud or information presented orally or through other media.

RI.1.5:   Know and use various text features (e.g., headings, tables of contents, glossaries, electronic menus, icons) to locate key facts or information in a text.


Second Grade
RL.2.7:  Use information gained from the illustrations and words in a print or digital text to demonstrate understanding of its characters, setting, or plot

W.2.6:  With guidance and support from adults, use a variety of digital tools to produce and publish writing, including in collaboration with peers.

SL.2.2:  Recount or describe key ideas or details from a text read aloud or information presented orally or through other media.

SL.2.5:  Create audio recordings of stories or poems, add drawings or other visual displays to stories or recounts of experiences when appropriate to clarify ideas, thoughts, and feelings.

L.2.4.E:  Use glossaries and beginning dictionaries, both print and digital, to determine or clarify the meaning of words and phrases.

RI.2.5:   Know and use various text features (e.g., captions, bold print, subheadings, glossaries, indexes, electronic menus, icons) to locate key facts or information in a text efficiently.


Third Grade
W.3.6:  With guidance and support from adults, use technology to produce and publish writing (using keyboarding skills) as well as to interact and collaborate with others.

W.3.8:  Recall information from experiences or gather information from print and digital sources; take brief notes on sources and sort evidence into provided categories.

SL.3.2:  Determine the main ideas and supporting details of a text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.

SL.3.5:  Create engaging audio recordings of stories or poems that demonstrate fluid reading at an understandable pace; add visual displays when appropriate to emphasize or enhance certain facts or details. 

L.3.4.D:  Use glossaries or beginning dictionaries, both print and digital, to determine or clarify the precise meaning of key words and phrases.

RI.3.5:   Use text features and search tools (e.g., key words, sidebars, hyperlinks) to locate information relevant to a given topic efficiently.


Fourth Grade
W.4.2.A:  Introduce a topic clearly and group related information in paragraphs and sections; include formatting (e.g., headings), illustrations, and multimedia when useful to aiding comprehension.

W.4.6:  With some guidance and support from adults, use technology, including the Internet, to produce and publish writing as well as to interact and collaborate with others; demonstrate sufficient command of keyboarding skills to type a minimum of one page in a single sitting.

W.4.8:  Recall relevant information from experiences or gather relevant information from print and digital sources; take notes and categorize information, and provide a list of sources.

SL.4.2:  Paraphrase portions of a text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.

SL.4.5:  Add audio recordings and visual displays to presentations when appropriate to enhance the development of main ideas or themes.

L.4.4.C:  Consult reference materials (e.g., dictionaries, glossaries, thesauruses), both print and digital, to find the pronunciation and determine or clarify the precise meaning of key words and phrases.

RI.4.7:  Interpret information presented visually, orally, or quantitatively (e.g., in charts, graphs, diagrams, timelines, animations, or interactive elements on Web pages) and explain how the information contributes to an understanding of the text in which it appears.


Fifth Grade
RL.5.7:  Analyze how visual and multimedia elements contribute to the meaning, tone, or beauty of a text (e.g., graphic novel, multimedia presentation of fiction, folktale, myth, poem)

RI.5.7:  Draw on information from multiple print or digital sources, demonstrating the ability to locate an answer to a question quickly or to solve a problem efficiently.

W.5.2.A:  Introduce a topic clearly, provide a general observation and focus, and group related information logically; include formatting (e.g., headings), illustrations, and multimedia when useful to aiding comprehension.

W.5.6:  With some guidance and support from adults, use technology, including the Internet, to produce and publish writing as well as to interact and collaborate with others; demonstrate sufficient command of keyboarding skills to type a minimum of two pages in a single sitting.

W.5.8:  Recall relevant information from experiences or gather relevant information from print and digital sources; summarize or paraphrase information in notes and finished work, and provide a list of sources.

SL.5.2:  Summarize a written text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.

SL.5.5:  Include multimedia components (e.g., graphics, sound) and visual displays in presentations when appropriate to enhance the development of main ideas or themes.

L.5.4.C:  Consult reference materials (e.g., dictionaries, glossaries, thesauruses), both print and digital, to find the pronunciation and determine or clarify the precise meaning of key words and phrases.


Middle School ELA Standards

Sixth Grade
RL.6.7:  Compare and contrast the experience of reading a story, drama, or poem to listening to or viewing an audio, video, or live version of the text, including contrasting what they "see" and "hear" when reading the text to what they perceive when they listen or watch.

RI.6.7:  Integrate information presented in different media or formats (e.g., visually, quantitatively) as well as in words to develop a coherent understanding of a topic or issue.

W.6.2.A:  Introduce a topic; organize ideas, concepts, and information, using strategies such as definition, classification, comparison/contrast, and cause/effect; include formatting (e.g., headings), graphics (e.g., charts, tables), and multimedia when useful to aiding comprehension.

W.6.6:  Use technology, including the Internet, to produce and publish writing as well as to interact and collaborate with others; demonstrate sufficient command of keyboarding skills to type a minimum of three pages in a single sitting.

W.6.8:  Gather relevant information from multiple print and digital sources; assess the credibility of each source; and quote or paraphrase the data and conclusions of others while avoiding plagiarism and providing basic bibliographic information for sources.

SL.6.2:  Interpret information presented in diverse media and formats (e.g., visually, quantitatively, orally) and explain how it contributes to a topic, text, or issue under study.

SL.6.5:  Include multimedia components (e.g., graphics, images, music, sound) and visual displays in presentations to clarify information.

L.6.4.C:  Consult reference materials (e.g., dictionaries, glossaries, thesauruses), both print and digital, to find the pronunciation of a word or determine or clarify its precise meaning or its part of speech.

RH.6.7:  Integrate visual information (e.g., in charts, graphs, photographs, videos, or maps) with other information in print and digital texts.

RST.6.9:  Compare and contrast the information gained from experiments, simulations, video, or multimedia sources with that gained from reading a text on the same topic.

WHST.6.2.A:  Introduce a topic clearly, previewing what is to follow; organize ideas, concepts, and information into broader categories as appropriate to achieving purpose; include formatting (e.g., headings), graphics (e.g., charts, tables), and multimedia when useful to aiding comprehension.

WHST.6.6:  Use technology, including the Internet, to produce and publish writing and present the relationships between information and ideas clearly and efficiently.

WHST.6.8:  Gather relevant information from multiple print and digital sources, using search terms effectively; assess the credibility and accuracy of each source; and quote or paraphrase the data and conclusions of others while avoiding plagiarism and following a standard format for citation.


Seventh Grade
RL.7.7:  Compare and contrast a written story, drama, or poem to its audio, filmed, staged, or multimedia version, analyzing the effects of techniques unique to each medium (e.g., lighting, sound, color, or camera focus and angles in a film).

RI.7.7:  Compare and contrast a text to an audio, video, or multimedia version of the text, analyzing each medium's portrayal of the subject (e.g., how the delivery of a speech affects the impact of the words).

W.7.2.A:  Introduce a topic clearly, previewing what is to follow; organize ideas, concepts, and information, using strategies such as definition, classification, comparison/contrast, and cause/effect; include formatting (e.g., headings), graphics (e.g., charts, tables), and multimedia when useful to aiding comprehension.

W.7.6:  Use technology, including the Internet, to produce and publish writing and link to and cite sources as well as to interact and collaborate with others, including linking to and citing sources.

W.7.8:  Gather relevant information from multiple print and digital sources, using search terms effectively; assess the credibility and accuracy of each source; and quote or paraphrase the data and conclusions of others while avoiding plagiarism and following a standard format for citation.

SL.7.2:  Analyze the main ideas and supporting details presented in diverse media and formats (e.g., visually, quantitatively, orally) and explain how the ideas clarify a topic, text, or issue under study.

SL.7.5:  Include multimedia components and visual displays in presentations to clarify claims and findings and emphasize salient points.

L.7.4.C:  Consult general and specialized reference materials (e.g., dictionaries, glossaries, thesauruses), both print and digital, to find the pronunciation of a word or determine or clarify its precise meaning or its part of speech.

RH.7.7:  Integrate quantitative or technical analysis (e.g., charts, research data) with qualitative analysis in print or digital text.

RST.7.9:  Compare and contrast the information gained from experiments, simulations, video, or multimedia sources with that gained from reading a text on the same topic.

WHST.7.2.A:  Introduce a topic clearly, previewing what is to follow; organize ideas, concepts, and information into broader categories as appropriate to achieving purpose; include formatting (e.g., headings), graphics (e.g., charts, tables), and multimedia when useful to aiding comprehension.

WHST.7.6:  Use technology, including the Internet, to produce and publish writing and present the relationships between information and ideas clearly and efficiently.

WHST.7.8:  Gather relevant information from multiple print and digital sources, using search terms effectively; assess the credibility and accuracy of each source; and quote or paraphrase the data and conclusions of others while avoiding plagiarism and following a standard format for citation.


Eighth Grade
RI.8.7:  Evaluate the advantages and disadvantage of using different mediums (e.g., print or digital text, video, multimedia) to present a particular topic or idea.

W.8.2.A:  Introduce a topic clearly, previewing what is to follow; organize ideas, concepts, and information into broader categories; include formatting (e.g., headings), graphics (e.g., charts, tables), and multimedia when useful to aiding comprehension.

W.8.6:  Use technology, including the Internet, to produce and publish writing and present the relationships between information and ideas efficiently as well as to interact and collaborate with others.

W.8.8:  Gather relevant information from multiple print and digital sources, using search terms effectively; assess the credibility and accuracy of each source; and quote or paraphrase the data and conclusions of others while avoiding plagiarism and following a standard format for citation.

SL.8.2:  Analyze the purpose of information presented in diverse media and formats (e.g., visually, quantitatively, orally) and evaluate the motives (e.g., social, commercial, political) behind its presentation.

SL.8.5:  Integrate multimedia and visual displays into presentations to clarify information, strengthen claims and evidence, and add interest.

L.8.4.C:  Consult general and specialized reference materials (e.g., dictionaries, glossaries, thesauruses), both print and digital, to find the pronunciation of a word or determine or clarify its precise meaning or its part of speech.

RH.8.7:  Integrate and evaluate multiple sources of information presented in diverse formats and media (e.g., visually, quantitatively, as well as in words) in order to address a question or solve a problem.

RST.8.9:  Compare and contrast the information gained from experiments, simulations, video, or multimedia sources with that gained from reading a text on the same topic.

WHST.8.2.A:  Introduce a topic clearly, previewing what is to follow; organize ideas, concepts, and information into broader categories as appropriate to achieving purpose; include formatting (e.g., headings), graphics (e.g., charts, tables), and multimedia when useful to aiding comprehension.

WHST.8.6:  Use technology, including the Internet, to produce and publish writing and present the relationships between information and ideas clearly and efficiently.

WHST.8.8:  Gather relevant information from multiple print and digital sources, using search terms effectively; assess the credibility and accuracy of each source; and quote or paraphrase the data and conclusions of others while avoiding plagiarism and following a standard format for citation.

High School ELA Standards

Ninth Grade
RI.9.7:  Analyze various accounts of a subject told in different mediums (e.g, a person's life story in both print and multimedia), determining which details are emphasized in each account.

W.9.2.A:  Introduce a topic; organize complex ideas, concepts, and information or make important connections and distinctions; include formatting (e.g., headings), graphics (e.g., figures, tables), and multimedia when useful to aiding comprehension.

W.9.6:  Use technology, including the Internet, to produce, publish, and update individual or shared writing products, taking advantage of technology's capacity to link to other information and to display information flexibly and dynamically.

W.9.8:  Gather relevant information from multiple authoritative print and digital sources, using advanced searches effectively; assess the usefulness of each source in answering the research question; integrate information into the text selectively to maintain the flow of ideas, avoiding plagiarism and following a standard format for citation.

SL.9.2:  Integrate multiple sources of information presented in diverse media or formats (e.g., visually, quantitatively, orally) evaluating the credibility and accuracy of each source.

SL.9.5:  Make strategic use of digital media (e.g., textual, graphical, audio, visual, and interactive elements) in presentations to enhance understanding of findings, reasoning, and evidence and to add interest.

L.9.4.C:  Consult general and specialized reference materials (e.g., dictionaries, glossaries, thesauruses), both print and digital, to find the pronunciation of a word or determine or clarify its precise meaning, its part of speech, or its etymology.

WHST.9.2.A:  Introduce a topic and organize ideas, concepts, and information to make important connections and distinctions; include formatting (e.g., headings), graphics (e.g., figures, tables), and multimedia when useful to aiding comprehension.

WHST.9.6:  Use technology, including the Internet, to produce, publish, and update individual or shared writing products, taking advantage of technology's capacity to link to other information and to display information flexibly and dynamically.

WHST.9.8:  Gather relevant information from multiple authoritative print and digital sources, using advanced searches effectively; assess the usefulness of each source in answering the research question; integrate information into the text selectively to maintain the flow of ideas, avoiding plagiarism and following a standard format for citation.


Tenth Grade
RI.10.7:  Analyze various accounts of a subject told in different mediums (e.g., a person's life story in both print and multimedia), determining which details are emphasized in each account.

W.10.2.A:  Introduce a topic; organize complex ideas, concepts, and information or make important connections and distinctions; include formatting (e.g., headings), graphics (e.g., figures, tables), and multimedia when useful to aiding comprehension.

W.10.6:  Use technology, including the Internet, to produce, publish, and update individual or shared writing products, taking advantage of technology's capacity to link to other information and to display information flexibly and dynamically.

W.10.8:  Gather relevant information from multiple authoritative print and digital sources, using advanced searches effectively; assess the usefulness of each source in answering the research question; integrate information into the text selectively to maintain the flow of ideas, avoiding plagiarism and following a standard format for citation.

SL.10.2:  Integrate multiple sources of information presented in diverse media or formats (e.g., visually, quantitatively, orally) evaluating the credibility and accuracy of each source.

SL.10.5:  Make strategic use of digital media (e.g., textual, graphical, audio, visual, and interactive elements) in presentations to enhance understanding of findings, reasoning, and evidence and to add interest.

L.10.4.C:  Consult general and specialized reference materials (e.g., dictionaries, glossaries, thesauruses), both print and digital, to find the pronunciation of a word or determine or clarify its precise meaning, its part of speech, or its etymology.

WHST.10.2.A:  Introduce a topic and organize ideas, concepts, and information to make important connections and distinctions; include formatting (e.g., headings), graphics (e.g., figures, tables), and multimedia when useful to aiding comprehension.

WHST.10.6:  Use technology, including the Internet, to produce, publish, and update individual or shared writing products, taking advantage of technology's capacity to link to other information and to display information flexibly and dynamically.

WHST.10.8:  Gather relevant information from multiple authoritative print and digital sources, using advanced searches effectively; assess the usefulness of each source in answering the research question; integrate information into the text selectively to maintain the flow of ideas, avoiding plagiarism and following a standard format for citation.


Eleventh Grade
RI.11.7:  Integrate and evaluate multiple sources of information presented in different media or formats (e.g., visually, quantitatively) as well as in words in order to address a question or solve a problem.

W.11.2.A:  Introduce a topic; organize complex ideas, concepts, and information so that each new element builds on that which preceded it to create a unified whole; include formatting (e.g., headings), graphics (e.g., figures, tables), and multimedia when useful to aiding comprehension.

W.11.6:  Use technology, including the Internet, to produce, publish, and update individual or shared writing products in response to ongoing feedback including new arguments or information.

W.11.8:  Gather relevant information from multiple authoritative print and digital sources, using advanced searches effectively; assess the strengths and limitations of each source in terms of the task, purpose, and audience; integrate information into the text selectively to maintain the flow of ideas, avoiding plagiarism and over reliance on any one source and following a standard format for citation.

SL.11.2:  Integrate multiple sources of information presented in diverse formats and media (e.g., visually, quantitatively, orally) in order to make informed decisions and solve problems, evaluating the credibility and accuracy of each source and noting any discrepancies among the data.

SL.11.5:  Make strategic use of digital media (e.g., textual, graphical, audio, visual, and interactive elements) in presentations to enhance understanding of findings, reasoning, and evidence and to add interest.

L.11.4.C:  Consult general and specialized reference materials (e.g., dictionaries, glossaries, thesauruses), both print and digital, to find the pronunciation of a word or determine or clarify its precise meaning, its part of speech, its etymology, or its standard usage.

RST.11.7:  Integrate and evaluate multiple sources of information presented in diverse formats and media (e.g., quantitative data, video, multimedia) in order to address a question or solve a problem.

WHST.11.2.A:  Introduce a topic and organize complex ideas, concepts, and information so that each new element builds on that which precedes it to create a unified whole; include formatting (e.g., headings), graphics (e.g., figures, tables), and multimedia when useful to aiding comprehension.

WHST.11.6:  Use technology, including the Internet, to produce, publish, and update individual or shared writing products in response to ongoing feedback, including new arguments or information.

WHST.11.8:  Gather relevant information from multiple authoritative print and digital sources, using advanced searches effectively; assess the strengths and limitations of each source in terms of the specific task, purpose, and audience; integrate information into the text selectively to maintain the flow of ideas, avoiding plagiarism and over reliance on any one source and following a standard format for citation.


Twelfth Grade
RI.12.7:  Integrate and evaluate multiple sources of information presented in different media or formats (e.g., visually, quantitatively) as well as in words in order to address a question or solve a problem.

W.12.2.A:  Introduce a topic; organize complex ideas, concepts, and information so that each new element builds on that which preceded it to create a unified whole; include formatting (e.g., headings), graphics (e.g., figures, tables), and multimedia when useful to aiding comprehension.

W.12.6:  Use technology, including the Internet, to produce, publish, and update individual or shared writing products in response to ongoing feedback including new arguments or information.

W.12.8:  Gather relevant information from multiple authoritative print and digital sources, using advanced searches effectively; assess the strengths and limitations of each source in terms of the task, purpose, and audience; integrate information into the text selectively to maintain the flow of ideas, avoiding plagiarism and over reliance on any one source and following a standard format for citation.

SL.12.2:  Integrate multiple sources of information presented in diverse formats and media (e.g., visually, quantitatively, orally) in order to make informed decisions and solve problems, evaluating the credibility and accuracy of each source and noting any discrepancies among the data.

SL.12.5:  Make strategic use of digital media (e.g., textual, graphical, audio, visual, and interactive elements) in presentations to enhance understanding of findings, reasoning, and evidence and to add interest.

L.12.4.C:  Consult general and specialized reference materials (e.g., dictionaries, glossaries, thesauruses), both print and digital, to find the pronunciation of a word or determine or clarify its precise meaning, its part of speech, its etymology, or its standard usage.

RST.12.7:  Integrate and evaluate multiple sources of information presented in diverse formats and media (e.g., quantitative data, video, multimedia) in order to address a question or solve a problem.

WHST.12.2.A:  Introduce a topic and organize complex ideas, concepts, and information so that each new element builds on that which precedes it to create a unified whole; include formatting (e.g., headings), graphics (e.g., figures, tables), and multimedia when useful to aiding comprehension.

WHST.12.6:  Use technology, including the Internet, to produce, publish, and update individual or shared writing products in response to ongoing feedback, including new arguments or information.

WHST.12.8:  Gather relevant information from multiple authoritative print and digital sources, using advanced searches effectively; assess the strengths and limitations of each source in terms of the specific task, purpose, and audience; integrate information into the text selectively to maintain the flow of ideas, avoiding plagiarism and over reliance on any one source and following a standard format for citation.

Tech Plan, From the beginning

Currently working on creating a Tech Plan from scratch.

It's times like this when I'm thankful that the Common Core State Standards (CCSS) exist. I remember last year, working in a school district where the technology standards were so dated that they were not even intertwined with the general curriculum.

The Elementary (K-5) Technology Standards were literally as follows:

1.  Use a variety of technology tools to gather data and information. (e.g., Web-based resources, e-books, online communication tools, etc.)

2.  Use a variety of technology tools to organize data and information. (e.g., word processor, graphic organizer, audio and visual recording, online collaboration tools, etc.)
3.  Use technology tools to present data and information (multimedia, audio and visual recording, online collaboration tools, etc.)

In a way, the above standards were great because it meant that there were endlessly possibilities for implementation. However, in another way, they felt so very drab, because the language was so separate from that which was used in defining the standards of the classroom teacher.

Now, working in a position where I have the authorization to create a curriculum, I've also been finding ways in which to set up technology standards for each grade level from preschool thru 12th grade. In addition, to the technology integration that is included in the CCSS, I strongly believe that there should be a basic set up technology skills and operations that students should have a strong foundation in by the culmination of each grade level.

Below is a simple grid highlighting some of these skills, which is still currently undergoing construction, so please excuse the holes. The complete version will be posted soon...

A Lesson Activity on Presidents

Wow, I can't believe it's the 20th of January, already. Tomorrow is the Presidential Inauguration, and though I live within a stone's throw of Washington, DC, I have no interest in being crammed in a Metro like a bunch of sardines, so I guess I'll be viewing the Inauguration from home.

That being said, I've found some nice websites that teach students about the roles and responsibilities of a President in a fun and interactive way.

The one described in this post is a two-part activity that I plan to utilize in my 4th grade classes.


Be the President

In this activity, students read a brief description about the activity, then they proceed to answer multiple choice questions regarding the decisions they would make if they were the President.

Students also have the option to read about some additional facts on the activities of previous Presidents. At the conclusion of this activity, students get a newspaper story that auto-fills their name and some of their favorite activities based on what answers they chose.

My Plan:
This week, my 4th grade students will complete the above activity and take notes. This will increase their knowledge of past Presidents, which they can then correlate with facts that they acquire within their classroom instruction, and will prepare them for Part Two.

Next week, we will commence with Part Two of the activity where students will be split up into 3 groups and will partake in a Jeopardy activity that questions them on Presidential facts that they learned from Part One.

As a personal note, the one thing that I must remember is to tell students this week that they will need to take notes in preparation for next week's Jeopardy game. For, if I don't share this important detail with them in the beginning, then they'll likely be very slack about pulling key facts and information from the text that they'll be reading.

The great thing about using Jeopardy labs is that you can select up to 12 teams, so if you have a large class, there can still be equality. You can choose your own questions, or use/edit one of the pre-made templates. As teams answer correctly, you click the green plus sign (+) once in order to add the points. If they answer incorrectly, then you have the option to click on the red minus (-) sign in order to decrease the points by the correct amount.

I have very high hopes for this lesson, as it teaches the students many great skills (reading online text, finding quality information, note-taking, teamwork and collaboration) that will build character as well as knowledge.


Let me know how this lesson activity works for you, if you happen to try it. :)

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

   

Keyboards for Kindergarten

This week, I'm really looking forward to seeing my kindergarten classes. For the last couple of months, (seeing each class for only one 30-minute period a week) we've been working on the various mouse functions:
1.  Click
2.  Double-click
3.  Click and drag (a.k.a "click-drap-drop")

They've completed activities like drawing pictures of plants on Paint software, clicking and dragging letters to match the capital with the lowercase in order to create a rainbow, and using Audacity recording software to record a line of their group's poem.

Now, they get to "play games". In order to get these young students to become more efficient with identifying written letters and using the keyboard, I happened to have tripped upon this game that requires students to find and press letters on the keyboard in a timed setting. On ABCya's Typing Rocket Game, students have to press the letter key that corresponds to the letter that they see on the rocket ship on the screen. Every time they get one right, the rocket (which looks more like a firework) explodes.

It's pretty entertaining, and disguising this keyboard familiarity building activity as a game makes it such an easy sell to any class.

The next step will be to incorporate Keyboarding Zoo, a more elaborate activity that requires the students to press one letter of the alphabet multiple times before moving on to the next ordinal letter.

First Grade Lesson: Usernames and Sight Word Practice

Just last week, I completed this really awesome first grade lesson that combined the creation of safe usernames with a fun, sight word game. I cannot even begin to describe how great it was, but, I'll give it a try.

For the first part of the lesson, we discussed the importance of Internet Safety and Privacy. We reviewed the previously taught lessons on information that should be kept private (name, phone number, address, school, birthdate, etc.). Next, we discussed the process of creating usernames based on some of the students' favorite things (like their favorite colors, words, animals, pet names and numbers). After writing a few demo usernames on the board, students were given a pencil and an index card where they were to write down their own unique username. This is where the fun began!

I gave the class 5 minutes to think of and write down their username. [If you're going to try this, make sure that you're very clear about having them write their own, real name first].

The list below shows some of the goofy usernames that the students came up with:
red18pigsy
sperbob22
spunge3dob
feshy8kat
gldmyne82

Making the usernames created so much laughter in the classroom as the students would crack up over the silly names that they and their peers had created. 

For the remainder of the class period; in order to put their usernames to good use, the students were directed onto Sight Words Recognition which is a relatively new game that can be found on www.ABCya.com. 

The game has been so great in so many ways. First, it enables the students to put their usernames to good use. Second, it helps the students to build their sight word recognition levels.

All the students have to do is:
1.   Enter their username.
2.   Click 'join' to join a game, or simply create a new game.
3.   Click 'Start Race'.
4.   When the race starts, click on the written version of the word that you hear.
5.   At the end, you'll see a results place that tells you your rank, your time, and the number of words you got correct within one minute.
6.   If you make a mistake in the game, then you're simply prevented from jumping onto the next ball of yarn.

Below are some screenshots of the game.

 This is where your kitten avatar bounces from word to proceeding word based on spoken version of the word.

 If you are the first one to jump on the couch, then you get a picture of three stars with the word 'WINNER' displayed on top of your kitten's head.

 The results page shows your place, your completion time, your accuracy percentage, your rate of words per minute and any questions that you may have missed.

All and all, I would give this lesson and the Sight Word Practice game two thumbs up, as it's important to hone in on key 21st century learner skills from a young age, while also improving upon their literacy through the Sight Words Practice portion of the activity.

      

Technology Integration Organization Initiative: Washington, DC

Having recently relocated to the Washington, DC area, I've realized that we're a little short on local education chapters....particularly in terms of an ISTE affiliate organization that caters to local professionals. In a way, I feel as though I've been a little spoiled for the last few years. Let's face it. Teaching in Philadelphia, one has access to the Pennsylvania Association for Educational Communications and Technology (PAECT). Teaching in Charlotte, one has access to the North Carolina Technology in Education Society (NCTiES).

In Washington, DC, we have access to..........?

This is a bit of an anomaly to me as a technology educator.
Let's take a look at the numbers.

Washington DC has a population of roughly 618,000, roughly the same population as the state of Vermont; a state that has an ISTE affiliate (VITA-Learn).

So, in an effort to get more involved with like-minded professionals in my local arena, I'll be attending a Meetup in two weeks.

DCEd Tech Meetup

My hopes in attending this meeting are two-hold. One is that I'm looking forward to a great professional development and networking session. Two is that I'm hopeful that together, we can work towards creating a organization to support the educational technology needs of professionals in the Washington, DC area.

Who's with me?
Follow @TechTeacherT

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.

Tagxedo and the Water Cycle

For the last few weeks, our second graders have been learning about the water cycle in their science classes. Knowing this in advance, I decided to incorporate my own version of a water cycle lesson to help the students in a variety of areas.

Online Assessments
First, we went onto Scholastic's Water Cycle workshop where students watched a video on the water cycle, read over the vocabulary words and took a 5-question multiple-choice assessment on the phases of the water cycle. The primary purpose of this portion of the activity was not to complete a graded assessment. No. The real purpose of this lesson was to expose students to the online testing that they will soon be undergoing, in a less-threatening environment.

I remember my last school, where 1st thru 5th graders took AR (Accelerated Reader) quizzes based on the books they read. I also remember the quarterly STAR tests that they took during technology class. While I refuse to disclose any type of bias for or against these assessments, one thing that I can say is that I noticed a greater sense of ease and comfort when my current students were taking their online assessments versus when my former students had done so.

It's important in this day and age that we expose our students to online assessments so that, at the very least, they are able to match computerized questions to computerized answers. And, in the case of this particular quiz, students also had to click on 'Next' in order to get to the next question. Anyone who has taken a computerized Praxis exam lately should know exactly what I'm talking about.


Creativity
The second part of this lesson has been the most exciting. It's hard to tell if it is more exciting for me or for the students. For now, we'll say it's a tie.

On Day Two of this lesson (one week later), I told the students that they'd be making a Word Cloud. Needless to say, there was many a confused face in the room. After showing the students some examples, they became exuberantly excited.

To refresh their memories on the knowledge that they had already acquired from our previous water cycle activity, I distributed a simple worksheet that looked as follows:

Name:____________________________            Class:____________________________

Water Cycle Notes

Condensation:
______________________________________________________________________ 
______________________________________________________________________

Evaporation:
______________________________________________________________________
______________________________________________________________________

Precipitation:
______________________________________________________________________
______________________________________________________________________

We then, for the last time, viewed the video from the Scholastic website above. The class had 2 minutes after the video ended to take as many notes as they could on the different phases of the water cycle. Next, the fun began :)

I introduced the class to Tagxedo. When introducing students to Tagxedo, it is so important that you direct them to click on the correct 'Submit' option. Otherwise, they'll be sitting and waiting for their screen to change.

By clicking on load, students can type in their own text. I specifically directed students to click on only the triangles, so as to physically see all of the options that they could possibly choose from. Students had to choose a shape that related to the water cycle in order to get a perfect grade. They also had to incorporate the words "condensation", "evaporation" and "precipitation" into the text of the Word Cloud.

Aside from "Shape", the only other options that I allowed students to change were: "Theme" (color), "Font" and "Orientation" of words (any which way, horizontal, vertical, h/v).

Below are just a few of the many creations that came from this particular unit. Things went so well with the 2nd graders that I'm already planning to have the 3rd and 4th graders create a Word Cloud out of their original poems.

Coming soon......Audacity, Kindergartners and Poetry All Rolled into One.