Summative Assessment on Covid 19 Impact on Socially-Distanced Contact with People Aged Under 18

This summative assessment analyzes the impact of Covid 19 on socially-distanced contact with people aged under 18. The report covers a period from July 2020 to February 2020 and uses raw data presentation, statistical techniques, and data manipulation to evaluate the results. The report also includes representation in charts and graphs. No subject, course code, or college/university mentioned.

SUMMATIVE
ASSESSMENT

Contents
1.Brief Description about Covid 19:......................................................................................3
2.Raw Data Presentation:.......................................................................................................3
3.Statistical Technique:..........................................................................................................4
4.Data Manipulation:..............................................................................................................6
5.Representation in Charts and Graphs:.................................................................................8
CONCLUSION..............................................................................................................................11
REFERENCES..............................................................................................................................12

MAIN BODY
1.Brief Description about Covid 19:
The data set which is considered to perform the task in Covid 19 which has affected the entire
globe with its huge impact on industry, business world, health of the people very severely for
almost during 2020. The data which has been considered to perform the test are socially contact
distanced with people having the age group of under 18 with other people so that analysis has
been carried out accordingly that how fast such pandemic has spread amongst the group of
individual. The period which has been considered in this report starts from July 2020 to February
2020 that is almost 1.50 years so that accuracy can be maintained with respect of inputs that have
been placed. In this report the raw data has been considered as base to evaluate the results
accordingly and then on that set of data the statistical techniques has been performed which
includes calculation of mean, median, mode etc. Thereafter the data manipulation techniques
have been performed such as sum, count, average, minimum, average etc. for the given set of
data relating to Covid 19.
2.Raw Data Presentation:
Time period
Socially-distanced contact with people aged under 18
Proportion
that had
contact
with 0
individuals
Proportion
that had
contact
with 1-5
individuals
Proportion
that had
contact
with 6-10
individuals
Proportion
that had
contact
with 11-20
individuals
Propo
rtion
that
had
contac
t with
21 or
more
individ
uals
19 July 2020 to 01 August 2020 0.38 0.37 0.12 0.06 0.07
02 August 2020 to 15 August 2020 0.38 0.36 0.13 0.07 0.07
16 August 2020 to 29 August 2020 0.38 0.35 0.13 0.07 0.07
30 August 2020 to 12 September 2020 0.22 0.16 0.08 0.09 0.45
13 September 2020 to 26 September 2020 0.17 0.08 0.06 0.08 0.60
27 September 2020 to 10 October 2020 0.18 0.07 0.06 0.07 0.62
11 October 2020 to 24 October 2020 0.19 0.07 0.05 0.07 0.61
25 October 2020 to 07 November 2020 0.24 0.11 0.06 0.07 0.51
08 November 2020 to 21 November 2020 0.20 0.06 0.04 0.07 0.63
22 November 2020 to 05 December 2020 0.20 0.05 0.04 0.07 0.64

06 December 2020 to 19 December 2020 0.18 0.05 0.04 0.07 0.66
20 December 2020 to 02 January 2021 0.51 0.21 0.04 0.04 0.21
03 January 2021 to 16 January 2021 0.67 0.17 0.05 0.04 0.07
17 January 2021 to 30 January 2021 0.68 0.17 0.06 0.05 0.05
31 January 2021 to 13 February 2021 0.66 0.19 0.05 0.05 0.05
14 February 2021 to 27 February 2021 0.62 0.24 0.05 0.05 0.04
28 February 2021 to 13 March 2021 0.43 0.17 0.06 0.07 0.27
14 March 2021 to 27 March 2021 0.17 0.05 0.04 0.08 0.66
28 March 2021 to 10 April 2021 0.24 0.15 0.07 0.07 0.47
11 April 2021 to 24 April 2021 0.24 0.16 0.07 0.08 0.46
25 April 2021 to 08 May 2021 0.13 0.05 0.05 0.07 0.70
09 May 2021 to 22 May 2021 0.12 0.05 0.04 0.07 0.72
23 May 2021 to 05 June 2021 0.15 0.08 0.06 0.07 0.63
06 June 2021 to 19 June 2021 0.16 0.08 0.05 0.07 0.64
20 June 2021 to 03 July 2021 0.14 0.06 0.05 0.06 0.69
04 July 2021 to 17 July 2021 0.16 0.06 0.05 0.06 0.67
18 July 2021 to 31 July 2021 0.27 0.16 0.08 0.06 0.43
01 August 2021 to 14 August 2021 0.36 0.26 0.13 0.08 0.17
15 August 2021 to 28 August 2021 0.36 0.26 0.13 0.08 0.17
29 August 2021 to 11 September 2021 0.23 0.17 0.09 0.07 0.45
12 September 2021 to 25 September 2021 0.10 0.04 0.03 0.05 0.78
26 September 2021 to 09 October 2021 0.10 0.03 0.03 0.05 0.79
10 October 2021 to 23 October 2021 0.10 0.03 0.03 0.04 0.80
24 October 2021 to 06 November 2021 0.17 0.09 0.06 0.06 0.62
07 November 2021 to 20 November 2021 0.09 0.03 0.02 0.05 0.82
21 November 2021 to 04 December 2021 0.09 0.03 0.03 0.04 0.81
05 December 2021 to 18 December 2021 0.08 0.03 0.03 0.04 0.82
19 December 2021 to 01 January 2022 0.29 0.17 0.06 0.05 0.43
02 January 2022 to 15 January 2022 0.19 0.10 0.05 0.05 0.61
16 January 2022 to 29 January 2022 0.09 0.03 0.02 0.04 0.81
30 January 2022 to 12 February 2022 0.08 0.02 0.03 0.04 0.83
13 February 2022 to 26 February 2022 0.11 0.06 0.04 0.05 0.73
3.Statistical Technique:
Time period
Socially-distanced contact with people aged under 18
Proportion
that had
contact
with 0
individuals
Proportion
that had
contact
with 1-5
individuals
Proportion
that had
contact
with 6-10
individuals
Proportion
that had
contact
with 11-20
individuals
Prop
ortio
n
that
had

conta
ct
with
21 or
more
indiv
idual
s
19 July 2020 to 01 August 2020 0.38 0.37 0.12 0.06 0.07
02 August 2020 to 15 August 2020 0.38 0.36 0.13 0.07 0.07
16 August 2020 to 29 August 2020 0.38 0.35 0.13 0.07 0.07
30 August 2020 to 12 September 2020 0.22 0.16 0.08 0.09 0.45
13 September 2020 to 26 September 2020 0.17 0.08 0.06 0.08 0.60
27 September 2020 to 10 October 2020 0.18 0.07 0.06 0.07 0.62
11 October 2020 to 24 October 2020 0.19 0.07 0.05 0.07 0.61
25 October 2020 to 07 November 2020 0.24 0.11 0.06 0.07 0.51
08 November 2020 to 21 November 2020 0.20 0.06 0.04 0.07 0.63
22 November 2020 to 05 December 2020 0.20 0.05 0.04 0.07 0.64
06 December 2020 to 19 December 2020 0.18 0.05 0.04 0.07 0.66
20 December 2020 to 02 January 2021 0.51 0.21 0.04 0.04 0.21
03 January 2021 to 16 January 2021 0.67 0.17 0.05 0.04 0.07
17 January 2021 to 30 January 2021 0.68 0.17 0.06 0.05 0.05
31 January 2021 to 13 February 2021 0.66 0.19 0.05 0.05 0.05
14 February 2021 to 27 February 2021 0.62 0.24 0.05 0.05 0.04
28 February 2021 to 13 March 2021 0.43 0.17 0.06 0.07 0.27
14 March 2021 to 27 March 2021 0.17 0.05 0.04 0.08 0.66
28 March 2021 to 10 April 2021 0.24 0.15 0.07 0.07 0.47
11 April 2021 to 24 April 2021 0.24 0.16 0.07 0.08 0.46
25 April 2021 to 08 May 2021 0.13 0.05 0.05 0.07 0.70
09 May 2021 to 22 May 2021 0.12 0.05 0.04 0.07 0.72
23 May 2021 to 05 June 2021 0.15 0.08 0.06 0.07 0.63
06 June 2021 to 19 June 2021 0.16 0.08 0.05 0.07 0.64
20 June 2021 to 03 July 2021 0.14 0.06 0.05 0.06 0.69
04 July 2021 to 17 July 2021 0.16 0.06 0.05 0.06 0.67
18 July 2021 to 31 July 2021 0.27 0.16 0.08 0.06 0.43
01 August 2021 to 14 August 2021 0.36 0.26 0.13 0.08 0.17
15 August 2021 to 28 August 2021 0.36 0.26 0.13 0.08 0.17
29 August 2021 to 11 September 2021 0.23 0.17 0.09 0.07 0.45
12 September 2021 to 25 September 2021 0.10 0.04 0.03 0.05 0.78
26 September 2021 to 09 October 2021 0.10 0.03 0.03 0.05 0.79
10 October 2021 to 23 October 2021 0.10 0.03 0.03 0.04 0.80
24 October 2021 to 06 November 2021 0.17 0.09 0.06 0.06 0.62

07 November 2021 to 20 November 2021 0.09 0.03 0.02 0.05 0.82
21 November 2021 to 04 December 2021 0.09 0.03 0.03 0.04 0.81
05 December 2021 to 18 December 2021 0.08 0.03 0.03 0.04 0.82
19 December 2021 to 01 January 2022 0.29 0.17 0.06 0.05 0.43
02 January 2022 to 15 January 2022 0.19 0.10 0.05 0.05 0.61
16 January 2022 to 29 January 2022 0.09 0.03 0.02 0.04 0.81
30 January 2022 to 12 February 2022 0.08 0.02 0.03 0.04 0.83
13 February 2022 to 26 February 2022 0.11 0.06 0.04 0.05 0.73
Statistical Technique:-
Mean for Covid-19 0.25 0.12 0.06 0.06 0.51
Median for Covid-19 0.19 0.08 0.05 0.07 0.62
Mode for Covid-19 0.38 0.03 0.05 0.07 0.07
4.Data Manipulation:
Time period
Socially-distanced contact with people aged under 18
Proportion
that had
contact
with 0
individuals
Proportion
that had
contact
with 1-5
individuals
Proportion
that had
contact
with 6-10
individuals
Proportion
that had
contact
with 11-20
individuals
Proportion
that had
contact
with 21 or
more
individuals
19 July 2020 to 01 August 2020 0.38 0.37 0.12 0.06 0.07
02 August 2020 to 15 August 2020 0.38 0.36 0.13 0.07 0.07
16 August 2020 to 29 August 2020 0.38 0.35 0.13 0.07 0.07
30 August 2020 to 12 September
2020 0.22 0.16 0.08 0.09 0.45
13 September 2020 to 26 September
2020 0.17 0.08 0.06 0.08 0.60
27 September 2020 to 10 October
2020 0.18 0.07 0.06 0.07 0.62
11 October 2020 to 24 October 2020 0.19 0.07 0.05 0.07 0.61
25 October 2020 to 07 November
2020 0.24 0.11 0.06 0.07 0.51
08 November 2020 to 21 November
2020 0.20 0.06 0.04 0.07 0.63
22 November 2020 to 05 December
2020 0.20 0.05 0.04 0.07 0.64
06 December 2020 to 19 December
2020 0.18 0.05 0.04 0.07 0.66

20 December 2020 to 02 January
2021 0.51 0.21 0.04 0.04 0.21
03 January 2021 to 16 January 2021 0.67 0.17 0.05 0.04 0.07
17 January 2021 to 30 January 2021 0.68 0.17 0.06 0.05 0.05
31 January 2021 to 13 February 2021 0.66 0.19 0.05 0.05 0.05
14 February 2021 to 27 February
2021 0.62 0.24 0.05 0.05 0.04
28 February 2021 to 13 March 2021 0.43 0.17 0.06 0.07 0.27
14 March 2021 to 27 March 2021 0.17 0.05 0.04 0.08 0.66
28 March 2021 to 10 April 2021 0.24 0.15 0.07 0.07 0.47
11 April 2021 to 24 April 2021 0.24 0.16 0.07 0.08 0.46
25 April 2021 to 08 May 2021 0.13 0.05 0.05 0.07 0.70
09 May 2021 to 22 May 2021 0.12 0.05 0.04 0.07 0.72
23 May 2021 to 05 June 2021 0.15 0.08 0.06 0.07 0.63
06 June 2021 to 19 June 2021 0.16 0.08 0.05 0.07 0.64
20 June 2021 to 03 July 2021 0.14 0.06 0.05 0.06 0.69
04 July 2021 to 17 July 2021 0.16 0.06 0.05 0.06 0.67
18 July 2021 to 31 July 2021 0.27 0.16 0.08 0.06 0.43
01 August 2021 to 14 August 2021 0.36 0.26 0.13 0.08 0.17
15 August 2021 to 28 August 2021 0.36 0.26 0.13 0.08 0.17
29 August 2021 to 11 September
2021 0.23 0.17 0.09 0.07 0.45
12 September 2021 to 25 September
2021 0.10 0.04 0.03 0.05 0.78
26 September 2021 to 09 October
2021 0.10 0.03 0.03 0.05 0.79
10 October 2021 to 23 October 2021 0.10 0.03 0.03 0.04 0.80
24 October 2021 to 06 November
2021 0.17 0.09 0.06 0.06 0.62
07 November 2021 to 20 November
2021 0.09 0.03 0.02 0.05 0.82
21 November 2021 to 04 December
2021 0.09 0.03 0.03 0.04 0.81
05 December 2021 to 18 December
2021 0.08 0.03 0.03 0.04 0.82
19 December 2021 to 01 January
2022 0.29 0.17 0.06 0.05 0.43
02 January 2022 to 15 January 2022 0.19 0.10 0.05 0.05 0.61
16 January 2022 to 29 January 2022 0.09 0.03 0.02 0.04 0.81
30 January 2022 to 12 February 2022 0.08 0.02 0.03 0.04 0.83
13 February 2022 to 26 February
2022 0.11 0.06 0.04 0.05 0.73
Data Manipulation Techniques:-

Sum 10.51 5.13 2.46 2.57 21.33
Average 0.25 0.12 0.06 0.06 0.51
Count 42 42 42 42 42
Minimum 0.08 0.02 0.02 0.04 0.04
Maximum 0.68 0.37 0.13 0.09 0.83
5.Representation in Charts and Graphs:

CONCLUSION
Data handling is the process which ensures that the input that has been used to carry out the
research study are stored, disposed of in the safe and secure manner at the time of carrying out
the research study and then after the conclusion has been drawn accordingly. This report
showcase the analysis of raw data which is related with covid 19 spread that how it is spreading
amongst the people having the age group of 18 years or less. Further in this report to sort and
evaluate such data various statistical technique has been used such as mode, median and mean
along with this graphical presentation has been carried out with the given set of input. The main
purpose of this report tis to conduct the statistical analysis about how and what rate the infection
is spread amongst the people of above age group if they contact the different groups of people
and what result are obtained on that data.

REFERENCES
Books and Journals
Cizek, G.J., Andrade, H.L. and Bennett, R.E., 2019. Formative Assessment. Handbook of
formative assessment in the disciplines. pp.3-19.
Davison, C., 2019. Using assessment to enhance learning in English language education. Second
handbook of English language teaching. pp.433-454.
Garcia-Loro, F., Martin, S., Ruiperez-Valiente, J.A., Sancristobal, E. and Castro, M., 2020.
Reviewing and analyzing peer review Inter-Rater Reliability in a MOOC platform.
Computers & Education. 154. p.103894.
Raud, Z. and Vodovozov, V., 2019, October. Advancements and restrictions of e-assessment in
view of remote learning in engineering. In 2019 IEEE 60th International Scientific
Conference on Power and Electrical Engineering of Riga Technical University (RTUCON)
(pp. 1-6). IEEE.
van der Vleuten, C., van den Eertwegh, V. and Giroldi, E., 2019. Assessment of communication
skills. Patient Education and Counseling. 102(11). pp.2110-2113.