Rubric for Online Discussion and discussion 1 answers
docx
keyboard_arrow_up
School
Purdue University *
*We aren’t endorsed by this school
Course
57000
Subject
Communications
Date
Feb 20, 2024
Type
docx
Pages
2
Uploaded by AdmiralWolverine1375
Question 1
(10 points)
No initial posting exists to evaluate. 0 Points
Your final answer is incorrect but the work shows one or more steps that are correct. 1-6 Points
The final answer is incorrect but most of the work is correct. 7 Points
The final answer is incorrect with only a minor calculation error, or the final answer is correct but the work needs more detail. 8 Points
The final answer is correct and the work is complete. 10 points
Question 2 (10 points)
No initial posting exists to evaluate. 0 Points
Your final answer is incorrect but the work shows one or more steps that are correct. 1-6 Points
The final answer is incorrect but most of the work is correct. 7 Points
The final answer is incorrect with only a minor calculation error, or the final answer is correct but the work needs more detail. 8 Points
The final answer is correct and the work is complete. 10 points
Participation in Discussion (10 points)
No responses to other classmates were posted in this discussion forum.
0 Points
May include one or more of the following: 1-5 Points
Comments to only one other student's post.
Comments are not substantive, such as just one line or saying, “Good job” or “I agree.
Comments are off topic.
Comments to two or more classmates’ initial posts but only on one day of the week. Comments are substantive, meaning they reflect and expand on what the other student wrote.
6-7 Points
Comments to two or more classmates’ initial posts on more than one day. Comments are substantive, meaning they reflect and expand on what the other student wrote.
8-9 Points.
Comments to two or more classmates’ initial posts and to the instructor's comment (if applicable) on two or more days. Responses demonstrate an analysis of peers’ comments,
building on previous posts. Comments extend and deepen meaningful conversation and may include a follow-up question.
10 Points
Chap4_Question 16:
Step 1: Under the “Products” tab click in the empty tab under “add column” and typed in the following “=Related(ProductCategories[ProductCategoryName])” and press enter. Step 2: Under the “Products” tab click in the empty tab under “add column” and typed in the following “=Related(ProductSubcategories[ProductSubcategoryName])” and press enter. Step 3: On the bottom right of the excel workbook click on the three little boxes labeled “diagram”. Step 4: On the top right corner of the “Products” box, click on the “Maximize” tab on the right and then click on the “Hierarchy” tab to the left of the “Maximize” tab. Step 5: Label hierarchy “Product Structure” and drag the following fields to the new hierarchy label in the following order: ProductSubCategory, then BrandName, then ProductCategory, and then ProductName.
Yes, Power Pivot does allow you to create a hierarchy in the products table, even if you drag the
fields in the wrong order. However, the hierarchy will not make logical sense because it does not follow the natural order of the product structure. For example, if you drag the fields in the order of product subcategory, brand name, product category, and then product name, the hierarchy will be confusing because the product category, which is a broader classification, comes after the product subcategory and brand name, which are more specific classifications. Thus, while Power Pivot allows this, it is not recommended to create a hierarchy in this way.
Chap14_Question19:
Step 1: Under the orders tab, click in the empty tab under “add column” and typed in the following “=If ([ShipDate]<[OrderDate], True, False)” and press enter. Column populated with “False”.
Step 2: Under the orders tab, clicked in the empty tab under “add column” and typed in the following “=If ([ShipDate]<[OrderDate], +3, True, False)” and press enter. Column populated with “False and True”.
Step 3: Clicked on the “Pivot Table”, selected “New worksheet”, and hit “ok”. Step 4: Under “orders” dragged “ShippedLate” to the Rows table and dragged “DataError” to the
Values table. Based on the data input into the Pivot Table the “True” value represents the number of orders that were shipped late. Out of the 944 orders, 191 or 20% were shipped late.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help