CS 200 Fall 2015Excel ScriptingAdministriviaPlease read and highlight the assignment and course notes before labStaff suggests reading the assignment before lecture(Last term’s is usually quite similar to this term’s, if the latter is not yet available)There are hyper-text commented source files for most of the Excel macros used in this lecturesee “Lectures > Commented Excel Macros” on the CWSFiles used in this lecture are on LearnWeek 6: Application Scripting (Excel): Files for LectureTodayScripting in ExcelThe Copy PearlRemember that the CWS contains material on the pearls WarningWe are running Office 2011, in the Mac Labs—test Windows docs in the lab before submitting3
CS 200 Fall 20154Midterm InformationThe midterm is on Thursday of next week in classContentThe midterm will mostly consist of short essay questions.50-75% of the questions will be, or be derived from, the Study Questions in the course notes.There is alwaysa pearl question.There is usuallya compare-and-contrast question.There is oftena design question (eg from Robin Williams).There is oftena “how does this dialog work” question.There are alwayskeyword definitions (see Learn for weekly keywords).A sample midterm can be found in the course notes & online.The midterm is worth 25% of your final mark.
CS 200 Fall 2015Excel ScriptingAssumptionYou have used a spreadsheet beforeYou understand a simple program/algorithm5
CS 200 Fall 2015Excel ScriptingThings to Think AboutWhat are the data objects in a Spreadsheet program?How does the interface differ from the other applications we have seen so far?What are the efficiencies/deficiencies of the interface?When would I use a spreadsheet?How does a spreadsheet compare to a database?How would macros be useful in other applications we have seen so far?6
CS 200 Fall 2015PearlsThe Copy PearlKeep copies of your old stuff aroundin well-named files and foldersworks better if you comment what you doLurk on news groups and capture examples as they come byCheck out what comes with the appBuild a list of what examples can be found where
CS 200 Fall 2015Excel ScriptingApplication Scripting in ExcelWhat is “(intra-)application scripting”?
You've reached the end of your free preview.
Want to read all 44 pages?
Visual Basic for Applications, scripting, Visual Basic Editor