Task 1 
A. Research and critically evaluate literature surrounding the problem of effectively 
assessing loan applications for credit worthiness (700 words approx) 
10 Excellent A perfect piece of work. 
8 Very good A very good piece of work that meets all specified criteria. 
6 Good Competently meets the criteria specified. 
5 Average Adequately meets the criteria as specified. 
3 Poor Did not sufficiently meet the criteria as specified. 
1 Very poor Clearly does not meet criteria to pass. 
0 Not Attempted No attempt made or irrelevant. 
B. Using RapidMiner conduct an exploratory analysis of creditdata.csv data set to 
identify and discuss with appropriate use of statistical tables and graphs what you 
consider to be top five key variables which contribute to determining whether a 
potential loan applicant is a good credit risk or a bad credit risk. (800 words approx) 
25 Excellent A perfect piece of work. 
20 Very good A very good piece of work that meets all specified criteria. 
15 Good Competently meets the criteria specified. 
13 Average Adequately meets the criteria as specified. 
10 Poor Did not sufficiently meet the criteria as specified. 
5 Very poor Clearly does not meet criteria to pass. 
0 Not Attempted No attempt made or irrelevant. 
c) Discuss how and why it is important that information governance and information quality be 
incorporated into the design of a data warehouse architecture (1000 words approx). 
15 Excellent A perfect piece of work. 
13 Very good A very good piece of work that meets all specified criteria. 
10 Good 
Competently meets the criteria specified. 
8 Average 
Adequately meets the criteria as specified. 
6 Poor Did not sufficiently meet the criteria as specified. 
4 Very poor 
Clearly does not meet criteria to pass. 
0 Not attempted No attempt made or irrelevant. 
Task 2 
A. Create a report and accompanying graph using Tableau 8.0 or a pivot table that lists by sub 
region, business segment and model for all mountain bikes sold for the years 2002, 2003 and 
2004 and comment on key trends and patterns in this report (125 words approx.) 
10 Excellent A perfect piece of work. 
8 Very good A very good piece of work that meets all specified criteria. 
6 Good Competently meets the criteria specified. 
5 Average Adequately meets the criteria as specified. 
3 Poor Did not sufficiently meet the criteria as specified. 
1 Very poor Clearly does not meet criteria to pass. 
0 Not Attempted No attempt made or irrelevant. 
B. Create a report and accompanying graph using Tableau 8.0 or a pivot table that lists by 
region, sub region, business segment, unit price and list price for all bicycle clothing for the years 
2002, 2003 and 2004 and comment on key trends and patterns in this report (125 words approx.) 
10 Excellent A perfect piece of work. 
8 Very good A very good piece of work that meets all specified criteria. 
6 Good Competently meets the criteria specified. 
5 Average Adequately meets the criteria as specified. 
3 Poor Did not sufficiently meet the criteria as specified. 
1 Very poor Clearly does not meet criteria to pass. 
0 Not Attempted No attempt made or irrelevant. 
C. Create a report and accompanying graph using Tableau 8.0 or a pivot table that lists by 
region, sub region, business segment and model for all the road bicycles in order of the total 
sales for years 2002, 2003 and 2004 and comment on key trends and patterns in this report 
(125 words approx.) 
10 Excellent A perfect piece of work. 
8 Very good A very good piece of work that meets all specified criteria. 
6 Good Competently meets the criteria specified. 
5 Average Adequately meets the criteria as specified. 
3 Poor Did not sufficiently meet the criteria as specified. 
1 Very poor Clearly does not meet criteria to pass. 
0 Not Attempted No attempt made or irrelevant. 
D. Create a report and accompanying graph using Tableau 8.0 or a pivot table that lists by 
category, model, order quality and colour for all bicycles for the years 2002, 2003 and 2004 and 
comment on key trends and patterns in this report (125 words approx). 
10 Excellent A perfect piece of work. 
8 Very good A very good piece of work that meets all specified criteria. 
6 Good Competently meets the criteria specified. 
5 Average Adequately meets the criteria as specified. 
3 Poor Did not sufficiently meet the criteria as specified. 
1 Very poor Clearly does not meet criteria to pass. 
0 Not Attempted No attempt made or irrelevant. 
Report presentation writing style and referencing 
Presentation use of formatting, spacing, paragraphs, tables and diagrams, 
introduction, conclusion, table of contents 
Writing style Use of English (Correct use of language and grammar. Also, is there 
evidence of spelling-checking and proofreading?) 
Referencing (appropriate level of referencing and correct referencing style) 
10 Excellent presentation, writing style and referencing 
9 Very good presentation , writing style and referencing 
7 Good presentation , writing style and referencing 
5 Average presentation, writing style and referencing 
3 Poor presentation, writing style and referencing 
1 Very poor presentation, writing style and referencing 
0 
Little or no attempt to make appropriate use of formatting, spacing, paragraphs, 
Tables and diagrams, to address writing style, grammar and spelling, to 
reference correctly using Harvard referencing style