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:


  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

  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


Post a Comment

Popular posts from this blog

Why did I become a teacher? Because I was a black belt first.

Why I'm Flipping Out Over FLIPGRID 🎥

No More Net Neutrality - What now?