A. General Information and Submission

● This is an individual assignment.

● Submission method: Submission is online through Moodle as a .zip file

● Penalty for late submission: 10% deduction for each day

B. Assignment Overview

Task 1: Create a GPX file

For  this  assessment  task,  you  are  required to use GPX tracking applications and  spatial databases for geospatial data analysis. The assignment involves using a GPX tracker app, handling  GPX  files,  and  using  a  spatial  database  for  storing,  retrieving,  cleaning  and transforming data and analyzing the data.

(Note: The following two applications are provided as guidance for generating a GPX file. You are free to use any other applications that suit your needs. However, please ensure that the GPX file generated by any other application can effectively answer all the questions in this assignment.)

For iOS users, you can download the following mobile applications for this assignment.

Once you have downloaded the application, you can start tracking your walking by clicking the  "Start  Tracking" button. If you need to pause the tracking, you can click the "Pause" button. When you are finished with your tracking session, you can click the "Save" button to save your path as a GPX file. To access the GPX file, click on the "folder" icon located in the top left corner of the application. From there, you can select a GPX file and share it via Gmail. Download the shared GPX file from your Gmail account to your laptop or local PC. Make sure you save your GPX file to disk C or another preferred location.

At this point, you will have a GPX file stored on your local PC. In the next step, you will load this data into a Spatial database for further analysis and processing.

For   Android users,  you  can  download  the   following  mobile  applications  for  this Assignment.

Output of Task 1: A GPX file

Task 2: Import GPX file

2.1 Import GPX file

Before restoring the GPX files, make sure you have prepared a destination schema in your database. For this assignment, the destination schema is "a5".

You are required to create a script for importing the mentioned GPX files into the database using the "ogr2ogr" tool. The script should create a table named "Authcate" where "Authcate" represents the first part of your  student email address before the "@" symbol. For example, if your authcate is "test001" in the email "[email protected]," the table name  should be "test001." Please replace "authcate" with your specific information accordingly.

Once you have successfully restored the data, take a screenshot of the "Authcate" table showing the imported data.

Output of Task 2: Restore a "Authcate" table in the spatial database

Task 3: Data Analytics

3.1 Speed analysis

Based on the "Authcate" table you have restored, write a script that makes queries to calculate the average speed of your walking or driving, etc. When you have run the script and obtained the results, take a screenshot of both the script and its output. The screenshot should clearly show the script code and the average speed calculated.

3.2 Further Data Analysis

In  addition  to  the  speed  analysis,  you  will be required to  carry  out further data analysis on the “Authcate” table using the technique we have learnt in this unit. You are free to choose any specific perspectives or aspects of data analysis that are relevant to your data set. This could include exploring different statistical measures or other relevant analyses.

As part of this data analysis, you must also create data visualizations [QGIS] to present your findings.  Data  visualizations  can  include  charts,  graphs,  or  any  other  visual  representations  that effectively communicate the insights derived from your analysis. These visualizations will be used in the next section of the assignment, the summary report. To support your analysis, you can include screenshots of the visualisations directly in the report.

Be sure to include the script or code used for data analysis and data visualisation in the appendix of your report. The script should provide clear instructions on how the analysis was performed and any necessary calculations or transformations applied to the data. This will ensure that your analysis can be  reproduced  and  verified.  Remember  to  include  appropriate  labels,  titles,  and  legends  in  your visualizations to make them easy to understand. The visualizations should be of sufficient quality and clarity to effectively convey your analysis findings.

Output of Task 3.1: Script and Screenshot for Speed Analysis

Output of Task 3.2: Data Analysis and Visualization

Task 4: Summary report

As  a  professional  data  analyst,  your  task  is  to  consolidate  all the previous tasks,  including data creation, import, analysis, and visualizations, into a comprehensive written report. The report should adhere to a word limit of 1000 words and follow a structured format, consisting of an introduction, methodology, results, conclusion, and appendix. Please note that a question-and-answer format is not acceptable for this assignment, and marks will be deducted for using such a format.

The output of Task 4: Summary report

C. Marking criteria

The grading of the assignment presentation is based on the following criteria:

The grading criteria for the assignment presentation are as follows:

● Creation of an Appropriate GPX File

● Successful Import of GPX File

● Accuracy and Depth of Data Analysis

● Quality and Relevance of Visualizations

● Coherence of the Report Structure and Clarity in Presenting Methodology and Results

● Creative and Critical Interpretation of Analysis Results:

● Overall Quality of the Written Report:

○   Evaluate the clarity and effectiveness of the writing, including grammar, sentence structure, and vocabulary.

○   Assess the proper use of visuals, such as figures, tables, and charts, to support the written content.

○   Consider  the  adherence  to  proper  citation  practices  and  referencing  of  external sources.

D. Assignment Submission

The assignment must be submitted electronically through Moodle. Please ensure the following:

1.   The submission of this assignment must be in the form of a single ZIP file. No other forms will be accepted.

2.   The ZIP file includes a GPX file from Task 1, scripts from Task 3 and a PDF file for the Task 4. Please note that the maximum file submission size on Moodle is 500MB.

3.   The output for Task 2 only needs to be included in the appendix of the report, as mentioned in Task 4.

You must ensure that you have all the files listed before submitting your assignment to Moodle. Failure to submit a complete list of files will incur mark penalties.

E. Authorship

This assignment is an individual assignment and the final submission must be identifiably your own work. Breaches of this requirement will result in an assignment not being accepted for assessment and may result in disciplinary action.

As  per  the  University’s  policy  on  the  guidelines  and practice pertaining to the usage of Generative AI, this assignment restricts all use of generative AI. In this assessment, you must not use generative artificial intelligence (AI) to generate any materials or content in relation to the assessment task.

F. Late Penalty:

Late  assignments  submitted  without  an  approved  extension  may  be  accepted  up  to  a maximum of seven days with the approval of the Chief Examiner and/or Lecturer but will be penalised at the rate of  10%  per day (including  weekends and public holidays). Assignments submitted more than seven days after the due date will receive a zero mark for that assignment and may not receive any feedback.

Please note:

●   An inability to manage your time or computing resources will not be accepted as a valid excuse. (Several assignments being due at the same time are a fact of university life.)

●   Hardware  failures,  whether  of personal  or  university  equipment, are not normally recognised as valid excuses. Failure to back up assignment files is also not recognised as a valid excuse.

G. Special Consideration:

From  this  semester  onwards,  students  will  no  longer  seek  extensions  from  the  Chief Examiner/Unit Teaching Team. All extensions / special considerations will now be handled by the central Spec Con team. Please do not email teaching staff to request an extension or special consideration.

Extensions  and  other individual alterations to the assessment regime will only be considered using the University Special Consideration Policy. Students should carefully read   the Special    Consideration   website,   especially    the   details   about   what    formal documentation is required.

All   special   consideration   requests   should   be  made  using  theSpecial Consideration Application .