CEAB Attribute Report Enhancement

[arana2]

• The user has requested the ability to view the raw data of the CEAB Attribute Report
• The user would like a breakdown of each graduate attribute expectation number by course and number

Example: For Graduate Attribute - Design with Exceed Expectation = 100, Meets Expectation 30, Marginal Expectation = 10, Below Expectation = 0

Exceed Expectation Course A =70 Course B = 30

Meets Expectation Course C = 30

Marginal Exptecation Course A = 10

[arana2]

• @arana2 to determine feasibility and estimated duration

[arana2]

• Enhanced the report by adding a read-only view of the Vena data below the bar chart
• Users will be able to view the individual data that makes up the sum of a selected expectation
• This feature is available for both Windows and macOS users o For macOS users, added VBA code to calculate AVG score and % of expectations o This was necessary because Excel for Mac attempts to execute the Excel formulas before Vena's Contributor connector retrieves the data o The VBA code executes after the Vena data is retrieved
• Instructions to execute the drill down function is also listed on the report below the bar chart

Full view:

Steps to execute drill down function

1. Log in Vena
2. Select Contributor -> Reports
3. Open CEAB Attribute Report a. Program/Course: (Chemical Engineering (B.Eng.) b. Term: 2018-2019 c. Section: All
4. Select a cell intersecting between an attribute and expectation a. Example: 301 (4. Design x Below Expectation)

5. Vena Tab -> Drill -> Drill Down
6. A new Excel tab will be generated displaying a breakdown of the data by course, year, attribute, section, value, etc.

[arana2]

• [x] Add instructions to user guide: instructor, department representative, administrator

[arana2]

• GitHub repository has been updated with the latest guides
• Also updated the PDF guides on measure.mcmaster.ca