Game Genius
Client Problem 👤
Pre-existing Solutions
Not suitable
Some applications where confusing for the user
Some of the applications required an internet connection to function properly
Gamespot
Suitable
Categories for games
Wish list for games
Share function for games
IGN
Metacritic
Self-established criteria
Find games to view based on search criteria
View relevant information about games
Add and remove games on their wish list
View a list of all games on their wish list
Data
Update game records to indicate if a game is on a user's wish list or not
Display all games currently on a user's wish list
Retrieve and display game records based on search criteria
User experience
Be accessible on movile devices
Feature a responsive interface that meets the usability and accessibility requirements of the intended user group
Code
An algorithm to update the game database with wish list data
An algorithm to retrieve records from the database based on the search criteria
Recommend games to view based on user's preferences.
Constraint: 4 week time frame
Developer Problem ⭐
Code
Generating and comparing the data and SQL components needed to allow users to retrieve and update records in a video game database.
Environment
Psuedocode
SQLite
Mobile Application
SQL
Develop a low-fidelity prototype of the mobile application for people of all ages
Algorithms
Query for game based on search criteria
Select all from game_list where game_title = "search" or game_genre = "search"
Queries based on game genres
Select all from game_list where game_genre = "select"
Providing information on games
Select synopsis, genre, rating, duration, release_date from movie_list where movie_title = "Movie Title"
Adding/Removing games from "Wish List"
Insert into wish_list values ("Added video-game Name")
Delete from wish_list where game_title = "Removed Game"
Viewing a list of all games in the "Wish List"
Select all from wish_list
User interface
Screens
Homepage
Recommendations to the User
Trending (must play) games
Genre's
Sort by different data sets (Score phrase, console etc.)
Search
Tutorial
Relevant to you
Logo
Wish List
Share Games
Recommended by friends
Popular from friends
Add Friends
Add/ Remove from Wish List
Search
Sort by feature
Usability Principles
Learnability
Icons should be comprehensive and relevant to option
Utility
Shortcut actions (back button, settings)
Safety
Reminder of the action the user is committing
''ARE YOU SURE YOU WANT TO DELETE THIS FROM YOUR WISH LIST?''
Effectiveness
legible Icons
Easy to use
Accessibility
Coherent and simplistic design
Sounds, Languages, Text size
Physical impairments adaptability
Data
Vgsales
Name
Genre
Platform
Publisher
Developer
Critic score
Year
Basename
Ersb rating
User score
Total shipped
Url
IGN
Score phrase
Title
Platform
Score
Genre
Editors choice
Release year
Release month
Url
Release day
User Problem 👥
Teenagers and young adults
Potential Consumers who are interested in reading the
reviews on a game
Gamer fanatics
Impacts
Economic
Personal
Social
Data entered by the users needs to be secure in order for the users' personal information and privacy to be safe
Users are given the opportunity to save money and invest into only games they like after reading reviews
Users are able to connect with friends and other users by creating an account and writing reviews or suggesting games
Pre-existing solutions often have paid services, while this is a free app this allows for more users against competing apps
Cons
Pros
Pros
Cons
Crictic Score
Genre, Platform. developer
Esrb rating
Total shipped is not relevant
Basename redundent
Score phase
Editors choice
Score
Release year, month, day normilisation
Requirements
Utilise stimulus data in an innovative and creative way
Must engage a diverse range of users
Game ratings
IOS Application