Please enable JavaScript.
Coggle requires JavaScript to display documents.
Bundaberg eSports Web App Problem Exploration (Client Problem (Logos (Web…
Bundaberg eSports Web App
Problem Exploration
Client Problem
Constraints
Time
Coronavirus pandemic
Home learning
Shalom College Esports Club
Bundaberg Schools
CQU
Logos
Web App Logo maybe?
Bundaberg, CQU logos
School logos
Team logos
User Problem
User personas
Mitch
Would want to view detailed and raw statistics
Would want medium level of control for event co-ordination
Penny
Would want to view processed basic/intermediate statistics
Mandy
Peter
Would want high level/detailed control/access
[All]
Level of technology usage and potential disabilities unknown – accessibility important
Socio-economic status unknown – likely enough to have PC/console/phone
Internet connectivity and bandwidth unkown
Physical meet-up ability impacted by social distancing
Existing solutions
Australian eSports League
EA Sports FUT19
Developer Problem
Development & coding environment
IDE
Visual Studio Code
Programming language(s) & frameworks
Python
[Framework] Flask
Document markup and styling
HTML (HyperText Markup Language)
CSS (Cascading Style Sheets)
Use pre-built style template or from scratch? From scratch to avoid licensing issues and to have full control
SQL SELECT queries to get rank-appropriate data from DB for user
Automatically analyse data with pre-programmed algorithms
Production environment
Server
Hardware
Operating System
Software
Cloud hosting or dedicated server
Data Environment
DMBS
SQLite? PostgreSQL?
Privacy and data ownership
Need to comply with the Australian Privacy Act (1988)
Users need to be aware of data and how to remove/change
Password authentication
Need to comply with copyright law (include appropriate attribution to data and images used)
What needs to be stored?
User data
Name, in-game username / info, contact info, school info
Statistics
Match statistics
Overbuff statistics
Store most data in a central SQL database
Process Overbuff from HTML to CSV or direct to DB? Create reusable submodule with modular output?
Update esport datasets in central DB quickly
Database schema
User Interface
User registration
Administrator-only
Data validation and verification
Alerts
Configuration
Generate area-specific alerts / message registered users
Administration area
Useability
Accessibility
Effectiveness
Safety
Utility
Learnability
Responsive UI
CSS media queries
Must comply with Australian accessibility guidelines
Must be clear and consistent