A Versatile Platform for Programming and Data Acquisition: Excel and Visual Basic for Applications
Guardat en:
| Publicat a: | Association for Engineering Education - Engineering Library Division Papers (Jun 15, 2014), p. 24.125.1 |
|---|---|
| Autor principal: | |
| Publicat: |
American Society for Engineering Education-ASEE
|
| Matèries: | |
| Accés en línia: | Citation/Abstract Full text outside of ProQuest |
| Etiquetes: |
Sense etiquetes, Sigues el primer a etiquetar aquest registre!
|
MARC
| LEADER | 00000nab a2200000uu 4500 | ||
|---|---|---|---|
| 001 | 2317709398 | ||
| 003 | UK-CbPIL | ||
| 035 | |a 2317709398 | ||
| 045 | 0 | |b d20140615 | |
| 100 | 1 | |a Evensen, Harold T | |
| 245 | 1 | |a A Versatile Platform for Programming and Data Acquisition: Excel and Visual Basic for Applications | |
| 260 | |b American Society for Engineering Education-ASEE |c Jun 15, 2014 | ||
| 513 | |a Conference Proceedings | ||
| 520 | 3 | |a A versatile platform for programming and data acquisition: Excel and Visual Basic for Applications We have switched to a new software platform to for instrument interface and data collection in our upper-‐division Sensors Laboratory course. This was done after investigating several options and after several meetings with our industrial advisory board. This change was motivated by a campus-‐mandated change in operating system, plus expiring software licenses. We decided on the Visual Basic for Applications platform (VBA), which resides in the Microsoft Office suite (in particular, MS Excel). This meets the recommendations of our advisory board, which strongly urged that we use a “traditional” programming language, as opposed to a graphical one, in order to provide our students the broadest possible applied programming “base.” Further, it has the advantage that the platform is widely available and the required add-‐ins are free, so that graduates (and other programs) are able to use this as well. Finally, this approach has the added benefit of extending the students’ prerequisite computer programming into VBA, which is useful beyond the realm of instrument control and data acquisition. This paper will describe the resources that were collected – and modified – by the author, for the apparently novel combination of VBA, 64-‐bit programming, and access to both serial/USB and GPIB instrumentation, and provides examples of implementation. The basic principles of VBA for non-‐experts will also be given, as well as strengths and drawbacks of this approach. We will also report on the first offering of the redesigned course and remark on future improvements. | |
| 653 | |a Software | ||
| 653 | |a Data buses | ||
| 653 | |a Licenses | ||
| 653 | |a Visual programming languages | ||
| 653 | |a Science education | ||
| 653 | |a Visual Basic for Applications | ||
| 653 | |a Data collection | ||
| 653 | |a Graduates | ||
| 653 | |a Students | ||
| 653 | |a Control equipment | ||
| 653 | |a Computer programming | ||
| 653 | |a Application | ||
| 653 | |a Programming languages | ||
| 653 | |a Acquisition | ||
| 773 | 0 | |t Association for Engineering Education - Engineering Library Division Papers |g (Jun 15, 2014), p. 24.125.1 | |
| 786 | 0 | |d ProQuest |t Library Science Database | |
| 856 | 4 | 1 | |3 Citation/Abstract |u https://www.proquest.com/docview/2317709398/abstract/embedded/6A8EOT78XXH2IG52?source=fedsrch |
| 856 | 4 | 0 | |3 Full text outside of ProQuest |u https://peer.asee.org/a-versatile-platform-for-programming-and-data-acquisition-excel-and-visual-basic-for-applications |