Office of Curriculum and Assessment
Virtual Visit Request info Apply
MENUMENU
  • Degree Program Expectations & Reporting
    • DPE How-to Guide
    • Annual Curriculum & Assessment Reporting Requirements
    • Academic Program Reviews & Discipline-Specific Accreditations
    • DPE Inventory
    • DPE Archive
  • Curriculum Proposal Resources
  • Assessment Process and Resources
  • Curriculum and Assessment Committees
  • Staff Directory
  • IN
  • Office of Curriculum and Assessment
  • Storing Qualitative and Quantitative Data

Storing qualitative and quantitative data

There are two storage tasks to complete in the data collection process:

  • Selecting an electronic storage system
  • Ensuring the security of the information stored

How to complete the storage tasks Accordion Closed

First, you will want to select an electronic storage system wherein all of the information/data and examples of student work are filed. The most sustainable electronic storage system is one that your faculty already know how to use and are comfortable using. Because assessment is a shared endeavor, consider identifying a method that can be shared by faculty. All of the following have been used successfully by faculty across the campus: BlackBoard Learn, Google Shares, a Shared Drive, SharePoint, Dropbox, and many others.

Whatever methods are used, it is generally a good idea to back up the files onto a departmental drive. Many programs track direct measures by creating electronic databases/ACCESS/Excel spreadsheets, and statistical packages such as SPSS, etc. to store data for later analysis. The database will typically lists all students completing the measure and their performance on the measure. Remember that if you want to link the assessment data to measures in LOUIE, such as when they took certain classes, incoming HSGPA, etc., you will want to collect their STUDENT ID as well.

Example of a program database illustrates how to compile the database of assessment data:

Last Name

First Name

Year

Rubric Row 1: LO5

Rubric Row 2: LO4

Rubric Row 3: LO5

Allan

Jane

Senior

4

5

4

Miller

Larry

Senior

5

3

5

Smith

Bob

Senior

3

4

4

Bloom

Desmond

Junior

4

3

4

Jones

Robin

Junior

5

4

4

Smith

Troy

Junior

5

4

5

Second, you want to make sure that the data you collect is secured. Because this database will have individual student information, it is very important to ensure it remains secure and that only faculty and staff involved in the assessment activity have access to the contents. As noted in the section about keeping data work secure, student work is protected by The Family Educational Rights and Privacy Act (FERPA) (20 U.S.C. § 1232g; 34 CFR Part 99). To comply with FERPA regulations, student work should either be maintained in a secure system with access limited to those involved in assessment. Only if it is not possible to maintain the data on a secure system should the unit have all personally identifiable information removed. The moment personally identifiable information is removed, no further analyses can be conducted on the data, as the data can no longer be matched to other data that is maintaining within LOUIE, CIVITAS, or other data collection systems at NAU. This can severely limit the ability to use the data to inform decisions and make changes and improvements within the unit.

Additionally, it is recommended that samples of students’ work be stored to document the assessment process. Generally, for each direct measure, an example at each level of the performance standard should be saved. If possible, scan the student’s work, converting it into an electronic file, as electronic copies of student work can reduce space required for storage and allow the original work to be returned to the students.

Enlist the assistance of assessment and testing specialists when you plan to create, adapt, or revise assessment instruments. Staff in the Office of Curriculum, Learning Design & Academic Assessment are happy to assist you in finding the appropriate resources and helping you to design the assessment. Areas in which you might want to seek assistance include:

  • ensuring validity and reliability of test instruments;
  • ensuring validity and reliability of qualitative methods;
  • identifying appropriate assessment measurements for specific goals and tasks; and
  • analyzing and interpreting quantitative and qualitative data collected as part of your assessment plan.

Adapted from Western Washington University’s Tools & Techniques for Program Improvement: Handbook for Program Review & Assessment of Student Learning (2006)

Welcome
Location
Building 60
Student and Academic Services Building
1100 S. Beaver Street
Flagstaff, AZ 86011
Mailing Address
PO Box 4091
Flagstaff, AZ 86011
Email
curriculum.assessment@nau.edu
Phone
928-523-5291
Fax
928-523-1922