Peer Review for material titled "ID Lesson Plan: Spreadsheets to Develop Graphing Skills"
eTextbook Reviews for material titled "ID Lesson Plan: Spreadsheets to Develop Graphing Skills"
User Rating for material titled "ID Lesson Plan: Spreadsheets to Develop Graphing Skills"
Member Comments for material titled "ID Lesson Plan: Spreadsheets to Develop Graphing Skills"
Bookmark Collections for material titled "ID Lesson Plan: Spreadsheets to Develop Graphing Skills"
Course ePortfolios for material titled "ID Lesson Plan: Spreadsheets to Develop Graphing Skills"
Learning Exercises for material titled "ID Lesson Plan: Spreadsheets to Develop Graphing Skills"
Accessibility Info for material titled "ID Lesson Plan: Spreadsheets to Develop Graphing Skills"
Please enter a Bookmark title
Please limit Bookmark title to 65 characters
Please enter a description
Please limit Bookmark title to 4000 characters
A Bookmark with this title already existed.
Please limit a note about this material to 2048 characters
Search all MERLOT
Select to go to your profile
Select to go to your workspace
Select to go to your Dashboard Report
Select to go to your Content Builder
Select to log out
Search Terms
Enter username
Enter password
Please give at least one keyword of at least three characters for the search to work with. The more keywords you give, the better the search will work for you.
Select OK to launch help window
Cancel help

MERLOT II

Advanced Search



        

Search > Material Results >

ID Lesson Plan: Spreadsheets to Develop Graphing Skills

        

ID Lesson Plan: Spreadsheets to Develop Graphing Skills

Logo for ID Lesson Plan: Spreadsheets to Develop Graphing Skills
This is a lesson designed to help students understand scientific data representation (graphs, tables, etc) by having them create their own graphs after completing a scientific lab in class.  Sharing data information through Google Docs Spreadsheets will allow students the ability to compare their results with their classmates.  This lesson can be applied to any chemistry, physics, or other science related lab.
Go to material
Material Type: Reference Material
Technical Format: HTML/Text
Date Added to MERLOT: May 15, 2011
Date Modified in MERLOT: September 15, 2016
Author:
Submitter: Tammie Mirolli
Keywords: spreadsheets, Google Docs, data representation, graphs, science

Quality

  • Reviewed by members of Editorial board for inclusion in MERLOT.
    Editor Review (not reviewed)
  • User review 4.33 average rating
  • User Rating: 4.33 user rating
  • Discussion (2 Comments)
  • Learning Exercises (none)
  • Bookmark Collections (1)
  • Course ePortfolios (none)
  • Accessibility Info (none)

  • Rate this material
  • Create a learning exercise
  • Add accessibility information
  • Pick a Bookmark Collection or Course ePortfolio to put this material in or scroll to the bottom to create a new Bookmark Collection
    Name the Bookmark Collection to represent the materials you will add
    Describe the Bookmark Collection so other MERLOT users will know what it contains and if it has value for their work or teaching. Other users can copy your Bookmark Collection to their own profile and modify it to save time.
    Edit the information about the material in this {0}
    Submitting Bookmarks...

About

Primary Audience: High School
Mobile Compatibility: Not specified at this time
Technical Requirements:
Language: English
Cost Involved: unsure
Source Code Available: unsure
Accessibility Information Available: unsure
Creative Commons: unsure

Connections



QR Code for this Page

Users who viewed this material also viewed...

Discussion

Discussion for ID Lesson Plan: Spreadsheets to Develop Graphing Skills

Log in to participate in the discussions or Sign up if you are not already a MERLOT member.

Return to Top of Page
Avatar for Chris Hren
5 years ago

Chris Hren (Teacher (K-12))

I think this lesson plan does a fine job of outlining a way in which to teach ACT preparation through the use of technology. I especially liked the beginning piece of the activity where students will be graphing and examining data about the use of cell phones in schools. I think that will really get their attention and help them to focus on the material presented throughout the lab. I also really like the idea of integrating Google Docs into the lab section as I believe it leads to a great deal of collaboration and cooperation within the groups. Finally, I think the technology expectations are well within the ability of students today and that it could be done quite well in a classroom.

My only questions arose when I wanted to actually know what the lab you are doing is. Perhaps as a chemistry teacher that matters more to me then it would others. In truth though I am just curious what lab you are actually doing with this material? I ask because as all science teachers know some labs go far easier with things like this then others do. Also, as a suggestion for making the lesson seem more impactful perhaps including actual content or ACT standards would be a good idea for the instructional objectives. I believe from looking at it that you synthesized those objectives yourself which I think is always a good idea but perhaps including some Michigan HSCEs, ACT standards, or Common Core standards might be a good idea.

Technical Remarks:

In terms of technical aspects of the activity I find no problems. The actual lesson plan document worked perfectly and I believe the lesson described is well within a high school student’s technical ability.

Time spent reviewing site: 40 Minutes

Avatar for Jessica Haggerty
5 years ago

Jessica Haggerty (Teacher (K-12))

Thanks for this lesson idea.  I also teach sophomores and juniors and am always looking for more ways to prepare them for the MME as schools are so focused on the results.  I like that the students are making their own graphs and ask to come up with conclusions about the data.

One suggestion I would make is to have groups do different sets of data and have each group come up with questions that relate to their graph.  One the students share their graphs and data, the other groups can answer the questions.  This way all groups are not only practice analzying data, but also answering quetisons on data they are just seeing,

Technical Remarks:

Reading through this lesson it looks like this would all flow very smoothly with the technology.  Another thing you could do in addition to this lesson is to then have students collect data using a temperature or pH probe and practice collecting data using another form of technology.

Time spent reviewing site: 15 min