Excel Report (20%, due Tues November 16th)
You need to watch this video tutorial to complete this assignment (https://youtu.be/YkoEAYLcFZQ). The purpose of this assignment is to help you become familiar with Excel as a tool for analysing and presenting quantitative data. You will produce charts and tables that can inform your recommendations for our client. You should use this as practice for your Final Report, where you will have more choice in how to analyze the data more fully to answer the research questions.
The report must be completed alone. DO NOT ALLOW OTHERS TO EDIT OR COMPLETE ANY PARTS OF YOUR WORK. DO NOT SHARE YOUR FILES WITH OTHER STUDENTS. This could result in grade penalties (up to a ZERO) and a disciplinary notice on your transcripts.
The report should include two sections:
- A brief Introduction that identifies client, knowledge gap, research purpose, and research questions.
o Then identify (i.e. name the answer, or type etc.), briefly explain (i.e. what does it mean?), and where appropriate critique (i.e. what is good and bad about it?) the following items relating to the data you are using. - Target population
- Sampling strategy(ies)
- Sampling frame(s)
- Sample size
- Sampling ratio
- Margin of error
- And Results, a series of tables, pie charts and bar charts (as explained below), each with two to five sentences interpreting the results.
Tables and charts should be presented using the formats explained here and in the video instructions.
You do not need a title page, or to reference literature or provide a reference list.
Use the following part of this document as a template (make sure you delete this introductory information before you submit).
Watch the video tutorial to fully understand expectations and requirements; failure to follow guidelines as outlined in this document and the video will result in lower grades.
Submit two documents to the Dropbox on D2L. - Report as a PDF file
- Excel file- this will not be graded, and does not need to presented in a very specific way, but does need to show where the information in your report came from. Failure to submit the Excel file will result in 5% being taken off your grade.
You need to have completed the Academic Integrity Quiz to have access to the dropbox, if you have not completed this quiz before the deadline and it causes your submission to be late you will receive a 20% penalty on the grade.
The TA will grade the paper with the rubric below:
Criteria Weight
Sampling Information: Clearly identified the following in introduction:
● Target population (5%)
● Sampling strategy(ies) (5%)
● Sampling frame(s) (5%)
● Sample size (5%)
● Sampling ratio (5%)
● Margin of error (5%) 30%
Results as directed (more info will be shared)
● Table comparing sample to target population (8%)
● Pie chart on awareness of Islands (5%)
● Table comparing TM vs. Oths on Info Sources (8%)
● Column Chart comparing TM vs. Oths on Info Sources (8%)
● Table comparing TM vs. Oths on Faculty (8%) 30%
T-Tests and Chi-Square
● Appropriate and correct application within results (10%)
● Appropriate interpretation within text (15%) 25%
Overall professional presentation of tables, graphs and charts
● APA format is consistently used 5%
Quality of interpretation and insight
● Between 2-5 sentences for each table/graph
● Must summarize key points that reader should see from table/graph
● Professional language and tone 10%
Failure to submit Excel file with workings results in -5% penalty
TOTAL 100%
• Here is the link to the data- https://docs.google.com/spreadsheets/d/1yCX8s-EWuJ6U6aBvyzEt0klU892VGcy2A3pdh31RbJA/edit?usp=sharing
• Here is the link to the survey – https://drive.google.com/file/d/1dvxipRYUPSBc2p7LvXORX9_SX_Q0c46r/view?usp=sharing
• Here are instructions for accessing the Data Analysis Pack in Excel for Windows and Mac https://support.microsoft.com/en-us/office/load-the-analysis-toolpak-in-excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4#OfficeVersion=Windows
Understanding Opportunities to Attract Ryerson Students to the Toronto Islands
Introduction
The purpose of this study is to…
Results
Sample Compared with Target Population
…
Table 1: Sample compared with Target Population
TABLE GOES HERE
Awareness of Toronto Islands
…
PIE CHART GOES HERE
Figure 1: Awareness of Toronto Islands
Target Market
Identifying a Target Market is useful because… For this report Target Market has been operationalised as those who answered….
Use of Information Sources
…
Table 2: Information Sources for Free Time Activities
TABLE GOES HERE
COLUMN CHART GOES HERE
Figure 2: Information Sources for Free Time Activities. Rate….
Faculty
…
Table 3: Faculty of Study
TABLE GOES HERE
Sample Solution
