show your ability to use the tools

Project #1 – Student Copy

 

Project Instructions

Download and Use Data Set:  GBI Data (E1-1) for Year 2008

 

 

The Goal is to show your ability to use the tool and provide real, meaningful analysis of the data.

 

The Project assignment will provide you with an opportunity to reflect upon your hands-on learning experiences in the classroom utilizing analytics tools and techniques. Your professional portfolio will also act as evidence of your newly acquired skills that can be utilized to provide evidence.

 

Your Project will be evaluated based on the following criteria: completeness, organization, professionalism, and the quality of your analysis, charts and recommendations.

 

Project must contain the following elements:

  1. Answer to the following questions in complete sentences
  2. MS Word document, Title Page, Footers with Team members names, Student ID’s, Footer with page numbers (example page 1 of page 2)
  3. Chart Images (Screen shots) of Data and Charts, Data sorted High to Low by Revenue, Discount, Sales Quantity and Net Sales.
  4. Submit via the drop box

 

 

Instructions 1 Analysis & Recommendations: In 500 + words (single spaced), Submit via the drop box. Project can NOT be emailed to the instructor. The Project is timed and once the drop box closes, a “zero” grade will be assigned to the student with an absent submission.

Please review your drop box submission. A high Turnitin Similarity score suggests your work may lack originality and will be subject to enhanced plagiarism detection. If you have any doubt about your compliance with Conestoga’s academic integrity policy, please contact your course professor.

All papers must be submitted and scanned by Turnitin Similarity.

Instructions 2 Excel Software Charts: Answer the Data Set questions that are assigned to you. Each student TEAM is assigned 1 Data Set Letter A, B, C, D.  If you answer the incorrect assigned data set = 0 grade.

Data Sets A

Data Sets B

Data Sets C

Data Sets D

 

Instructions 3 Submitting to Dropbox: Submit Project 1 Analysis & Recommendations and Project 1 Excel Software Charts as (2) SEPARATE MS Word Files called: Project 1 Analysis & Recommendations, Project 1 Excel Software Charts.

 

 

 

 

 

 

Answer questions using:   GBI Data (E1-1) for Year 2008

 

 

The Project is timed and once the drop box closes, a “zero” grade will be assigned to the student with an absent submission.

All papers must be submitted and scanned by Turnitin Similarity.

Caution: identical charts (colors, format) is copied material!!!!!!

 

 

 

 

 

 

 

 

 

 

 

 

 

100 Points Total per Data Set, 1 assigned data set per team

 

Charts – 40 Points

10 points Data:                                    Sort data High to Low, include commas with numbers, no pennies

20 points Charts:                                 2D Column (Clustered, Stacked),

2D Bar (Clustered, Stacked),

2D Pie (Pie, Doughnut),

2D Line (Line, Area)

10 points Formatted:                          Charts with Multiple Colors,

Detailed Chart Titles,

Numbers with Commas

 

Each team project is required to have (8) different chart types in total (NOT 64 charts). The charts are

8 charts in total

 

Analysis + Recommendations – 60 Points

60 points Analysis + Recommendations: In 500 + words (single spaced) for TOTAL data set

(NO BULLET POINTS)

Format Example of Chart Data

Charts and Formatted (different colors, commas with #’s)

Analysis & Recommendation – In 500 + words (single spaced) for TOTAL data set (NO BULLET POINTS)

Data Set C:  Using GBI Data (E1-1), using Excel Calculate:  Sales Quantity by customer, product, currency, month, day, division, sales org, country

Year:                2008

Data:                Sort data High to Low, include commas with numbers, no pennies

 

Charts:             2D Column (Clustered, Stacked),

2D Bar (Clustered, Stacked),

2D Pie (Pie, Doughnut),

2D Line (Line, Area)

 

Formatted:      Charts with Multiple Colors,

Detailed Chart Titles,

Numbers with Commas

 

Analysis and Recommendations: In 500 + words (single spaced) for TOTAL data set (NO BULLET POINTS)