Spreadsheets

This week in computer tech we have been working on google sheets. We hav learned how to make formulas and create charts.

The chart (made in google sheets) above graphs my physical activity over the course of the last week. I created this graph in google sheets after writing all the information down in google sheets and translating it into a graph. What I did was I put the days of the week on the top of a column and I put the physical activities I was planning to do everyday on the side of each column. Then I filled it out accordingly. After I had done this I wanted to figure out the totals of all the activity I had done each day. Instead of tracking up time to count all of the numbers and add them together, I used a google sheets formula. What I did was I made a column underneath all the other ones and labeled it “totals”. In the space underneath each column on that column I would write and “=“ and then I would put after that “insert column number on the side and column letter on the top + another role of those formulas” and so on until it was the end of the column, except the numbers would go up as I want up the sheet. Then I filled all the rows out just like that and hit return and it would calculate the total for me! I found this so cool and interesting, I didn’t know google sheets could do that. Now its a tool I will use way more often. I also think this technique would be good for a lot of other things like calculating a number of pages you read or calculating the number of school assignments you have done fo rather week. I’m really glad I learned this technique because know I can use it for whatever!

Leave a Reply