Basic Statistics and ICT skills - Desklib

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