Digital Labs using Sheets and Docs

I am so excited to be going digital with my lab books this year. Despite being a "techy teacher", I have always had my students keep a graph paper composition notebook for labs in chemistry.

Provide Lab as a Google Doc Copy
For this lab, my students were provided with a lab handout as a Google Doc that would force them to make a copy. This was done by sharing the link to the doc and changing the word "edit" to "copy". It was my first time doing it and it worked like a charm!

Students Record Data in Doc
Students then used their copy to write their purpose, answer their pre-lab questions, and record their dat while working in lab. My students all have an iPad, so that is the device they were working on.

Create a Class Data Table in Sheets
In a shared folder with my class, I created a class data sheet. Each group typed their data into the sheet and we ended up with a beautiful collaborative data table.

Create Individual Data Tables in Sheets
I wanted each student to practice graphing the data, so I had them copy the class data into a new sheet. This was our first time graphing, so even though all the graphs look the same the goal was to learn the process.

Graph in Sheets (on computers)
At this point, we had reached the limit of what I had my students do on their iPads. Can you graph in Sheets on iPad? YES, but you cannot insert trend lines and get the linear regression equation of the line. Google has made some marvelous improvements to Sheets on iPad. I would highly recommend checking it out! We created Scatter Plots and inserted trend lines. We used the equation from the linear regression to get the density of our substance.

Insert Graph into Docs
Google got this one right! You simply select "Insert" once you are inside your lab Doc and choose "From Sheets". It inserts a linked graph, which means if you update your graph in Sheets, it will auto update in Docs. How cool is that?!


Here is a sample of the finished product:

Comments

  1. When I need a piece of advice, I will find your posts and read them. To me, they are very useful. I can make use of advice to resolve my problems. Sometimes, I read articles to learn new knowledge. I hope I will add more posts. Thank you so much.
    gói VD300 của VinaPhone, Gói MAXSV2 của VinaPhone, Gói cước 3G VinaPhone theo ngày

    ReplyDelete
  2. I really want to express my gratitude to you. Your pieces of advice are very effective. The articles are useful. They help me so much. Can you continue uploading them frequently? I wait for them and always support you. email with love 2018,apps email with love online 2018

    ReplyDelete
  3. Thanks for your blog post and discussing your own results together with us. Very well completed! I think a lot of people find it hard to understand paying attention to many controversial things associated with this topic, and your own results speak for themselves. I think several additional takeaways are the significance of following each of the ideas you presented above and being willing to be ultra unique about which one could really work for you best. Nice job
    sales pop master online
    sales pop master app
    koi Nhật

    ReplyDelete
  4. It is because of that, it does not guarantee the source of water after filtration, safe for everyone's health. So periodically replacing the filter element is something you need to keep in mind. Filtering is an important part of the quality of the water supply. During operation, the filter core is responsible for retaining the impurities, residues, and algae, so that these impurities and harmful bacteria after a period of time can seal the filter, causing the phenomenon. reverse osmosis.
    gái gọi, gai goi ha noi, gai goi cao cap, Gái gọi Trần Duy Hưng

    ReplyDelete
  5. It is because of that, it does not guarantee the source of water after filtration, safe for everyone's health. So periodically replacing the filter element is something you need to keep in mind. Filtering is an important part of the quality of the water supply. During operation, the filter core is responsible for retaining the impurities, residues, and algae, so that these impurities and harmful bacteria after a period of time can seal the filter, causing the phenomenon. reverse osmosis.
    gái gọi, gai goi ha noi, gai goi cao cap, Gái gọi Trần Duy Hưng

    ReplyDelete
  6. Thank you very much for sharing this useful information, hope it will help many people and share it to more people know it.
    https://autoketing.com/project/facebook-chat-box, https://apps.shopify.com/facebook-chat-box, https://autoketing.com

    ReplyDelete
  7. Modern life, people always find new technology to replace old technology, it takes a lot of time. Thus, artificial grass is born not only in sports but also in garden decor. The play area for children is also used to create a green space for the garden and play in a comfortable space. for young children. In addition, it is also used in interior decoration, outdoor carpets, interior decoration, playground for kindergarten children, golf course, tennis court
    Gái gọi Nguyễn Trãi, Gái gọi Nguyễn Chí Thanh, anh sex, Gái gọi Kim Liên mới, Gái gọi Gia Lâm - Long Biên

    ReplyDelete
  8. Thanks for the post, visit this site because it has so many applications and information needed for everyone, share it to more people to know more, thanks a lot.
    shopify app free shipping bar, shipping bar app, autoketing

    ReplyDelete
  9. It is a good source of information, people should know more about this site, share it with others, I would like to discuss it too, thank you for posting this post. This really helps a lot.
    currency converter free, currency converter portable, autoketing

    ReplyDelete

Post a Comment

Popular posts from this blog

Why I'm Flipping Out Over FLIPGRID 🎥

No More Net Neutrality - What now?

Using Tech Outside of the Classroom