2. Create an excel sheet of the reported COVID 19 cases in Pakistan in any
of
the five days (by observing /reading the news on COVID 19). Show the statistics of
COVID province wise on day-to-day basis for minimum five days (Hint(s): create a
table, use the appropriate formulas e.g., SUM, AVERAGE and then plot a line/bar
chart).
a)
b)
c)
Cases: Punjab, Sindh, KPK, ICT, Balochistan
Recovered: Punjab, Sindh, KPK, ICT, Balochistan
Deaths: Punjab, Sindh, KPK, ICT, Balochistan
Using IF statement formula, show which province has maximum number of total
reported cases, recovered cases and deaths.
Create a line/bar chart of the statistics province wise.
Take its print and submit it.
(8 marks
Answers
Explanation:
Biomass-fired power production in the UK increased last year, along with the fuel’s share in the nation’s electricity mix. This comes despite an overall drop in power prices and total grid demand, according to data from utility Drax and Imperial College London. Biomass power output rose by 8.3% in 2020, reaching 19.45TWh. This compares with 17.96TWh in the previous year. UK power prices rebounded in Q3 and Q4, after demand declined following the imposition of pandemic-related lockdowns.
Renewable energy supplied 50% of electricity used by Germany’s national grid during the coronavirus pandemic. Analysis by Berlin-based think tank Agora Energiewende says this enabled the country to achieve its 2020 climate targets. Carbon emissions from Germany stood at 772Mt in 2020, 82Mt lower than that of previous year. This is the equivalent of a 10% drop in emissions. The analysis says the country would have reduced its emissions by 38% if the Covid-19 pandemic had not occurred.
Four renewable power plants in Peru commenced commercial operations last year, despite the Covid-19 pandemic. The four plants include two wind farms, one hydroelectric plant and a biomass thermal plant. The total installed capacity of the four plants is 58MW, with a total construction investment of $98m.