Learning Outcome
5.1 Arrange data and information
5.2 Clean data
5.3 Present data
Analyse Wastewater Infrastructure Design
Data
Introduction to learning outcome
This learning outcome covers categorizing population into various classes, analyzing and
cleaning climatic and hydrological data, and producing topographical maps and ground
profiles from survey data.
Definition of key terms
The hydrostatic bench is a self-contained unit with all necessary apparatus.
for a comprehensive range of experiments on properties of fluids and hydrostatics.
Open Channel-defined as a design of flow enclosed in a conduit with a free surface
commonly known as a channel.
Weirs are barriers across a river’s width, designed to alter its flow.
5.1 Arrange data and information based on various themes.
Qualitative data analysis involves identifying themes.
can be done by reviewing literature and come from the phenomena being studied, already
agreed-upon professional definitions, local common-sense constructs, and researchers.
Data can be arranged using various techniques, in modern trends and computing data is
mostly arranged in Microsoft Excel for easier and faster analysis.
Besides Excel sheets, data can also be grouped using:
Pie charts
Graphs
Flow charts
Tabulations
5.2 Clean data as per best practice.
After collecting and arranging data there is a need for it to be cleaned by a process known
as data cleansing, this can be defined as a process of detecting and correcting inaccurate
data from the database arranged. We shall focus on the quality of data, the quality can be
assessed by the following factors: Validity
Accuracy
Completeness
Uniformity
Consistency
Uniformity
Data cleansing involves several processes.
i. Data auditing by use of statistical methods
ii. Workflow specifications by removing anomalies
iii. Workflow execution where correctness is verified after the specification
iv. Post-processing and controlling by inspection of the results.
PARAMETERS OF CALCULATION
Wastewater contamination
extent
Data can be sorted into 3 main categories as municipal,
agricultural, or industrial wastewater.
Geological data
Focusing on the vegetation in terms of infiltration and
soil conditions.
Discharge requirements
Policies are a tool that can be used to come up with
wastewater data this is based on requirements by bodies
e.g., NEEMA and KEBS
Sizing of components
Here data is sorted as Primary, secondary and tertiary
Data presentation should be clear and easy to interpret it can be done by a graphical format
or tabular, data can be in figures or textual.
Data presentation methods:
Bar graph – used mainly for comparison
Pie chart – shows percentages
Line graph – useful in displaying data that changes over time
Pictographs- uses small identical or figures of objects called isotopes in making
comparisons.
Conclusion
This learning outcome covered categorizing population into various classes, analyzing and
cleaning climatic and hydrological data, and producing topographical maps and ground
profiles from survey data.
Written Assessment
Data processing involves assessing data quality through the following.
except which one
a) Completeness
b) Validity
c) Uniformity
d) Presentation
Which of the following is not a data presentation method?
a) pie chart
b) line graph
c) creating models
d) bar graphs
3. Explain the term data cleansing
4. Evaluate the sue of the hydrostatic bench.
5. Explain ways in which themes can be identified from a database?
6. explain various methods of data arrangements
7. Classify the modern techniques of arranging data
Oral Assessment
Explain the following processes:
a) Data auditing
b) Workflow specification
Case Study Assessment
Using hydrological data from your area, tabulate and interpret the data then present it
Oral Assessment
Briefly explain the following methods of data presentation.
1. Pie charts
2. pictograms
Practical Assessment
Give an example of a pictogram using data provided, 739.
Project Assessment
Using hydrological data from your area, arrange clean, and present the data using your
preferred method.