The task scenario is based around organised open water swimming events where people pay to participate in different lengths of swim. Each event has an organiser who is responsible for specific lochs. Caterers can also hire pitches to offer refreshments on the day. Students are asked to do a variety of Database tasks including a database query, calculated field and report. There are plenty of Spreadsheet tasks including Nested IF Statement, CountIF and SumIF, LookUps, Sorting, Rounding and Pivot Tables.
***Solutions and a Student Help Guide are also included in this pack***