9 Search X AutoSave Off SMS 421 Assignment 2 Spreadsheet - Protected View v File Home Insert Page Layout Formulas Data Review View Automate Help Acro PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in co v I X Vfx A B D 1 A Lot Size 2 B Sample Size (AC SUR 004 3 C Sampling Plan (www.random.org) Provide evidence (random number generator) UT A 6 8 19 10 IN = 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Sampling Plan Sampling Plan Results Conclusion + Ready 12 " C Cloudy Q Search4 80% + Assignment 2 (10 Marks) SMS 421 AUDIT SYSTEMS Transport Canada collects aviation occurrence information through CADORS. The purpose of the system is to provide initial information on occurrences involving any Canadian-registered aircraft as well as events which occur at Canadian airports, in Canadian sovereign airspace, or international airspace for which Canada has accepted responsibility that includes events involving foreign registered aircraft. This assignment consists of developing and executing a sampling plan to determine if Civil Aviation Daily Occurrence Reporting System (CADORS) reports conform to the audit criteria (requirements) listed below . For this assignment you are required to include the following information with your submission: Sampling Plan Sampling Plan Results (spreadsheet) Conclusions The sampling plan must clearly identify the lot size, sample size, and the reports to be sampled. Evidence of how the sampling plan was created must also be provided (e.g., list of random numbers). The sampling plan should be recorded on the spreadsheet provided. The sampling plan result shall be recorded on a spreadsheet provided. The conclusions should be recorded on the spreadsheet provided. Audit Criteria (requirements): The audit criteria (or requirement) that you will use for this assignment is simply that Transport Canada has filled-in each "field" in the Aircraft Information section of the CADORS report form. Audit Scope (period under review); Each student will be provided with a Month-Year, This will consist of your audit scope (period under review) for your individual audit. The entire month is to be included (first to last day). ENG IN Q Search L OU hpThe Population (lot size) To determine your lot size, you are expected to use the CADORS query tool at https://wwwapps.tc.gc.ca/Saf-Sec-Sur/2/cadors-screag/q.aspx. You MUST apply the following filters: Occurrence Date Range: Provided TSB Class of Investigation: Class 5 For all other fields, use the default values - see below. Search Reset Occurrence Information CADORS Number: Occurrence Date 2019-01-01 Range: (yyyy-mm-dd) Occurrence Type: All Occurrence Types Fatalities: Injuries: Canadian Aerodrome Enter any part of an Aerodrome Id in the text box, and then click on the ID: Aerodrome Lookup button to populate the Aerodrome list. Results will appear in this list Occurrence Location: Province: All Provinces Occurrence Region: All Regions TSB Occurrence Number: TSB Class Of Investigation: Class 5 LOCHO O awhpAssignment 2 (10 Marks) SMS 421 AUDIT SYSTEMS Sampling Plan Results Execute the sampling plan and record your results on the spreadsheet provided. Include a copy of the spreadsheet with your submission. Conclusion What did you concluded? Was the requirement (e.g., ISARP) conforming or non-conforming? If non-conforming, provide a summary of your conclusions (based on the sampling results): For example, X of X CADORS reports sampled had one or more fled(s) with information missing. X were missing... X were missing... Etc. LOC - B myhp3 4 80% + Sample Size To obtain your sample size, use the sampling plan chart found in Transport Canada AC SUR-004 Simple Random Sampling Simple random sampling shall be used for this assignment. To obtain the list of CADORS (reports) for your population go to the CADORS download page and select "occurrence date". From this list you can create a sampling plan by highlighting the reports that you randomly selected. CADORS CADORS: Download download tit - Notepad File Ede Format View Help Please select one or more fields to download. The CADORS number is automatically included. Occurrence Information Cadors Number Occurrence Date WARNING: Requests for a large amount of data will process for an extended period of time and there 201301509 2013-06-20 possibility that the application will not be able to complete your request. In the event that the report doe 201301506 2013-06-24 not function properly, users should attempt to download the desired data in smaller increments. It is 201301503 2013-06-05 suggested that these types of reports be broken down by date range and that the Increments be 201301418 than two months. 2013-06-29 201301380 2013-06-24 201301347 2013-06-22 201301344 2013-06-22 281301340 2013-06-20 Occurrence Information 2013Q1318 2013-06-18 201301315 2013-06-14 Select all 201301305 2013-06-16 Occurrence Time Day or night 201301303 2013-06-14 Occurrence Type Fata bes & lejunes Canadian Aerodrome LD 201301276 2013-06-13 Aerodrome Name Joccurrence Location Country 201301237 2013-06-09 World Area Occurance ReQ AOR Number 201301231 2013-06-08 Reported BY TER Occurrence No. & Class Occurrence Event(s) 201301226 2013-06-06 Event(s) 201301211 2013-06-06 201301197 2013-06-04 Occurrence Category (les) 201301187 2013-06-04 Category(les) 2013P0869 2013-86-25 2813P3866 2013-06-24 2013P0864 2013-06-23 Aircraft Information 2013P0858 2013-06-24 Select all 2013P0841 2013-06-21 2013P0837 2013-06-21 Registration 2013P0834 2013-06-20 Areran Category Country of Registration 2013P0832 2013-06-16 Engine Type Engine Make & Model nocar Tree 2013P0823 2013-06-18 Phase of Flight Damage Owner 2013P0815 2813-06-17 Operator Operator Type 2013P0805 2013-06-14 Flight rule CARE SubPart 2013P8796 2913-06-14 Aircraft Event (2) 2013P0786 2013-06- Event (=) 2013P0784 2013-06-12 2013P0782 2013-06-12 2013P0781 2013-06-12 Occurrence Summer 2013P0776 2013-06-12 Select all Windows (CRLF)|UTF. Date Updated hp