MIS Lab Exercises_Test.pdf - MANAGEMENT INFORMATION...

This preview shows page 1 - 3 out of 6 pages.

MANAGEMENT INFORMATION SYSTEMS (BADB1023) OCTOBER 2018 Lab Exercises and Test Information systems that improve decision making LEARNING ABOUT MICROSOFT EXCEL WHAT DO WE COVER? Microsoft Excel is a spreadsheet developed by Microsoft for Windows , macOS , Android a nd iOS . It features calculation, graphing tools, pivot tables , and macro programming language called Visual Basic for Applications . It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office . Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager ). It has a programming aspect, Visual Basic for Applications , allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics, and then reporting the results back to the spreadsheet. It also has a variety of interactive features allowing user interfaces that can completely hide the spreadsheet from the user, so the spreadsheet presents itself as a so- called application , or decision support system (DSS), via a custom-designed user interface, for example, a stock analyzer, or in general, as a design tool that asks the user questions and provides answers and reports. In a more elaborate realization, an Excel application can automatically poll external databases and measuring instruments using an update schedule, analyze the results, make a Word report or PowerPoint slide show, and e-mail these presentations on a regular basis to a list of participants. What-if Analysis Learn about Scenario Managers under the What-If Analysis tool that covers the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. Page 2 Pivot Table Learn about PivotTable, which is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data. Add some tips about PivotChart to compliment the PivotTable. Page 4 Using MS Excel as a decision-making tool by Misyer Mohamed Tajudin
MIS | LAB EXERCISES AND TEST 2 In this section, you will learn to use a feature called What- If Analysis under Excel’s Scenario Manager. The scenario that will be used concern the required grades you need this semester for each subject registered in order to achieve a desired level of GPA/CGPA. Basically, you are going to find out what grade you need for MIS (and other

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture