Monday, December 19, 2016

Agenda: Monday, 12/19/16

Announcements & Reminders:

  • The spreadsheet test makeup is moved to Wednesday. If you would prefer to take it Tuesday (for example, if you're not going to be here on Wednesday), let me know and I'll arrange that. If you would like to retake the Spreadsheet Test, you must have no missing assignments for my class.
  • If you turned in an assignment on time and would like to redo it for a better grade, as always you certainly may do so. Please show me your work in class, before school, or after school and I can update your grade on the spot.  :-)

Today's Work

UPDATE: This app is not working for us. Don't worry about doing the assignment.

1st/2nd hour:

Work on Moovly (example). Due tomorrow.
Goal:
  • Create an animation that contains at least two actors (or sprites) and a background.
  • The actors must move.
  • The actors must somehow react to each other or to other objects in the animation.

Reminder: you will need to create an account:
  1. Go to www.moovly.com
  2. Click "sign up/login"
  3. Click "Google Login" and sign in with your pinckneypirates.org account.
  4. Click "Create New Moov"
  5. Name it,
  6. Click "Create from scratch"

5th/6th Hour:

Due to our technical difficulties from Friday, the moovly assignment isn't due until tomorrow. Today you have time to work on your Moovly (example). Due tomorrow.
Goal:
  • Create an animation that contains at least two actors (or sprites) and a background.
  • The actors must move.
  • The actors must somehow react to each other or to other objects in the animation.

Reminder: you will need to create an account:
  1. Go to www.moovly.com
  2. Click "sign up/login"
  3. Click "Google Login" and sign in with your pinckneypirates.org account.
  4. Click "Create New Moov"
  5. Name it,
  6. Click "Create from scratch"

Thursday, December 15, 2016

Agenda: Thursday, 12/15/16

Reminders:

  • The Scratch Tutorial was due on Tuesday.
  • If you would like to retake the Spreadsheet Test, you may do so next Tuesday, December 20th. However, in order to retake the test, you must have no missing assignments for my class.
  • If you are missing a spreadsheet assignment, you have until Friday to turn it in to me. You will not receive full credit and there are no redos for assignments turned in past the due date. In order to get credit for it you must do the following:
  • If you turned in an assignment on time and would like to redo it for a better grade, as always you certainly may do so. Please show me your work in class, before school, or after school and I can update your grade on the spot.  :-)

Today's Work

1st/2nd hour:

Introduction to Moovly (example).

Create an account:
  1. Go to www.moovly.com
  2. Click "sign up/login"
  3. Click "Google Login" and sign in with your pinckneypirates.org account.
  4. Click "Create New Moov"
  5. Name it,
  6. Click "Create from scratch"
Goal:
  • Create an animation that contains at least two actors (or sprites) and a background.
  • The actors must move.
  • The actors must somehow react to each other or to other objects in the animation.

5th/6th Hour:

Earth Science work today

Wednesday, December 14, 2016

Agenda: Wednesday, 12/14/16

Announcements

Scratch Tutorial was due yesterday.

Many have not turned this in.
Turn it in:
    1. take a screenshot and submit it to Google Classroom
    2. Create a (free) Scratch account and publish your animation there (if you don't share it, I won't be able to see it). Take the link and paste it in this form.

Grade Announcements

  • Grades are up to date. Check them and let me know if there is a mistake. Some of you aren't putting names on things.
  • If you would like to retake the Spreadsheet Test, you may do so next Tuesday, December 20th. However, in order to retake the test, you must have no missing assignments for my class.
  • If you are missing a spreadsheet assignment, you have until Friday to turn it in to me. You will not receive full credit and there are no redos for assignments turned in past the due date. In order to get credit for it you must do the following:
  • If you turned in an assignment on time and would like to redo it for a better grade, as always you certainly may do so. Please show me your work in class, before school, or after school and I can update your grade on the spot.  :-)

Today's Work

Introduction to Moovly (example).

Create an account:
  1. Go to www.moovly.com
  2. Click "sign up/login"
  3. Click "Google Login" and sign in with your pinckneypirates.org account.
  4. Click "Create New Moov"
  5. Name it,
  6. Click "Create from scratch"
Goal:
  • Create an animation that contains at least two actors (or sprites) and a background.
  • The actors must move.
  • The actors must somehow react to each other or to other objects in the animation.

Tuesday, December 13, 2016

Agenda: Tuesday, 12/13/16

Work on Scratch Tutorial. This is due today.

  1. Create a project in Scratch (scratch.mit.edu)
    1. Option 1: go to Scratch: Make it Fly tutorial and complete it
    2. Option 2: create a game of your own design
  2. Turn it in:
    1. take a screenshot and submit it to Google Classroom
    2. Create a (free) Scratch account and publish your animation there (if you don't share it, I won't be able to see it). Take the link and paste it in this form.
  3. If you finish with this early, then the challenge for you is to figure out how to make your main sprite react to colliding with other objects (or make other objects react to colliding with your sprite). Please submit your work as described above in #2.
  4. If you finish all of the above, you may work on missing work (see below).

Grade Announcements

  • Grades are up to date. Check them and let me know if there is a mistake. Some of you aren't putting names on things.
  • If you would like to retake the Spreadsheet Test, you may do so next Tuesday, December 20th. However, in order to retake the test, you must have no missing assignments for my class.
  • If you are missing a spreadsheet assignment, you have until Friday to turn it in to me. You will not receive full credit and there are no redos for assignments turned in past the due date. In order to get credit for it you must do the following:
  • If you turned in an assignment on time and would like to redo it for a better grade, as always you certainly may do so. Please show me your work in class, before school, or after school and I can update your grade on the spot.  :-)

Monday, December 12, 2016

Friday, December 9, 2016

Agenda: Friday, 12/9/16

Test answer form

Work on Scratch Tutorial.
  1. Create a project in Scratch (scratch.mit.edu)
    1. Option 1: go to Scratch: Make it Fly tutorial and complete it
    2. Option 2: create a game of your own design
  2. Turn it in:
    1. take a screenshot and submit it to Google Classroom
    2. Create a (free) Scratch account and publish your animation there (if you don't share it, I won't be able to see it). Take the link and paste it in this form.
  3. If you finish with this early, then the challenge for you is to figure out how to make your main sprite react to colliding with other objects (or make other objects react to colliding with your sprite). Please submit your work as described above in #2.


Thursday, December 8, 2016

Agenda: Thursday, 12/8/16

Reminder: test tomorrow

  • how to write a range


Debrief Hour of Code

  • What is code?
Animation notes

Assignment: Scratch Tutorial
  • go to Scratch: Make it Fly tutorial and complete it
  • To turn it in:
    • take a screenshot and submit it to Google Classroom
    • Create a (free) Scratch account and publish your animation there. Take the link and paste it in this form.

Wednesday, December 7, 2016

Agenda: Wednesday,12/7/16

Reminder:

Spreadsheet test on Friday

1st Hour

Review these concepts:

  • working with multiple sheets
  • keyboard navigation and selection keys
  • relation to databases
Spreadsheet test review

  • Relative vs. absolute cell references
  • Definition of a function, including ranges
If time permits today: Hour of Code

Tuesday, December 6, 2016

Agenda: Tuesday 12/6/16

Earth Science Test Answer Form


Spreadsheet Quiz on Friday

Monday, December 5, 2016

Agenda: Monday, 12/5/16

Today

  1. Turn in Half-Life Analysis if you haven't done so already
  2. Finish and submit shopping spreadsheet (see below). Turn in both the original spreadsheet and the requested JPEG.





Assignment 2: Shopping!

Pretend you have been given $300 to spend with only two conditions: you must purchase at least 5 items and you lose any money you don’t spend (so spend as much as possible without going over!). Working by yourself or with a partner, plan how to spend it by creating a spreadsheet that allows you add up the purchase prices and quantities so that you can use as much of your money as possible. Your spreadsheet must:
  • Have a place to list:
    • each item
    • where it will be purchased
    • the quantity
    • sales tax
    • the total cost per item
    • the amount spent on all items
  • Use formulas and functions to figure out all your data. Use cell references!!!! Do not use the actual numbers as part of your formulas.


Hint #1: set up your table(s) and formulas first and then go shopping; it will be easier to stay within your price range.

Hint #2: use colors, borders, and formatting to make it easier to see how your table is organized.

To turn it in:


  1. Go to View>All Formulas
  2. Take a screenshot (Part of a page: Crtl + Shift + Switch window
  3. Import into a Google Slide
  4. In Google, use shapes and lines to identify a formula, a function, and a range on the screenshot of your spreadsheet.
  5. Name the slide with your name(s)
  6. Download as a JPEG.
  7.  Submit the JPEG and your original spreadsheet to Google Classroom.

Friday, December 2, 2016

Agenda: Friday, 12/2/16

Finish Half-Life Analysis

Goal:

Use a spreadsheet to analyze half-lives to answer the following questions:
  1. The Fermi nuclear power plant melts down. What generation of your descendants will be able to move back to Detroit? Prove it with data from a spreadsheet?
  2. You're building a sand castle on the shores of Lake Michigan. Digging in the sand, you find the charred wood left from a campfire. Analysis shows that the charring is 93.75% Carbon 12. Approximately how long ago was the campfire made? Who made it?

Steps:


    1. Create a spreadsheet to calculate half-lives. WE WILL HELP!
      1. What categories of data do you have?
      2. What question(s) do you need to be able to answer?
      3. What math will you need to perform?
        1. relative cell references
        2. absolute cell references
    2. Create a slideshow to present your results. Embed your data from your spreadsheet.
      1. Include the following slides:
        1. Title slide (include the names of the people who worked on this)
        2. The question
        3. Your data
        4. Your analysis
        5. Your conclusion (the answer to the question)
      2. Each question should be answered in its own slideshow










  • Example sheet
  • Example slideshow


  • Assignment 2: Shopping!

    Pretend you have been given $300 to spend with only two conditions: you must purchase at least 5 items and you lose any money you don’t spend (so spend as much as possible without going over!). Working by yourself or with a partner, plan how to spend it by creating a spreadsheet that allows you add up the purchase prices and quantities so that you can use as much of your money as possible. Your spreadsheet must:
    • Have a place to list:
      • each item
      • where it will be purchased
      • the quantity
      • sales tax
      • the total cost per item
      • the amount spent on all items
    • Use formulas and functions to figure out all your data. Use cell references!!!! Do not use the actual numbers as part of your formulas.


    Hint #1: set up your table(s) and formulas first and then go shopping; it will be easier to stay within your price range.

    Hint #2: use colors, borders, and formatting to make it easier to see how your table is organized.

    To turn it in:


    1. Go to View>All Formulas
    2. Take a screenshot (Part of a page: Crtl + Shift + Switch window
    3. Import into a Google Slide
    4. In Google, use shapes and lines to identify a formula, a function, and a range on the screenshot of your spreadsheet.
    5. Name the slide with your name(s)
    6. Download as a JPEG.
    7.  Submit the JPEG and your original spreadsheet to Google Classroom.

    Thursday, December 1, 2016

    Agenda: Thursday, 12/1/16

    Functions!

    Finish Half-Life Analysis

    Goal:

    Use a spreadsheet to analyze half-lives to answer the following questions:
    1. The Fermi nuclear power plant melts down. What generation of your descendants will be able to move back to Detroit? Prove it with data from a spreadsheet?
    2. You're building a sand castle on the shores of Lake Michigan. Digging in the sand, you find the charred wood left from a campfire. Analysis shows that the charring is 93.75% Carbon 12. Approximately how long ago was the campfire made? Who made it?

    Steps:


      1. Create a spreadsheet to calculate half-lives. WE WILL HELP!
        1. What categories of data do you have?
        2. What question(s) do you need to be able to answer?
        3. What math will you need to perform?
          1. relative cell references
          2. absolute cell references
      2. Create a slideshow to present your results. Embed your data from your spreadsheet.
        1. Include the following slides:
          1. Title slide (include the names of the people who worked on this)
          2. The question
          3. Your data
          4. Your analysis
          5. Your conclusion (the answer to the question)
        2. Each question should be answered in its own slideshow








    • Example sheet
    • Example slideshow


    • Assignment 2: Shopping!

      Pretend you have been given $300 to spend with only two conditions: you must purchase at least 5 items and you lose any money you don’t spend (so spend as much as possible without going over!). Working by yourself or with a partner, plan how to spend it by creating a spreadsheet that allows you add up the purchase prices and quantities so that you can use as much of your money as possible. Your spreadsheet must:
      • Have a place to list:
        • each item
        • where it will be purchased
        • the quantity
        • sales tax
        • the total cost per item
        • the amount spent on all items
      • Use formulas and functions to figure out all your data. Use cell references!!!! Do not use the actual numbers as part of your formulas.


      Hint #1: set up your table(s) and formulas first and then go shopping; it will be easier to stay within your price range.

      Hint #2: use colors, borders, and formatting to make it easier to see how your table is organized.

      To turn it in:


      1. Go to View>All Formulas
      2. Take a screenshot (Part of a page: Crtl + Shift + Switch window
      3. Import into a Google Slide
      4. In Google, use shapes and lines to identify a formula, a function, and a range on the screenshot of your spreadsheet.
      5. Name the slide with your name(s)
      6. Download as a JPEG.
      7.  Submit the JPEG and your original spreadsheet to Google Classroom.