Tuesday, November 29, 2016

Agenda: Tuesday 11/29/16

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





  • (5th and 6th hour) Turn in a spreadsheet that acts as a checkbook
    1. Include columns for 
      1. the item (paycheck, eating out, etc)
      2. income
      3. expenses
      4. total in account; don't forget to include the starting amount
    2. The "total" column should update automagically whenever you add income or subtract an expense. Create a formula that will do either so you can copy it down the "totals" column.
    3. Submit via Google Classroom

    Monday, November 28, 2016

    Agenda: Monday, 11/28/16

    Review Spreadsheet Concepts

    • formula
    • cell reference
    • autofill handle



      Redo Spreadsheet practice (create a sheet that calculates your grades)

        1. Create a spreadsheet that helps you calculate your grades. You will need:
          1. A column for the assignment name
          2. A column for the assignment type (quiz, homework, project, etc.)
          3. A column for the number of points possible
          4. A column for the number of points you actually earned
          5. A column that uses a formula to actually calculate your grade on the assignment (format it as a percentage)
          6. A cell that averages your grades into one overall percentage.
        2. Fill in the data for 8 assignments and find out the grades. You may use real or made-up data; do not give yourself a 100% on everything!
      (5th and 6th hour) Create a spreadsheet that acts as a checkbook
        1. Include columns for 
          1. the item (paycheck, eating out, etc)
          2. income
          3. expenses
          4. total in account; don't forget to include the starting amount
        2. The "total" column should update automagically whenever you add income or subtract an expense. Create a formula that will do either so you can copy it down the "totals" column.
        3. Submit via Google Classroom

      Tuesday, November 22, 2016

      Agenda: Tuesday, 11/22/16

      Finish the assignment from Friday and submit it to Google Classroom.


      Here are the instructions again:

      Spreadsheet practice: create a sheet that calculates your grades

      1. Review these websites for info on working with spreadsheets:
        1. Spreadsheet basics
        2. Using formulas (this one is really important)
        3. Cell borders and colors (The link takes you to the last page of the tutorial; don't worry about the previous pages)
      2. Use this information and your notes to complete this assignment:
        1. 1st and 2nd hour: see Google Classroom (½) for the assignment.
        2. 5th and 6th hour:  see Google Classroom (5/6) for the assignment.
        3. Instructions:
          1. Create a spreadsheet that helps you calculate your grades. You will need:
            1. A column for the assignment name
            2. A column for the assignment type (quiz, homework, project, etc.)
            3. A column for the number of points possible
            4. A column for the number of points you actually earned
            5. A column that uses a formula to actually calculate your grade on the assignment (format it as a percentage)
            6. A cell that averages your grades into one overall percentage.
          2. Fill in the data for 8 assignments and find out the grades. You may use real or made-up data; do not give yourself a 100% on everything!
          3. There are several variations listed for the assignment in Google Classroom; these are optional for anyone who would like a challenge, but they are not required.

      Friday, November 18, 2016

      Agenda: Friday, 11/18/16

      Spreadsheet practice: create a sheet that calculates your grades

      1. Review these websites for info on working with spreadsheets:
        1. Spreadsheet basics
        2. Using formulas (this one is really important)
        3. Cell borders and colors (The link takes you to the last page of the tutorial; don't worry about the previous pages)
      2. Use this information and your notes to complete this assignment:
        1. 1st and 2nd hour: see Google Classroom (½) for the assignment.
        2. 5th and 6th hour:  see Google Classroom (5/6) for the assignment.
        3. Instructions:
          1. Create a spreadsheet that helps you calculate your grades. You will need:
            1. A column for the assignment name
            2. A column for the assignment type (quiz, homework, project, etc.)
            3. A column for the number of points possible
            4. A column for the number of points you actually earned
            5. A column that uses a formula to actually calculate your grade on the assignment (format it as a percentage)
            6. A cell that averages your grades into one overall percentage.
          2. Fill in the data for 8 assignments and find out the grades. You may use real or made-up data; do not give yourself a 100% on everything!
          3. There are several variations listed for the assignment; these are optional for anyone who would like a challenge.

      Thursday, November 17, 2016

      Agenda: Thursday, 11/17/16

      1st and 2nd hour

      ES: notes on the interior of the earth

      Continue intro to spreadsheets

      Spreadsheet practice: create a sheet that calculates your grades; see Google Classroom (½) for the assignment.


      5th and 6th hour

      Spreadsheet practice: create a sheet that calculates your grades; see Google Classroom (5/6) for the assignment.



      Wednesday, November 16, 2016

      Agenda: Wednesday 11/15/16

      Spreadsheets pre-test (answer form here).

      Notes: intro to spreadsheets (this information can be found at http://www.gcflearnfree.org/)

      Tuesday, November 15, 2016

      Friday, November 11, 2016

      Agenda: Friday 11/11/16

      I'm not here today! Are you?

      1st and 2nd hour: 

      Science review and test


      5th and 6th hour:


      1. Look at the rubrics from yesterday’s projects (one per group).
      2. Circle or highlight the areas where you lost points.
      3. Then use the time to correct the problems with your project.
        1. Write up the information you left out of your presentation in detail, using a Google Doc or a slideshow. For example, many students lost points for failing to provide examples; this would be a good time to do so. 
        2. If you lost points for a spoken part of the presentation (for example, a hook in your introduction), write out a script for what you would say if you were going to present again.
        3. Everything must be in your own words. Anything copied from a website will not be accepted.
        4. Project corrections are to be done individually.
        5. I will collect corrections on Monday.

      Monday, November 7, 2016

      Agenda: Monday, 11/7/16 through Thursday 11/10/16

      Monday: Project work time
      Tuesday: no school
      Wednesday: Presentations
      Thursday: Presentations and science test review.

      Friday, November 4, 2016

      Agenda: Friday, 11/4/16

      Review internet notes; discuss WiFi

      Develop an idea for your project. Rubric can be found here.


      For those who need them, directions for Quarter 1 assignments can be found here.

      Wednesday, November 2, 2016

      Agenda: Wednesday 11/2/16

      Test scores are in MiStar. If you would like to retake it, you may do so this Thursday. In order to retake the test, you must draw by hand on paper a diagram of how a computer works. You must include:
      • The major components of a computer
      • What each component is
      • What each component does
      • How information moves through the computer, starting with input and ending with output.
      Please check your grades. The quarter ends on Friday.



      Today:
      Use SketchUp to design some sort of dwelling, real or imaginary. When you are done, you will save it with your full name (last name, then first name), download it, and share it with me via the assignment in Google Classroom.


      How is data stored?
      How is data transmitted?
      • Notes on the internet
      • Terms:
        • IP Address
        • Server
        • Network
        • DNS
        • URL

      Tuesday, November 1, 2016

      Agenda: Tuesday, 11/1/16

      Test scores are in MiStar. If you would like to retake it, you may do so this Thursday. In order to retake the test, you must draw by hand on paper a diagram of how a computer works. You must include:
      • The major components of a computer
      • What each component is
      • What each component does
      • How information moves through the computer, starting with input and ending with output.
      Please check your grades. The quarter ends on Friday.



      Today:
      Introduction to SketchUp, a program for creating 3d models. A free version of Sketchup can be downloaded for Mac or Windows at www.sketchup.com. For the Chromebooks there is a surprisingly powerful online version at my.sketchup.com.

      Use SketchUp to design some sort of dwelling, real or imaginary. When you are done, you will save it with your full name (last name, then first name), download it, and share it with me via the assignment in Google Classroom.