Essay BIAM 500 All Weeks Labs DeVry
BIAM 500 All Weeks Labs DeVry
Week 1 Lab Rubric-500
| Criteria | Ratings | Pts |
|---|---|---|
| This criterion is linked to a Learning OutcomeStep 1 – Importing, Cleaning, and Converting DataSales data sheet contains data imported from the text file, professionally formatted, with added columns OrderTotal, FullName, and OrderCategory. Any spelling errors are corrected and duplicate records, or records with missing data, are removed. | 10.0 pts | |
| This criterion is linked to a Learning OutcomeStep 2 – Table AnalysisMountain-500 U.S. Orders and Touring-3000 Australia Orders sheets contain records filtered as indicated. Sales by Product Category and Sales by Country sheets contain appropriate subtotals and pie charts. | 15.0 pts | |
| This criterion is linked to a Learning OutcomeStep 3 – Pivot TablesSales Pivot by Product Country sheet contains a pivot table and pivot chart as described in instructions. A second pivot sheet contains a pivot table and pivot chart using different fields selected by the student. | 15.0 pts | |
| This criterion is linked to a Learning OutcomeStep 4 – /What If AnalysisMountain-200 What If sheet contains baseline model, two one-variable data tables, and two two-variable data tables. Scenario Summary sheet contains a scenario summary report as described in instructions. | 15.0 pts | |
| This criterion is linked to a Learning OutcomeStep 5 – Opinion PaperProvide at least two findings and recommendations. | 15.0 pts | |
| Total Points: 70.0 |
Week 2 Lab Rubric-500
| Criteria | Ratings | Pts |
|---|---|---|
| This criterion is linked to a Learning OutcomeStep 1: Creation of Formulas with ConstraintsTouring Bike Model Mix sheet has correct set up of problem with all parameter values, constraints, and formulas. | 15.0 pts | |
| This criterion is linked to a Learning OutcomeStep 2: Use Solver to find an optimal solution.Objectives, variables, constraints, and solution method are correctly set in the Solver dialog, and the correct optimal production quantities are shown on the Touring Bike Model Mix sheet. Answer, sensitivity, and limits reports for the solution were generated correctly. | 15.0 pts | |
| This criterion is linked to a Learning OutcomeStep 3: Perform Sensitivity AnalysisPerform sensitivity analysis showing how changing parameters by plus or minus 10% affects the solution. A scenario summary sheet was created showing how the optimal product mix is affected by changing the gross profit per unit of each model by plus or minus 10% compared to the original solution. | 15.0 pts | |
| This criterion is linked to a Learning OutcomeStep 4: Create Monte Carlo SimulationMonte Carlo simulation calculates and charts the average gross profit over 100 simulations for the specified range of production quantities. | 15.0 pts | |
| This criterion is linked to a Learning OutcomeStep 5: Opinion PaperWrite a one-page paper explaining your findings and making recommendations. Paper is in APA format, free of typographical, spelling, and grammar errors, and clearly states appropriate findings and recommendations from the analysis. | 10.0 pts | |
| Total Points: 70.0 |
Week 3 Lab Rubric-500
| Criteria | Ratings | Pts |
|---|---|---|
| This criterion is linked to a Learning OutcomeStep 1: Analysis of Simple Six-vertex NetworkProvide a NodeXL-based workbook that contains analysis of simple six-vertex network. Network vertices and edges entered correctly; directed network graph displayed with vertices labeled, color-coded by gender, and sized by in-degree. | 25.0 pts | |
| This criterion is linked to a Learning OutcomeStep 2: Capture and Analyze Twitter FeedProvide a NodeXL-based workbook that contains analysis of simple six-vertex network. Network vertices and edges entered correctly; directed network graph displayed with vertices labeled, color-coded by gender, and sized by in-degree. | 25.0 pts | |
| This criterion is linked to a Learning OutcomeStep 3: Opinion PaperWrite a one-page paper explaining your findings and making recommendations. Paper is in APA format, free of typographical, spelling, and grammar errors, and clearly states appropriate findings and recommendations from the analysis. Paper includes a list of 10 specific key influencers with the reason why each was chosen. | 20.0 pts | |
| Total Points: 70.0 |
Week 4 Lab Rubric-500
| Criteria | Ratings | Pts |
|---|---|---|
| This criterion is linked to a Learning OutcomeCreate Dashboard with Summary of Key MetricsSummary of key metrics with call numbers, trend lines, abandon rate with traffic light status indicator, and orders for all shifts and each shift individually | 10.0 pts | |
| This criterion is linked to a Learning OutcomeCreate Calls Handled by Auto Response ChartColumn chart for percent of calls handled by auto response, including target line and slicers for day type and date | 10.0 pts | |
| This criterion is linked to a Learning OutcomeCreate Additional KPI DisplaysAt least two additional KPIs of your choosing relevant to the strategic objective displayed on the dashboard with appropriate visual representations and clear descriptive labeling. | 20.0 pts | |
| This criterion is linked to a Learning OutcomeFinalize WorkbookDashboard is professionally formatted with data and calculation sheets hidden; gridlines, formula bar, and row/column headings not visible on the dashboard sheet; and professional use of colors, fonts, borders, and shapes. | 10.0 pts | |
| This criterion is linked to a Learning OutcomeWrite Opinion Paper and SubmitPaper is in APA format, free of typographical, spelling, and grammar errors, and clearly states appropriate findings and recommendations from the analysis. Findings and recommendations are relevant to the strategic objective and are supported by the dashboard. | 20.0 pts | |
| Total Points: 70.0 |
Week 5 Lab Rubric-500
| Criteria | Ratings | Pts |
|---|---|---|
| This criterion is linked to a Learning OutcomeStep 1: Create Simplified Star Schema in Student Data WarehouseScreenshot showing successful copying of the FactCurrencyRate, DimCurrency, and DimDate tables from the AdventureWorksDW data warehouse to the student data warehouse | 10.0 pts | |
| This criterion is linked to a Learning OutcomeStep 2: View Data from Related Tables in the Data WarehouseScreenshot showing data from the FactCurrencyRate, DimCurrency, and DimDate tables in the student data warehouse | 10.0 pts | |
| This criterion is linked to a Learning OutcomeStep 3: Create and Deploy a Data CubeScreenshot showing the measure and dimensions of the Internet Sales data cube, with a status message indicating successful deployment of the cube | 10.0 pts | |
| This criterion is linked to a Learning OutcomeStep 4: Browse the CubeScreenshot showing a pivot table and pivot chart generated by browsing the cube, with SalesTerritoryCountry as the columns, the Fiscal Year-Quarter-Month date hierarchy as the rows, and SalesAmount as the values | 10.0 pts | |
| This criterion is linked to a Learning OutcomeStep 4(d): Browse the Cube (d: on your own)Screenshots showing at least two additional pivot tables and corresponding pivot charts generated by browsing the cube, with different choices for the row and column dimensions | 20.0 pts | |
| This criterion is linked to a Learning OutcomeWrite Opinion Paper and SubmitPaper is in APA format, free of typographical, spelling, and grammar errors, and clearly states appropriate findings and recommendations from the analysis. | 10.0 pts | |
| Total Points: 70.0 |
Week 6 Lab Rubric-500
| Criteria | Ratings | Pts |
|---|---|---|
| This criterion is linked to a Learning OutcomeStep 1: Load and Prepare DataWorkbook contains worksheets for the OldCustomer and NewCustomer data sets. Age column was added to both sheets with formula to calculate customer age. CustomerClassification column was added to both sheets, with formula to determine customer classification on the OldCustomers sheet only. | 15.0 pts | |
| This criterion is linked to a Learning OutcomeStep 2: Define the Training/Testing and Prediction Data SetsA training and testing data set is defined based on the OldCustomer data, and a prediction data set is defined based on the NewCustomer data. Variable types are set appropriately for both data sets. | 15.0 pts | |
| This criterion is linked to a Learning OutcomeStep 3: Train and Test Neural NetworkNeural network is trained based on the training and testing data set, and tested using a randomly selected sample of 20% of the cases. Individual case test results are in the OldCustomers sheet, and summary results are in the Lab6_yourlastname_Summary workbook. | 15.0 pts | |
| This criterion is linked to a Learning OutcomeStep 4: Predict Classifications for New CustomersPredicted classifications generated by the neural network are recorded in the NewCustomers sheet. | 15.0 pts | |
| This criterion is linked to a Learning OutcomeStep 5: Write Opinion Paper and SubmitPaper is in APA format, free of typographical, spelling, and grammar errors, and clearly states appropriate findings and recommendations from the analysis. Findings and recommendations are relevant to the strategic objective and are supported by the dashboard. | 10.0 pts | |
| Total Points: 70.0 |
Stop Stressing. Your Academic Success is Guaranteed.
Domyassignment is your direct route to higher grades. Thousands of students trust our PhD-level experts to deliver 100% original, custom-written papers—from tough essays to massive dissertations.
Zero Plagiarism (Free Report)
On-Time Delivery
Free Unlimited Revisions
100% Confidential
Secure Your Paper Now
