Geo Sba
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 |
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 |
Bibliography: Gay, Glenda. Oxford Information Technology for CSEC. Spain, 2009. King, George. Microsoft Excel 2000/2002 Made Simple. Jamaica West Indies, 2002.