Class10 - Class meeting #10 Monday, Sept 27th Alt-F11 GEEN...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1 1 GEEN 1300 Introduction to Engineering Computing Class meeting #10 Monday, Sept 27 th Excel & Visual Basic for Applications (VBA) b The VBA Programming Environment b Recording Macros b Working with the Visual Basic Editor (VBE) Section Test #1, tonight, 7:00-9:00, HUMN 1B50 Sections 101-106 RAMY C250 Sections 107-112 bring pencils, eraser, calculator Coverage: Class #1 through #9, Labs 1-5 Text, pages 1-274 Alt-F11 2 More Announcements Office hours tonight from 4:30-6:00 B any final questions for the exam Office hours tomorrow – cancelled! (no HW due Wednesday) *Anything we announce via email is official ! *Anything we announce in class is official ! B no excuses! Tip: In your email account, create a folder for each course and place emails in that – check that it isn’t going to spam. Everything in this course is your responsibility , we are the facilitators!
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 3 One More Announcement CHEN/CBEN Majors – MANDATORY ADVISING IN THE NEXT COUPLE OF WEEKS!! KEEP AN EYE ON YOUR EMAIL – DON’T TAKE LIGHTLY AND DON’T DELETE – YOU WON’T BE ABLE TO REGISTER WITHOUT YOUR “FLAG” LIFTED!!! 4 Clicker Question What advantage does the Bisection Method have over Goal Seek and the Solver tools in Excel? B) The bisection method solution is “live”, meaning that as soon as you change an input value the solution also changes. C) Constraints can not be used with the Solver. A) The bisection method can be easily used for optimization.
Background image of page 2
3 5 Why get involved with this programming business? If you can't program, you will be limited by Excel's built-in capabilities. These are many, but Excel will be dictating to you what you can do. Programming lets you turn the tables. If you can't program, your use of Excel will be inefficient. Programming allows you to automate repetitive activities and cut down on your work time. Time is money, etc. We live in a competitive world. If you can't program in Excel, someone else will be able to. Their work will be better than yours. They will beat you out. 6 What is VBA? It is the programming language embedded in Excel. What isn’t VBA? It is not Visual Basic. Visual Basic is a separate, software package that is used for developing stand-alone Windows applications. It is very different from VBA.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 14

Class10 - Class meeting #10 Monday, Sept 27th Alt-F11 GEEN...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online