MS3111 Data Analytics with Excel VBA
Project Report (Task 2)
Project Group No:
Members (Name and Student Number):
Expand or shrink each box as needed.
|
· Application Tasks and the associated activities outline.
|
|
Screenshots of the Dim statements used at the module level and subs or functions. The name of the sub that contains the corresponding Dim statements must be clearly stated. If the reported Dim statements are in the module level, mark with “Module level”.
|
|
· Screenshots of the Userform. involved in the application.
|
|
· Screentshots of the Sub segment that involving the manipulation of workbooks and worksheets objects. Multiple screenshots may be submitted. Each screenshot must be accompanied with sufficient annotation.
· Annotation
|
|
· Screenshots of the Sub segment that involves the manipulation of Range objects for record extraction, record merging, and new variable derivations. Multiple screenshots may be submitted. Each screenshot must be accompanied with sufficient annotation.
· Annotation
|
Screenshots of the Sub segment for Userform. control usages. The subs that involve the object properties, method, and event should be reported. Multiple screenshots of a control may be submitted. Each screenshot must be accompanied by sufficient annotation.
|
· OptionButton Control
· Annotation
|
|
· CheckBox Control
· Annotation
|
|
· RefEdit Control
· Annotation
|
|
· ScrollBar or SpinButton Control
· Annotation
|
|
· ComboBox Control
· Annotation
|
|
· Frame. Control
· Annotation
|
|
· ListBox Control
· Annotation
|
|
· MultiPage Control
· Annotation
|
|
· Screenshots of the Sub segment for creating a character variable’s distribution table.
· Annotation
|
|
· Screenshots of the Sub segment for creating a table that reports summary statistics of a numeric variable for each level of a character variable.
· Annotation
|
|
· Screenshots of the Sub segment for creating a distribution table for a numeric variable.
· Annotation
|
|
· Screenshots of the Sub segment for creating the first of the two different types of charts.
· Annotation
|
|
· Screenshots of the Sub segment for creating the second of the two different types of charts.
· Annotation
|