Job Detail

  1. Home
  2. Data Analysis
  3. Job detail
Freelancers

Compile Feedback from CSV Files

  • Job typeJob type: Remote
  • Job Duration01 to 03 months
  • Project LevelBasic Level
  • Project deadlineNovember 14, 2021

Project detail

I run a trade school, and, after each class we collect feedback from our instructors using Gravity Forms on a WordPress website.

The entries of this form are available for us to manually download as a CSV file as needed.

I am looking for way to be able to:
1) Take the information from the CSV file, format it into a simple report (see examples attached) including comments and add some simple averages for a total feedback scores
2) Send the feedback form to the specific instructors with one click.  If we have a list of the instructor ID, name, and email, then I am hoping that our admins can review and send these forms to all instructors at once to save them time.

I imagine some custom VBA and/or application forms will be needed here.  Ideally, our admins would simply open this Excel file, be prompted by a form, choose the CSV file, have the opportunity to review, and then one click to send the individual feedback form to the individual instructors.

3) Compile averages for all instructors across all classes.  Have filters by date range.

I look forward to finding someone with experience in these areas who can help us build a better long term solution.

Thanks.

Hourly Range: $30.00-$65.00

Posted On: October 14, 2021 16:48 UTC
Category: Data Analytics
Skills:Microsoft Excel, Excel VBA, MS Excel, Spreadsheets, Data Analysis, Email

Country: United States

click to apply

Industry Categories

Languages required

Project Completion deadline

November 14, 2021