CAIS 201-12–Introduction to CAIS How is data different from information? How is information different from knowledge?

CAIS 201-12–Introduction to CAIS

Assignment #1

All assignments must be typed in MSWord and Exceland must be submitted via Canvas.

Please see the instructions posted in Canvas for online assignment submission

 

Answer the following questions with your own words

 

  1. How is data different from information? How is information different from knowledge? (10 pts)

 

  1. What is an information system? What is the role of feedback in a system? (10 pts)

 

  1. Why are information systems so essential for running and managing a business today? (10 pts)

 

  1. What are the basic modules of an ERP? Pick two different ERP systems in the market and compare the modules. (15 pts)

 

  1. Suppose that you are the manager of a computer parts warehouse. Create a simple inventory dashboard using annual inventory data given in the following table. Use the instructions given under the inventory table to create the dashboard.

 

INVENTORY
PRODUCT JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
SKU1 472 2,447 2,465 2,350 1,628 965 292 259 2,333 784 1,847 2,482
SKU2 191 320 931 458 628 555 229 150 453 577 201 452
SKU3 2,220 1,800 999 2,150 1,952 2,722 1,281 1,639 2,139 1,801 1,118 2,604
SKU4 394 586 606 994 390 426 531 230 331 883 84 347
SKU5 2,347 466 2,323 2,559 2,822 836 2,545 504 2,396 1,064 2,295 2,006
SKU6 2,014 1,869 2,035 2,344 1,818 1,601 2,663 1,750 944 2,097 2,755 2,687
SKU7 2,741 1,490 2,607 1,077 357 2,254 620 1,308 1,946 194 318 319
SKU8 821 2,040 447 1,002 1,153 1,457 157 379 384 703 250 675

 

  1. Calculate the Min and Max quantities of each SKU (10 pts)

 

  1. Calculate the average quantity and standard deviation of each SKU (10 pts)

 

  1. Draw a Pie Chart to display annual stock breakdown (percentages) (15 pts)

 

  1. Draw a Bar Chart to display monthly total stock in the warehouse (10 pts)

 

  1. Create a Line Graph to display the monthly trends of each SKU (10 pts)

 

Please follow and like us:
error