Basic Statistics and ICT Skills | Desklib Online Library | Solved Assignments, Essays, Dissertation

Learn about the impact of COVID-19 on the economy, healthcare, and social interactions in the UK. Also, find a step-by-step guide on Microsoft Excel working and a PowerPoint task. Subject: Basic Statistics and ICT Skills.

Basic Statistics and ICT
skills

Contents
Contents...........................................................................................................................................2
INTRODUCTION...........................................................................................................................1
Task 1 Report...................................................................................................................................1
Task 2: Microsoft Excel Working...................................................................................................4
Insert the Data Mentioned on the Question Paper.......................................................................4
Merge the cells from A2 to J2. Apply the following changes to the title line:............................5
Using range selection, select the cells from B3 to J3. Then, select the cells from A4 to A9.
Now change the font type, font size and font style of the selected cells as Times New Roman,
12, bold-italic...............................................................................................................................5
Using the AutoSum feature, find and write the sum of cells from B4 to F4 into cell G4. Then,
copy it to G5, G6, G7, G8 and G9...............................................................................................5
Using the Average function find and write the average GDP for Canada in H4. Repeat the last
step for the rest of the countries...................................................................................................5
Using the MIN and MAX formulas, find the minimum and the maximum GDP values for
Canada in I4 and J4 respectively. Do the same for the rest of the countries...............................5
Add a comment to H4. Write the text “GDP Average over years” into the comment box.........6
Select the cells from B4 to F9. Change format of the selected cells to Currency with 2 decimal
places...........................................................................................................................................6
Change the column width of Column A and make sure that all the texts on this column can fit
into the cells.................................................................................................................................6
Select the columns from B to J and apply AutoFit Selection for these columns.........................6
Add a new row above the 3rd row (that is between rows 2 and 3)..............................................6
Add outside and inside borders to your table. For the outside border choose a thicker line.......6
Select the title and change the cell colour to yellow...................................................................7
Select the cells B4 to J4 and A5 to A10. Change the cell colour to Light Blue..........................7
Select the cells from G5 to J10. Change the cell colour to Light Green.....................................7
Create a bar chart to show the total GDP across countries. Write “Total GDP across countries”
as the Chart title, “Country” as the (X) axis, “Value” as the (Y) axis. Add labels to the bars....7

Follow the instructions in the assessment brief on how to submit your task 2 i.e., take a
screenshot of your solution and include it in your report, then submit your excel file to the
correct submission link................................................................................................................8
TASK 3 POWERPOINT.................................................................................................................8
REFERENCES................................................................................................................................9

INTRODUCTION
The COVID-19 incident started a series of events which led to modifications in many
different companies, approaches, and processes (Al-Qirim, Tarhini and Rouibah, 2017). The
study has examined the changes in monetary reality, healthcare environment, and social
interactions. In additional to the study, information from medical questionnaires conducted in
United Kingdom were examined, along with the safeguards that should be taken in order to
provide a better atmosphere for future generations. Lastly, based on the presentation, an
evaluation of online courses was created, taken into consideration its advantages and
disadvantages in addition to ways that it can be made better for students.
Task 1 Report
Covid-19's terrible position appears to have an effect on every nation's economy and society.
However, this is what has demonstrated to be a particularly challenging time for a first-world and
engaged country like the United Kingdom, whereby international engagement is necessary. This
analysis will show how COVID-19 has affected individual's daily lives in United Kingdom by
examining developments in the health and technical fields, the economy, and social interactions.
There has been a significant influence on a number of criteria because the corona virus was first
identified in United Kingdom in January 2020. After the first corona virus case, numerous
procedures in United Kingdom would have to change in order to guarantee the government's
safety, from the learning system to socializing (Antignac, Scandariato and Schneider, 2016).
The vast bulk of educational institutions was using the internet to conduct their instructional
activities. To ensure security, not only educational establishments but mainly industry and
economical operations are and were done online; this has unquestionably been a wise move.
With 87 percentage of consumers making internet purchases this year—the highest percentage in
the preceding 11 years—the internet market in United Kingdom has boomed. Without the need
for a doubt, the e-commerce cultural significantly improved the fiscal condition in United
Kingdom. The physiological, academic, economical, and emotional conditions of everyone
living in United Kingdom, especially teenagers and the aged, appear to have fallen into disarray
as a result of the COVID-19. It should come as no wonder that the country's economic and social
status considerably led to the mental discomfort of the community. Online treatment and
communication through online social connecting sites have helped this generation both inwardly

and outside throughout the months. Considering that there have been over 10 million occurrences
and over 145 000 deaths in United Kingdom, the country's overall condition has been
significantly affected during period. The demand for workers has increased quickly in several
fields, especially in computational power and medicine. However, period cures all scars, and a
sizable portion of the populace has received vaccinations; in United Kingdom, 89 percent of
those above the age of twelve have had their first dose of the vaccine. The administration has
indeed been successful in assuring the security of its population, in contrary to certain other
third-world countries (Bartels, 2017).
The percentage of deaths in United Kingdom has changed significantly over period, as
indicated in the chart. Following the first epidemic in January 2020, cases surged quickly for a
few days, but because to the excellent service provided by United Kingdom's medical system, the
frequency steadied for many weeks. However, the following outburst (another COVID-19
variant) occurred in the fall of 2020, rendering the effects and situation uncontrollable. The
frequency of occurrences significantly rose at the beginning of 2021. Due to the health industry
and attention, diseases have once again diminished.
The chart demonstrates that the following wave had the highest incidence of deaths in a
given day, showing that the next wave was more challenging for United Kingdom. Considering
information, we estimated the frequency of corona influenza illnesses throughout March 2021.
Statistics show that there were roughly 126,445 deaths and 4,319,128 Corona communicable

disease. This suggests that 2.9% of people were not afforded the opportunity to recover from the
illness, while the rest of people recovered or are recovering adequately. There have been a
tremendous amount of people discovered, in terms of the quantity of people. Amazingly,
3,748,042 people in United Kingdom have recovered from the illness as a result of the measures
implemented to safeguard both their psychological safety and the security of the healthcare
community. There are presently many people recovering, and after that, the proportion of
complete recovery alone has risen. Notwithstanding the fact that some people killed as a
consequence of the illness, the majority of people recovered, and unlike many other countries,
the majority of people lived. With adequate measures and the assistance of the health industry,
United Kingdom is probably prepared to manage any future surges (Bolino, Long and Turnley,
2016).
The economy of the country was likewise greatly affected. However, based on the
statistics we have, the unemployment rate is unquestionably just beneath the desired threshold.
At the beginning of the calendar year, the regularity of requests for unemployment benefits was
far lower than 1500, but by the end of 2020, it had both met and exceeded that mark. In my
opinion, it is previous years for the United Kingdom to start offering electronic scientific
education to unemployed people in an effort to involve them. It could help with the country's
current problems brought on by COVID-19 and give information about their future.

In contemporary years, the socialization procedure in United Kingdom has changed along
with the macroeconomic climate. The process of making new friends and trying to understand
people online has become significantly more successful over period. Sites for socializing internet
are now extremely widespread. The United Kingdom is no exception; 60 percentage of
individuals globally currently utilise internet communication sites.
Without a doubt, this is the best chance to effectively use social media sites in especially to
promote people's mental wellness (Chen, He and Paudel, 2018). From my personal viewpoint,
I've always been comfortable making friends online; however, this year, I made the decision to
go to performances while there were fewer Covid-19 events to help the entertainment sector as
well as meet more people that have similar preferences. This would have worked out perfectly
for me. In conclusion, a lot of issues had already changed during the past few months, especially
how various tasks are carried out and activities are attended. Because there appears to be a 24/7
food provider in addition to other supportive offerings, including specialized therapy, the
internet's assistance in United Kingdom has improved over the years. Although the
circumstances in United Kingdom altered throughout time, they were ultimately settled.
Task 2: Microsoft Excel Working
Stage 1

Stage 2

Stage 3

Stage 4

Exercise 1
Stage 1

Stage 2

Insert the Data Mentioned on the Question Paper

Merge the cells from A2 to J2. Apply the following changes to the title line:
 Change the horizontal and vertical text alignments as centre.
 Change the row height of row 2 to 30.
 Change the font, font size, font style and font colour as Ariel, 18, bold, Red.
Using range selection, select the cells from B3 to J3. Then, select the cells from A4 to A9. Now
change the font type, font size and font style of the selected cells as Times New Roman,
12, bold-italic.
Using the AutoSum feature, find and write the sum of cells from B4 to F4 into cell G4. Then,
copy it to G5, G6, G7, G8 and G9
Using the Average function find and write the average GDP for Canada in H4. Repeat the last
step for the rest of the countries.

Using the MIN and MAX formulas, find the minimum and the maximum GDP values for
Canada in I4 and J4 respectively. Do the same for the rest of the countries.
Add a comment to H4. Write the text “GDP Average over years” into the comment box.
Select the cells from B4 to F9. Change format of the selected cells to Currency with 2 decimal
places.
Change the column width of Column A and make sure that all the texts on this column can fit
into the cells.
Select the columns from B to J and apply AutoFit Selection for these columns.
Add a new row above the 3rd row (that is between rows 2 and 3).

Add outside and inside borders to your table. For the outside border choose a thicker line.
Select the title and change the cell colour to yellow.
Select the cells B4 to J4 and A5 to A10. Change the cell colour to Light Blue.
Select the cells from G5 to J10. Change the cell colour to Light Green.

Create a bar chart to show the total GDP across countries. Write “Total GDP across countries” as
the Chart title, “Country” as the (X) axis, “Value” as the (Y) axis. Add labels to the bars.
Follow the instructions in the assessment brief on how to submit your task 2 i.e., take a
screenshot of your solution and include it in your report, then submit your excel file to the
correct submission link.

TASK 3 POWERPOINT

REFERENCES
Books and journals
Al-Qirim, N., Tarhini, A. and Rouibah, K., 2017, August. Determinants of big data adoption and
success. In Proceedings of the International Conference on Algorithms, Computing and
Systems (pp. 88-92).
Antignac, T., Scandariato, R. and Schneider, G., 2016, October. A privacy-aware conceptual
model for handling personal data. In International Symposium on Leveraging
Applications of Formal Methods (pp. 942-957). Springer, Cham.
Bartels, L., 2017. Swift, Certain and Fair-Does Project Hope Provide a Therapeutic Paradigm for
Managing Offenders?. Swift, Certain and Fair-Does Project Hope Provide a
Therapeutic Paradigm for Managing Offenders.
Bolino, M., Long, D. and Turnley, W., 2016. Impression management in organizations: Critical
questions, answers, and areas for future research. Annual Review of Organizational
Psychology and Organizational Behavior, 3, pp.377-406.
Chen, Y.H., He, Q. and Paudel, K.P., 2018. Quality competition and reputation of restaurants:
the effects of capacity constraints. Economic research-Ekonomska istraživanja. 31(1).
pp.102-118
Cong, C., Chen, X. and Yang, Q., 2016, November. An Innovative Training & Managing Model
for High School Practical Projects and Innovative Education. In 2016 3rd International
Conference on Management, Education Technology and Sports Science (METSS 2016).
Atlantis Press.
de Paula, N., Arditi, D. and Melhado, S., 2017. Managing sustainability efforts in building
design, construction, consulting, and facility management firms. Engineering,
Construction and Architectural Management.
Dębniewska, M., Skorwider-Namiotko, J. and Wojtowicz, K., 2018. Risk assessment of tourism
companies listed on the stock exchange based on their financial reporting. Ekonomia i
Środowisko.
Efendioğlu, D. and Bulkan, S., 2017. Capacity management in hotel industry for turkey.
In Handbook of Research on Holistic Optimization Techniques in the Hospitality,
Tourism, and Travel Industry (pp. 286-304). IGI Global.
Wiersema, M.F. and Bird, A., 2017. Organizational demography in Japanese firms: Group
heterogeneity, individual dissimilarity, and top management team turnover. Academy of
management Journal.