Science 200 Laboratory Manual


Science 200 is a course in Scientific Computing, Measurements and Models designed to help science students formulate, analyze, solve, and present scientific problems encountered in research or in courses. Excel is the analysis software and Powerpoint is the presentation software.

The material here includes
1. Primers for Powerpoint, Excel, and Visual Basic in Excel
2. Course Outline and the set of 22 laboratory exercises
3. Text files and images for the exercises.
4. Sample tests
5. Schedule and Assignment of Lecturers

PRIMERS


xlprimer.doc     EXCEL PRIMER
ppprimer.doc     POWERPOINT PRIMER
vbx_prmr.doc     VISUAL BASIC for EXCEL PRIMER

LABS

OUTLINE      COURSE OUTLINE
LAB 1        INTRODUCTION TO POWERPOINT
LAB 2        INTRODUCTION TO EXCEL: EQUATIONS AND DRAWING
LAB 3        FILES IN EXCEL
LAB 4        CONDITIONAL FUNCTIONS AND FORMATTING: MAPPING
LAB 5        EQUATIONS OF SYSTEMS AND CHANGE, ITERATION: EXPONTENTIALS
LAB 6        TEMPERATURE AND HEAT BALANCE MODELS
LAB 7        SIMULTANEOUS EQUATIONS (MINVERSE, MMULT)
LAB 8        SOLVING EQUATIONS - GRAPHICAL TECHNIQUES, SOLVER  
LAB 9        INTRODUCTION TO STATISTICS (COMMAND BUTTONS + SCROLL BARS)  
LAB 10       PROBABILITY DISTRIBUTIONS AND SCATTER DIAGRAMS
LAB 11       STATISTICS AND ENSO  
LAB 12       REGRESSION AND FORECASTING: CO2 TRENDS
LAB 13       STATISTICAL TESTS
LAB 14       POISSON DISTRIBUTION AND THE CHI SQUARE TEST
LAB 15       DERIVATIVES, INTEGRALS, MOTIONS
LAB 16       PREDATOR-PREY RELATIONS - THE LOTKA VOLTERRA EQUATIONS
LAB 17       MATHEMATICS OF THE ARMS RACE
LAB 18       THE CONTROL TOOLBOX - ANIMATION  
LAB 19       MAPS AND MOVING CONTINENTS
LAB 20       MACROS, COMMAND BUTTONS, AND VISUAL BASIC (VB) FOR EXCEL
LAB 21       VB PROGRAMMING: LOOPS AND CONDITIONS  
LAB 22       VB PROGRAMMING: NESTED LOOPS AND GRAPHICS
LAB 23       VB PROGRAMMING: FILE ANALYSIS AND MANIPULATION
EXTRAS       *** EXTRAS THAT MAY BE OF INTEREST AND ASSISTANCE ***

TEXT FILES AND IMAGES

sunyear1.txt  
darwin_p.txt  
tahiti_p.txt  
nyc_grid.txt  
scores.txt
atom_wt.txt
ht_wt.txt
afr_grid.gif  
sam_grid.gif
afr_map.gif  
sa_map.gif
ccny.gif
q_aswan.txt  
survey of friends
survey of views  

SAMPLE TESTS

TEST 1              TEST 1 SPRING 2005
TEST 2              TEST 2 SPRING 2005
TEST 3              TEST 3 SPRING 2005

SCHEDULE AND ASSIGNMENT OF LECTURERS

TEACHERS              FIND YOUR LECTURE AND PARTNERS