• 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. ICT Report 2b: ICT in Organisations

    It is highly advantageous because it is much faster, neater and formal than handwritten reports and can be done with ease. The only drawback that could be associated with this is that it makes staff less optimistic to jot down notes and makes them lazier (not even needing to move

  2. 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

  1. System administration report

    - Are records kept for software and hardware? Backup Procedures - How do you know which data should be backed up and which shouldn't? - How is data backed up? - What processes are performed? Social and Moral Issues - How are user desks laid out to reduce eyestrain and RSI?

  2. 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.

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