Spreadsheets

Goal: Learn to use a spreadsheet program to do arithmetic and create graphs.

Before Starting: Essential Points
  1. Teacher notes:
    1. Start at the very beginning of class, when possible
    2. Open Excel
    3. Save file and create folder
  2. You must save all documents into your home directory (H:).
  3. In your home directory, create a folder and name it "computers".  (Unless you already have one.)
  4. Make sure to enter all formulas into cells.  (Do not type in what the result should be.)
  5. Ask teacher to try a super simple example in Excel, and show how to create a folder and save.

I. Arithmetic - Part 1

Part 1A: 
Save, Create, and Add
  1. Raise your hand when you are done.  Politely ask your teacher to check it.

Part 1B: Use Formulas and Do Cool Stuff
  1. Raise your hand when you are done.  Politely ask your teacher to check it.

Part 1C:  Save & Convert
  1. If you have already saved, you may fast forward to 2:50!  :-)
  2. Watch This Video to Save Upload
  3. Raise your hand when you are done.  Politely ask your teacher to check it.


Part 1D:  Submit to Infinite Campus Portal
  1. Hand it In through the Portal
  2. Raise your hand when you are done.  Politely ask your teacher to check it.




II. Circle Charts

Part 2A:  My Day Circle Chart

  1. Part 2A - How to Make a Circle Chart! - Updated 2015 Fall
  2. Raise your hand when you are done.  Politely ask your teacher to check it.


Part 2B:  A Typical Saturday for Me

  1. Create a circle chart showing a typical SATURDAY for you, how you spend your time.
  2. Enter the data on one sheet.  Name this "Saturday".
  3. Make the graph a separate sheet.  Name it "My Saturday
  4. Raise your hand when you are done.  Politely ask your teacher to check it.





III.  Column Charts

Part 3A:  Population of Countries

  1. Part 3A How to Make a Column Chart - Updated 2015 Fall
  2. Raise your hand when you are done.  Politely ask your teacher to check it.


Part 3B:  States' Highest Elevations

  1. Make a column chart of highest points (elevations) in meters of several states in the USA .
  2. Choose any seven (7) states.
  3. Make a nice table with the name of the states, and the elevation of each state's highest point (in meters, NOT feet).
  4. Info 1: Use the Wikipedia page titled "List of U.S. states by elevation".
  5. Create a good looking column chart. Make it a separate sheet.
  6. Info 2:  Both axes need titles.
  7. Info 3:  Anytime a legend or key has only one color, get rid of it.
  8. Raise your hand when you are done.  Politely ask your teacher to check it.


Part 3C:  Download & Submit

  1. Download spreadsheet to home directory & submit to grade book (updated 2015).
  2. Raise your hand when you are done.  Politely ask your teacher to check it.




IV.  Scatter Plots (also called XY plots)

Part 4A:  Table of Human Height

  1. Create a table of a person's height from one year to the next, along with an scatter chart.
  2. Watch this video to create the XY scatter plot (updated 2015).
  3. Raise your hand when you are done.  Politely ask your teacher to check it.


Part 4B:  Human Population Growth

  1. Create an XY scatter chart, showing the number of humans on Earth, every 10 years, from 1900 thorough 2010.
  2. Hint: Use the Wikipedia page called "world population estimates".
  3. Make the titles and labels on the axes describing what is being shown.
  4. Raise your hand when you are done.  Politely ask your teacher to check it.




V.  Checking Dubious Claims

Part 5A:  A Dubious Claim

  1. Watch this video and do all the steps along with the video.
  2. Raise your hand when you are done.  Politely ask your teacher to check it.


Part 5B:  Download & Submit

  1. Download your file to your COMPUTERS folder as an XLSX file.
  2. Submit the file to Infinite Campus Portal for the "Spreadsheets - Dubious Claims" assignment
  3. Hint:  If you don't remember how, watch this video:   Google Docs to Infinite Campus
  4. Raise your hand when you are done.  Politely ask your teacher to check it.

 

 


Teacher Notes

  • The first students to complete all parts will take about four class periods of 54 minutes each; these will be the fastest typists in the class.
  • The first part can be completed in a class period, but only if students do not have to repeat to redo formulas, or have issues with software bugs.
  • 7th grade students were given five full class periods to work on this unit.  Most completed parts 1, 2, and 3.  Parts 4 & 5 scored as "bonus assignments".
  • 8th grade student had six class periods, and were scored for all 5 sections.


  1. There are some changes to the video below.  Please read these first, then watch the video:
  2. CHANGE 1:  Office 2013 looks a little different.  Just keep working to save it.
  3. CHANGE 2:  To create a folder (if needed), click the new folder button at the top left, and name it:  Computers.
  4. CHANGE 3:  To open the file once it is in Google Drive ->  Right-Click on the file; then go to Open With -> Google Sheets.
  5. Save it, convert to Google Docs format & rename sheets. (db)




OLD -- Before 2015 October

Part 1A:  Create a Sheet

  1. Create a spreadsheet by doing these steps:  Spreadsheet Tutorial Video.
  2. Hint: Pause and rewind the video as much as you want.
  3. Raise your hand when you are done.  Politely ask your teacher to check it.

Part 2C:  Share a Google Doc File

  1. Share your Google Doc file with your teacher.
  2. Click on Share so your teacher can check that email address.
  3. Raise your hand when you are done.  Politely ask your teacher to check it.


Creative Commons License
This work by Aaron Wissner is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.

 

Comments