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 PRIMERLABS
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 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