ICTDBS503
Create a Data Warehouse
ASSESSMENT TASK 1
Knowledge Questions
ICT50120 Diploma of Information Technology
ASSESSMENT TASK 1 COVER SHEET
Please ensure this form is fully completed prior to submitting.
This page MUST be on the front of your assessment and needs to be easily accessible, filled in and signed.
Student Number:
Student Name:
Subject:
ICTDBS503 Create a Data Warehouse
Course:
ICT50120 Diploma of Information Technology
STUDENT DECLARATION
I hereby certify that:
1. This assessment task is my own work based on my personal study
esearch and not the work of another student and/or source.
2. I have acknowledged all material and sources used to prepare this assessment task.
3. I have not plagiarised or copied any part of this assessment task from the work of any other student or source either. (I know the penalties for plagiarism include $200 re-assessment fee)
4. This assessment task has not previously been submitted.
5. I am aware of the requirements set by my Trainer & Assessor.
6. I have retained a copy of this assessment task for my own records.
7. I have completed all my assessments, tasks & activities (on Moodle®) successfully.
Student’s Signature: _______________________________ Date: _________________
Wentworth Institute RTO Code: XXXXXXXXXXNovember 2017 Version: 1.0
Student instructions
This Assessment is designed to test the knowledge that you have acquired throughout the unit so far. Use the following tips to help you answer the questions:
Read each question carefully. Check with your trainer or assessor if you are not sure what the question is asking.
HINT: Use these questions as subheadings to create a business style report to answer your assessment
Your response to each question should aim to provide enough information to answer the question. In most cases, this can be done with just a few paragraphs. Do not forget to refer to attachments under the heading (question) applicable, e.g. ‘See attached email’.
Important: Your assessment must contain this coversheet and your own coversheet (for your “report”)
Your answers & assessment submission must be professional in style (Business), content and format. Maximum font size 11 points: Font Arial or Times New Roman; single spacing; clear paragraphs with appropriate punctuation, spellchecking and final submission will need to be proof-read. (i.e., few missing words or typo’s)
In particular:
- Use clear, non-discriminatory language
- Avoid the use of jargon
- Write clearly using plain English
- Consider your target audience
- Ensure that your responses meet the needs of the target audience (in this case your trainer or assessor).
All of your work must be original.
Performance Evidence
Evidence of the ability to:
· prepare the specifications for a data warehouse, from a range of organisational information
· design a data warehouse system that reflects the cu
ent, and future, business specifications, and also the business’s knowledge management strategy
· test the data warehouse system
· implement the data warehouse design.
Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.
Knowledge Evidence
To complete the unit requirements safely and effectively, the individual must:
· explain the functions and features of:
· data warehousing and data mining
· dimension tables and fact tables
· various steps and processes, including transformer steps, program steps, structured query language (SQL) steps, and user-defined program steps
· subject areas, warehouse sources and warehouse targets
· warehouse agents and agent sites
· outline the business operating systems related to the data sources
· describe the decision support systems related to the knowledge management strategies
· define the parameters for a security plan
· outline the system’s configuration parameters
· describe the key features of “Big Data” including:
· data access speeds and processing
· the information handled by large corporations
· distribution, via the cloud, across the database servers.
Assessment Conditions
Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, inte
uptions and time variances must be typical of those experienced in the database field of work, and include access to:
· equipment and materials
· industry software packages
· the business requirements
· computers configurable as information servers
· the enterprise’s knowledge management strategy
· internet connectivity tools
· the local area network (LAN), with a relational database management system (DBMS)
· proxy server software
· specialised internet security software.
· Assessors must satisfy NVR/AQTF assessor requirements.
To achieve competency for this unit:
· All assessment activities in this unit must be successfully completed.
· The student must achieve a SATISFACTORY result in all the assessment activities in this unit to be deemed COMPENTENT.
· Students must perform to the standard as expressed by the competency standards of the ICT Training Package.
Reasonable Adjustment:
· Reasonable adjustment is any approved modification or allowance made in assessment to accommodate a disability related function. Reasonable adjustment allows a learner with a disability to participate equitably in assessment procedures and demonstrate required skills and knowledge. Adjustment could be made in the physical environment, the assessment strategies or using assistive technology. Any adjustments made to the assessment must preserve the integrity of the assessment outcome.
Marking and Criteria guide:
Assessor and student must read this carefully before assessment.
· All parts of the assessment must be completed successfully in accordance with the guidance provided in the Marking guide for the student to achieve competence in this unit.
· Students & assessors must note that professionally critical aspects/concepts must be included (e.g., obtain knowledge of data warehouse).
· All parts (criteria) in the marking guide must be completed successfully for the student to achieve competence in this unit.
EDUCATOR to complete.
Observation/assessment
Satisfactory/not Satisfactory
Comments
All assessments, tasks & activities (on Moodle®) successfully
Add Scale
Task 1: Knowledge Questions
1. Explain the functions and features of:
1.1 Data warehousing and data mining - no less than word count of 50 words
Add Scale
1.2 Dimension tables and fact tables - no less than word count of 50 words
Add Scale
1.3 Various steps and processes, including transformer steps, program steps, structured query language (SQL) steps, and user-defined program steps
Add Scale
1.4 Subject areas, warehouse sources and warehouse targets
Add Scale
1.5 Warehouse agents and agent sites
Add Scale
2. Explain the business operating systems related to the data sources - no less than word count of 50 words.
Add Scale
Task 1: Knowledge Questions
3. Report on the decision support systems related to the knowledge management strategies - no less than word count of 50 words
Add Scale
4. Report on the parameters for a security plan - no less than word count of 50 words
Add Scale
5. Determine the system’s configuration parameters - no less than word count of 50 words
Add Scale
6. Determine the key features of “Big Data” including:
6.1 Data access speeds and processing - no less than word count of 50 words
Add Scale
6.2 Information handled by large corporations - no less than word count of 50 words
Add Scale
6.3 Distribution, via the cloud, across the database servers - no less than word count of 50 words
Add Scale
Practical Checklist
Assessor to complete: (circle)
Did you observe the student? Choose an item.
Further comments required:
Assessment Result
XXXXXXXXXXSATISFACTORY |_| NOT SATISFACTORY |_|
Resubmission Required
XXXXXXXXXXNO |_| XXXXXXXXXXYES |_|
Assessor’s Feedback
Date resubmission must be handed in: …………………………………….
Assessor’s name and signature: ………………………………………………. Date: ………………
Learner’s Feedback
Learner’s name and signature: ………………………………………………. Date: ………………
Task 1: Knowledge Questions
1. Explain the functions and features of:
1.1 Data warehousing and data mining - no less than word count of 50 words
1.2 Dimension tables and fact tables - no less than word count of 50 words
1.3 Various steps and processes, including transformer steps, program steps, structured query language (SQL) steps, and user-defined program steps
1.4 Subject areas, warehouse sources and warehouse targets
1.5 Warehouse agents and agent sites
2. Explain the business operating systems related to the data sources - no less than word count of 50 words.
3. Report on the decision support systems related to the knowledge management strategies - no less than word count of 50 words
4. Report on the parameters for a security plan - no less than word count of 50 words
5. Determine the system’s configuration parameters - no less than word count of 50 words
6. Determine the key features of “Big Data” including:
6.1 Data access speeds and processing - no less than word count of 50 words
6.2 Information handled by large corporations - no less than word count of 50 words
6.3 Distribution, via the cloud, across the database servers - no less than word count of 50 words
Feedback Form
Student Name
Student #:
Date:
UOC Name:
Create a Data Warehouse
UOC Code:
ICTDBS503
I have read the assessment instructions and know the observation criteria and I am ready to participate in the practical assessment
Students Signature: _________________________________________________________________
Observation
Satisfactory
Not Satisfactory
Did the candidate:
Answered all the given questions
|_|
|_|
Satisfactory
|_|
Not Satisfactory
|_|
Educator Name and Signature:
c:\users\valissam\downloads\onedrive_ XXXXXXXXXXcreate cloud computing services a1 v01_ XXXXXXXXXXdocx
e:\work\wentworth institute\training\dip of ict\2021\term 4\2. create data warehouse\assessments\ict XXXXXXXXXXcreate a data warehouse a1 v01_90721.docx
Page 1 of 2
hw1-4iceag20.pdf
Homework Set #1
1. The National Crime Victimization Survey is described in Ch. 1 (p. 7). In 2015, it included a supplement to report
on school-based crime among those enrolled in K-12 education in the U.S. I’ve provided a link to the actual
survey here. For the following questions only, identify the level of measurement (ordinal, nominal, or interval-
atio). https:
www.bjs.gov/content/pu
pdf/scs15_q.pdf
Questions 1d, 7, 14a, 21b, 24, and 39
2. The frequency distributions below show frequencies of murder and non-negligent manslaughter in Colorado for
selected years (1999 and 2016) by age of the victim.
a. Complete both frequency distributions by calculating percentages, cumulative frequencies and
cumulative percentages for each table.
Murder and Non-Negligent Manslaughter
y Age of Victim In Colorado
1999 frequency %
Cum.
Frequency Cumulative %
Under 18 36
XXXXXXXXXX