Discussion Post and journal entries

Discussion Post: Forecasting Models: Strengths and Caveats Forecasting models have their strengths, but also their caveats. Present an example in which a forecasting model could be used, what method you would choose and why? What are the particular strengths of the model and what would it be used for? What should we be skeptical or … Read more

M6 P6

The goal of this project is to explore the topic of the Personal Auto Policy (PAP). The project requires you to work in Excel with the provided spreadsheet. Be sure to fill in the yellow boxes in the Excel file for full credit and show all work by referencing cells where necessary (do not simply … Read more

Take Home: Excel Chapter 4 Grader Project

StepInstructionsPoint Value1Start Excel. Download and open the file named Exp19_Excel_Ch04_Cap_AutoSales.xlsx. Grader has automatically added your last name to the beginning of the filename. 02Freeze the first row on the Fleet Information worksheet.53Convert the data to a table, name the table Inventory, and apply the Gold, Table Style Medium 19.104Remove duplicate records.35Sort the table by Make … Read more

Take Home: Excel Chapter 2 Grader Project

StepInstructionsPoint Value1Start Excel. Download and open the file named Exp19_Excel_Ch02_Cap_InlandJewelers.xlsx. Grader has automatically added your last name to the beginning of the filename.02Insert a function in cell B2 to display the current date from your system.103With cell B2 selected, set the width of column B to AutoFit.04Insert a VLOOKUP function in cell C5 to display the … Read more

business software

  Word 2019 In Practice – Ch 1 Independent Project 1-4 Word 2019 In Practice – Ch 4 Independent Project 4-4  Word 2019 In Practice – Ch 3 Independent Project 3-5  Excel 2019 In Practice – Ch 1 Independent Project 1-4  Excel 2019 In Practice – Ch 2 Independent Project 2-4  Access 2019 In Practice … Read more

Statistics

  Problem 1 (35 % marks) File: MALL. XLS A national chain of women’s clothing stores with locations in the large shopping malls thinks that it can do a better job of planning more renovations and expansions if it understands what variables impact sales. It plans a small pilot study on stores in 25 different … Read more

Case Study Presentations and Discussions

Use this discussion forum to submit your case study and review others students’ submissions.  Please submit your Executive Summary (Abstract) and your Conclusions from your project. Review a minimum of one other case study report and provide comments / feedback to your classmate(s).

MS Access

In MS Access I have a database of 5000 companies. I need you to create a GUI to make queries.  Query the database to retrieve the following information:    Companies with the same type of      business Companies in the same region (use post      codes for this query) Companies with similar names (report their      company numbers … Read more