PFA
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/research 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: 91178 November 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 current, 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, interruptions 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 SATISFACTORY |_| NOT SATISFACTORY |_| Resubmission Required NO |_| YES |_| 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_2021-05-16\create cloud computing services a1 v01_ 170521.docx e:\work\wentworth institute\training\dip of ict\2021\term 4\2. create data warehouse\assessments\ict50120\120 - create 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- ratio). https://www.bjs.gov/content/pub/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 by Age of Victim In Colorado 1999 frequency % Cum. Frequency Cumulative % Under 18 36 18-29 68