Please enable JavaScript.
Coggle requires JavaScript to display documents.
NCGC - Coggle Diagram
NCGC
Data
The data comes from the Google Play Store and was obtained through web scraping
The data is in CSV format, named googleplaystore.csv
It is tabular data, representing information about various attributes of Google Play Store apps, such as category, rating, reviews, size, installs, type, price, content rating, and genres.
The data was collected through web scraping. The Google Play Store uses modern techniques like dynamic page loading with JQuery, making scraping more challenging.
A person by the account name Lavanya placed this data together 5 years ago through the form of web scraping
It will be accessed through the raw dataset which will then be normalised and turned into entity relationship diagrams. As the data is an open, flat, csv file it can be seen that the data is valid and reliable as well.
The data is layed out into 8 fields with 9660 apps that show the information of every app on the Google Play Store
This database will be stored in a relational database using SQLite after it has been normalised
Users will access this database through creating reviews and searching for other reviews.
There are 9660 data entries for the database however only 11% of those are games
The dataset on kaggle is an open dataset.
Tools
Python
Flask
HTML
CSS
Bootstrap
SQlite
Lucidchart
Kaggle
Coggle
Balsamiq
Constraints
Economic
The economic aspect of a webs development can affect the overall quality of the final product. The use of API’s, servers and bandwidth can all contribute to the economic state of a solution and the expenses that follow with it.
Time
When building a solution, time is always a limiting factor and may cause some areas of the product to be unfinished or incorrect. It won’t end up being perfect, only to the best of the ability of the creators in the time frame.
Technical
The ability of a creator and product can all be related back to skill level. There is always room for potential errors when creating a solution.
Data
The data being used is private and should not be able to be accessed by the public such as login details. It should be secured and protected.
Privacy
Following the Australian Copyright Laws and the Australian Privacy Act, the information in this solution must be protected and cannot be shared with others.
Coded Components
Login
Upload
Sign Up
Search
Usability Principles
Utility
The usefulness of an interface is determined by its input and output functions, which improve its operability, responsiveness, and portability.
Learnability and Effectiveness
The efficiency of a user interface depends on how well it accomplishes the tasks for which it was designed. An effective interface allows users to engage with a digital solution quickly, effortlessly, and precisely without having to comprehend its complexity. An interface that is easy to understand is said to be intuitive, and applying CARP principles can increase its efficiency.
Accessibility
Accessibility for all users must be prioritised in digital solutions to ensure fair access to information. Screen reader compatibility is a requirement in many nations for programme development. When investigating a digital issue, consider the tools and user groups that will interact with the solution and make accessibility a key component of the development process.
Safety
Interface designs should include safeguards such as consent prompts for sensitive data access, icons for security indications, and warnings for unintended file deletion to ensure a secure user experience.
User
Shane Weebly
16
Currently boarding at Nudgee
Student at St Joseph's Nudgee College
Male
Shane is an avid computer user and likes to build and alter websites. He also enjoys video games and plays a lot of them.
Shane is very experienced in this area and would be able to use a website that has quite advanced techniques.
Shane needs a website where he is able to efficiently find it and see what is relevant to his gaming experience as an advanced technology user.
Shane wants a solution that lets him explore different aspects of games and figure out what he could play in the future. A bright and contrasting site would suit his personality, closer to following the CARP process.
Shane is a teenage boarder at Nudgee who spends most of his free time playing video games. He is further ahead than his piers in the technology aspect and would like an area where he can find more relevant games to play.
Rick Sanchez
11
Carseldine, Brisbane, Queensland
About to start at Nudgee
Male
Rick has come from his farm up north to live down in the city in his preparation for Nudgee. He enjoyed doing stockman jobs and interacting with the cattle.
He has no skills when it comes to technology as there is no internet out at his farm.
Rick needs access to a simple website to be able to understand how to use technology and get into the swing of how the club works. As Rick is colour blind, he also will need accessibility features to use the technology.
Rick wants the ability to connect with his new mates and so being able to share reviews and communicate through the website with others. He wants to be able to know what games would be good for him and what would be recommended for his age.
Rick is a young future Nudgee boy who is colour blind and works up at a farm in Northern Queensland, currently staying with his grandparents in Carseldine. Rick has no interaction with technology and will need a simple yet interactable website to learn as well as contain accessibility options and the ability to share reviews with other kids.
Ron Jacoby
14
Ascot, Brisbane, Queensland
Student at St Joseph's Nudgee College
Male
Ron enjoys playing club Rugby with his mates as well as hoping on the video games after school with them. He also plays the saxophone and uses his phone for music tabs.
Ron has minimal digital skills from using technology in school as well as his phone. Would know how to navigate a website.
Ron is in need of a catalogue of his favourite games that he can find easily so he will require a simple quick access option or a search bar to find reviews of the games he likes.
Ron wants a creative, colourful design on the website that lets people know exactly what the website is about the moment they open it, video games. He wants to be able to know what the game is about without having to click on a bunch of different pages and have ease of access as to where the games can be found.
Ron is a grade 9 student who enjoys gaming, sports and music. With his limited digital experience and his preferences for a visually appealing interface, a straightforward website would be an important factor that caters to Ron’s interests. It would also enable him to obtain a seamless experience for learning and finding more about his favourite games.
Criteria
Prescribed
Built for St Joseph's Nudgee College gaming club involving the Nudgee logo
Have colourblind options as well as text-to-speech options for disabled users
Simple and effective design able for users to easily find what they are looking for
Having a login page that includes hashing the passwords in a database
Uploading and searching reviews to differentiate between critique and user recommendations
Self-Determined
There is a happy face next to a comment if it is positive, a mediocre face if the comment is average, and a sad face if the comment is negative
Have blue and white colouring to make it Nudgee themed
Breaking up the reviews with fun facts about the game or trivia so the user isn’t as boring
Extended filter options to be able to find the games the user is looking for
Use of multimedia, showing relevant information to users about the game
Requirements
Functional
The digital solution must be in the form of a web application an be made using, Python, SQlite and Flask
An open from either IOS or Google Play dataset from Kaggle must be refined and then used
Create a technical proposal for the solution of a web app that allows the sharing of reviews of games
A multimodal presentation must be made to present the technical proposal
Have the ability to understand the data, processes and layout of the solution
Non-Functional
Must adhere to the Privacy Act, Copyright & Patents Act, and laws around online ownership
Must use Nudgee branding as the school will be in use of the solution
With school students interacting with the app, the usability principles must be followed to ensure safety
Design will be based around the wants and needs of the user group, which are teenagers