REDCap (Research Electronic Data Capture), a secure, web-based application for building and managing online research surveys and databases, is a premier tool for supporting UO research efforts with the goals of better collaboration and easier data management. REDCap can be used to rapidly develop projects via a point and click interface or by creating a “data dictionary” template file in Microsoft Excel that can easily be uploaded into the application. We offer REDCap as a free resource for UO researchers and their external team members.
REDCap is a preferred data management tool. Developed by programmers at Vanderbilt University, REDCap is a reliable and secure web-based application that allows you to better manage your research team’s data collection process from start to finish. REDCap features allow you to:
Build online surveys and databases quickly and securely – Create and design your project rapidly using secure web authentication from your browser. No extra software is required.
Be fast and flexible – Conception to production-level survey/database in less than one day.
- Export data to common data analysis packages – Export your data to Microsoft Excel, PDF, SAS, Stata, R, or SPSS for analysis.
- Create ad hoc reports – Create custom queries for generating reports to view or download.
- Schedule and organize – Utilize a built-in project calendar and scheduling module for organizing your events and appointments.
- Easily manage a contact list of survey respondents or create a simple survey link -Build a list of email contacts, create custom email invitations, and track who responds, or you may also create a single survey link to email out or post on a website.
- Save your data collection instruments as a PDF to print – Generate a PDF version of your forms and surveys for printing to collect data offline.
- Use advanced features – Auto-validation, calculated fields, branching/skip logic, and survey stop actions.
Links to Additional Content
For more information on REDCap (screenshots, setup, examples of data analysis), click here for an introductory guide.
The Oregon Clinical and Translational Research Institute at the Oregon Health Sciences University has an extensive tutorial page and help site located here.
The Institute for Cliinical and Translational Science at the University of Iowa has developed a large public support page for REDCap. Click here for more information.
Click here for the site developed and operated by Vanderbilt University, the creator of REDCap
If you would like use REDCap here at UO, contact CASIT Systems for more information.
This post is using Formidable Pro, a plugin for WordPress that allows site managers to create forms for various needs. Some examples include sign-up sheets for events or avenues to receive feedback among many other options.
Click one of the options below to proceed:
Formidable Pro is a WordPress plugin that allows site administrators to create forms for gathering various data. To activate Formidable, select the Plugins option from the Dashboard menu, scroll down until you find Formidable Forms, then press Activate. Formidable will then appear below your Pages option on your Dashboard menu.
Create A Form
Once Formidable has been activated, you can start creating forms. Formidable will show up in the Dashboard Panel. To get started highlight the Formidable option and select Forms then click Add New.
When adding a new form, Formidable will allow you the option to either create a form from an existing template or one from scratch.
Once you have you have made your decision, you will be directed to the Build menu of the form which will allow you to add form fields or tweak what is existing. The images below are for if you selected Blank Form but the behavior of the menu works in any form.
- Note: If form fields and/or their descriptions need to be edited, go to the Build menu.
- Make sure that you are on the Build menu
- Name your form or edit the existing title if you choose
- Click the parenthetical statement to explain the purpose of the form and/or instructions on how the form is to be filled out.
You will be given a range of options to choose from regarding types of form fields. Click and drag the form field into place…
… each of which have descriptions and settings that can be edited.
- Select the asterisk if you want this form field to be a required field
- Provide a title for your form field or edit the existing title if you choose.
- Provide instructions as to how to fill out this form field (optional but recommended).
- Field Options Menu (for adding additional properties like Custom CSS Layouts)
Edit Custom CSS Layouts / Form Page Layouts
Once all of your form fields and descriptions have been added, you can readjust the layout of the form by clicking on the Field Options Menu. In so doing, there are several options to choose from. The main focus of this section is adjusting the page layout and particular settings within each form field.
- Note: Each form field will have its own options, the example below and corresponding descriptions are of options in every form field.
Here are descriptions of each option shown above:
CSS layout classes: This is for adding CSS script to determine where a particular field will be located on the overall form. If left blank, Formidable will have list the form fields vertically one after another. To make modifications, you do not need CSS knowledge but there are a few considerations to make.
The examples below are the options you can choose from and a template of some of the the CSS classes.
- Note: The CSS Layout Classes below can be added only when the CSS layout classes field is highlighted. It will be inactive (grayed out) at any other time.
Label Position: Assigns the position form field label. The default setting will have the label aligned to the left edge of the form field.
Field Size: This option imposes limits on the length and the amount of characters (rows, columns, etc.) of the form field.
- Note: The field size parameters are specific to each form field type.
Visibility: If user roles are enabled on your site, this option can restrict who sees this form.
Conditional Logic: Certain form fields can be made visible after conditions have been met.
Validation: If the form field is dependent upon certain conditions (like Phone Number or Email Address), this option allows you to edit the response if the correct conditions are not met.
Click the Settings option. Under General menu:
There are several settings that can be changed quickly and easily however several of them are dependent upon other actions within your site.
- Aside from the Action After Form Submission option, all settings are going to be dependent on whether site user accounts are enabled and advanced coding (using AJAX)
- You can also choose what form respondents will receive as a confirmation as well as being notified of new entries. See Responses sent to an email / Linking to RT.
- Additionally, the form can be restricted to Logged-In Users. If selected, the form will require a DuckID and password to be seen. Users can allow form respondents to edit responses and restrict to one form submission.
Under the Form Actions option, you can choose who is notified of a form submission and how the message appears to that person.
To set up email notifications, click on the Form Actions option within the Settings for your form and select the envelope icon for an email notification (seen below).
- The email notification box.
- Label for the notification.
- The desired email address to receive the notification
- Subject line and message
- The number code in brackets is corresponding to a form field entry (which are on the right-hand side of the form action)
- The default message is for all entries into the form.
- Conditional logic may be applied to this notification depending on the nature of the form.
Adding a form to a web page
Formidable utilizes shortcodes that can be inserted into posts or pages. Shortcodes may be found either in the Build or Settings section of a given form. It will be in a set of brackets (e.g., Please select a valid form) and located in the upper-right hand corner of either page.
Links to Additional Content
For other help articles from CASIT, click here.
Due to the threat posed by the Heartbleed Bug, UO Information Services is requiring that all users change their Duck ID passwords at https://duckid.uoregon.edu AFTER they receive an e-mail from Information Services asking them to do so. DO NOT change your password until you have received an e-mail from firstname.lastname@example.org instructing you to do so.
If you are a CAS Google Apps for Education user, you will also want to change your password for that service.
From Information Services:
“This request comes out of interest for your online safety. The Heartbleed flaw, announced April 7, is a severe flaw that allows hackers to get personal information without detection, and this is why we are asking you to change your password.”
For more information about the Heartbleed Bug at the University of Oregon, see http://it.uoregon.edu/
If you have any questions about the Heartbleed Bug or changing your password contact CASIT at 541-346-2388 or email@example.com, or the Information Services Technology Service Desk at 541-346-HELP or firstname.lastname@example.org.
This purpose of this article is to help you connect to your CAS-FS file shares after the planned migration.
CASIT is migrating its file servers to new hardware in December. This move is necessary because the current hardware is nearing its end of life and cannot be expanded further. The new file storage infrastructure will be capable of continuing to expand smoothly, and will be much more resilient to data loss. During a scheduled hardware upgrade, file shares and home folders will be offline. Most network drives will have to be re-mapped after the upgrade.
Most CAS networked file shares and home folders will be inaccessible starting at 12:01AM on December 21. The hardware upgrade, data move, and testing will be complete by December 25 and users can reconnect starting December 26.
The audience for this article are those who are comfortable remapping drives on their own. If you are *not comfortable*, and/or you would prefer a CASIT Tech to help you remap your file shares, please email us at email@example.com or call us directly at 346-2388.
If you desire to remap your drives on your own, read on.
Remapping File Shares
After the migration, the method you are currently using to connect to the file share will be similar, however your file share path(s) will change. It will necessary to “remap” your share(s), reflecting the new changes. These changes affect both departmental file shares and personal “home folder” file shares.
To see a list of these changes for departmental shares, please see the first table below. The table lists the old path in the first column, followed by columns of new path names for both Windows and Mac users. Find your share(s) and copy/note the new path name for input later. (If you are unsure of your old path name, don’t worry, these paths include department names that you will recognize).
To see a list of home folder changes, see the last table on this page (scroll way down). The table lists the old path in the first column, followed by columns of new path names for both Windows and Mac users. Instead of a list of departments, I have listed one row of “formula” for you to follow, and a row beneath that as an example, using the duckid “scrow”.
To remap your file share(s), follow the instructions below:
For Mac PCs:
- Find your *new* Mac file share paths in the tables below.
- Copy the *new* Mac file share path(s).
- Click here for detailed Mac instructions.
For Windows PCs:
Note: Before you follow these instructions, you should restart your machine. Many CAS Windows machines are connected to an Active Directory network. One benefit of Active Directory is that CASIT can remap your drives automatically. A restart should suffice to bring down new mappings. If it does not, please follow the instructions below.
- Find your *new* Windows file share paths in the tables below.
- Copy/note the *new* Windows file share path(s).
- Click here for detailed Windows instructions.
Departmental Share Path Grid
|Old Share Path *DO NOT COPY*||New Mac Path (Copy!)||New Windows path (Copy!)|
Home Folder File Share Path Grid
|Old Home Folder Path||New Mac Home Folder Path||New Windows Home Folder Path|
|\\cas-fs\Home\<duckid initial>\<duck id>||smb://cas-fs1/home/<duck id>||\\cas-fs1\home\<duck id>|
We are very sorry to inform you that Cathleen Leué passed away unexpectedly in her sleep on 6/18/2013.
Contributions in Leué’s name can be made to the UO Foundation, toward an economics scholarship in her honor. The donor must specify that the donation is in honor of Cathleen Leué in the “My Gift is a Tribute” box at the bottom of the page. If the contribution is by check, the notes field of the check must include “Cathleen Leué.”
Google provides easy to use tools to visualize data called Google Chart Tools. They have a rich gallery of interactive charts and data tools that are customizable, support all browsers and are free to use.
An example of using a Google spreadsheet as a datasource is Tribal Climate Change Funding Guide. The page displays a table of data that CASIT Web Services set up using the Google visualization API combined with some PHP code to add specific filters that use the Google data queries. The page was set up based on guidelines from Google Chart tools documentation and from Katie Piatt’s Blog.
Quick link: Introduction to Using Chart Tools.
CASIT is happy to announce the launch of UO Blogs. UO faculty, students, and staff are now able to create their own UO-hosted blogs using the WordPress blogging platform. Users can create an unlimited number of blogs for their courses, for personal use, and for UO sponsored activities and groups. There are a variety of themes and plugins for users to choose from and flexible privacy and commenting settings.
To get started, check out our UO Blogs help page.
UO Blogs is a free service sponsored by Information Services, the UO Libraries, the School of Architecture and Allied Arts, the College of Arts & Sciences, the Lundquist College of Business, the College of Education, the School of Journalism and Communications, the Clark Honors College, the School of Music and Dance, and the Office of Enrollment Management.
CASIT would like to talk to you about upgrading your paper forms to online web-based forms. The summer offers a great opportunity to take a paper form and workflow and move it to an online system.
Your online form will be hosted on websites that can be accessed from anywhere. The results of the forms will also be accessible online. We can have the website generate reports showing the form entries in a table form. The websites will use databases to store and access the form information.
Style and Accessibility
The online forms can be styled in many ways. We make sure that all online forms meet US Section 508 accessibility standards. We make sure forms work on the desktop browser and also if required we can create one that can be used on a mobile device.
We can make the online forms have multiple levels of access. The form itself can be made accessible to everyone or only authenticated users. The results of the form can be made accessible to only admin level users or review level users. If your workflow involves form reviewers we can set up the form results to be viewed only by reviewers and we can also have fields that only reviewers can view and edit. For example, a reviewer can approve a form entry by checking a box on the same form entry.
Security and Encryption
The websites and databases that host the forms will have authentication via users’ Duck IDs that can be restricted to only a few users, or open registration. We can set up different access levels as needed, for example seperating administrators from regular users. All form entries can also be encrypted if this is needed.
CASIT would like to remind you that backing up your computer is very important. The summer offers a great opportunity to take time to setup backups or to ensure that your backups are working as intended.
10 GB Home Folders
For CAS faculty and staff, CASIT offers access to a free 10 GB “home folder” on our servers. That can be a convenient place to save files that need to be accessed from multiple computers, or that should be carefully backed up. Please let us know if you’d like more information or you want us to show you how to easily access your home folder.
If you need to store more than 10 GB, you may need a backup solution tailored to your needs. CASIT offers consultation to assist with:
- Windows or Mac operating systems
- Securely sharing data with others
- Remote or local backups
- Any amount of data
Some backup systems, despite being set up correctly and functioning to begin with, may have stopped functioning at some point. It’s a good idea to check every now and then to make sure your backup system is in full order. The worst time to discover your backups weren’t running is when you need to recover your data! If you’re unsure how to check, CASIT can help you confirm that your backup system is working as expected.
Copy charts from spreadsheets into documents and drawings. Start by creating a chart. Then, select the chart by clicking on it once, which will display the chart’s name. Click the chart name or the arrow next to it to open the dropdown menu of chart actions. From the menu, select Copy chart.
Next, open the document or drawing where you’d like to insert the chart and position the cursor where you’d like the chart to go. Use the Web Clipboard dropdown menu, as shown below, to locate your copied chart.
As you hover the mouse over the menu item for the chart, a thumbnail will be displayed. Clicking on the chart item will paste it into the document as an image, which can then be resized, aligned, etc. Here’s an example of a chart pasted into a document:
Note that the chart snapshots are just that — they are images of the chart at the time of copying and therefore do not update as the spreadsheet data changes. If you need to update a chart, just copy and paste it again.
The name of the chart shown in the Web Clipboard menu is the same as the chart’s name in the spreadsheet, which you can easily change from the default name, “Chart 1.” To rename a chart, select Edit chart from the chart’s action menu, and enter a new name on the Customize tab. This is particularly handy when working with charts from multiple spreadsheets.
We’ve also introduced a few new types of charts to Google spreadsheets. We now support candlestick charts and combo charts (which allow you to show columns, lines, and area lines all on the same graph). You can also use the GeoMap chart to insert a data-driven map of the world, a continent, or a country into your spreadsheet. Our TreeMap chart, meanwhile, should be exciting for the statisticians and logicians among you.
This makes creating great documents easy as pie (charts, of course).
If someone sends you a ZIP or RAR file in Gmail, you’ll be able to view its contents from within your browser by clicking on View.
This will bring up a view that includes all of the files in the archive, the file types, and the size of those files.
When you hover over the list you can activate a menu by clicking Actions. You’ll be able to View items supported by Google Docs Viewer and Print (PDF) those that we offer PDF support. Save to Google Docs and Download appear for all files.
ZIP and RAR archives that are embedded inside other archives also work. For example, if you have a RAR file inside a ZIP file (like in our example above) you can just click on that file to access the embedded archive.
Go ahead and try the feature by viewing a ZIP file.
This feature extends to Google Docs for mobile, too. For each viewable file (including embedded ZIP or RAR archives) there is a link to view.
This removes the need to download full archives when you only need to work on select items.