Skip to main content

Spreadsheets & Continue Reviewing, Thursday 1/21

I'm tired and this is really funny


Anyway. Today you are going to learn about SPREADSHEETS!
YAY!

"What are spreadsheets?" you ask?

Behold!
...it's a grid of boxes, called "cells".

"But wait!" you naively protest, "that isn't exciting or interesting!"

Ok, I grant you it may not be exciting, but it is interesting. Spreadsheets are oddly powerful. They changed the face of commerce since their widespread adoption in the 1980s (there's a good podcast about that that we can listen to sometime if we have extra time)


Spreadsheets count as a programming language, and are the most widely-used one. The vast majority (>90%) of companies use spreadsheets. And finally:

They do all the work for you!

Can you imagine how much you have to add, subtract, multiply, divide, calculate means, etc when you are running a business? You pay for things, you sell things, but the price of things change. What will the thing you are buying cost tomorrow? Next week? How much do you have to sell it for? Can you afford to give every salesperson a Raise. Why do you sell more of Thingy1 on Fridays, except at Store9, where you sell more of Thingy1 on Tuesdays. How could you possibly look at all that the information needed to figure that out? With a spreadsheet.

OK, enough build-up

Let's actually use one.

Starting process:

  1. Go to drive.google.com
  2. Sign into Google.
    1. If you don't have an account, we can make you one. You can use fake information
  3. Click the red "NEW" button, then find the option that says "Google Sheets"
  4. You have a spreadsheet!

Baby steps:

  1. enter a number in the upper left, cell A1
  2. enter another number below it, in cell A2
  3. enter yet another number below that one, A3
  4. in the cell below your last number, A4, write the following: =SUM(
  5. then click the first number, then hold down the 'shift' key and while holding it, click the last number
    1. It should say =SUM(A1:A3
  6. hit enter
  7. Now cell A4 displays the sum of cells A1 through A3. It could have just as easily multiplied, and it could have handled a few thousand numbers instead of three.
  8. In A5, find the product of cells A1 though A4.
  9. In A6, find the mean of cells A1 through A5 (hint: use AVERAGE, not MEAN).
Are you starting to see why this is so useful? Show me when you have completed this. BTW, anything after an equals sign is a FUNCTION. If a cell has a function in it, it doesn't show the function, but rather, it shows the answer the function gets. If you write "=SUM(10,5)" it will show "15", for example. Functions can get very complicated...

Finally go to your classwork/homework spreadsheet, "Possible Cars for my Growing Family". You have to use the information I put together and a formula that you come up with to help me pick a car to buy. For real.

For homework, do

  • Finish the Possible Cars for my growing Family spreadsheet
  • Finish any review problems from this list:

Comments

Post a Comment

Popular posts from this blog

Monday 9/28

9/28/15 Monday Check in: Friday class & Homework Classwork: As long as we’re talking climate change... If someone tells you they don’t believe humans are causing it, you might want to ask them if smoking is bad for you. Why? There is as much evidence that humans are causing global warming as there is evidence that smoking causes cancer (you don’t have to click that link, I just like to put it up). Anyway, here’s a chart: It is entitled “Breakdown of the anthropic greenhouse gas emissions by gas, in billion tons carbon equivalent, in 2004” - it is a breakdown of the greenhouse gases emitted in 2004 that humans are responsible for. What’s the biggest greenhouse gas? What’s all that CO2 doing, and where does it go? A lot of it goes into the ocean, which seems better than the air, and it is... up to a point. The more CO2 in the ocean, the more acidic it gets (And the more acidic it gets, the lower its ph gets). That is fine... until it’s not. At some...
4 comments
Read more

Statistical Studies - Tuesday 2/2/2016

Ok, today didn't go exactly as planned. If you saw the blog post I had up planned for today... we will get to that, but I incorrectly estimated how long some work would take you. Not your fault. You guys just move so fast through most material! You are working on the  Statistical Studies topic  on Khan Academy. It is not easy. That is okay. You don't have to get frustrated, or discouraged, or stressed. If it takes longer than I thought it would, I'll give you more time. Some good insights from the classwork: Go straight to the exercises, but go back to the videos if you are stuck If the videos feel too long, you can speed up playback (in the options menu, click the gear button). 1.25x isn't even noticeable. 1.5x is, but if you listen for a while you get used to it and can switch to 2x An "experiment" involves splitting a subset of the population you are looking at into two groups: one called the "control", who don't do anything diff...
5 comments
Read more

Feltron Variables - Monday 2/1/2015

Do you have your tickets... to the gun show? #flexin #doyouevenliftbro Please complete this to show you did your homework: Loading... So, let's talk about what makes this project hard: actually collecting data. It's not hard, but somehow, doing it every day is hard. It's easy to miss a day... then two... then all the sudden, you have missed a bunch, and it's scary and you don't want to think about it, so you don't do it. So we are going to preempt all that by putting some work in today to make it hard to forget. First, we will make a Google form. I started it for you, all you is copy it and add your 4 variables . Once you have that, you are going to use a cool feature of Google Sheets to have google email you this form every day. The form will be in the email itself, so all you have to do is open the email, fill out the form, and hit enter. Here are the instructions to follow . Don't be intimidated! You just have to copy and paste some cod...
2 comments
Read more