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