Stack of Books
Stack of Books

Stack of Books Image

Introduction

      Hello, my name is Katarina. I am a Junior Data Analyst given the task of figuring out the consequences or cause of banning books. And what affect it has on children. More specifically with the banning of so many books, does this hinder or enhance children’s learning experience in school? My client represents children’s education. And they want to know the questions found below. With the information I have gathered, I have reason to believe that it doesn’t quite hinder their learning experience. But, more so their independent way of thinking. Moving forward I will go through the steps I took in order to reach a conclusion needed by my client and their stakeholders. Our main focus being 8th grade. I will touch a little on 4th and 12th just to gather a range.


First I took into consideration the questions that were being asked.


Some problems needing to be identified.


Metrics for the study

      I plan on measuring not only how many books have been banned over the years starting in 2011 to 2022. But I also plan on measuring children’s test scores over the course of that same time. Hopefully we can see if there are some similarities. Or perhaps some differences. What I really want to focus on is the reading portion of test scores, especially if we are concerned with banned books playing a roll.


Banned Books 2021-2022 According to PEN America

Reading Test Scores 2011-2022

Credit: Bubert
Credit: Bubert

School House Cartoon


Visualizations showing Similarities and Differences

      Below is a link to the Tableau Viz I made in order to assist in this project I was tasked with. Once the webpage is loaded you will be brought to the searched page. From there you will scroll down and click on Number of Books Banned in the U.S 2011-2022. Created by me! (May have to open link in new browser to work)

Tableau Visualizations


Recap


Conclusion/ Possible Solutions


Answering the Questions

Has there been an increase in banned books over the years? Why?

  • Yes, there has been a major increase in banned books over the years. Meaning our views on banned books has changed doesn’t mean we forgot about the previous views. It’s almost as if we added on more views to ban. Which in turn upped the numbers even more.

What is to gain from banning books?

  • Some pros about banning books are that we would have content control, we would be able to uphold community values, and parents would have a say in what their children read. Some cons would be censorship, which would be against intellectual freedom. Equity and representation, as well as educational impact. All of these factors need to be taken into consideration when making a ban on a book.

Are specific views being taken into consideration?

  • As we can see from the data above and the visuals on Tableau, we can see that views are quite a big part of the books that have been banned. Ultimately “views” are the reason books are banned. It depends on the type of view, and who finds it worth banning.

Does banning books change children’s learning experience?

  • Realistically, it is hard to say if banning books is a cause of reading scores soaring low over the years. We have been banning books since the 14th/16th century. Could it have played a role in their scores? Most definitely however, we won’t ultimately know the truth to this question unless we dig deeper into test scores in the future.

URL Sign above

Next Steps

      A light at the end of the tunnel, that is figuratively speaking. Unfortunately this battle of banning books, views, and children’s education will always be just that, a battle.



      Hopefully you enjoyed my presentation of Banned Books. Honestly there are a ton more views I could take on the matter, but for now I’ll keep it simple. Thank you for reading.


Credit: Prof. Achyuta Samanta
Credit: Prof. Achyuta Samanta

Thank You Readers, Image

      Towards the bottom of this Page I will place my works cited, as well as the recorded timeframe of cleaning data that was used above. Thanks again!


Works Cited


Recorded Timeline

PEN America csv. file

  • Started this project approximately a week and a half ago. I downloaded the csv file from PEN America straight to an Excel spreedsheet.
  • The dataset wasn’t big enough for me to use SQL.
  • I formatted the csv. in Excel and trimmed any white space and also checked for duplicates.
  • Made sure there was a space between the first and last name using the Trim code as well, and dragging it down. (Double clicking was used as well in this step.)
  • Spelling was the next thing to tackle. The last name Johnson was misspelled two times as Johnshon. This is fixed with filters being added to the author row.
  • The name Sabnini was also fixed to read Sabnami. Adopton was changed to Adoption.
  • In cell 2399 the last name Van Whye, the V was not capitalized.
  • In cell 1770 Column C the cell itself was Red. A simple fill color change was all that was needed.
  • Changed all the blanks in the csv. file to N/A values. Again a filter was placed in order to fix the issue.

Nation’s report card

  • This information I was able to download right to Excel as well. I first placed two columns to hide. Columns that were not needed for this case study.
  • I then checked spelling. Nothing was needing to be fixed with this.
  • There were a couple null values that needed to be fixed. With that I used a filter to single out the null values and replace them with N/A.
  • I then trimmed white space and made sure the file was perfect.

Number of Books banned

  • This data I was able to manually type into Excel. With that said I was able to make sure spelling was correct. No white space was present, and no null values were recorded.

HTML Page

  • I find R to be more simple than SQL, hence why I went with using an HTML page for this case study. I feel like this page is a great way to get your point across. It’s organized and honestly you can change every aspect to it just like anything else. I used the skills I learned through the Google Certificate for Data Analytics to put together this page. First I started with a new workspace. I got to work creating a new HTML page, and saving appropiately. Once I gathered all my information on the topic I got to work inputting all the information.
  • Once the datasets, and images had been uploaded. I was able to piece together everything perfectly. I wanted to also show my skills with Tableau, hence why I created all the visualizations there. The last step after inputting all the information and links. I inputted the images, and used src and alt to resize to the desired size!

      The stakeholders and client have copies of a more run down timeline. A timeline with times, dates, and a more detailed manifest on how I put this project together.