Geo Sba

Only available on StudyMode
  • Topic: Spreadsheet, Sorting, Sorting algorithm
  • Pages : 4 (700 words )
  • Download(s) : 102
  • Published : December 23, 2012
Open Document
Text Preview
TOPIC: ROCK HARD GYM
SBA 2012-2013
SPREADSHEET MANAGEMENT
REGUIREMENTS AND ORDER OF PRINTING & BINDING

Prepared by: Walter Kirui & Mrs. Denis Ranger-Wilson & Kimberley Skyers

ORDER OF PAGE ORGANIZATIONS ALTERNATIVE A
Requirements:
* cover sheet
* Mark Scheme
* Acknowledgement
* Table of contents
* Introduction
* Worksheets (Gym members 1)
Question 1-4
* Trainers’ Information and their respective trainee members’ financial records * Trainers’ Information and their respective trainee members’ financial records Formulae

Question 5
* Trainers monthly summary sheet containing trainers’ names, total sessions attendance, total attendance fees due and commission Formulae * Trainers monthly summary sheet containing trainers’ names, total sessions attendance, total attendance fees due and commission Formulae

* Worksheets (Gym members 2)
Question 6-9
* Modification of Gym members 1 as per the instruction on the question paper. (Table must be sorted in ascending order after the changes has been made) * Formulae page of the above table.

* Worksheets (Gym members 3)
Question 10
* Sort the summary sheet in descending order by Total Attendance Fees Due * Sort the summary sheet in descending order by Total Attendance Fees Due formulae

Question 11
* Sort the trainers member worksheet (s) in ascending order by gym members Last name (primary sort), and then by Total Sessions (secondary sort) * Sort the trainers worksheet (s) in ascending order by gym members Last name (primary sort), and then by Total Sessions (secondary sort) formulae Question 12 (Use an advance filter to extract the required data from trainers’ summary table) * Information on trainers from the summary area whose session’s attendance is less than 100 sessions but have Commission greater than $3000.00. Criterion|

Session attendance| Trainer’s Commission ($)|
<100| >3000|...
tracking img