Super Auto Pets

Super Auto Pets

1. Constraints

   • Skill
     • Website will be led by a high school student
       • Knowledge and experience in web development and design may be limited

2. Task Requirements

   • Prescribed
     • Use data from an external data source
       • Normalise the .xlsv/.csv into a SQL .db
       • Use flask to integrate database into web application
     • Display data
       • Use flask to display data in html table
       • Sort data into respective fields
     • Incorporate Usability Principals
       • Dark mode and font size adjustment (accessiblity)
       • Search and sort function (utility)
       • Universal icons and simple UI (learnability)
       • Minimise user input, colour coding (safety)
   • Self-determined
     • Accessibility
       • Size adjustable text
         • Use a slider to allow for large range of text sizes
         • Hard of seeing
       • Dark mode
         • Helpful for users using site at night
       • Universal icons
         • Helpful for those with reading disabilities, improves learnability as well
     • Images of food
       • Display in same table as other statistics

3. User Problem

   • User Persona Sean Thornberry
     • Needs
       • Easy to use platform
         • Efficient, don't make user go through too many menus
         • Include images of food/toys
         • Learnable, don't use complicated procedures and try to utilise universal icons
       • Show SAP information
         • Use a concise table
         • Toys or food specifically
     • Frustrations
       • Text too small
         • Option to enlarge text
   • User Persona Sophie Hawthorne
     • Needs
       • Easy to use platform
       • Show SAP information
         • Animals specifically
     • Frustrations
       • Poor memory
         • Need data to be displayed quickly and effectively
           • Simple and effective UI to minimise user input

4. Resources

   • Online
     • Youtube
       • How to target usability principles
       • Web design tutorials
   • Software
     • Figma
       • Graphic design
     • Powerpoint
       • Flowcharts
   • Developer Environment
     • Front end
       • HTML
         • Structure and format website elements
       • CSS
         • Style HTML elements for aesthetics
     • Back end
       • Python Flask
         • Framework for building the web pages
       • SQL
         • Manage relational databases; create, delete, update and retrieve data

5. Impacts

   • Social
     • Super Auto Pets (video game)
       • Users may use site as way to verify statistics: build trust and engagement in community
   • Economic
     • Jobs
       • Development and maintenance of site may open up jobs
   • Personal
     • Entertainment
       • Users can use the site to browse and look at SAP pet stats for fun

6. Datasets

   • Data Types
     • Varchar
       • Food
         • Can be used for name, description
       • Pets
         • Can be used for id, name, abilities
       • Toys
         • Can be used for name, ability about, perk description
     • Integer
       • Food
         • Can be used for tier, attack_amount, defense_amount
       • Toys
         • Can be used for attack, health, type, id, tier, max tier, ability level
       • Pets
         • Can be used for baseAttack, baseHealth, tier
   • Strengths (for all)
     • Data is already mostly in 3NF
       • Data can nearly already be used efficiently in the application
       • Cleaning and normalisation will have to be implemented to remove null values
     • Pets
     • Food
       • Low number of (relevant) columns (5-6) means implementation and database can be less intensive
     • Toys
   • Limitations (for all)
     • Only one aspect of super auto pets data is included
     • Toys
       • Repeated ids and names
         • ID cannot be used as a primary key; must be combined with another column (ability level) to form a valid composite key
     • Food
       • id and name are essentially just repeats of each other, making for redundant columns (one must be removed during cleaning)
     • Pets
       • A large number of rows means that search functions or sort functions may have to be implemented for the display of data to be considered effective
   • Data sources
     • .csv/.xslv
       • The original external database, has to be further normalised for use
     • SQL .db
       • The data after it is cleaned and normalised, can be directly utilised for the web application