Introduction to Spreadsheet Problem Solving - PowerPoint PPT Presentation


PPT – Introduction to Spreadsheet Problem Solving PowerPoint presentation | free to download - id: 732e04-YmNiZ


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation

Introduction to Spreadsheet Problem Solving


Title: PowerPoint Presentation Author: David Clough Last modified by: David Clough Created Date: 9/1/2000 3:19:47 AM Document presentation format – PowerPoint PPT presentation

Number of Views:15
Avg rating:3.0/5.0
Slides: 8
Provided by: DavidC341
Learn more at:


Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Introduction to Spreadsheet Problem Solving

Introduction to Spreadsheet Problem Solving
  • Historical perspective
  • Excel fundamentals
  • Overview of Excel coverage
  • Hanging sign example

Historical perspective
Bricklin Frankston VisiCalc the Apple IIe
late 70s
Kapor Sachs Lotus 1-2-3 and the IBM PC
early 80s
The also-rans Multiplan, Supercalc, Wingz, etc.
mid 80s
The competitive era Quattro Pro Excel emerge
late 80s
The end of competition Excel 5.0 VBA
93 - 94
Excel 95 Excel 97 with major changes in
VBA Excel 2000 Excel 2002 (Office XP)
Spreadsheet use by engineers scientists
Early skepticism of a tool that was
developed primarily for business applications
Wide use in industry by the mid-80s
In the 90s, evolved to most commonly
used problem-solving tool for professionals
Many academics still skeptical since they
do mostly larger-scale scientific computing.
For the engineer, knowledge and skills
of spreadsheets are essential to survival
Large demand for spreadsheet training
among professionals
Spreadsheets in engineering education
In most universities, spreadsheets are not
taught and students have to pick up the skills on
the side
At CU, spreadsheets introduced in GEEN
1300 beginning the late 80s 3 weeks at end of
Spreadsheets move to center stage in GEEN 1300 in
Fall 2000 semester, including VBA programming
A number of other universities starting to teach
use of spreadsheets now
Engineering faculty gradually recognizing the
power of spreadsheets for problem solving
Excel fundamentals
cell addressing modes
cell contents text, numbers, logicals, formulas
selecting cells and blocks of cells
copying and moving
syntax for formulas
using Excels built-in functions
creating graphs
Overview of Excel coverage in GEEN 1300
understanding spreadsheet layout and operations
learning skills for efficient use of the software
how to set up the solution of typical engineering
learning VBA the missing link for most users
developing user interfaces and other enhancements
linking Excel to other software packages
Hanging sign example