1 / 13

IS 171 Computing with Spreadsheets

IS 171 Computing with Spreadsheets. Introduction to Spreadsheets Week 1. Introduction. Course Overview and Policies Where do spreadsheets fit? The history of spreadsheets Intro to Excel. The Idea of a Spreadsheet. What is a spreadsheet? What are its uses?

rafi
Download Presentation

IS 171 Computing with Spreadsheets

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. IS 171Computing with Spreadsheets Introduction to Spreadsheets Week 1

  2. Introduction • Course Overview and Policies • Where do spreadsheets fit? • The history of spreadsheets • Intro to Excel Fred Ferwerda and Carol Wilson

  3. The Idea of a Spreadsheet • What is a spreadsheet? • What are its uses? • Have you ever used a spreadsheet? Fred Ferwerda and Carol Wilson

  4. A Brief History of Spreadsheets • The accountant’s ledger • Dan Bricklin and Visicalc • Mitch Kapor and Lotus 1-2-3 • Bill Gates and Microsoft Excel Fred Ferwerda and Carol Wilson

  5. The accountant’s paper ledger • Big sheets of paper (spread out the sheets?) • Permits storing figures Fig. 1.1, p. 2 of book Fred Ferwerda and Carol Wilson

  6. Dan Bricklin (1951-) and VisiCalc • 1979 • Visible calculator • Apple II • Pushed sales of personal computers Fred Ferwerda and Carol Wilson

  7. Mitch Kapor (1950-) and Lotus 1-2-3 • 1982 • Spreadsheets for presentation too • Wildly successful http://www.nb-info.co.uk Fred Ferwerda and Carol Wilson

  8. Bill Gates and Microsoft Excel • 1985: originally written for Apple II • 1987: shipped with introduction of Windows • Graphical interface Fred Ferwerda and Carol Wilson

  9. Introduction to Excel • Spreadsheet: Excel calls it a Worksheet • A Workbook is a collection of worksheets • Grid of columns (labeled alphabetically) and rows (labeled numerically) • Each box is called a cell • Each cell is named by its cell reference (cell address) which is the column letter followed by the row number (such as B3) Fred Ferwerda and Carol Wilson

  10. More on Excel • Cells can contain • Constants (literals) • 1239 • Hello • Formulas • =(B3+C3) • Electronic spreadsheet does the paper version one better: it performs the calculations Fred Ferwerda and Carol Wilson

  11. Advantages • Labor Savings • Change all salaries for an company. • Do this for 1000 or more employees! • Allows "what-if" analysis; can play with the numbers… • Allows graphing and charting Fred Ferwerda and Carol Wilson

  12. Components of a Worksheet • Title Bar • Menu Bar • Toolbars • Standard toolbar • Formatting toolbar • View Toolbars menu option to change toolbars displayed • Active cell • Formula bar • Displayed value • Name box • Worksheet tabs • Entering/replacing cell contents (Tab, Enter, or arrow keys) Fred Ferwerda and Carol Wilson

  13. TM & © 2002 Grimmy, Inc. Mike Peters from http://www.grimmy.com (9/5/02) Don’t let this happen to you! Fred Ferwerda and Carol Wilson

More Related