User Manual, Revolution
Page tree

Versions Compared

Old Version 13

changes.mady.by.user Aaron Lew

Saved on

compared with

New Version Current

changes.mady.by.user Melissa Sze

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Image Removed

Database Queries allow users to

gather

see the 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 (Image Removed) 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 

    Image Removed

    Image Removed

    Image Removed
    • 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.

    Image Removed

    Image Removed

    How to Encrypt Excel with Password

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

    When open the file, there will have a notification to ask you for Enable Editing. 
    Image Removed
    Click the "Enable Editing" button.
    Go to File.
    Image Removed
    One the left bar, select "Info".
    Image Removed
    In Info, you will see some options, and we are going to select "Protect Workbook".
    Image Removed
    In the drop-down selection, we are going to click on "Encrypt with Password".
    Image Removed
    After you clicked on "Encrypt with Password", a window will pops up for prompting you a password and confirm you password.
    Image Removed → Image Removed
    Save the excel file.
  • 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



    Image Added


    • Figures for  basic demographic variables are found here so researchers can get an idea on how many potential participants may fit their study criteria


    Image Added


    From here, users can click "Queries Search" to find families by criteria.