• Queries allow users to gather statistics regarding the population in Revolution
    • This function could help users with recruitment as it can select for potential participants who fit in study-specified criteria
  • The categories by which you can select for individuals include categorical values and continuous values, which are further specified below
  • Categorical Values have options that can be seen and selected for by clicking the three lines () to the right of each option (highlighted with a purple arrow)
  • These values include: 
    • Future Contact (whether they would like to be contacted in the future by the lab)
    • Household Status
    • Biological Relationship (to household status, "Self" participant)
    • Sex
    • Pregnancy
    • Race
    • Ethnicity
    • Marital Status
    • Education Level
    • Public Assistance
    • Health Condition
    • Preferred Contact Method
    • Preferred Contact Time
    • Preferred Contact Day 



  • Continuous values have options that exist along a gradient, and therefore, can be selected using a moving marker along a bar, or typing in your specifications 
    • Age
      • Please note that when selecting an age, you must either choose "Age," in years (shown at the top of the left-most image) or "Age (in Months)" (shown at the bottom of the left-most image)
    • BMI
    • zBMI
    • BMI percentile


Export

Data that rendered using Queries Search are able to export as spreadsheet.

  • To export data, user can use Search Filters to filter the information and also able to customize what data to be display or export using Customize Output. 
  • Once the data are rendered, the "Export as Spreadsheet" button will appear right under Customize Output for user to export the data in a spreadsheet. 
  • Users are responsible to password protected the export file since data include PHI.



How to Encrypt Excel with Password

To encrypt the Excel for the exported spreadsheet from Revolution, please follow the guide below: 

  1. When open the file, there will have a notification to ask you for Enable Editing. 


  2. Click the "Enable Editing" button.

  3. Go to File.


  4. One the left bar, select "Info".


  5. In Info, you will see some options, and we are going to select "Protect Workbook".


  6. In the drop-down selection, we are going to click on "Encrypt with Password".


  7. After you clicked on "Encrypt with Password", a window will pops up for prompting you a password and confirm you password.
     → 

  8. Save the excel file.

  9. Once you completed the process above, the excel file is now encrypted with password. It will prompts you to enter password every time you are accessing the file.


Go to previous section Create a Study

Return to Revolution

Go to next section Import