Assessment Project PDF

Preview

Summary

assessment projects....

Description

Assessment Project TASK 1: 1. Imported all the data through import button on File. Imported all of them one by one because it would not import all of them at once with my version of excel on Mac. The version of the excel I have used is 16.36 (200413000). 2. Chose fixed width and not delimited because if you choose fixed width you can choose where to put the break line. Delimited would not let people choose the PM/AM section added in the time column. 3. After every CSV data was imported, I have made another column before the dates as sensor ID. Added every Sensor ID’s manually because could not do it automatically. It was easy to put them manually right after one sensor data was imported in.

TASK 2:

1. Added the format as US and AU manually as well. It can be done automatically but did not wanted to make any mistakes, so looked every sensor and added the format’s manually. After adding everything manually, it is best to double check by filtering the formats and check them with the format. 2. In Australian date format, I have used the Year, Month, Day function to put the year, month and day in separate columns. E.g., =year([@date]), =month([@date]) and =day([@date]). 3. In the US format, I have used Left, Mid and Right function as the year, month, and day function did not work in the US format because

Australia’s time format is dd/mm/yyyy and America’s time format is mm/dd/yyyy so using different function is necessary. E.g., =RIGHT([@Date],4), =LEFT([@Date],2), and =MID([@date],4,2). 4. Using the Text to Column function, I have moved the time into another time column. 5. In both formats, I have used Textjoin function to get the normalised time. E.g., =TEXTJOIN("",,[@year]&"/",[@month],"/",[@Day]," ",[@Time2]). 6. For Fahrenheit and Celsius column, because the temperatures from both countries have different weather, I used the “If And” function to determine the Fahrenheit and Celsius of both the countries. E.g., =IF(AND(D240,(D2-32)*5/9,D2)).

TASK 3

1. With task 3, firstly I tried to do with pivot table. With my sensor ID in my column section, Day in my rows section and average of Celsius in my Values section. 2. After making the table, I have made line chart. 3. With the line chart, I tried to come up with the possible 5 overlaps 9-23; 19-4; 2-8; 6-11; and 3-22....