Please enable JavaScript.

Coggle requires JavaScript to display documents.

Gamer Moment - Coggle Diagram

- - - - Steam, Epic Store
      - See library of games
      - Potentially see where games are cheap
- - - - Multimodel technical proposal
      - Analysis of two datasets
      - low-fidelity non codede prototype
        
        UI
        
        Algorithms
        
        Data
      - Criteria List
      - Annotated sketches
    - - Aims
        
        Engage Students in "Videos Games Through the Ages"
        
        Innovative Digital Solution
        
        Uses Video Game Data in interesting and innovative way
  - - - News/Entertainment app about video games and other pop culure items. Majority of content is reviews of games and walkthroughs and tutorials for games.
      - Not much information or featyres regarding the history of games, apart from occasional articles and features about old or nostalgic games
      - Mobile Application, PC Application
    - - Website
      - Features timeline functionality, where user can click through different time periods
      - Pictures with each game, and a short description of the game/console itself.
- - - - Be easy to understand
        
        Have visible text, and make blocks of text concise and easy to understand
        
        Make all buttons clearly distinguishable and show feedback when pressed
        
        Use simple language and basic colours
      - All users should be able to access app no matter the device
        
        Consistent Back button takes user to previous screen viewed
        
        Home screen is accessible from all screens through home screen button
      - Help with reduction of errors in the usage of the app
        
        Output error messages if incorrect entries are placed into text fields
        
        Distinguish if text is incorrectly spelt and make known to the user
        
        Make Text boxes wide enough to be read so users can see what they are doing
    - - Hall of Fame
        
        Ranks games from 1-10 based on user specified filter
        
        Can be sorted by ascending to descending
        
        User can choose to sort by average review score
      - Random Game
        
        Takes user to random game using Random Int for array
        
        Takes user to the game description screen for a random game
      - Search Function
        
        Can choose to filter by:
        
        Genre
        
        Console
        
        Year Released
        
        Publisher/Developer
        
        etc.
        
        Returns results in a table cell
        
        User can click on a game shown in table and is directed to page about the game.
      - Game Description
        
        Shows picture of game
        
        Publisher, Genre and Release date are shown
        
        Title of Game is Shown in caps
        
        Link to related games is shown
    - - History
        
        Table View Cell with individual cells showing name of game and the date added.
        
        Button to the right of the movie to delete it from history
        
        User can scroll down the table
      - Hall of Fame
        
        Table View is main feature
        
        Toggle Button to sort by Review Score
        
        Shows year, reeview score and name of game in table view
      - Search Function
        
        Text Fields for user to enter search
        
        Main Text field searches for game based only on name of the game
        
        User can press advanced search and additional filters will be shown to search by
        
        Genre
        
        Release Year
        
        Review Score
        
        Text Fields has large text and is shown on top of screen
        
        Previous searches are also shown to user
        
        Displayed Results can be clicked on
      - Game Description
        
        Image is centre top of screen
        
        Small text box with bold headings and information about game
        
        Bold Heading with name of game underneath
        
        Back button on top left to go back to previous
        screen
      - Linked Services
  - - - Xcode
        
        Used for Low-Fidelity Prototype
      - Notability/Keynote
        
        Used for Sketches and Low-Fidelity Prototype
      - SQLite3
        
        Used to write key algorithms and test key algorithms
      - Excel
        
        Used for searching through database and normalisation
    - - SQL
        
        Search Function
        
        Search (field) from (table) where (condition)
        
        Used to return all results that match a condition
        
        Uses specific filters the user has inputted
        
        Alter/Update Function
        
        Used to add and remove games from playlist and history
        
        Update (table) set (field)=(value) where (condition)
        
        Columns are changed depending on if the user had added or removed items from the history and playlist
        
        Order By Function
        
        select (field) from (table) order by (field) asc|desc
        
        Uses specific filters the user has provided
        
        Used to sort the results returned for ease of access
        
        Used for Hall of Fame Function
      - Xcode
        
        Import SQL into Xcode
        
        add in field and table names
        
        change database name and location on drive
        
        Use default code for importing
        
        Random Integer
        
        Used for Random Game feature
        
        Retrieves Data from SQL Databse and places it into an array
        
        Based on what integer is returned, SQL query runs and returns all relevant information
      - Link to other services
        
        Allows user to connect steam, epic games and other services to app
        
        Addding column into database with only 1 and 0 values
  - - - Search Function
        
        Title
        
        Year
        
        Genres
        
        Rating
        
        Consoles/Handheld Status
        
        Review Score
      - Hall of Fame
        
        Year
        
        Review Score
        
        Sales amount
        
        Rankings of games in comparison to others
        
        Whether a game was released before another one for example
      - Linking Services
        
        User's library for service
        
        Would only contain information on whether the user owns the game, no det
        
        Titile of Game
        
        Names of Services
        
        Local Data, not stored in app
        
        Thumbnail or image of game
        
        Local Data not stored in app
      - Random Game
        
        Numerical position of game in database
        
        Title
        
        Release Year
        
        Publisher
        
        Rating
        
        Review Score
    - - video games
        
        Pros
        
        Lots of information about the game itself
        
        Has columns for sequels, consoles and genres
        
        columns are 1 or 0, meaning yes or no conditiions can be used
        
        Cons
        
        not as much detailed information regarding sales figure
        
        also no links to game review unlike other
      - vg_sales
        
        pros
        
        lots of information regarding sales details
        
        Has an image link for each ganea
        
        cons
        
        high redundancy present in the table, as games with multiple platforms have multiple entries
        
        Data set does not contain much information on games themselves as opposed to other datasets
    - - Retreval
        
        SQLite 3 Data Base
      - Storage:
        
        Data set is provided as a CSV file
        
        Normalised and opened in SQLite 3