Excel Projects for MIS 213

Videos to help you - Excel Projects


Tutorial on Excel

  • If you do not have Basic Excel Experience, it is recommended you complete the "Getting Started in Excel 365". It is free tutorial from UNCW
    • Go to mySeaport
    • Click on the Percipio Courses in the left column
    • Search for the 'Getting Started in Excel 365'

Project 5 - Excel Refresher

  • Complete steps 1-30 of the Excel-Refresher.- Download Project 5 PDF
  • This is found on pages D-1 to D-12. Your spreadsheet will be submitted through Entropy.
  • You will not need to use Horizon for any of the EXCEL projects. MAC users can download a full version of Excel, go to Office.com, and enter your UNCW email when prompted.
  • You should start from a new (blank) Excel Spreadsheet. Do not download anything from Entropy for this project.
  • Upload your completed Excel (.xlsx) file to Entropy for Project 5: Excel Refresher.

Project 6 - Decision Support Mini Exercises

  • Complete all steps described in the Project 6 PDF - Download Project 6 PDF
  • To start this assignment, download the template file from Entropy
    (go to Entropy and click the Upload/Download Link and then download the starting template)     .
  • You will not need to use Horizon for any of the EXCEL projects. MAC users can download a full version of Excel, go to Office.com, and enter your UNCW email when prompted.
  • Upload your completed Excel (.xlsx) file to Entropy for Project 6: Mini Exercises

Project 7 - Excel Scenario  - Cell Phone Plans

  • Complete steps 1 to 52 of the Scenario Manager Tutorial: Cell phone plans. - Download Project 7 PDF
  • This is found on pages F-1 to F-21, do not do step F.5 on Page F21
  • To start this assignment, download the template file from Entropy
    (go to Entropy and click the Upload/Download Link and then download the starting template)     .
  • Upload your completed Excel (.xlsx) file to Entropy for Project 7 Scenario Manager Tutorial.

Project 8 - Solver - ILM Wood Products

  • Complete Steps 1-37, Solver Tutorial: Wilmington Wood Products EXCLUDING the How To Interpret the Results section. Download Project 8 PDF
  • The part you should complete is found on pages H-1 to H-17.
  • To start this assignment, download the template file from Entropy
    (go to Entropy and click the Upload/Download Link and then download the starting template)     .
  • Upload your completed Excel (.xlsx) file to Entropy for Project 8: Solver Tutorial.