Description
A summer camp currently uses spreadsheets to process registrations for attendees of the camp. Attendees enter their registrations in an online form builder application (Wufoo), which generates the CSV files they work with. Currently, users use spreadsheets with the attendees to verify, correct and update information. For security purposes, users are not able to edit the database directly, so they keep 2 sets of records, log which records need to be updated, and then update them in the original data manually.
The proposed application would load a CSV and allows users to update the information, tracking which information needs to be manually updated in the original data source.
Target users
Administrator
Logged in user (user)
Tags
User Stories
Administrators
As an administrator, I can create new administrators and new users to provide access to the system.
Login
As an administrator or user, I need to be able to log in to keep the information in the system private
Edit
As an administrator, I need to be able to edit any information.
List
As a user, I need to be able to see all attendees information.
Filter
As a user, I need to be able to filter and view certain attendees' information. Filters include payment status, assigned registrar, records that are missing required data, and age groups.
User Edit
As a user, I need to be able to change most of attendees' information.
Changes
As a user, I need to be able to see which data elements have been changed.
Updates
As a user, I need to see if the changes made to data elements have been updated in the database.
List Changes
As an administrator, I need to be able to see a list of changes that have been made by users and need to be updated in the database.
Mark Updates
As an administrator, I need to be able to mark changed items as having been entered in the database.
History
As a user or administrator, I need to be able to see a history of the changes that have been made to the record for an attendee.
Additional Info
As a user, I need to track additional information beyond the information provided to me: notes about the status of an attendee’s information, dorm accommodations we assign, the status of financial payments, whether additional paperwork has been submitted, etc.
Emails
As a user, I need to be able to send structured emails to attendees in different scenarios and create additional structured documents (name tags, instructional documents with their information, etc). The information needs to come from the filtered information above.
Invoices
As a user, I need to be able to generate invoices for attendees or for several attendees (a family) on one invoice.