Civil Engineering Winter Assignment

Question One

Please note that the dataset is too big to be loaded into Excel, and while it opens, it will strip about 1/3 of the data.

The structure of the dataset is as follows:

Column 1: Point Location in WGS84

Column 2: Temperature in degree Celsius

Column 3: Rainfall in mm

Column 4: Number of people in the location

Column 5: Sensor value A

Column 6: Sensor value B

• Import the dataset into QGIS

• Create a map that color-codes the locations based on sensor value A

• Create a map that color-codes the locations based on minimal rainfall and uses marker sizes based on the maximum number of people in the location

• Create a heat map for the maximum sensor value B values per location

Important:

Answer should follow this:

Color Coded Map: The map of the entire area is shown with an identifiable color scheme. A close up in any area is provided to highlight the different Color codes

Colour and Size Coded Map: The map of the entire area is shown with an identifiable Color scheme and multiple symbol sizes. A close up in any

area is provided to highlight the different colour codes and sizes.

Heat Map: A heatmap for the entire area is shown with a suitable Color

scheme. A close up is provided into a ‘high heat’ area

Question Two

Link: https://www.latimes.com/opinion/editorials/la-ed-salton-sea-failure-20190329-story.html

The Salton Sea has been shrinking for years. Its negative impacts on the surrounding environment and public health has been a major concern in Southern California.

You are bidding for the qualification to make strategic restoration plans for the State. To compete in the Phase I of this bidding process, you must complete a report including the following information:

  1. Based on the water resources data on USGS over the past years (or even decades), predict the annual stream flow, annual precipitation, and annual evapotranspiration rates in 2050.
  2. Estimate the size of Salton Sea in 2050. How much smaller (in percentage) will it be comparing with its size today?
  3. Propose strategies that will effectively prevent (or at least slow down) the shrinking of Salton Sea.

2. Useful Links

USGS Water Resources:

https://www.usgs.gov/mission-areas/water-resources

Question Three

1. Consider your close circle of friends; you are known as a professional with the background
in architectural engineering and construction, currently upgrading your qualifications by
completing MCM at Deakin University.
2. One of your friends (Giulietta) approached you proposing management of a project
involving construction of her house. Giulietta wants the project to be known as “The house
at my place - THAMP”.
3. She proposes that you will be contracted as the Project Manager under the AS4915-2002
Project Management – General Conditions contract.
4. The ultimate product of the THAMP project is a two-storey building. The basic design
documentation was given to you for your consideration and Giulietta assumes you evaluate
the design from ‘value engineering/management’ viewpoint. Please see the 2020-T1 case
project folder in the Cloud Deakin site of SRM752 unit.
5. All preliminary works (site surveying, etc.) and permits (planning, building, no-go zone, etc.)
necessary to start and continue constructions are finalized/granted.
6. Location of the building is still to be decided by Giulietta and her decision to choose her
preferred location is based on your advice. However, the location must be either in the
Greater Melbourne () or Greater Geelong [] boundaries.
7. Giulietta confirmed that she has financial resources to complete the THAMP project
8. As you currently have some spare capacity in terms of your professional engagements,
you have gladly accepted the offer and signed out the AS4915-2002 contract for the value
of $5,000 ($3,425 + $1,575) with your client (Giulietta), at this stage just for the preparation
of project management plan (PMP).
9. Based on the merit of your plan Giulietta is willing to engage you as the Project Manager
with professional fees of 14% of the total cost of the THAMP project for management of the
THAMP project.
10. Giulietta has given you three months to prepare the THAMP project management plan for
the construction and management of the project resources.
11. You have no access to any resources from the so called “parent organization”. So, in order
to complete the THAMP project, you will need to perform either, by yourself any necessary
managerial and/or construction tasks, or commission service(s) from others,

Question Four

Problem 1

Please read Section 1.2 and Section 1.3 in the textbook (the scan copy is attached) Use the information in Table 1.2.2 Dynamics of Actual Water Availability in Different Regions of the World,

  1. 1)  Plot a line graph showing how the actual water availability per unit area (unit: m3 m-2 per year) changed in the United States from 1950 to 2000. The population in the United States in 2000 was about 282.2 million.
    • Note: x-axis is time (in year); y-axis is the actual water availability per unit area (in m3 m-2 per year).
    • Requirement: Please show sample calculations (must).
  2. 2)  Plot a bar graph showing comparing the actual water availability per capita (unit: m3 per year per capita) in 2000 in different continents, i.e., Europe, Africa, North America, South America, Australia/Oceania, and Asia.
    • Note: x-axis is time (in year); y-axis is the actual water availability per capita (in m3 per year per capita); each bar should represent one continent.
    • Requirement: Please show sample calculations (must).

Problem 2 (20 points)

Please read Section 1.2 and Section 1.3 in the textbook (the scan copy is attached). Use the information in Table 1.2.3 Dynamics of Water Use in the World by Human Activity,

  1. 1)  In 2000, among agricultural, industry, municipal, and reservoirs, which one is the biggest water user in terms of withdrawal? Which one is the smallest water user in terms of consumption? Please provide your suggestions (> 3) on how to reduce water use. Note: you may need to search on the internet for additional information.
  2. 2)  What are withdrawal and consumption, respectively? What may cause the difference between the two? Note: you may need to search on the internet for additional information.

Problem 3

Please read Section 1.5 and Section 1.6 in the textbook (the scan copy is attached).

  1. 1)  What are the three broad categories of water resources management?
  2. 2)  Please define water resources system.
  3. 3)  Please explain water-energy nexus (< 100 words).
  4. 4)  Based on Figure 1.6.4, please explain climate-energy-water-land nexus (<100 words).

Problem 4

The average rainfall in a small watershed (total area: 1.271 km2) is 50 inches per year over the recent ten years; the average annual net surface stream flow (inflow minus outflow) is 432 mm (total volume divided by the watershed area); the average annual net groundwater crossing the watershed boundary (inflow minus outflow) is 0.3 ft. The average change in storage each year is (+) 16551 acre-in. On an annual average basis, what fraction of rainfall is evapotranspiration? Start your solution with the general form of water budget.

Question Five

It is proposed to construct a canal in the ground shown in Figure for ferry transport (the Len bank is not shown).
Your task is to assess the canal banks stability for the following scenarios: • Long-time after excavation of the canal without any water (in case of the operation of the canal has been delayed due to unforeseen events). • During normal operation of the canal where the top water level of the canal is maintained at RL- 33 m for a long period of time. • During the sudden draw down of the canal for urgent repair of sluice gate downstream.
The analysis is to be undertaken with the computer package -SLOPENV”. Use Bishop method as your analysis type.

Question Six

Design a concrete mixture proportions which will be used for offshore concrete platform. Norway is a world leader on offshore concrete platforms with 1a of the world’s 30 larger offshore concrete structures located on the Norwegian continental shelf. The first of these platforms where the Ekofisk Tank installed in 1974 and the last was Troll gravity-based structure installed in 1996. The Sakhalin project is located in a harsh and artic environment where concrete structures have proven excellent characteristics with a minimum of maintenance. 80 mm slump value is required for the Sakhalin project. 28-days concrete characteristic strength is 2b MPa. It is required that no more than 1 test result in 100 will fall below the specified strength. The fine aggregate has a fineness modulus of 2.60 and Zone 3. For Coarse Aggregate (Uncrushed): SSD Bulk Specific Gravity: 2.65, Absorption Capacity: 2.b %, Total Moisture: 1.c % and Dry Rodded Unit Weight: 1345 kg/m3. For Fine Aggregate (Uncrushed): SSD Bulk Specific Gravity: 2.70, Total Moisture: 3.d % and Free Moisture: 2 %. Cement: Portland Composite Cement, Specific Gravity: 2.97. For 0.e5 m3 of concrete, binder amount is calculated as 120 kg (Use ACI Method of Mix Design)