• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  • Level: GCSE
  • Subject: ICT
  • Word count: 676

SPREADSHEET TECHNICAL DOCUMENTATION

Extracts from this document...

Introduction

SPREADSHEET TECHNICAL DOCUMENTATION SPREADSHEET TECHNICAL DOCUMENTATION 1 THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE HOME PAGE 2 THE PRINTED REPORT OF THE HOME PAGE 2 THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE INPUT PAGE 3 THE PRINTED REPORT OF THE INPUT PAGE 3 THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE CALCULATIONS PAGE 1 4 THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE CALCULATIONS PAGE 2 4 THE PRINTED REPORT OF THE CALCULATIONS PAGE 1 AND 2 5 THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE BACKUP PAGE 6 THE PRINTED REPORT OF THE BACKUP PAGE 6 THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE DATA PAGE 7 THE PRINTED REPORT OF THE DATA PAGE 7 THE LAYOUT OF SCREEN REOPRT AND PRINT ...read more.

Middle

BACKUP PAGE THE PRINTED REPORT OF THE BACKUP PAGE THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE DATA PAGE THE PRINTED REPORT OF THE DATA PAGE THE LAYOUT OF SCREEN REOPRT AND PRINT REPORT IN THE GRAPHS PAGE THE LAYOUT OF SCREEN REOPRT AND PRINT REPORT IN THE TESTPLAN PAGE THE FORMULAS USED (ANNOTATED PAGES BY HAND AFTER END OF THIS PAGE) 6 COMPLEX FEATURES USED 1. Sorting and Subtotalling 2. List boxes and drop down boxes to select data entry 3. named cell and ranges for use in formulas 4. Protecting cells by hiding and locking cells 5. control buttons to initiate macros 6. multiple sheets with links between them THE LIST OF NAMED WORKSHEETS 1. ...read more.

Conclusion

and remove subtotals macro work Na/ When clicking each macro one should create all the subtotals and once should remove them When clicked each macro one created all the subtotals and one removed them None worked fine 6 test that multiple work sheets are working n/a when some thing is entered in input its shown in calculations Nothing was shown Went back to formula changed it then re tested in test no. 7 7 Re test that multiple work sheets are working n/a when some thing is entered in input its shown in calculations when some thing was entered in input it1s shown in calculations None RECORDS OF THE SYSTEMS DEVELOPMENT AND CHAGES YOU MADE DURING THE DEVELOPMENT This how the first input page looked: ?? ?? ?? ?? VCE ICT UNIT 3 TASK 3 1 MITHUN CHANDARANA ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. User Documentation for ICT A Coursework 2a

    1.2 Processing and Outputting Data [3 marks] 1.2.1 Producing Results [1-3] You need to show the user how to: Run all pre-existing queries Query on xbox 360 games To run all pre existing queries first of all, you need to open them first in design view So for this you

  2. System administration report

    System Analysis: The hardware and software that the hotels uses and that employees work on. Training procedures: The different types of training provided by the hotel along with a feedback session to show how effective the training programme was. Security issues: The security features of the hotel, is it well organised and well secure from potential threats.

  1. Develop a spreadsheet application for the Ibis Hotel.

    I happen to think that it is a great idea to change all the manual administrative work done in the Hotel into computerized data. I anticipate that you will be the right person to rely on. I accept the request you have sent me.

  2. Document layout and presentation.

    * Fonts, styles and sizes - The most common styles are: * Italic * Bold * Underlined The most common effects are: * Strikethrough * SMALL CAPS * Superscripted * Subscripted * ALL CAPS * Justification - Fully justifying text means making both the left and right margins even.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work