you only need to do part A
Title of the module here © Juan Marcelo Gomez, 2022 Licensed for use in course RMG300 taught by Juan Marcelo Gomez. Any use outside of these parameters is a copyright violation. 1 RMG300: Information Management A1. EDIFACT IID DATA TRANSFORMATION CHALLENGE Group: 20% weight of course The final date for submission and/or evaluation of this assessment is as stated in the assignment folder This content is delivered through the D2L Brightspace virtual learning environment. All assignments must be submitted through https://my.ryerson.ca If you have any technical difficulties using D2L Brightspace, please visit the support pages at: https://www.ryerson.ca/courses/ IMPORTANT: ALWAYS RETAIN A COPY OF YOUR ASSIGNMENT WARNING: Once submitted no substitute assignments will be allowed https://my.ryerson.ca/ https://www.ryerson.ca/courses/ © Juan Marcelo Gomez, 2022 Licensed for use in course RMG300 taught by Juan Marcelo Gomez. Any use outside of these parameters is a copyright violation. 2 Specific Tasks 1. In your groups as per stated maximum requirements 2. Ensure all group member have self-enrolled 3. Download ECCRD v4 manual document as instructed. 4. Listen to the project introduction lecture provided. 5. Examine the flat file provided 6. Engineer a software solution using Microsoft Excel to decode the flat file. 7. Replicate and engineer a software solution using Microsoft Access to decode the flat file. 8. Document the steps taken using Microsoft Word from start to finish to create the solutions with examples. 9. Please submit documents (Excel/Word files and Access database) with your completed work as a group to the assignment folder. Only 1 member needs to submit on behalf of the group. Files types must be Microsoft Word, Excel and Access, any other type of files such as google sheets or docs will not be accepted and the assignment will be awarded zero marks. 10. Students that do not contribute to group work will be awarded zero marks. Data Transformation Please ensure the right file is being processed for the assigned group. The EDI flat file will be available in the [Project] folder. Group EDI File Purpose Odd numbers (e.g., 1; 7) Boysenberry Create Decoding Software Even numbers (e.g., 2; 8) Kava Create Decoding Software Either use the file provided by your professor or request [Chapter 23: Single Window Initiative Integrated Import Declaration (IID)] using this link https://www.cbsa-asfc.gc.ca/eservices/eccrd-eng.html The purpose of this document [Version 4.0, April 2017] is to provide industry partners with data requirements, technical and systems information related to the Electronic Data Interchange (EDI) transmission of the IID. The document (ECCRD Version 4.0) includes the EDIFACT inbound and outbound message specifications and code tables. It also includes the Canada Boarder Service Agency (CBSA) and agencies requirements for submitting an IID. The document contains the necessary information for you to familiarize with the use of TAGS/Segments, Data Elements, Rules and Conditions, and Codes that are used for the transmission of data using an EDIFACT message. In this assignment you will specifically address Canadian Food Inspection Agency (CFIA) related programs. Message structure is described starting on page 26. Tags/Segments are described starting on page 30. Data Elements are described starting on page 175. Partial Example: UNB+UNOC:3+13276IID:ZZZ+INETCECPT:ZZZ+171204:1200+9' UNH+14569M+GOVCBR:D:13A:UN:IID+SWI210' https://www.cbsa-asfc.gc.ca/eservices/eccrd-eng.html © Juan Marcelo Gomez, 2022 Licensed for use in course RMG300 taught by Juan Marcelo Gomez. Any use outside of these parameters is a copyright violation. 3 DTM+132:201712061200:203' MOA+134:13330:CAD' RFF+ABO:889781704RM0001' Your project involves transforming the above code into information that is easily understandable (decoded) using the skills that you have learned in this course and other information/formulas that you have researched. All of your work must be shown, including formulas. For Example: Decoded Coded Data Values Element UNB+UNOC:3+13276IID:ZZZ+INETCECPT:ZZZ+171204:1200+9' 171204:1200:9 Interchange header UNH+14569M+GOVCBR:D:13A:UN:IID+SWI210' SWI210 Message header DTM+132:201712061200:203' 201712061200 Estimated Time of Arrival at the First Point of Arrival MOA+134:13330:CAD' 13330:CAD Total Value for Duty RFF+ABO:889781704RM0001' 889781704RM0001 Originator's reference Part A: Develop a Microsoft Excel Workbook that contains all the decoding details as demonstrated by your instructor. The worksheet should have 3 columns. In the first column, your instructor should be able to paste the flat file information. The second column should decode the Data Values. The third column should decode the Element. IMPORTANT - Please note that Data Values and Elements should have the ability to be decoded regardless of the line order. Part B: Develop a Microsoft Access Database that contains all the decoding details as Part A. You are encouraged to be creative and develop your own solution that you see best fits and provides the ability to replicate the results from Part A. Part C: In no more than 2 pages (no cover page or TOC or references required), using Microsoft Word, describe what were the challenges, what you enjoyed about this project and what you would like to see if you were to redo the project. Finally, describe how this project can help your career in retail for managing information. Admin © Juan Marcelo Gomez, 2022 Licensed for use in course RMG300 taught by Juan Marcelo Gomez. Any use outside of these parameters is a copyright violation. 4 Main Assessment Criteria Performance indicator Did not meet expectations 0-40 marks Met expectations 50-70 marks Exceeded expectations 80-100 marks Part A • Excel decoder not provided or does not function as expected. Part B • Access decoder not provided or does not function as expected. Part C • Writing/Illustration is vague and unstructured • Writing/Illustration includes more than 5 spelling /grammatical errors. • Student(s) has/have not used own words or illustrations • Not supported by analysis • Unclear or non-concise identification of elements • Little to no application of concepts and models to elements • Evaluation is less clear. • Word/page count under or over requirement tolerance. • Structure and formatting do not comply to requirements. • Appendix data not included. Part A • Excel decoder provided or partially functions as expected. Part B • Access decoder provided or partially functions as expected. Part C • Writing/Illustration is clear and logically structured • Writing/Illustration includes 1 – 4 spelling /grammatical errors. • Students have used own words or illustrations • Supported by some analysis • Mostly clear and moderately concise identification of elements • Elements are somewhat supported with evidence • Some application of concepts and models to elements • Somewhat clear evaluation. • Word/page count met requirement within 6-10% tolerance. • Structure and formatting somewhat comply to requirements. • Appendix data included. Part A • Excel decoder provided and fully functions as expected. Part B • Access decoder provided and fully functions as expected. Part C • Assignment met all requirements • Writing/Illustration is clear and logically structured using a professional style • Writing/Illustration does not have any spelling /grammatical errors. • Students have used own words or illustrations • Supported by good analysis • Clear and concise identification of elements • Application of concepts and models to elements. • Clear evaluation. • Word/page count met requirement within 5% tolerance. • Structure and formatting comply or exceeds requirements. • Appendix data included. Note: if there is evidence of plagiarism, the grade for the assignment will be 0 marks. The Academic Misconduct policy will apply. © Juan Marcelo Gomez, 2022 Licensed for use in course RMG300 taught by Juan Marcelo Gomez. Any use outside of these parameters is a copyright violation. 5 Structure and Formatting: Written Document 1. Assignments should be typed, 11-point font size (Times Roman or similar) double spaced with the page size specified as ‘Letter’. All pages must be numbered. The overall document must look professional 2. MS Office 2016-2019/365 is an appropriate format. PDF or IOS Pages files are not accepted. 3. Two pages maximum from the start to the end of the written document. 4. Assignments may be uploaded once only. Where this assignment is conducted as a group project, one group member submits on behalf of the whole group; substitutions are not permitted and students should therefore ensure that the version uploaded is the final submission. 5. Please ensure you include student number(s) and the assignment reference in all submitted assignments. Failure to do this may lead either to a grade not being assigned or being wrongly assigned. Your document should look professional. Documents need to be well-structured, divided into numbered sections that correspond logically to the assignment purpose. Note: One instructor will review your assignment unless there is a case of plagiarism to investigate. Please ensure that student name(s), student number(s) are detailed on the submission A1. EDIFACT IID DATA TRANSFORMATION CHALLENGE Specific Tasks Data Transformation Main Assessment Criteria Structure and Formatting: Written Document Please ensure that student name(s), student number(s) are detailed on the submission UNB+UNOC:3+13276IID:ZZZ+INETCECPT:ZZZ+171204:1200+7' UNG+GOVCBR+13276IID:ZZZ+IIDT+171204:1200+14567F+UN+D:13A:IID' UNH+14567M+GOVCBR:D:13A:UN:IID+SWI210' BGM+929+13276211308974+9+' DTM+132:201711201200:203' MOA+134:7450.00:CAD' RFF+ABO:122235922RM0001' RFF+CN:DH3232' GOR++5' LOC+23+0495+9495:::' GOR++1' LOC+0495+9495:::' NAD+IM+122235922RM0001++LOBLAWS INC::+1 PRESIDENTS CHOICE CIRCLE::+BRAMPTON+ON+L6Y5S5+CA' CTA+AH+:Willson International Ltd - Fort Erie'
[email protected]:EM' COM+(905) 816-4405:FX' COM+(905) 871-1310:TE' CTA+IC+:Willson International Ltd - Fort Erie'
[email protected]:EM' COM+(905) 816-4405:FX' COM+(905) 871-1310:TE' NAD+CB+13276++WILLSON INTERNATIONAL LIMITED::+2345 Argentia RdSUITE 201::+Mississauga+ON+L5N2X7+CA' CTA+AH+:Willson International Ltd - Fort Erie'
[email protected]:EM' COM+(905) 816-4405:FX' COM+(905) 871-1310:TE' CTA+IC+:Willson International Ltd - Fort Erie'
[email protected]:EM' COM+(905) 816-4405:FX' COM+(905) 871-1310:TE' UNS+D' SEQ+1' NAD+UC+107342++LOBLAWS INC::+1 PRESIDENTS CHOICE CIRCLE::+BRAMPTON+ON+L6Y5S5+CA' CTA+AH+:Willson International Ltd - Fort Erie'
[email protected]:EM' COM+(905) 816-4405:FX' COM+(905) 871-1310:TE' CTA+IC+:Willson International Ltd - Fort Erie'
[email protected]:EM' COM+(905) 816-4405:FX' COM+(905) 871-1310:TE' NAD+VN+309102++Cedar Creek Orchards Plc::+269 Mulhollands Rd.::+Thrilmere+Wollongong+ 2572+AU' CTA+AH+:Willson International