Test 2 Flashcards
Module
a set of actions run continuously when certain criteria are met (aka macro)
1st step to creating a userform
insert->userform
Application.OnTime
Use when you want to schedule some activity of the program at a certain time, eg. runs “showtime” every second
Userform
Triggers events by controls
Format for Do Until
Do Until [Jump out Condition]…Loop
Major functions needed in time related interface design (3)
- how to display real time dynamically
- Time adjustment - how to stop displaying the real time in order to adjust the time
- Alarm function - how to play sound
Timer vs. time vs. timevalue
timer; cannot keep time of system, time can, timevalue are arbitrary time values added or subtracted from time
VBA
a graphical programming tool
Place that defines what the button says
“Caption”
Coding skills for production systems
Simulation of production systems, healthcare systems
Place that defines the code name for the button
“Name”
How to turn on VBA
File->Options->customize ribbon
Steps to creating “adjust time” module
(1) create userform and 3 labels
(2) declare variables and adjhour
(3) code the module
(4) code the userform
Coding languages in operations research
MATLAB, CPLEX
Where to display time in VBA
- Toolbox -> Label (Label.caption)
- Toolbox -> TextBox (TextBox.text)
Saving VBA
A macro-enabled workbook
Benefits of VBA (3)
- easy to learn compared to C++ or C
- easy access
- data logging
Format for Do While
Do While [condition]…Loop
Format for If Then
If [condition] Then…Else…End if
Coding skills for HCI
Design and program interactive interface to interact with subjects/users
the horizontal in information architecture
depth
Interactive UI Materials
A stack of paper, colored pencils
4 ways to arrange elements within one layer
(1) alphabetically
(2) functionally
(3) frequency of use (most used at top)
(4) sequence of use/operation
Best balance of depth and breadth
depth < breadth
