SUSTAIN 2S03 Lecture Notes - Lecture 2: Permafrost, Smog, Sulfur
Document Summary
Get access
Related Documents
Related Questions
Take your time and pay attention to the "differences" between the scales. You need to pay close attention to the scale for each item. Do not look at the numbers in the charts, but the categories.
Be sure to review the Levels of Measurement information in this weekâs reading.
Example:
What is the level of measurement for license plates:
California 2346
Iowa 3yt904
Virginia 8934 grt
Georgia 45OK825?
The category is license plates, the numbers have no meaning other than identification, so the answer is Nominal.
Assignment Directions: Answer the following questions concerning different "scales" or "levels of measurement."
NOTE: The best information about this assignment is in this weekâs readings.
1) A Speedball field is 36,400 square feet, this represent which "scale" or "level of measurement?" Category (dimension/square feet).
2) Look at the chart below and identify the "scale" or "level of measurement" it represents. Category (Once per year: Once per month; Once per week; Never).
Activity | Number in your household who participated or watched the following activities at least: | |||
Once per year | Once per month | Once per week | Never | |
Aerobics | 6 | 3 | 8 | 43 |
Archery | 2 | 3 | 1 | 59 |
Arts and crafts | 9 | 20 | 12 | 27 |
Baseball | 8 | 22 | 21 | 27 |
Basketball | 4 | 15 | 22 | 34 |
Bicycling BMX | 6 | 2 | 5 | 46 |
Bicycling mountain/road | 6 | 14 | 19 | 41 |
Bird watching | 10 | 2 | 14 | 43 |
Boating | 16 | 17 | 18 | 29 |
3) According to the information below, identify the "scale" or "level of measurement" it represents. Category (Blonde; Brunette; and Redhead).
Hair color | Swimming | Mtn. Biking |
Blonde | 32 | 14 |
Brunette | 4 | 54 |
Red Head | 29 | 39 |
4) According to the information below, identify the "scale" or "level of measurement" it represents. Category (Never true; Seldom true; Somewhat true; Often true; and Always true).
(1) Never true | (2) Seldom True | (3) Somewhat True | (4) Often true | (5) Always True |
5) According to the information below, identify the "scale" or "level of measurement" it represents. Category (City; or County).
Do you live in the County or City? ____ County ____ City
Week One: Hands-on MIS Application Software ExerciseSolution
Store & Region Sales Database
This exercise helps students understand how a raw file of salestransactions can be analyzed to produce valuable information formanagers. Your challenge is to ask the right questionsabout the data and then present your case!
Import the data into Excel or Access (or compatiblespreadsheet/database). Use the data to perform the belowanalyses:
Analyze ALL THREE of the below items:
1.Best Performing Regions by TotalRevenue
2.Best Performing Stores by TotalRevenue
3.Best Selling Products by TotalRevenue
Select ONLY ONE of the below items:
A.Strongest Selling Period for eachProduct by Total Revenue
B.Strongest Selling Period for eachRegion by Total Revenue
C.Strongest Selling Period for eachStore by Total Revenue
Provide a business case â in the form of ONE descriptiveparagraph and ONE data table-- for eachanalysis. Each paragraph must refer to the informationpresented in the table using the labeled Table #. UseAPA format to label your tables.
SUBMITâ your final report with one WORDdocument and one EXCEL/ACCESS file.
Store & Region Sales Database | |||||||
ID | StoreNo | SalesRegion | ItemNo | ItemDescription | UnitPrice | UnitsSold | WeekEnding |
1 | 1 | South | 2005 | 17"Monitor | $229.00 | 28 | 10/27/10 |
2 | 1 | South | 2005 | 17"Monitor | $229.00 | 30 | 11/24/10 |
3 | 1 | South | 2005 | 17"Monitor | $229.00 | 9 | 12/29/10 |
4 | 1 | South | 3006 | 101Keyboard | $19.95 | 30 | 10/27/10 |
5 | 1 | South | 3006 | 101Keyboard | $19.95 | 35 | 11/24/10 |
6 | 1 | South | 3006 | 101Keyboard | $19.95 | 39 | 12/29/10 |
7 | 1 | South | 6050 | PC Mouse | $8.95 | 28 | 10/27/10 |
8 | 1 | South | 6050 | PC Mouse | $8.95 | 3 | 11/24/10 |
9 | 1 | South | 6050 | PC Mouse | $8.95 | 38 | 12/29/10 |
10 | 1 | South | 8500 | DesktopCPU | $849.95 | 25 | 10/27/10 |
11 | 1 | South | 8500 | DesktopCPU | $849.95 | 27 | 11/24/10 |
12 | 1 | South | 8500 | DesktopCPU | $849.95 | 33 | 12/29/10 |
13 | 2 | South | 2005 | 17"Monitor | $229.00 | 8 | 10/27/10 |
14 | 2 | South | 2005 | 17"Monitor | $229.00 | 8 | 11/24/10 |
15 | 2 | South | 2005 | 17"Monitor | $229.00 | 10 | 12/29/10 |
16 | 2 | South | 3006 | 101Keyboard | $19.95 | 8 | 10/27/10 |
17 | 2 | South | 3006 | 101Keyboard | $19.95 | 8 | 11/24/10 |
18 | 2 | South | 3006 | 101Keyboard | $19.95 | 8 | 12/29/10 |
19 | 2 | South | 6050 | PC Mouse | $8.95 | 9 | 10/27/10 |
20 | 2 | South | 6050 | PC Mouse | $8.95 | 9 | 11/24/10 |
21 | 2 | South | 6050 | PC Mouse | $8.95 | 8 | 12/29/10 |
22 | 2 | South | 8500 | DesktopCPU | $849.95 | 18 | 10/27/10 |
23 | 2 | South | 8500 | DesktopCPU | $849.95 | 18 | 11/24/10 |
24 | 2 | South | 8500 | DesktopCPU | $849.95 | 20 | 12/29/10 |
25 | 3 | South | 2005 | 17"Monitor | $229.00 | 38 | 10/27/10 |
26 | 3 | South | 2005 | 17"Monitor | $229.00 | 30 | 11/24/10 |
27 | 3 | South | 2005 | 17"Monitor | $229.00 | 3 | 12/29/10 |
28 | 3 | South | 3006 | 101Keyboard | $19.95 | 30 | 10/27/10 |
29 | 3 | South | 3006 | 101Keyboard | $19.95 | 32 | 11/24/10 |
30 | 3 | South | 3006 | 101Keyboard | $19.95 | 33 | 12/29/10 |
31 | 3 | South | 6050 | PC Mouse | $8.95 | 25 | 10/27/10 |
32 | 3 | South | 6050 | PC Mouse | $8.95 | 5 | 11/24/10 |
33 | 3 | South | 6050 | PC Mouse | $8.95 | 26 | 12/29/10 |
34 | 3 | South | 8500 | DesktopCPU | $849.95 | 28 | 10/27/10 |
35 | 3 | South | 8500 | DesktopCPU | $849.95 | 27 | 11/24/10 |
36 | 3 | South | 8500 | DesktopCPU | $849.95 | 29 | 12/29/10 |
37 | 4 | North | 2005 | 17"Monitor | $229.00 | 18 | 10/27/10 |
38 | 4 | North | 2005 | 17"Monitor | $229.00 | 20 | 11/24/10 |
39 | 4 | North | 2005 | 17"Monitor | $229.00 | 4 | 12/29/10 |
40 | 4 | North | 3006 | 101Keyboard | $19.95 | 12 | 10/27/10 |
41 | 4 | North | 3006 | 101Keyboard | $19.95 | 24 | 11/24/10 |
42 | 4 | North | 3006 | 101Keyboard | $19.95 | 36 | 12/29/10 |
43 | 4 | North | 6050 | PC Mouse | $8.95 | 29 | 10/27/10 |
44 | 4 | North | 6050 | PC Mouse | $8.95 | 11 | 11/24/10 |
45 | 4 | North | 6050 | PC Mouse | $8.95 | 38 | 12/29/10 |
46 | 4 | North | 8500 | DesktopCPU | $849.95 | 21 | 10/27/10 |
47 | 4 | North | 8500 | DesktopCPU | $849.95 | 24 | 11/24/10 |
48 | 4 | North | 8500 | DesktopCPU | $849.95 | 30 | 12/29/10 |
49 | 5 | North | 2005 | 17"Monitor | $229.00 | 27 | 10/27/10 |
50 | 5 | North | 2005 | 17"Monitor | $229.00 | 25 | 11/24/10 |
51 | 5 | North | 2005 | 17"Monitor | $229.00 | 23 | 12/29/10 |
52 | 5 | North | 3006 | 101Keyboard | $19.95 | 80 | 10/27/10 |
53 | 5 | North | 3006 | 101Keyboard | $19.95 | 82 | 11/24/10 |
54 | 5 | North | 3006 | 101Keyboard | $19.95 | 75 | 12/29/10 |
55 | 5 | North | 6050 | PC Mouse | $8.95 | 65 | 10/27/10 |
56 | 5 | North | 6050 | PC Mouse | $8.95 | 24 | 11/24/10 |
57 | 5 | North | 6050 | PC Mouse | $8.95 | 55 | 12/29/10 |
58 | 5 | North | 8500 | DesktopCPU | $849.95 | 55 | 10/27/10 |
59 | 5 | North | 8500 | DesktopCPU | $849.95 | 57 | 11/24/10 |
60 | 5 | North | 8500 | DesktopCPU | $849.95 | 47 | 12/29/10 |
61 | 6 | East | 2005 | 17"Monitor | $229.00 | 24 | 10/27/10 |
62 | 6 | East | 2005 | 17"Monitor | $229.00 | 85 | 11/24/10 |
63 | 6 | East | 2005 | 17"Monitor | $229.00 | 56 | 12/29/10 |
64 | 6 | East | 3006 | 101Keyboard | $19.95 | 52 | 10/27/10 |
65 | 6 | East | 3006 | 101Keyboard | $19.95 | 58 | 11/24/10 |
66 | 6 | East | 3006 | 101Keyboard | $19.95 | 69 | 12/29/10 |
67 | 6 | East | 6050 | PC Mouse | $8.95 | 35 | 10/27/10 |
68 | 6 | East | 6050 | PC Mouse | $8.95 | 39 | 11/24/10 |
69 | 6 | East | 6050 | PC Mouse | $8.95 | 44 | 12/29/10 |
70 | 6 | East | 8500 | DesktopCPU | $849.95 | 78 | 10/27/10 |
71 | 6 | East | 8500 | DesktopCPU | $849.95 | 88 | 11/24/10 |
72 | 6 | East | 8500 | DesktopCPU | $849.95 | 99 | 12/29/10 |
73 | 7 | East | 2005 | 17"Monitor | $229.00 | 34 | 10/27/10 |
74 | 7 | East | 2005 | 17"Monitor | $229.00 | 36 | 11/24/10 |
75 | 7 | East | 2005 | 17"Monitor | $229.00 | 35 | 12/29/10 |
76 | 7 | East | 3006 | 101Keyboard | $19.95 | 49 | 10/27/10 |
77 | 7 | East | 3006 | 101Keyboard | $19.95 | 47 | 11/24/10 |
78 | 7 | East | 3006 | 101Keyboard | $19.95 | 48 | 12/29/10 |
79 | 7 | East | 6050 | PC Mouse | $8.95 | 45 | 10/27/10 |
80 | 7 | East | 6050 | PC Mouse | $8.95 | 42 | 11/24/10 |
81 | 7 | East | 6050 | PC Mouse | $8.95 | 45 | 12/29/10 |
82 | 7 | East | 8500 | DesktopCPU | $849.95 | 55 | 10/27/10 |
83 | 7 | East | 8500 | DesktopCPU | $849.95 | 57 | 11/24/10 |
84 | 7 | East | 8500 | DesktopCPU | $849.95 | 55 | 12/29/10 |
85 | 8 | East | 2005 | 17"Monitor | $229.00 | 18 | 10/27/10 |
86 | 8 | East | 2005 | 17"Monitor | $229.00 | 17 | 11/24/10 |
87 | 8 | East | 2005 | 17"Monitor | $229.00 | 23 | 12/29/10 |
88 | 8 | East | 3006 | 101Keyboard | $19.95 | 22 | 10/27/10 |
89 | 8 | East | 3006 | 101Keyboard | $19.95 | 18 | 11/24/10 |
90 | 8 | East | 3006 | 101Keyboard | $19.95 | 22 | 12/29/10 |
91 | 8 | East | 6050 | PC Mouse | $8.95 | 14 | 10/27/10 |
92 | 8 | East | 6050 | PC Mouse | $8.95 | 16 | 11/24/10 |
93 | 8 | East | 6050 | PC Mouse | $8.95 | 17 | 12/29/10 |
94 | 8 | East | 8500 | DesktopCPU | $849.95 | 32 | 10/27/10 |
95 | 8 | East | 8500 | DesktopCPU | $849.95 | 28 | 11/24/10 |
96 | 8 | East | 8500 | DesktopCPU | $849.95 | 30 | 12/29/10 |