Step 3: Download/upload data and other files to RStudio

Download the data file

1. After the data collection process is completed, your data is ready to upload.

2. Go to the “Responses” tab of the Google Form.

3. Click the three dots (next to “Link to Sheets”) ➜ “Download responses (.csv)”

   

4. The file will be downloaded as a .zip folder.

5. Double-click that folder to extract the file.

6. Rename the file name to “df.csv” (Make sure it’s not “df.csv.csv”).

   

Download the Quarto file

Click to download the Quarto file:

1. Short form Quarto file

OR

2. Standard form Quarto file

Download the Word Template file

Click to download the Word Template file:

QR_Report_Template.docx

Upload these files to RStudio

1. Upload these three files (df.csv, .qmd, and the Word Template files) to RStudio one by one.

2. You will see three files under the “Files” tab.

   Click on “standard.qmd” or “short.qmd” (the version you use):

3. Clicking on the .qmd file will open it on RStudio.

   Click “Run” ➜ “Run All.

4. This process will install all the packages. For the first time the codes are run, this process may take 15-20 minutes or shorter depending on your internet connection.

   You will see a STOP sign and codes are running in the console. You should wait until the “STOP” sign in the console disappears and no more code is running in the console.

5. During this process, if you see the pop-up window above (Updating Loaded Packages), click “No” every single time.