Digital Solutions IA2

Digital Solutions IA2

1. Identification

   • Prescribed Criteria
     • PC1
       • Visually pleasing to look at.
         • Requirements
           • By using features and visual communication concepts, the online application must have an attractive aesthetic.
     • PC2
       • Easy to access.
         • The user interface of a web application should be simple and straightforward.
     • PC3
       • Easy access for anyone to use.
         • Requirements
           • Accessibility of the web application's content for all users.
     • PC4
       • Two data sets will be used in the SQL lite code.
         • A minimum of two open data sets must be utilized by the web application.
     • PC5
       • Filter to make finding your house easier.
         • Requirements
           • The web application must allow users to view a filtered list of different variables that would impact house location choice.
   • Self Determine Criteria
     • SDC1
       • animations on some of the buttons and options would be nice for the user.
         • Requirements
           • rows, data sets, or even small things like button movie ment with animations
     • SDC2
       • A place for new users to understand how you use your new website
         • Requirements
           • Something that the new user can use to find things, that arnt specific for example, a tutorial or help phone number
     • SDC3
       • useful features and interfaces.
         • Requirements
           • Things that can help the user overall. to see what's upcoming or news, like news stuff, or even a clock.

2. Interactions

   • User Persona
     • Eddie and Kim
       • Needs: -Locations of each airport in Brissy. - Needs houses up for sale. -Need events and stuff to do.
       • Wants: -wants to find a house in brissy. -park for bush walks. -warmer climate.
       • Details: Currently live in Tasmania and have just retired. They want to move to a warmer climate but also want to meet new people around their age. Kim and Eddie like bush walking, if they could find a home close to a walking track.
     • Megan and Steven Elliot
       • Needs: - Needs a school around them. - Needs an airport to get to brissy. - Needs locations and events around area, and road statistics to get to work.
       • Wants: - Wants a good primary school for their 2 girls. - Wants a park around his area. - Wants to live close to work.
       • Details: Currently live in Melbourne but Megan just accepted her high paying, dream job in Brisbane. Steven works from home but sometimes likes to go to a park to work. He would like to move to an area with nice parks with good wifi. They have 2 girls aged 11 and 15, they would like to move to an area with good schools and libraries.
     • Greg
       • Needs:-Locations of each airport in Brissy. - Needs houses up for sale. - available places around him to store his jet ski.
       • Wants: - Wants to buy a cheap house that can fit a single person in it - Wants a place where he can store his jet ski and take it out on the seaside. - Wants to fix his single problem.
       • Details: Single Lives in Sydney Works as a receptionist in a large firm. Dreams of owning his own home, but can’t afford the prices in Sydney so is moving to Brisbane to find something more affordable. Has a jet ski and would like to live close to a boat ramp.

3. Impacts

   • Social
     • it allows the users to be able to socialize by showing where the popular, and where all the social gatherings are.
   • Personal
     • This app should help others who are needing help finding locations
   • Economic
     • Its simple and fast to use with less features to keep it fine when running in the background while you search for a location

4. Developer Problems

   • Data
     • Data Source Options
       • Boat Ramp Location
         • Pros
           • Published last year
           • CSV Formats
           • Updated Monthly
         • Cons
           • A lot of data
           • Not all signals within Brisbane are operated by Brisbane City Council.
           • This dataset contains only the Brisbane City Council operated signals.
         • https://www.data.brisbane.qld.gov.au/data/dataset/brisbane-boat-ramps/resource/a4014da6-dc85-4c80-98d5-27285361ac77?view_id=48ab3e49-706a-43fd-b758-753c16a1a1e4
       • Events locations
         • Pros
           • has a lot of data
           • CSV file containing location information for Brisbane City Council events venues. The file has the Venue Name, Venue type, Address, Latitude and Longitude.
           • Brisbane City Council runs a range of classes, workshops, activities and events in Brisbane. The events are things like concerts, sports and fitness, green events, markets, arts, culture, craft and more.
         • Cons
           • Data will be shown
           • This dataset is supplied so you can access the latitude and longitude of the event venues linking those points by Venue Name to the events published on the Brisbane City Council Open Data website.
           • Updated Biannually frequently
         • https://www.data.brisbane.qld.gov.au/data/dataset/brisbane-city-council-events-locations/resource/08107e61-5960-4b3c-a9c9-468d6d295020?view_id=16811e6c-a689-4147-bd7b-1a739d752fb6
       • Park locations
         • Pros
           • This Data can be used by any one cause it uses the creative city council 2023 attribute
           • Has Street and Suburbs, post codes, and house numbers
           • Has LONGITUDE AND LATTATUDE COORDINATES
         • Cons
           • There are over 100 locations which is gonna take time, inserting each in there place, in the sql lite code
           • The data from this frequency was updated 3 years ago
           • only shows a limited id
         • https://www.data.brisbane.qld.gov.au/data/dataset/park-locations/resource/2c8d124c-81c6-409d-bffb-5761d10299fe?view_id=61e1e50e-42a0-4f7e-9b65-eaf5a8be9225
       • Library's location
         • Pros
           • Shows location of the libraries
           • quite updated
           • there all in queensland
           • the data sets all have websites
         • Cons
         • https://www.data.brisbane.qld.gov.au/data/dataset/libraries-information-location/resource/0f223803-897b-46e3-8fbb-930ad1925673?view_id=c2d6bc9c-67b2-4e07-a9d6-2f97cea41db7
     • Required Data
       • Park Locations
         • CSV
           • 1-100
             • (PARK_NUMBER VARCHAR(255), PARK_NAME VARCHAR(255), HOUSE_NUMBER VARCHAR(255), STREET_ADDRESS VARCHAR(255), SUBURB VARCHAR(255), POST_CODE VARCHAR(255), LONG VARCHAR(255), LAT VARCHAR(255)
       • Events Locations
         • CSV
           • 1-100
             • VENUE_NAME VARCHAR(255), VENUE_ADDRESS VARCHAR(255), VENUE_TYPE VARCHAR(255), LATITUDE VARCHAR (255), LONGITUDE VARCHAR(255)
       • Library Locations
         • CSV
           • 1-100
             • VENUE VARCHAR(255), LATITUDE VARCHAR(255), LONGITUDE VARCHAR(255), WEBSITE VARCHAR(255), ADDRESS VARCHAR(255), OPEN VARCHAR(255), PARKING VARCHAR(255), PHONE VARCHAR(255), SUMMARY VARCHAR(255), FACILITIES VARCHAR(255), MEETINGROOMS VARCHAR(255)
       • Boat Ramp Locations
         • CSV
           • 1-100
             • ASSET_ID VARCHAR(255), DESCRIPTIO VARCHAR(255), STREET VARCHAR(255), SUBURB VARCHAR(255), LONGITUDE VARCHAR(255), LATITUDE VARCHAR(255)
   • Data Storage and Retrieval
     • SQLite Database
     • Create Table Statement used
   • User Interface
     • User Interface Components
       • Links
         • Hyper Links
       • Buttons
       • Drop Down Menus
       • Filters
       • Images
       • Settings
     • Userability Principles
       • Safety
         • The capacity of users to make mistakes and learn from them is important for safety.
       • Learnability
         • How simple a system is to learn is what learnability is all about.
       • Accessibility
         • A product must be accessible in order to be used by a wide range of users, including those with impairments. Making websites accessible also helps individuals who use mobile devices or who have sluggish network connections.
       • Utitlity
         • Utility is concerned with a system's capacity to offer all the capabilities consumers require. It gauges how much pleasure or happiness a person derives from a certain application. Users are frequently prepared to put up with some degree of usability difficulties in a system that offers vital functionality.
       • Effectiveness
         • The capacity of users to utilize the system to do the tasks they need to complete, including dependability, is a key component of effectiveness. A system is consistent, trustworthy, or repeatable if it is reliable. You search for items that work or do not work as expected while evaluating effectiveness.
     • Features
       • Filtering side menu
       • Find Route button
       • Search
       • Site map
       • Data base columns
       • Buttons
       • Help Links

5. Task Requirements

   • Constraints and Limitations for the app
     • The amount of time giving
     • How many tasks and data sets giving in the amount of time
     • Lack of motivation
     • Making everything relatable to the criteria
   • Solution for the App
     • Pros
       • Being able to use data sets from governmental website to locate the crazy traffic areas.
       • The Button will be made from html and the filtering system will use snippets of the cheapest house options on a reliable data website.
       • Being able to have satisfaction when, spending seconds looking for you location.
     • Cons
       • four data sets takes more time to write code
       • Limit of time to do this project
   • Programming tools
     • CSS
       • CSS (Cascading Design Sheets) is used to style and layout web pages, such as changing the font, colour, size, and spacing of your content, splitting it into numerous columns, or adding animations and other ornamental elements.
         • CSS will be used to Stylize and customize the app and will be done so that coding will be used by HTML.
     • HTML
       • HTML is a standardized system for tagging text files in order to achieve font, color, graphic, and hyperlink effects on World Wide Web pages.
         • HTML, will be the essential scaffold you can say to make the basic, functions of the website
     • SQL
       • SQL is an abbreviation for Structured Query Language. SQL allows you to connect to and manipulate databases.
     • SQLite3
       • SQLite is an in-process library that implements a serverless, transactional SQL database engine with zero configuration.
         • SQL and SQL LITE, will make the website store data, and values, such as the data base later on in the PowerPoint and the LITE will make more complicate Data storage.