Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Spreadsheet

VIEWS: 32 PAGES: 4

									  ICT Division
  BTEC Level 3 Extended Diploma in IT (2011-12)
  Unit 42: Spreadsheet Modelling




                                                    Spread sheet system for Charlton FC.




         1. Investigation.                        2. Create the 1st                    3. Create the work                      4. Create the
                                                  worksheet for club                   sheet for details of                    worksheet for
                                                  details.                                   player.                         details of fixtures.



1.1 Investigate about club details.                                                                                        4.1 Rename the sheet to Fixtures
                                                  2.1 Rename it to the club name.    3.1 Rename the sheet to player
Such as ground capacity and
                                                                                     details.
ground name
                                                                                                                           4.2 Add list of games to be
                                                  2.2 Add hyperlinks to take the                                           played
                                                                                     3.2 Add player detail, their weekly
1.2 Investigate about player stats                user to the club’s website         wages and their category.
such as player names, player                                                                                               4.3 Add list of grades of the
category, and player wages
                                                  2.3 Add the name of the ground     3.3 Calculate annual wages            opposition

1.3 Investigate about team fixtures,                                                                                       4.4 Add the competition the
opposition grades and their home                  2.4 Find out the ground capacity
                                                                                                                           game played in
and away conditions.

                                                                                                                           4.5 Add the details about the
1.4 Investigate about tickets, their                                                                                       match if its Home or Away match.
prices and discount if any apply for
that term.
  Muhammad Yasir Uddin                                                                                                                            1|Page
  S45224225
    ICT Division
    BTEC Level 3 Extended Diploma in IT (2011-12)
    Unit 42: Spreadsheet Modelling




                       5. Create                    6. Create profit and            7. Customize the               8. Carryout
                        Tickets                             loss                       spreadsheet                 automation



                                                                                                                8.1 Add Macros in spreadsheet.
5.1 Rename the sheet to                        6.1 Predict future attendance   7.1 Add restricting data entry
Tickets.
                                                                                                                8.2 Add Active X control in
5.2 Add details of season                                                      7.2 Add Data Validation          spreadsheet.
                                               6.2 Predict income for home
tickets.                                       remaining games.
                                                                               7.3 Add error Messages.          8.3 Add Visual Basic in
5.3 Add details of the Away
                                                                                                                spreadsheet.
tickets.

5.4 Add details of the Home Fan
Tickets.

5.5 Calculate the income from
ticket sales




    Muhammad Yasir Uddin                                                                                                                  2|Page
    S45224225
        ICT Division
        BTEC Level 3 Extended Diploma in IT (2011-12)
        Unit 42: Spreadsheet Modelling




       9. Carry out analysis                            10. Produce a short        11. Produce test plan           12. Produce user
       and interpretation of                            document to compare        and results                     manual
       the data                                         different auto method



9.1 Convert Data                              10.1 Include Macros               11.1 Add Test Number            12.1 Create a user manual


9.2 Add Graphs and Charts.                                                      11.2 Include what is tested
                                              10.2 Include Active X control

9.3 Add Patterns and Results
                                                                                11.3 Include Expected Outcome

9.4 Draw Conclusion                           10.3 Include Visual Basic
                                                                                11.4 Include Actual Outcome




        Muhammad Yasir Uddin                                                                                                           3|Page
        S45224225
   ICT Division
   BTEC Level 3 Extended Diploma in IT (2011-12)
   Unit 42: Spreadsheet Modelling




             13. Produce a                                    14. Produce a guide                 15. Produce information about
             reference booklet                                                                    recommendation and
                                                                                                  improvement.


13.1 Include Formulas                              14.1 Produce a guide that has       15.1 evaluate the spread sheet
                                                   interpretation methods to analyse   model incorporating feedback from
                                                   data.                               others
13.2 Include Functions

                                                                                       15.2 Add recommendations          for
13.3 Include Validations                                                               improvements.


                                                                                       15.3 Carry out a survey


                                                                                       15.4 Produce a questionnaire


                                                                                       15.5 Collect the questionnaires


                                                                                       15.6 Produce a word processed document after modifications and add
                                                                                       explanations what has been modified.




   Muhammad Yasir Uddin                                                                                                           4|Page
   S45224225

								
To top