Assignment Cover Sheet

Qualification Module Number and Title

Higher National Diploma in Computing & Business Analytics : Crime Analysis
Software Engineering
Student Name & No. Assessor
Chatura N. Warnasuriya
Hand out date Submission Date

Assessment type Duration/Length of Weighting of Assessment

Coursework Assessment Type
3 weeks 100 %

Learner declaration

I, ………………………………………….<name of the student and registration number>,

certify that the work submitted for this assignment is my own and research sources are fully
acknowledged.

Marks Awarded
First assessor

IV marks

Agreed grade

Signature of the assessor Date

1
 FEEDBACK FORM

INTERNATIONAL COLLEGE OF BUSINESS & TECHNOLOGY

Module:
Student:
Assessor:
Assignment:

Strong features of your work:

Areas for improvement:

Marks Awarded:

2
 Coursework

Learning outcomes covered

 Understand Business Analytics methodologies, tools and the techniques

 Evaluate business advantages produced by business analytics.
 Be able to perform a business analysis
 Be able to propose solution for a business problem or creating opportunity using
appropriate business analytics methodologies, tools and the techniques

Scenario and the Task

Introduction

The Business Analytics subject domain is considered to be one of the major area
where most of the companies and various profitable and non- profitable institutions consider for
achieving the best decision support in their respective various operations life cycles. Because of
the economy is moving rapidly to achieve tangible and intangible as well as financial and non-
financial targets all most all the government and private organizations required to consider X and
precision and accuracy of their management decisions in all major three levels operational,
tactical and strategic. The amount of information generated in modern agile economic
environment is very high and nature of consistency also highly varies within short time frame.
Because of the fact that utilization of big data analysis considered as one of the prime concern to
deal with the data to produce credible and valuable information. During the process of
conversion data to decision supportive information it is very important use different data analysis
methods, techniques and tools that are comprehensively explained in data analytics. The high
importance of data analytics subject elements leads to include those in modern management
information systems and decision support information systems for enabling online analytical
processing to incorporate with connected operational databases, data marts and data warehouses.

In performing big data analysis, it is very important to use good statistical software. At present
there are many such products available under generic or bespoke software category considering
open source or closed source. Usually open source products are financially feasible for many
organizations compared to closed source products. At present big data analysis rapid growth
identifiable in open source category with frequent versions and many feature extensions
compared to closed source. On the other hand, side much reliable many software products have
been released by industry pioneer solution providers. Therefore, section of the best product for
data analysis is also need to be done wisely by relevant authorities of organizations for their
objectives to be precisely achieved.

3
 SCENARIO

The crime analysis considered to be one of the major subject area to be considered by law and
order enforcing and securing organizations in many parts of the world. The importance of crime
mitigation and eradication is directly supports worlds’ countries and states’ social, Technical and
economic development to boost at a rapid rate. Different governments use different level of
security analysis via many security organizations with the support of modern technologies.

The provided scenario based on United States’ National Uniform Crime Reporting (UCR)
program pioneered by Federal Bureau of Investigation (FBI). In complying with the program the
New York’s official crime statistics; the Division of Criminal Justice Service (DCJS) collects
crime reports from over 500 New York state police and sheriff’s departments and handover to
FBI. In New York state law enforcement agencies use UCR system to monthly report crime
totals to DCJS. The UCR reporting system collects information on seven crimes identified as
Index offenses which are most commonly used to gauge overall crime volume such as the
violent crimes of murder / non-negligent manslaughter, forcible rape, robbery, and aggravated
assault; and the property crimes of burglary, larceny, and motor vehicle theft. Firearm counts
are derived from taking the number of violent crime which involve a firearm.

Assume you are one of criminal big data analysts working for FBI who is assigned to submit a
report to the higher officials on “Crimes and associated crucial and hidden factors to find
credible measures on crime controlling, eradication and informed decision making”. Your report
should be prepared based on tasks below mentioned using the dataset provided.

The New York DCJS collected original dataset has been provided to you as a separate data file
labeled “Index__Violent.csv” which comprises of data collected from year 1990-2016-time
period.

4
Tasks
1. Provide an in detailed explanation about FBI expectation of the analysis and benefits
generated. (5Marks)

2. Explain tools, techniques and methodologies going to use for crime analysis purpose. (6Marks)

3. Find out minimum, maximum, mean, median, mode of violent incidents in Washington.
(6 Marks)
4. Find out summary statistics of firearm incidents in Washington
(6 Marks)
5. Graphically represent violent count, firearm count and property count in Washington using
statistical charts. (10 marks)
6. Conduct central tendency analysis for violent count, firearm count and property count and
find out standard deviation of those. Represent finding graphically using bell curves.
(12 Marks)

7. Using statistical hypothetical testing prove, whether there is a statistically identifiable

relationship exist with Violent count and Firearm count. (10 marks)
8. Using statistical hypothetical testing prove, whether there is a statistically identifiable
relationship exist with Violent count and Population. (10 marks)
9. Using statistical hypothetical testing prove, whether there is a statistically identifiable
relationship exist with Violent count and Property count. (10 Marks)
10. Write a conclusion of findings of the data analysis process based on above findings and suggest
necessary recommendations. (25 Marks)

 Proper report format carries 10 Marks.

 Question no 8,9 and 10 should be incorporated with mean analysis and variance analysis
apart from other important analysis.

 Note: The conclusion can include the findings of suitable regression analysis as well.

5
 Marking Scheme

Task-1 contains 5 marks

Marks
Criteria
Out of 5
Fail
Not Explained the scenario and not included the benefits provided
by the analysis for the selected company/institution. 0-1

Pass
Explained the scenario. 1-2

Good
Explained the benefits provided by the analysis for the selected
2-3
company/institution.

Excellent
Well explained the scenario and the benefits provided by the
3-5
analysis for the selected company/institution.

Task-2 contains 6 marks

Marks
Criteria
Out of 6
Fail
Not Stated tools, techniques and methodologies going to be used
for analysis 0-1

Pass
Stated tools, techniques and methodologies going to be used for 1-2
analysis
Good
Stated tools, techniques and methodologies going to be used for
analysis. Explained the mentioned tools, techniques and 2-4
methodologies

Excellent
Stated tools, techniques and methodologies going to be used for
analysis. Well explained the mentioned tools, techniques and 4-6
methodologies.

6
Task-3 contains 6 marks
Marks
Criteria
Out of 6
Fail
Not used minimum, maximum, mean, median, mode functions to
get respective statistics of provided data 0-2

Pass
Used minimum, maximum, mean, median, mode functions to get 2-4
respective statistics of provided data
Good
Used minimum, maximum, mean, median, mode functions to get
4-5
respective statistics of provided data and got an accurate set of
results and explained briefly about what obtained.
Excellent
Used minimum, maximum, mean, median, mode functions to get
5-6
respective statistics of provided data and got an accurate set of
results and well explained about what obtained.

Task-4 contains 6 marks

Marks
Criteria
Out of 6
Fail
Not included summery statistical data using summary statistical
function. 0

Pass
Included summery statistical data using summary statistical 6
function.

7
Task-5 contains 10 marks
Marks
Criteria
Out of 10
Fail
Not Included bar chart/pie chart/ to represent data provided
graphically. 0-1

Pass
Included bar chart/pie chart/ to represent data provided 1-5
graphically.
Good
Included bar chart/pie chart/ to represent data provided graphically
6-7
and included brief information about what is represented in the
charts.
Excellent
Included bar chart/pie chart/ to represent data provided graphically
8-10
and included well described information about what is represented
in the charts.

Task-6 contains 12 marks

Marks
Criteria
Out of 12
Fail
Not Included bell curves based on data provided
0-1

Pass
Included bell curves based on data provided 1-6

Good
Included bell curves based on data provided and
6-10
Described information represented in the charts briefly

Excellent
10-12
Included bell curves based on data provided and
Well described information represented in the charts briefly

8
Task-7 contains 10 marks
Marks
Criteria
Out of 10
Fail
Not Inclusion of hypothetical statement considering null
hypothesis and alternative hypothesis 0-1

Pass
Inclusion of hypothetical statement considering null hypothesis
1-5
and alternative hypothesis and statistical justification of result
based on correlation analysis test
Good
Inclusion of hypothetical statement considering null hypothesis
6-7
and alternative hypothesis and statistical justification of result
based on correlation analysis test supported by normality test
Excellent
Inclusion of hypothetical statement considering null hypothesis
and alternative hypothesis and statistical justification of result 7-10
based on correlation analysis test supported by normality test,
variance test and mean test.

Task-8 contains 10 marks

Marks
Criteria
Out of 10
Fail
Not Inclusion of hypothetical statement considering null
hypothesis and alternative hypothesis 0-1

Pass
Inclusion of hypothetical statement considering null hypothesis
1-5
and alternative hypothesis and statistical justification of result
based on correlation analysis test
Good
Inclusion of hypothetical statement considering null hypothesis
6-7
and alternative hypothesis and statistical justification of result
based on correlation analysis test supported by normality test
Excellent
Inclusion of hypothetical statement considering null hypothesis
and alternative hypothesis and statistical justification of result 7-10
based on correlation analysis test supported by normality test,
variance test and mean test.

9
Task-9 contains 10 marks
Marks
Criteria
Out of 10
Fail
Not Inclusion of hypothetical statement considering null
hypothesis and alternative hypothesis 0-1

Pass
Inclusion of hypothetical statement considering null hypothesis
1-5
and alternative hypothesis and statistical justification of result
based on correlation analysis test
Good
Inclusion of hypothetical statement considering null hypothesis
6-7
and alternative hypothesis and statistical justification of result
based on correlation analysis test supported by normality test
Excellent
Inclusion of hypothetical statement considering null hypothesis
and alternative hypothesis and statistical justification of result 7-10
based on correlation analysis test supported by normality test,
variance test and mean test.

Task-10 contains 25 marks

Marks
Criteria
Out of 25
Fail
Not Provided conclusion based on statistical findings done based
on hypothetical testing. 0-4

Pass
Provided conclusion based on statistical findings done based on 5-11
hypothetical testing.
Good
Provided conclusion based on statistical findings done based on
12-18
hypothetical testing. The conclusion should comprise of sub
conclusions of question no 07, 08 and 09.
Excellent
Provided conclusion based on statistical findings done based on
hypothetical testing. The conclusion should comprise of sub
conclusions of question no 07, 08 and 09. The student provided
19-25
recommendation to support improvements of the organization.
Applications of suitable regression analysis findings are highly
anticipated. Proper report format.

10
Submission Guidelines

Report Structure:
 Executive Summery
 Table of contents, Table of Figures, Table of Tables
 Introduction of the Organization & its operational environment /Scenario
 Data Analysis and Discussion
 Conclusion
 Future Recommendation
 Gantt chart & its Description
 Referencing
 Appendix (Appendix A, Appendix B, etc.) for Group meetings, Samples of Questionnaire

Report Format:

 Submission format Report

 Paper Size: A4
 Words: 4000 words
 Printing Margins: LHS; RHS: 1 Inch
 Binding Margin: ½ Inch
 Header and Footer: 1 Inch
 Basic Font Size: 12
 Line Spacing: 1.5
 Font Style: Times New Roman
 Referencing should be done strictly using Harvard system

11