1 / 14

Session 6 - Spreadsheet Assignment

Note: We are NOT going to do a grade book!. Session 6 - Spreadsheet Assignment. Introduction to creating a classroom spreadsheet. Outline of Session 6. What is a spreadsheet? Microsoft Excel Introduction to simple spreadsheet. List of things you can do… Actual spreadsheet.

elma
Download Presentation

Session 6 - Spreadsheet Assignment

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Note: We are NOT going to do a grade book! Session 6 - Spreadsheet Assignment Introduction to creating a classroom spreadsheet.

  2. Outline of Session 6 • What is a spreadsheet? • Microsoft Excel • Introduction to simple spreadsheet. • List of things you can do… • Actual spreadsheet. • List of resources and classroom projects using spreadsheets. • Download a sample spreadsheet from the web to practice on. • Work on U.S. Census spreadsheet assignment. • Post spreadsheet file to web. • Modify standards.htm to include Spreadsheet Assignment link (NETS Standard I. A.).

  3. What is a spreadsheet? • A simple way to think of a spreadsheet is as a blank sheet of paper with columns and rows. Each intersection of a column and row results in a cell where data can be recorded. • A spreadsheet application is a software program in which you can enter words and numbers as well as formulas to calculate numbers. A spreadsheet might be used by accountants to keep a ledger or by a teacher to create an electronic grade book. • Unlike the paper version the computer version can automatically manipulate, calculate and display data.

  4. What is a spreadsheet? Excel 2003

  5. What is a spreadsheet? Office button Tabs Ribbon(purple area) Name box Formula bar Dialog window button Excel2007 Status bar (Not shown) Worksheet name

  6. What is a spreadsheet? History • Lotus 1-2-3 (DOS version) • Early 1980’s • Lotus 1-2-3 (Windows version) • 1990’s

  7. What is a spreadsheet? Excel specifications and limits Blank sheet of paper. Columns (A - ?) ( 6,384 ) Rows ( 1 - 1,048,576 ) Worksheets (1 - ?) Limited by available memory and system resources Column width 255 characters Row height 409 points Cell is the intersectionof a column and a row.(Cell “F13” shown inred at the right.) Cell coordinates are in the form of column/row “F13”.

  8. Microsoft Excel • Current dominate spreadsheet application. • Tutorials and templates for Excel available at:www.microsoft.com/education/ Trivia: The original version of Lotus 1-2-3 had 2048 rows of 256 columns.

  9. Introduction to simple spreadsheet.

  10. Introduction to simple spreadsheet. • Cell D12 selected on Sheet 1 • Function:=SUM(D5:D12) • Three differentcharts representingthe data.

  11. List of things you can do… • Operations: add (+), subtract (-), multiply (*), divide (/) • Order formulas: 9 = (2+1)*3 vs. 5 = 2+1*3 • Functions: =SUM(range), =AVG(range) • Graphing/charting: • Conditions: =if(condition,true,false)

  12. Actual spreadsheet from EDUC496. From: Using Excel to Analyze Data: an example Demonstrates data organization, missing data, charts, and using the following data analysis formulas: • Mean [ =AVERAGE(C4:C24) ] • Mode [ =MODE(C4:C24) ] • Median [ =MEDIAN(C4:C24) ] • Maximum [ =MAX(C4:C24) ] • Minimum [ =MIN(C4:C24) ] • Range [ =C37-C40 ] • Countif [ =COUNTIF(C4:C24,">3") ] (Occurrences of) 

  13. List of resources and classroom projects using spreadsheets. • Almost Everything You Need for Using Spreadsheets in the Classroom (www.ncwiseowl.org) • Condensed from postings from the EDTECH listserv at H-NET.MSU.EDU • Shopping Spree – online toy shopping with imaginary currency. Calculate:total cost = price + taxes + shipping + other. • Manage the class Scholastic Book Order. • Investment tracking and analysis for a semester. • Graphing M&M’s and Lucky Charms.

  14. Shakespeare'sFavorite Formula The end... =OR(B2,NOT(B2)) Bad Spreadsheet Humor

More Related