Computer Science > STUDY GUIDE > IFT 201 - Computer and Network Systems: Organization and Administration Arizona State University - I (All)

IFT 201 - Computer and Network Systems: Organization and Administration Arizona State University - IFT 130Assignment3b_ElectronicData2

Document Content and Description Below

IFT 201 - Computer and Network Systems: Organization and Administration Assignment 3b – Electronic Data Instructions: Answer the following question. Show your work with screenshots. All question... s are based on SampleData.txt (prefix added per session) file provided separately with in this Assignment 3b in Canvas. You cannot use any software to convert the files. All data conversion task needs to be done manually, which means using notepad or other text editor to type in the pipe, tags for xml, curly braces for json etc. 1. View this file and describe what type of file is this (3 points). It is a text file with raw data. What is the character delimiter used in this FILE (3 points)? Comma and Tab Is the data in the file structured or unstructured data? (4 points) Structured Data 2. Import this data into Microsoft Excel using Get Data wizard and provide detailed Screen Shots. Fix the format if needed. Hint there are only six rows of data and the Product Model IDs are 19, 23, 25, 28, 34 and 35. Take screenshots of each step and save it to a file(s). Save the imported data into Microsoft Excel file format. (10 points) Open Excel and type in search Get data from Text [Show More]

Last updated: 2 years ago

Preview 1 out of 21 pages

Buy Now

Instant download

We Accept: