Converting+Reports+to+Spreadsheet

Converting Files from one format to another and/or extracting information from one system to another are often tasks left for system administrators. However, sometimes there are programs that require us to import a class roster for example, where it is easy enough for us to create our own spreadsheets or IDs. In these cases, we can 1) generate PDFs where we can copy and paste information into an Excel spreadsheet and convert the information into what we need or 2) run a report from another system that will give us the information that we need.

In the following example, steps are taken to extract information from a Gradebook Export, into a file that can be imported into SMART Responder to generate a class list.

Reports Gradebook Export Select Your Class and Section Select CSV (Comma Separated Value) Generate Report (This report will give you roster with ID #s) Open File with Excel Delete unnecessary title rows Highlight Column if you would like to split data in one column to two Data Tab Text to Column Add a # to the Other deliminator field Follow the Steps to split your data into columns After your data is ready to be imported into another program, remember to save the file. Save, Save As .csv (comma separate values) Comma Separated Value formats are typically use to import data into programs. The file created will look like: lastname, firstname, idnumber and the program will place the data into fields by using the comma to separate the information. Thus firstname will go into a First Name field, lastname will automatically go into the next field. In our example we include an ID number because importing csv class lists into SMART Responder will allow you to track students by ID number (which means students can use the SENTEOS (clickers) to enter into your Responder class with their 5 digit ID). This will allow you to track their assessments and see learning curves over time.
 * Exporting from Infinite Campus**: