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"

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:
• Get a "share" link for the assignment
• Submit the link on my late work form.
• 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

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:
• Get a "share" link for the assignment
• Submit the link on my late work form.
• 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.

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:
• Get a "share" link for the assignment
• Submit the link on my late work form.
• 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.  :-)

Agenda: Monday 12/12/16

Snow Day!

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.

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.

Test answer form

Agenda: Wednesday,12/7/16

Reminder:

Spreadsheet test on Friday

• Spreadsheet test review

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

• Minecraft

Agenda: Tuesday 12/6/16

Earth Science Test Answer Form


Spreadsheet Quiz on Friday

• Review pretest results
• Rate your current understanding
• Spreadsheet test review

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.

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.

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.