LI-YUXUAN-TSWD-Portfolio

Catalog of Final Project

Part I: Brief Intro & Overview: Working Overtime in the U.S.
Part II: storyboards and user research
Part III: Final project and presentation
Shorthand Website Link: Shorthand for final presentation

Brief Summary So Far 💕💪😘

Summary for Part I ✍️

In Part I, because I hope to look at the working overtime situation in the U.S. through this project, I pick the topic about how to solve the dilemma of working overtime in the U.S..

After determing the topic, I planned the whole story is divided into 7 big scenarios of smaller story points:
Scenario 1: Introduce the working hours in the countries of the world and compare with each other.
Scenario 2: Focus on the average working hours in the United States.
Scenario 3: Pay attention to the US paid time off situation and holiday usage data.
Scenario 4: Concern about the hazards of overtime work.
Scenario 5: Explore why employees work overtime even though there are so many hazards.
Scenario 6: Study what kind of people are more courageous to refuse to work overtime.
Scenario 7: Call to reject meaningless working overtime.

And then I developed a pitch for my presentation that included Project Summary, Project Topic, Reader Perspective, Call To Action, The Story Arc, and also Data Source. Plus, I also completed the draft of charts using in presentation. The chart of final project was designed and created with Tebleau, Inforgram, Flourish and Canva.

Additionally, I also identified how I will tell this story. The final deliverables will be an interactive stand-alone project created with Shorthand. Each of the scenarios depicted above will have one or two pages on the final Shorthand website. Interaction and movement between pages will be used to promote interactivity and engagement with potential audiences. Moreover, key information will be highlighted through the use of color.

Summary for Part II 📊

In Part II, after the discussion with my classmates, I redivided the whole story into 5 big scenarios with some small stories:
Scenario 1: Setup - Look into the status of overtime in the United States
Story 1.1: Introduce the working hours in the countries of the world and compare with each other.
Story 1.2: (small conflict) Focus on the average working hours in the United States.
Scenario 2: Pay attention to the US paid time off situation and holiday usage data.
Scenario 3: Conflict- Concern about the hazards of overtime work.
Scenario 4: In-depth exploration - Explore why employees work overtime even though there are so many hazards.
Scenario 5: Resolution - How to refuse to work overtime
Story 5.1: Study what kind of people are more courageous to refuse to work overtime.
Story 5.2: How to become a person who can refuse to work overtime
Scenario 6: Call on - Call to reject meaningless working overtime.

Besides, I started to construct the actual narrative that will take the reader on the journey through my story. After the suggestions from classmates of my draft charts in the part I, I redesigned the Wireframes and storyboards using Shorthand, and also completed the moodboard. After that, I also identified the Target Audience, found representative individuals to interview, and collected the feedback from them to improve your story.

Summary for Part III 🎯

In Part III, I’m moving on to final deliverable which will be completed and giving the published story on Shorthand. I’m redesigning the shorthand websites and charts based on all previous feedbacks. I’m also providing a writeup on Github that summarizes my work done for the final presentation. Finally, I will implement everything into the shorthand website, and will give a presentation during the last class of Telling Stories With Data course in CMU.
Importantly, because this is a public website, I edit the formate of the cite of external sources more normative.

Change in the Final Data Story 🎬

Changes made since completion of part II:

Add menu bar

As the suggestions from classmates, on the top of the website, I add a menu bar with the titles of each major section. This bar gives the audience a clearer idea of the structure and allows readers to effortlessly go back and forth between sections.
Add menu bar

Add the section covers

I add the section cover before each scenarios to give the audience a clearer idea of the topic of each scenarios.
Add the section covers 1
Add the section covers 2
Add the section covers 3
Add the section covers 4
Add the section covers 5
Add the section covers 6

Edit the cite of external sources

As the requirement of course, I edit the formate of the cite of external sources more normative.
cite 1
cite 2
cite 3
cite 4
cite 5
cite 6
cite 7
cite 8
cite 9
cite 10

Add the cultural differences

Based on the suggestion from professor, for comparisons between the US and China / India, I add worth explaining why some cultural differences might exist to give more valuable information for students.

cultural difference

Change the formate of data in chart

Based on the suggestions from classmates, I change the data formate from 0.49 to 49% and from 0.21 to 21% in the chart, because it will be consistent with the description below the chart.
Change data format 1
Change data format 2

Add informatiion about working while on vacation

Based on the suggestion from classmates, they hope me to put more information about that people are still working while on vacation. They think this information made them more disappointed. Therefore, I add informatiion about working while on vacation.
Add informatiion about working while on vacation

Redesign why employees work overtime even though there are so many hazards.

Based on the suggestion from classmates, the original chart to present the survey result about why employees still working overtime is dizzy. Therefore, I redesign it and use more words to illustrute the results.
survey 1
survey 2
survey 3
survey 4

Redesign the content of how to refuse to work overtime

Based on the suggestion from classmates, I make the important information bold and use red or green color to attract the eyes of audiences. Plus, I also give some examples of dialogue to help the audiences to learn about how to refuse work overtime.
refuse 1

refuse 2
refuse 3
refuse 4
refuse 5
refuse 6

Redesign the Top 3 Industries

Based on the suggestion from classmates, I eedesign the Top 3 Industries with the highest percentage of employees taking paid vacation. I just pick top three industries and delete other information to make it clear.
Top 3

Redesign the content of call to reject meaningless working overtime.

Based on the suggestion from classmates, I’m supposed to give more words to engage audience about refusing overtime work. So I use both charts and the illustration for the the last call on section. Call on 1

Call on 2

Call on 3

Call on 4

Add thanks part in the end of the website

I add the “Thank You” in the last page of the website. Thank You

Target audience 👨‍👩‍👧‍👦

The main target audience are employees or prospective employees who are suffering or at risk of suffering from overtime.
Because the call to action of this whole project is to ask for workers to stand up to refuse and defend their right when overtime is so serious that it has infringed on their right, employees or prospective employees who are suffering or at risk of suffering from overtime will be more likely to relate to the content.
“On CMU’s campus, there are always people who chant “My heart is in the work”. But working long hours can bring you a great deal of danger. So more specifically, my target audience is Carnegie Mellon University recent graduates who don’t know much about the current overtime situation in the U.S. or how to turn it down in the workplace. I hope to use this website to help them understand what they should know about Overtime work in the U.S. but don’t.

Data Source 📊

The sources of the data have been labeled below the individual sketches. Here again, the data sources are summarized.

Data Resource and URL Description and Usage
Statistics on working time: The ILO Department of Statistics The chart is used to describe average hours and prevalence of excessive working time, especially the average hours per week per employed person of each countries
Work and Workplace: Gallup Historical Trends The data from survy about the working hours in the U.S.
Average hours per day spent in selected activities on days worked by employment status and sex: U.S. Bureau of Labor Statistics The data from U.S. Bureau of Labor Statistics is used to describe average hours per day spent in selected activities on days worked by employment status and sex
No-Vacation Nation, Revised: CENTER FOR ECONOMIC AND POLICY RESEARCH The data is used to describe paid vacation and paid holidays, OECD Nations, in working days
79 percent of private industry workers had access to paid vacation leave in March 2019: U.S. Bureau of Labor Statistics The data is to describe the percent of private industry workers with paid vacation leave
Why you Are Not Taking your Paid Vacation Days, but Should: 20 Something Finance.com The survey data shows only 51% of paid vacation days being used and provide the reasons for working overtime in the U.S.
Prevalence of depression, anxiety, PTSD, and suicidal ideation in the past 2 weeks among public health workers in the United States as of April 2021, by hours worked per week: Statistics The data used to describe the mental illness of working overtime
Higher paid workers more likely than lower paid workers to have paid leave benefits in 2020: The Economics Daily: U.S. Bureau of Labor Statistics The data shows the higher paid workers are more likely to have paid vacation, giving us ideas about how to gain paid vacation
Paid leave benefits: Average number of sick and vacation days by length of service requirement: U.S. Bureau of Labor Statistics The data shows the longer service requirement the more paid vacation
Who receives paid vacations? : U.s. Bureau of Labor Statistics The data shows which industries have more paid vacation





🥰Thanks for your reading. If you are interested in other works from my course portfolio of Telling Stories with Data at CMU, please feel free to visit my Home Page.