Canadian Sales Data Reduced Assignment
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
IDS 200
Summer 2019
Assignment 2
Due Friday 7/5/2019
60 points
Instructions
Deadline
In order to receive full credit, this assignment must be submitted by Friday, July 5th at 11:59pm. Submitting your assignment early is recommended. Late submissions will be accepted (but penalized 15pts) up to one week after the submission deadline. After that, assignments will not be accepted.
Assignment
Using the file CanadianSalesDataReduced.accdb, complete the following:
1) Reports:
- Show all fields of all records, grouped by province and then by region.
- For all product categories, show the sum of sales, grouped by region. You can include the sums using the “Summary Options” button in the third Report Wizard window, where you select ascending or descending order.
2) Queries:
Canadian Sales Data Reduced Assignment
- For all records with a 2010 order date, show the average shipping cost for each product category.
- For each province, show the sum of sales for each ship mode.
- Show all fields of any records with sales at least $1000 and the order priority is high.
- Show all fields of any records with sales at least $1000 or the order priority is high.
- Show the sales and profit (only) of any records from the month of November (any year) from the Quebec region and province.
- For each province, show the sum of sales from the months of October, November, and December. The sum should be for the entire three-month range. Each province and year should have a separate sum value shown.
- Show all fields of any records with a critical order priority if the product category is office supplies or technology.
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow Canadian Sales Data Reduced Assignment