Every year we are challenged with finding the best way of recording results
for sports carnivals. There are a couple of challenges. The first challenge is
recording the names of the students both quickly and accurately. I like to
pre-populate the students names, because modern day names are spelt in all
sorts of different ways. I don’t want to offend any student so creating a query
to mine the main admin DB and populating a list of some kind is the best
approach to avoid misspelling. Traditionally we have used excel, but I like
sharepoint because sharepoint gives you a couple of advantages over excel. The
first advantage is the use of views. When the pressure is on, data entry ease
and speed are important. It is not uncommon for recorders to put the results
for breaststroke in the backstroke column, so views allow you to eliminate this
problem. SharePoint also automatically fills the dropdown box of names,
allowing you to find students in your SharePoint list very quickly.
In this picture, my sharepoint
list consists of choice fields and calculated fields. The choice fields are for
the place the student achieved in the event, and the points are automatically
calculated based on place. I have provided an example nested formula below. I
found that I had to use quotation marks around all integers which is slightly different
from the microsoft formulae’s site.
The other great thing about
sharepoint lists is that you can group data, and therefore determining house
champions and age group champions becomes a very easy task.
There is one hurdle that you will need to overcome using a
sharepoint list in this capacity however. The essence of this problem is that
sharepoint lists can not total a single field (down a column). Some work
therefore has to be done in sharepoint designer. I have provided a link to Laura
Rogers screencast that will guide you through achieving this process.
Unfortunately for me I think I
have a different version of designer. My version of designer is 2010. I have
provided a screenshot of how to sum calculated columns within a sharepoint