Upgrade to Pro — share decks privately, control downloads, hide ads and more …

GameHub

lynhvu
July 14, 2022

 GameHub

lynhvu

July 14, 2022
Tweet

Other Decks in Education

Transcript

  1. Why Create GameHub? • Help gamers explore various games from

    different companies across a plethora of genres in a single location.
  2. APIs We Scraped for Models’ Data RAWG.io • We mainly

    used RAWG.io’s API to gather the bulk of our data. However, there were numerous instances in which RAWG’s data was incomplete, leading us to use IGDB to fill in these gaps. IGDB.com • We used IGDB’s API to fill in any gaps in the data gathered from RAWG.
  3. Models Games • Id # • Name • Description •

    Score • Genre_Id • Released • Company_Id • Pictures • Platform Genres • Id # • Name • Description • Num_Games • Games • Picture • Themes • Companies Companies • Id # • Name • Description • Location • Year • Num_Games • Games • Genre_Id • Img
  4. Model Relationships Explained Company – Games : One-to-Many • One

    company may produce many games. Genre – Games : One-to-Many • One genre may have many games in that genre. Genre – Companies : One-to-Many • One genre may have many companies contribute to it, but each company typically specializes in one main genre.
  5. What did we do well? • Cohesive design of the

    user interface • Designed a cohesive user interface where every page contained clear links to other pages of related information • Easy to navigate
  6. What did we learn? • Scrape APIs and create and

    use a database • Design an interesting website frontend using HTML, CSS, and JavaScript/Bootstrap • How React adds dynamic functionality to a webpage • How Flask organizes a backend with Python • How APIs can be scraped to provide data, and how this data can be stored in a database • Use GCP to deploy the web applications to the cloud • Use Postman to test APIs
  7. What can we do better? • Adding more information for

    each item ◦ Social media links on company pages • Add trailer and review for each game • General Search Page ◦ Display some sample games/companies/genres ◦ Show a specific number of items ◦ Implement “Show more” option • A map that shows the density of players of specific game
  8. What puzzles us? • Get data from the APIs. ◦

    Not familiar with the mechanics of API requests ◦ Many results seemed inconsistent with the documentation
  9. What did they do well? • The website was laid

    out clearly ◦ Information neatly divided into tables ◦ The headers made it easy to access each page • The website also included useful interactive elements ◦ Inbuilt Google Maps windows for each location • Simplistic and not overwhelming
  10. What did we learn from their website? • Different Jobs

    ◦ Where they are located at ◦ The companies that are looking to fulfill these jobs • Interesting Visualizations ◦ Brainstorm styled words display that are very visually appearling ◦ Graphs to represent data
  11. What can they do better? • Show a list of

    page numbers ◦ Hard to navigate by just arrows • A quick Apply button on Job page model • Improving the search function on the list pages, which (at the time) don’t show anything • Add more visuals to create a more inviting feeling to the website • Improve UI ◦ It kind of feels like a big spreadsheet
  12. What puzzles us about their website? • It was a

    bit difficult to figure out how to sort the elements of their website. It turned out that we had to click the header of each table to do so, which was not clearly indicated. • Visualizations (word cloud) were fun, but ◦ Visitors couldn’t figure out exactly what information was supposed to be conveyed by them ◦ Perhaps, convey the amount of item in each word?