Session 6: Data Collection/Excel
Katie Derington, PharmD
October 25, 2018
Please note that during the ASPIRE session, all examples will be completed using Microsoft Excel ® 2013 for PC. This is highly similar to Excel® 2016 for MAC (with very minor differences), but has some significant differences from Excel ® 2011 for MAC.
During ASPIRE, we will go through some practice Excel manipulations. If you have Excel® 2011 for MAC and are concerned about following along, you may consider using an alternative device with other versions or Excel.
Due to connectivity issues at Kaiser, please be sure to download all materials needed for this session BEFORE coming to Kaiser.
Katie Derington, PharmD
October 25, 2018
Please note that during the ASPIRE session, all examples will be completed using Microsoft Excel ® 2013 for PC. This is highly similar to Excel® 2016 for MAC (with very minor differences), but has some significant differences from Excel ® 2011 for MAC.
During ASPIRE, we will go through some practice Excel manipulations. If you have Excel® 2011 for MAC and are concerned about following along, you may consider using an alternative device with other versions or Excel.
Due to connectivity issues at Kaiser, please be sure to download all materials needed for this session BEFORE coming to Kaiser.
- Pre-Session assignment:
- Consider what data collection tools you are going to use for your research project.
- Make a draft of your data collection tool and bring it to the ASPIRE session.
- Link to example data collection tool
- Optional Pre-Work:
- If you have not spent very much time using Excel before, I recommend that you review basic information about Excel (links listed below) prior to the ASPIRE session.
- Session Materials:
- Large Group Session Slides
- Large Group Session Recording
- Large Group Session Handout
- Practice Data Set
- ASPIRE_Excel 2013 PC and Excel 2016 MAC Guide
- ASPIRE_Excel 2011 MAC Guide
- We will breakout into small workgroups to practice LG session tools (No Small group session)
- Optional Readings: N/A
- Useful Tools: (See "Research Tools" for additional links)
- Supplemental Slide Set
- Excel ® 2011 (MAC)
- Excel ® 2016 (MAC)
- Excel® 2013 (PC)
- Basic Excel® Tasks for Excel® 2013 (PC)
- The Fill Handle for Excel® 2013 (PC)
- Create an Excel Workbook- Watch "Add formulas and references" section
- Overview of Formulas in Excel® 2013 (PC)
- Supplemental Slide Set