Creating a Swimming Carnival IS using SharePoint

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.

http://msdn.microsoft.com/en-us/library/bb862071.aspx

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.

http://www.endusersharepoint.com/2009/09/01/get-it-together-groups-and-totals-in-the-data-view-web-part-screencast/

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
list.

Good Luck

 

 

Advertisements

About whellmuth

Working with the education software industry to build software with standard arhitectures that allows schools to have extensible and well integrated technologies. Member of Software QLD. Member of Microsoft advisory board on cloud computing. My doctorate specialises in Software Architecture in the Education environment. My Master Research specialised in IT change management.
This entry was posted in Microsoft SharePoint. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s