Class -- ESD 70J
Last update: Sept 6,
units to those that want them, otherwise students can register as
or simply sit in on class.
Instructors: Xin Zhang and Richard de Neufville
This micro-subject is given
over 4 periods
at the beginning of the Fall semester.
In 2012, it is offered from 5:30 to 7:30 pm
on Sept 10, 11, 12, and 13 (Mon - Thurs).
A Session 0 for
Excel beginners and those uneasy about English language version
will meet 5.00 - 5.30 on Monday September 10 in 32-155, just
before Session 1.
apologize for the awkward evening hours, but it seems to be the only
facilities needed for the class. We meet in the Stata Center,
Room 32-155, opposite the
Cafe, which supplies food and drink. Bring your lap-tops and
sustenance you need to keep you going through the class.
Details provided in the syllabus .
Session 0: Slide show0
; spreadsheet 0-1 ;
Session 1: Slide Show1 ; spreadsheet 1-1 ;
Session 2: Slide
Show2 ; spreadsheet
2-1 ; spreadsheet 2-2
Session 3: Slide Show3 ;
3-1 Part_1 ; spreadsheet
3-1 Part_2 ; spreadsheet_3-1_Part_1_@Risk;
; spreadsheet 3-2
Session 4: Slide Show4 ; spreadsheet 4-1 ; spreadsheet 4-2 ; spreadsheet_4-2_@Risk;
You may want to refer to the Excel "hot
For the convenience of people using
The purpose of the course is to enable entering graduate students to
proficient in the use of Excel, at the level needed for efficient,
effective use of
It is particularly designed to complement the combined courses:
It is however
open to all ESD students,
in whatever program, as well as to students
- Risk and Decision
Analysis, ESD 710 and
- Engineering Systems
Analysis for Design, ESD 71.
from other departments.
The motivation for this offering is that faculty notice that many
entering students have
only a rudimentary grasp of how to use Excel effectively.
Our experience is that many
familiar with how to use the Data Table function (arguably the main
the development of spreadsheets), let
alone conversant with how to run simulations
using RAND(). The
short course is designed to fill these and other
gaps quickly by
walking students through worked out examples.
Should I take the course?
To see if you should follow this course, look at the
If you feel you could comfortably complete
its tasks within a morning, then you have
no need for the short
course. On the other hand, if these tasks look daunting,
you should particpate in the short course! ESD 71/710 assume
that you will have
the capability covered in this
mini-subject. Up to you!
To receive credit for the course, you must complete the assignment by cob
(5 pm) Friday Sept. 28.