Introduction to Spreadsheet Problem Solving - PowerPoint PPT Presentation

Loading...

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



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Introduction to Spreadsheet Problem Solving

Description:

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: http://www.engr.uky.edu
Category:

less

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

Title: Introduction to Spreadsheet Problem Solving


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

2
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)
3
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
4
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
course
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
5
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
6
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
problems
learning VBA the missing link for most users
developing user interfaces and other enhancements
linking Excel to other software packages
7
Hanging sign example
About PowerShow.com