LARC access can be requested through OARS (Online Access Request System). Requests will be reviewed by U-M data stewards, primarily the Registrar's Office. Acquiring approval is easiest if requesters enter a brief abstract of their intended work, in OARS' Additional Comments section, to help approvers understand how the data will be used. Requesters can ask for the following roles:
Requesters should obtain IRB (Institutional Review Board) approval and sign a MOU (Memorandum of Understanding) describing their specific research interests prior to submitting their request. When access is granted, requester will receive access to Oracle tables for direct database access and U-M Box folders for flat files.
If the user does not have a department affiliation (e.g. student) the Dept ID field must be filled in with the department making the request in order for the UL to approve it. This Dept ID field must be entered BEFORE the request is submitted. If this is not done, then an incident needs to be opened for ITS Access & Accounts to enter the deptid (see screen shots below)
Any tool capable of connecting to an Oracle database can connect to the LARC data set. Our recommended tools are Oracle SQL Developer (SQL client) and Tableau (data visualization), but we have connected many other tools including SQL Workbench/J (SQL client), Denodo (data virtualization), and R (statistical computing). If using LARC flat files downloaded from the U-M Box folder, any software capable of working with large flat files should work.
Start by referring to communication you received when you first were granted access. That should contain connection strings and ID/password information to help you make a connection. If using a tool that supports TNSnames.ora files provided by MiWorkspace, edwprod.world is the correct selection. If you still need help for other connections, please contact 4-HELP. They have access to a Knowledge Base Article that contains detailed connection string information that we prefer not to share in a public document. If you prefer not to use a database connection, download the flat files from U-M Box.
LARC is refreshed four times per year - approximately three weeks after the end of each academic term. The specific refresh schedule is available online - http://www.mais.umich.edu/reporting/datasets_refresh.html#teaching-learning.
LARC can be joined with other data held in the data warehouse or other local data by linking through students' UMID or uniqname. LARC can be requested with or without identities. When requesting LARC with identities, UMID and uniqname will be included.
Refer to the data dictionary (linked from the Teaching & Learning Data Sets web page) for technical metadata. Refer to the data glossary (coming soon) for user-contributed information. For interpretation questions, submit a 4HELP request to the LARC Dataset Support team and the question will be routed to the university's subject matter expert on your specific question.
Change requests for the LARC data set should be emailed to firstname.lastname@example.org for review by the data set's oversight committee.