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

Popular posts from this blog

Marvin Minsky, AI, Math Education

The audio is too good to make this a gif. So, to be clear, this is the blog post for THURSDAY, 1/28. If you are looking for Tuesday's post, go back a post. I wanted to mention to you all that a mathematician and artificial intelligence researched named Marvin Minsky died on Sunday. Among lots of amazing things he did in his life, he wrote about math education for the OLPC (One Laptop Per Child) project. Here is that article ; I'd like you to read it for homework. Speaking of death, check out this amazing visualization ! Finally, for classwork, I would like you to go back to Tuesday's blog post, and comment on other people's homework. Specifically do you like the charts they chose? Are they interesting? Any feedback? Homework IMPORTANT: Pick which 5 (or more) variables that you will track for the Feltron project. Think about how you will keep track of them - pen and and notebook? The Reporter App? A pedometer? Also, that Marvin Minsky article is really...

Bio Homework 3/15

Read this follow up to the movie we watched in class: http://www.pbs.org/wnet/nature/episodes/silence-of-the-bees/how-can-you-help-the-bees/36/ and write a 1 paragraph response to the movie and the reading. And remember... study study study! There's a quiz on Wednesday.

ISRP March 17th, Transformation

Theme: Transformation First, I returned work. Checked in with people who have missing assignments. I should probably grade late ones, but haven’t. Second, share any good ads. Collect homework; if you don’t have it go to Liz. To wrap up with morals, mention that some of them, from the homework, seem amoral. To make it clear that morals are about right and wrong, ask questions like: Do animals have rights? Do all humans have rights? Is euthanasia acceptable? Is lying ever acceptable? If someone else can obviously make more out of their life than I, is it moral to sacrifice myself for them if needed? Then we introduced the idea of transformation with these stories: Samsa and Seuss from This American Life: (14 min) Goo and You - Radiolab - What happens to butterflies? (17 min) Homework: Write a short, short story involving transformation. Ideally, it would have a theme, or moral. Actually, ideally it would be really good and fu...