omework $2$

CPS $1110-01$ Computer Literacy

Due: $09/05/2024$

$[100$ points$]$

Note: You have to turn in your homework in D$2$L$.$ Late submission will not be

accepted. If you need excuses on medical grounds or official on duty work, talk

to the class teacher. Makeups will be given on above mentioned grounds with

appropriate excuse letter, and makeup homework should be submitted within two

weeks from the actual due date.

$1.$ Prepare a line and bar chart in MS Word for the data given in the following table. The

data represent the monthly sales $($in millions$)$ of various super markets located in Ohio

State. $(40$ points$)$

Walmart Meijer Kroger Aldi Target Kohl$$s Lowe$$s Sam$$s Club

month$123\mathrm{.}6346\mathrm{.}6148\mathrm{.}564\mathrm{.}5934\mathrm{.}4155\mathrm{.}2363\mathrm{.}2143\mathrm{.}25$

month$247\mathrm{.}0326\mathrm{.}9965\mathrm{.}3936\mathrm{.}4220\mathrm{.}2918\mathrm{.}6115\mathrm{.}4752\mathrm{.}11$

month$387\mathrm{.}3188\mathrm{.}4316\mathrm{.}6152\mathrm{.}3439\mathrm{.}0435\mathrm{.}4466\mathrm{.}1641\mathrm{.}62$

month$426\mathrm{.}3748\mathrm{.}9513\mathrm{.}3960\mathrm{.}3637\mathrm{.}3886\mathrm{.}6687\mathrm{.}7666\mathrm{.}09$

month$536\mathrm{.}6638\mathrm{.}1544\mathrm{.}4733\mathrm{.}9710\mathrm{.}8450\mathrm{.}218\mathrm{.}8662\mathrm{.}89$

month$653\mathrm{.}1656\mathrm{.}2361\mathrm{.}3568\mathrm{.}9795\mathrm{.}924\mathrm{.}5554\mathrm{.}5935\mathrm{.}68$

$2.$ Prepare Pie charts for the following:

a$)$ Prepare a Pie chart for the data representing Kroger company monthly sales.

$(15$ points$)$

b$)$ Prepare a Pie chart for the data representing month$4$ sales of various

companies. $(15$ points$)$

For questions $1$ and $2,$ to get full credit, you need to prepare charts with axes title, chart

title, legends and data table within the chart.

$3.$ Prepare your weekly school schedule. The table must have at least $5$ rows and $7$ columns.

Each cell must have a relevant text. For example, if you have no class during an hour,

you have to write the text in that cell as break. Fill solid blue color for the break $($free

time$)$ hours. Fill solid green color for math classes. $(30$ points$)$