Reference no: EM133888549

Python Programming Studio

Investigating Australian Climate Change' Studio Project Requirements Document

Overview
This document outlines the tasks for the "Anthropomorphic Climate Change" social challenge. You can think of this document as the product idea from the UCD perspective, and the case study from the database perspective.
Challenge: Investigating Australian Climate Change
According to the World Meteorological Organization, climate change is a term used to describe changes in climate that can be identified by changes in the average or variability of climate properties over an extended period of time. The reasons for climate change are complex. Some climate change may be due to internal or external processes such as changes in the solar cycle or volcanic eruptions. Hire Online Assignment help service for completing assignment!

For example, the year 1816 was famously described as "the year without a summer" due to the eruption of Mt Tambora in Indonesia which causes significant crop failures in the northern hemisphere. Anthropomorphic climate change is also known as Human-Induced climate change. Anthropomorphic Climate Change occurs when human
actions have an effect on climate trends. Examples of human actions include:
Burning fossil fuels
Deforestation
Land Use Change
Livestock Management
Fertilisation of Soil
Waste Management
Industrial Processes
Human induced climate change has resulted in accelerated changes in several climate metrics including increased temperatures, melting of Antarctic ice shelfs, glacial retreat, and an increase in extreme weather events. Signifiers of climate change include increased minimum and maximum temperatures over time, increased rainfall as more water enters the atmosphere, increased humidity, as well as new extremes in various climate measurements.
Using the Bureau of Meteorology data, your challenge is to develop a web-application to help various key parties including the general-public, corporations and policy makers to explore unbiased information on climate change over an extended period (1970 - 2020). You will need to:
Present this information in an informative, respectful, and unbiased manner.
Cater for a diverse range of users who are seeking to become more informed on this topic.
Provide diverse types of information on functionality, including both high-level summaries, and enabling an in-depth analysis of the data.
By using your website, users should be able to become well-informed about anthropomorphic climate change in the Australian context.

Level 1 - "Big Picture" Content
Level 1 sub-tasks capture the attention of the users and show how to use your website. It is up to you to decide the best way to show the users the required information, that is, complete the UCD.

Sub Task A: Landing Page
Capture the attention of all users of your website.
Highlight the topics targeted by your website.
Present a snapshot of the data covered by your website.
You should present 4 facts that are of interest to your selected user groups.
For example:
The year range (first and last year) for available data
Identify the weather station that has the lowest recorded temperature in the dataset.
Identify the weather station that has the highest recorded rainfall measurement in the dataset.
Identify the region with the most weather stations.
Other facts that are of particular interest to your selected user groups.

List all attributes and descriptions using a "natural language" label.
These must be stored in and retrieved from your database based on the provided description.csv file in BOM_DATA.ZIP.

Sub-Task B: Mission Statement
This presents the overall purpose of your website. This should:
Present your perspective on how your website addresses the social-challenge.
Describe how your site can be used.
Present the Personas that your website targets. These must be stored in and retrieved from your database.
List the names and student numbers of all team members. These must be stored in and retrieved from your database.

Level 2 - "Shallow Glance" of the data
Level 2 sub-tasks explore the issue of climate change for various geographic locations, climate metrics and time
periods. You should carefully consider your UX/UI designs and the ER model. The sub-tasks include UX/UI design and ERM design challenges.
In this level you must demonstrate the ability to select, filter, sort, join and aggregate data using efficiently written SQL.
Any data anomalies such as missing data, duplicate data etc must be identified and handled appropriately. For example, you might average values for duplicate rows that have inconsistent data.

Sub-Task A: Focused view of climate change by Weather Station
Present information about the climate for user selected States.
Allow the user to select any ONE from all the available States.
Allow the user to select a start latitude and an end latitude
Allow the user to select a specific climate metric.
Provide a facility to sort the data on any of the resultant columns.

Sub-Task B: Focused view of Climate Change by Climate Metric
Present information about climate changes for specific climate metric measurement across all states and regions.
Allow the user to select any ONE from all available climate metrics.
Allow the user to select a range of station id's
Allow the user to select a start date and end date
For the selected metric display the daily value for the selected metric for all the stations with the ability to filter and sort on any of the resultant columns.
For example, station IDs range 3000 - 4000 between the dates 01/01/1970 - 03/01/1970 looking at precipitation totals, sorted by station ID.

Allow the user to summarise the data by combining information from more than one table. For example: the total value for precipitation for a State
May 2005

Level 3 - "Deep-dive" of the data
Level 3 sub-tasks explore a deeper view of the issue of climate change for various states territories & regions, climate metrics.
In this level you must demonstrate the ability to use the results of one query to find another sub-dataset.
You should carefully consider your UX/UI designs and the ER model. These sub-tasks include complex UX/UI design and ERM design challenges. For top-marks you will need to take a very well-considered approach.
Write an efficient SQL query that:
Retrieves only the required data.
Uses JOINs and column selection to work in a single query if possible.
Performs sorting based on similarity using SQL.
Avoids post-processing of data using Python where it can be handled through careful crafting of the SQL query.
Sorts results by a user selected criterion.
Note that this is a challenge in making suitable SQL queries.

Sub-Task A: Identify weather station locations with similar change in metric percentages
In this task, enable your users to analyse weather stations that have changed over time to identify which ones show
similar rates of change.
Note the primary focus for this sub task is identifying similar weather stations via the use of metrics. Your user should be able to:
Select multiple time periods
(e.g. specific date ranges or aggregated time periods such as quarters, half decades etc).
Choose a reference weather station (e.g. Melbourne Airport).
Choose the number of weather stations to find.
For Example:
The user wants to find the two most similar weather stations to Melbourne Airport based on average temperature, and a time range from 2005 to 2015, grouped into two half-decade periods (2005-2009 and 2010-2015).

The system calculates how much each climate metric changed across the two time periods and compares them to other weather stations that have a similar rate of change on a second climate metric.

Sub-Task B: Exploring Climate Metrics Similarities
In this task, enable your users to explore how different climate metrics (e.g. Precipitation, Max Temperature, Sunshine) have changed over time to identify which ones show similar rates of change.
Note the primary focus for this sub task is identifying and correlating similar climate metrics. Your user should be able to:
Select multiple time periods
(e.g. specific date ranges or aggregated time periods such as quarters, half decades etc).
Choose a reference climate metric (e.g. Precipitation).
Choose the number of climate metrics to find. For

In this first milestone, 'Milestone - Design', you will be:
Understanding the structure of the Studio Project.
Reviewing the requirements of the web-app and data: Investigating Australian Climate Change
Registering your project group and working collaboratively
Writing the 'Milestone - Design' report

Assessment Task
Understanding the Structure of the Studio Project

In Python Programming Studio's Canvas->Assignments->Assessment Task 3: Studio Project, you and your project partner will eventually create a data-driven web-app based on a provided dataset, using the concepts covered in the user centred design (UCD), databases (DB) and programming classes of the course. There are several milestones to complete for this major project and both team members will need to complete each milestone.
Your team's web-app will have 6 unique pages. Each student will create three pages. Each page corresponds to a sub-task within a level. Each level corresponds an increasing level of complexity.

Reviewing The Requirements of The Web-App and Data: Investigating Australian Climate Change
Both project members must thoroughly familiarise themselves with the following details that apply to the entire Studio Project:

Registering Your Project Group and Working Collaboratively

how you must register your group and, as a part of it, how you must setup the private team in Microsoft Teams and its access permissions as required by the studio project as a whole. The Q&A in the same activity also explains how you should work collaboratively to avoid issues and obtain the
maximum marks.

Writing the 'Milestone - Design' Report

Bringing Group Issues to the Attention of Staff During Classes
Whenever you feel there is an issue with the teamwork, you must add a submission comment under this assignment page and bring this to the attention of your class instructors during class times so that they can provide the best advice for your team to function correctly. Simply adding submission comments will not suffice.

Submitting Your Report Regularly
Refer to section 5. Assessment Submission and Feedback, further below in this page.

Timeline
It is expected that you will create and maintain an up-to-date version of the timeline that you created for Canvas->Assignments->Stand-Up 4, in your private Microsoft Team. Remember to communicate any crucial dates relating to work that needs to be done together. E.g. both students should work together on the navigation aspect of their wireframes to give a consistent experience to the end-user.