Unit 9 Assignment 1
Date issued:
Teacher: Rawa Baker
Final deadline:
Students: Yavor Todorov Panov Duration (appro
ID: 19021672 hours
, Introduction
I’m from administrator department where producing spreadsheets for footballing team, to be able handle infor
the club “season-ticket holder”.
I’ll produce the desire spreadsheet document that manager require from me.
The spreadsheet I’d been asked to produce:
Worksheet 1: Ticket-holder details
Worksheet 2 Ticket-holder details
Worksheet 3 Ticket-holder details
Each of this, I should create worksheet contain name, addresses and contain contact details of each ticket applica
Calculation and tools/techniques
We are going to use different tool and technique to improve the productivity and accuracy, to produce the desire spr
fulfil the manager requirement, such as (formatting , function, formulas, IF statement and macros);
Data input
We are going to use data entry to put the data into the ticket friendly! I should also put validation text on ticket whe
registered for any unexpected mistake.
, Before I create the spreadsheet, the manager has asked me to find out how that type of s
is used for real. The purpose of both spreadsheets is so that I can manage the data about
season ticket holders. This is going to help me as I don't need to rely on papers and we ha
electronic version which will be most useful to the manager.
How spreadsheets improve productivity
Spreadsheets improve productivity by allowing the users to use those function that can be
subtracting or searching for specific pieces of data and putting that data where it is neede
How spreadsheets improve accuracy
Spreadsheets improve accuracy by keeping track of the data inputted and allowing the use
complete and easy access to either read it or change/write data
Also the purpose is by creating those two spreadsheet by using costume modelling and sto
which will customize and make work more efficient, by calculating fast and make sure the
enough supplement in this football club. I should considering create spreadsheet table co
names, addresses and contact details of each ticket applicant
Date issued:
Teacher: Rawa Baker
Final deadline:
Students: Yavor Todorov Panov Duration (appro
ID: 19021672 hours
, Introduction
I’m from administrator department where producing spreadsheets for footballing team, to be able handle infor
the club “season-ticket holder”.
I’ll produce the desire spreadsheet document that manager require from me.
The spreadsheet I’d been asked to produce:
Worksheet 1: Ticket-holder details
Worksheet 2 Ticket-holder details
Worksheet 3 Ticket-holder details
Each of this, I should create worksheet contain name, addresses and contain contact details of each ticket applica
Calculation and tools/techniques
We are going to use different tool and technique to improve the productivity and accuracy, to produce the desire spr
fulfil the manager requirement, such as (formatting , function, formulas, IF statement and macros);
Data input
We are going to use data entry to put the data into the ticket friendly! I should also put validation text on ticket whe
registered for any unexpected mistake.
, Before I create the spreadsheet, the manager has asked me to find out how that type of s
is used for real. The purpose of both spreadsheets is so that I can manage the data about
season ticket holders. This is going to help me as I don't need to rely on papers and we ha
electronic version which will be most useful to the manager.
How spreadsheets improve productivity
Spreadsheets improve productivity by allowing the users to use those function that can be
subtracting or searching for specific pieces of data and putting that data where it is neede
How spreadsheets improve accuracy
Spreadsheets improve accuracy by keeping track of the data inputted and allowing the use
complete and easy access to either read it or change/write data
Also the purpose is by creating those two spreadsheet by using costume modelling and sto
which will customize and make work more efficient, by calculating fast and make sure the
enough supplement in this football club. I should considering create spreadsheet table co
names, addresses and contact details of each ticket applicant
