VCE ICT UNIT 3 TASK 3
SPREADSHEET TECHNICAL DOCUMENTATION
THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE HOME PAGE
THE PRINTED REPORT OF THE HOME PAGE
THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE INPUT PAGE
THE PRINTED REPORT OF THE INPUT PAGE
THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE CALCULATIONS PAGE 1
THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE CALCULATIONS PAGE 2
THE PRINTED REPORT OF THE CALCULATIONS PAGE 1 AND 2
...This is a preview of the whole essay
THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE HOME PAGE
THE PRINTED REPORT OF THE HOME PAGE
THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE INPUT PAGE
THE PRINTED REPORT OF THE INPUT PAGE
THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE CALCULATIONS PAGE 1
THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE CALCULATIONS PAGE 2
THE PRINTED REPORT OF THE CALCULATIONS PAGE 1 AND 2
THE LAYOUT OF SCREEN REOPRTS & MACROS USED IN THE 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
- Sorting and Subtotalling
- List boxes and drop down boxes to select data entry
- named cell and ranges for use in formulas
- Protecting cells by hiding and locking cells
- control buttons to initiate macros
- multiple sheets with links between them
THE LIST OF NAMED WORKSHEETS
- Home
- Input
- Calculations
- Backup
- Data
- Graphs
- Test plan
A TEST SPECIFICATION WITH EXAMPLES OF TESTS
RECORDS OF THE SYSTEMS DEVELOPMENT AND CHAGES YOU MADE DURING THE DEVELOPMENT
This how the first input page looked: