ScholarDesk

ScholarDesk/Guides/Leaving the spreadsheet

Leaving the spreadsheet, without losing the history

The spreadsheet is not the enemy; it holds everything you know. The move is about carrying that history over in a usable state.

One click, no account. Open the coordinator desk or a student file; the data is fictional and nothing you change is kept.

Clean before you move

  • One row per student, one column per fact
  • The same spelling for each university and program
  • Dates as dates, amounts as numbers
  • One list of payments with the student and the term on each line

Move in this order

  1. Universities, with their terms and programs
  2. Students, with their university and award
  3. Past payments, linked to each student

That order matters because each step refers to the one before.

Check a sample by hand

Pick ten students and compare their total paid in the old file and in the new system. Differences found now are cheap.

Run one term in parallel

Keep the spreadsheet for one term while students send requests in the new system. Stop the spreadsheet when the two agree.

How this looks in ScholarDesk

The import handles universities, students and payments in that order, lets you match your columns and lists every row with a problem before adding anything.

Questions

Asked before the first call

How long does a move take?

It depends on the state of the data more than on its size. Cleaning usually takes longer than importing.

Live demo

Judge it on what it does.

ScholarDesk is a working application, not a mock-up. Open the coordinator desk, approve a request, record a payment, then switch to a student file and send one yourself.