BACHELORS DEGREEASSIGNMENT SPECIFICATION
BACHELORS DEGREEASSIGNMENT SPECIFICATION
Student name:
Student P number:
Programme: B.Sc. Computing Portfolio
Module: Data Warehousing for Business Intelligence Module Level (4, 5, 6): 6
Module code: M3X8636 Contribution to Overall
Module Assessment (%): 70
Lecturer: Dr.Nik Whitehead Internal Verifier: Dr Stephen Hole
Assignment Title: Data Warehousing Assignment No (x of x): 1 of 2
Hand Out Date: November 2013 Submission deadline:
Referencing: In the main body of your submission you must give credit to authors on whose research your work is based. Append to your submission a reference list that indicates the books, articles, etc. that you have read or quoted in order to complete this assignment (e.g. for books: surname of author and initials, year of publication,title of book, edition, publisher: place of publication).
Disclosure:
I declare that this assignment is all my own work and that I have acknowledged all materials used from the published or unpublished works of other people. All references have been duly cited.
Student’s Signature:
Assignments will not be accepted without a signature here
Date:
Turnitin: Lecturer totick to indicate if an electronic version of the assignment must be submitted to Turnitin. Note: the Turnitin version is the primary submission and acts as a receipt for the student. Both electronic and paper versions MUST be submitted by the same deadline. No marks will be released until both submissions are received. Late submission of either the electronic or paper version will result in a late penalty mark. Penalties for late submission: Up to one week late, maximum mark of 40%. Over one week late, Refer. Only Year Tutors and the Programme Director may grant an extension. YES ?
NO
Student P number:
Programme: B.Sc. Computing Portfolio
Module: Data Warehousing for Business Intelligence Module Level (4, 5, 6): 6
Module code: M3X8636 Contribution to Overall
Module Assessment (%): 70
Lecturer: Dr.Nik Whitehead Internal Verifier: Dr Stephen Hole
Assignment Title: Data Warehousing Assignment No (x of x): 1 of 2
Hand Out Date: November 2013 Submission deadline:
Referencing: In the main body of your submission you must give credit to authors on whose research your work is based. Append to your submission a reference list that indicates the books, articles, etc. that you have read or quoted in order to complete this assignment (e.g. for books: surname of author and initials, year of publication,title of book, edition, publisher: place of publication).
Disclosure:
I declare that this assignment is all my own work and that I have acknowledged all materials used from the published or unpublished works of other people. All references have been duly cited.
Student’s Signature:
Assignments will not be accepted without a signature here
Date:
Turnitin: Lecturer totick to indicate if an electronic version of the assignment must be submitted to Turnitin. Note: the Turnitin version is the primary submission and acts as a receipt for the student. Both electronic and paper versions MUST be submitted by the same deadline. No marks will be released until both submissions are received. Late submission of either the electronic or paper version will result in a late penalty mark. Penalties for late submission: Up to one week late, maximum mark of 40%. Over one week late, Refer. Only Year Tutors and the Programme Director may grant an extension. YES ?
NO
Learning Outcomes tested
(from module syllabus) Assessment CriteriaTo achieve each outcome a student must demonstrate the ability to:
1. Display a detailed knowledge and systematic understanding of the current trends in data warehousing, business intelligence and data mining. • Write a report to evaluate the changes that have taken place since the beginning of data warehousing as a tool to generate competitive advantage via business intelligence.
2. Show a systematic understanding and knowledge of conceptual modelling for data warehouse applications, business intelligence and data mining techniques. • Design a small scale data warehouse for a given problem domain through the use of conceptual modelling techniques.
3. Demonstrate a comprehensive knowledge and systematic understanding of essential concepts, principles and tools to build, test and debug a data warehousing and data mining application that provide business intelligence to its users. • Produce a small scale prototype Data Warehouse to solve a case study based problem.
(from module syllabus) Assessment CriteriaTo achieve each outcome a student must demonstrate the ability to:
1. Display a detailed knowledge and systematic understanding of the current trends in data warehousing, business intelligence and data mining. • Write a report to evaluate the changes that have taken place since the beginning of data warehousing as a tool to generate competitive advantage via business intelligence.
2. Show a systematic understanding and knowledge of conceptual modelling for data warehouse applications, business intelligence and data mining techniques. • Design a small scale data warehouse for a given problem domain through the use of conceptual modelling techniques.
3. Demonstrate a comprehensive knowledge and systematic understanding of essential concepts, principles and tools to build, test and debug a data warehousing and data mining application that provide business intelligence to its users. • Produce a small scale prototype Data Warehouse to solve a case study based problem.
• Please submit the assignment parts in a suitable report folder– not in polypockets.
• This form (ALL PAGES) MUST be at the front of the paper submission. Assignments will not be accepted without this form as it is a requirement that you sign the disclosure regarding referencing convention.
• DO NOT put this form into Turnitin or it will match many similarities with other students’ submissions.
TASK DESCRIPTION
Report
Write a 2000-word report that describes a suitable methodology from the literature for the purpose of designing, constructing and testing of a commercial BIDW for a multinational company. You should evaluate the changes that have taken place since the beginning of data warehousing and show how these changes have affected the hardware and software that would be used for such a project over the last 40 years.
• This form (ALL PAGES) MUST be at the front of the paper submission. Assignments will not be accepted without this form as it is a requirement that you sign the disclosure regarding referencing convention.
• DO NOT put this form into Turnitin or it will match many similarities with other students’ submissions.
TASK DESCRIPTION
Report
Write a 2000-word report that describes a suitable methodology from the literature for the purpose of designing, constructing and testing of a commercial BIDW for a multinational company. You should evaluate the changes that have taken place since the beginning of data warehousing and show how these changes have affected the hardware and software that would be used for such a project over the last 40 years.
Data warehouse methodologies
1-Top down
2- bottom up
3- Read about Inmon and Kimball, what are they good at .
4 -hardware and software.
5- Future ideas ?
1-Top down
2- bottom up
3- Read about Inmon and Kimball, what are they good at .
4 -hardware and software.
5- Future ideas ?
*Top down:
1-Inmon 2-history 3design data marts .-combine to create DW .- work out what data is needed from source systems. 4-examples. 5 -where to use it?
1-Inmon 2-history 3design data marts .-combine to create DW .- work out what data is needed from source systems. 4-examples. 5 -where to use it?
*Bottom up:
1-history 2-Kimball 3-examine some data.-create logical DW Schema -create DM From DW.
4-Examples .5-Where to use it ?
1-history 2-Kimball 3-examine some data.-create logical DW Schema -create DM From DW.
4-Examples .5-Where to use it ?
GUIDANCEFOR STUDENTS IN THE COMPLETION OF TASKS
Informative use of the literature to chart the historical changes in the field of data warehousing.
? Descriptions of the two data warehousing methodologies in terms of:
o Technologies
? Tools
o Data
? Collection
? Transformation
o Business Intelligence
? Application types
? Originality
? Report Writing
o What are the historical changes with respect to Business Intelligence Data Warehousing in terms of methodologies?
o Format the document correctly
o Include a bibliography
o Reference the bibliographyClick here for more on this paper.......
? Descriptions of the two data warehousing methodologies in terms of:
o Technologies
? Tools
o Data
? Collection
? Transformation
o Business Intelligence
? Application types
? Originality
? Report Writing
o What are the historical changes with respect to Business Intelligence Data Warehousing in terms of methodologies?
o Format the document correctly
o Include a bibliography
o Reference the bibliographyClick here for more on this paper.......
MARKING CRITERIA AND STUDENT FEEDBACK
This section details the assessment criteria. The extent to which these are demonstrated by you determines your mark. The marks available for each criterion are shown. Lecturers will use the space provided to comment on the achievement of the task(s), including those areas in which you have performed well and areas that would benefit from development/improvement.
This section details the assessment criteria. The extent to which these are demonstrated by you determines your mark. The marks available for each criterion are shown. Lecturers will use the space provided to comment on the achievement of the task(s), including those areas in which you have performed well and areas that would benefit from development/improvement.
PART 1 – Essay on Data Warehouse Design Methodologies
Common Assessment Criteria Applied Marks available Marks
awarded
1. Research-informed Literature
Extent of research and/or own reading, selection of credible sources, application of appropriate referencing conventions.
Common Assessment Criteria Applied Marks available Marks
awarded
1. Research-informed Literature
Extent of research and/or own reading, selection of credible sources, application of appropriate referencing conventions.
60
2. Knowledge and Understanding of Subject
Extent of knowledge and understanding of concepts and underlying principles associated with the discipline.
10
3. Analysis
Analysis, evaluation and synthesis; logic, argument and judgement; analytical reflection; organisation of ideas and evidence
10
4. Practical Application and Deployment
Deployment of methods, materials, tools and techniques; application of concepts; formulation of innovative and creative solutions to solve problems.
0
5. Skills for Professional Practice
Attributes in professional practice: individual and collaborative working; deployment of appropriate media; presentation and organisation.
20
Assignment Mark (Assessment marks are subject to ratification at the Exam Board. These comments and marks are to give feedback on module work and are for guidance only until they are confirmed. ) Late Submission Penalties (tick if appropriate) %
Up to one-week late
Over one week late
Up to one-week late
Over one week late
PART 2 – Data Warehouse Case Study
Common Assessment Criteria Applied Marks available Marks
awarded
1. Research-informed Literature
Extent of research and/or own reading, selection of credible sources, application of appropriate referencing conventions.
Common Assessment Criteria Applied Marks available Marks
awarded
1. Research-informed Literature
Extent of research and/or own reading, selection of credible sources, application of appropriate referencing conventions.
0
2. Knowledge and Understanding of Subject
Extent of knowledge and understanding of concepts and underlying principles associated with the discipline.
0
3. Analysis
Analysis, evaluation and synthesis; logic, argument and judgement; analytical reflection; organisation of ideas and evidence
40
4. Practical Application and Deployment
Deployment of methods, materials, tools and techniques; application of concepts; formulation of innovative and creative solutions to solve problems.
50
5. Skills for Professional Practice
Attributes in professional practice: individual and collaborative working; deployment of appropriate media; presentation and organisation.Click here for more on this paper.......
No comments:
Post a Comment