Building Excel Reports Many professions require the collection and presentation of data. For the UX profession, the data are typically from usability studies. Part of being a professional in any field is the ability to analyze and present data in a form that is useful to your organization, colleagues and other stakeholders. Exercise 1 will acquaint you with some basic concepts behind reporting data from a usability study, with an emphasis on Excel. Exercise 1-Excel File The data for the usability study to be reported for Exercise 1 are found in Exercise1-Excel File. Some notes about this Excel file: 1. The file has three tabs: one labeled Presentation, one labeled Analysis, and one labeled Data. Separate tabs can be useful for reports and dashboards, rather than using a single large sheet. 2. The Data tab contains simulated data from 8 different tasks in a usability study with 15 participants. ? The only metric collected for Tasks 1-4 is whether or not the participant completed the task (1=Completed, 0=Did not complete). ? There are two different metrics for Tasks 5-8: - One metric was Level of Success, using a scale described in Section 4.1.2 of Measuring the User Experience: 1 = no problem, 2 = minor problem, 3 = major problem, and 4 = failure/gave up. - The second metric was Time-on-Task (TOT) in seconds. The task was stopped if the participant exceeded 10 minutes (600 seconds) therefore the maximum value is 600. 3. You will not be changing the data in the Data tab. You should review the data in the Data tab, then move on to Performing the Exercise, which involves creating summary tables of the data (which will go in the Analysis tab) and charts of the summary tables (which will go in the Presentation tab). Performing the Exercise 1. Save a copy of the Exercise 1-Excel file file with your last name. Use the file name Exercise 1-. You will make all changes in your copy of the file and submit this file to the Exercise 1 Assignment when you are done. 2. Create Summary Tables in the Analysis Tab In most cases, raw data collected in a usability study are not displayed in tables or charts. Instead, data typically need to be summarized into an acceptable intermediate form, such as a summary table showing frequency counts or means. For this Exercise, you will create summary tables for the raw data found in the Data tab. These summary tables will be created in the Analysis tab. The Analysis tab worksheet should look like this when you have completed all of the steps below:

Attachments:

I300-Exercise....pdf

Exercise-1-Na....xlsx