Pearson BTEC Unit 5: Data
Modelling Learning aim – B
& C | Level 3 qualifications in
Information Technology
,Table of Contents
Abstract....................................................................................................................................................... 3
Assignment Title.........................................................................................................................................3
Introduction................................................................................................................................................ 3
Learning aim - B - Functional Specification................................................................................................3
Nature of the problem............................................................................................................................3
Functions the model must perform........................................................................................................3
Use interface and navigation..................................................................................................................3
Success criteria........................................................................................................................................4
Spreadsheet model design.........................................................................................................................3
Producing worksheet structurediagrams for layout presentation.............................................................3
Processing and Output................................................................................................................................3
Test data................................................................................................................................................3
Test data................................................................................................................................................3
Test data................................................................................................................................................3
Data entry and Validation...........................................................................................................................3
Test data................................................................................................................................................3
Test data...............................................................................................................................................3
Reviewing and refining data model designs...............................................................................................3
Communicating with Clients.................................................................................................................3
Gathering feedback from Clients..........................................................................................................3
Scheduling and documenting meetings................................................................................................3
Adjusting timescales.............................................................................................................................3
Refining ideas and solutions.................................................................................................................3
Updating design specification documentation.....................................................................................3
Conclusion................................................................................................................................................... 3
Learning aim - C - Developing a data model solution.................................................................................3
Processing features and requirements.......................................................................................................3
Formulae..............................................................................................................................................3
Functions..............................................................................................................................................3
Logical functions...................................................................................................................................3
Data manipulation (sorting, grouping, filtering, Pivoting data..............................................................3
, Importing and exporting data...............................................................................................................3
Cell referencing and autofill..................................................................................................................3
Using macros........................................................................................................................................3
Using buttons to initiate procedures....................................................................................................3
Use of data entry forms........................................................................................................................3
Protecting cells (locking and password protection)..............................................................................3
Automated data transfer......................................................................................................................3
User prompts and messages................................................................................................................3
Output requirements..................................................................................................................................3
Testing functional requirements specification........................................................................................3
Test data...............................................................................................................................................3
Test data...............................................................................................................................................3
Test data...............................................................................................................................................3
Other factors to consider........................................................................................................................3
Reviewing and refining data model solution..........................................................................................3
Skills and behaviour...............................................................................................................................3
Media & communication skills...............................................................................................................3
References and ibliography ........................................................................................................................3
edit
Abstract
Modelling Learning aim – B
& C | Level 3 qualifications in
Information Technology
,Table of Contents
Abstract....................................................................................................................................................... 3
Assignment Title.........................................................................................................................................3
Introduction................................................................................................................................................ 3
Learning aim - B - Functional Specification................................................................................................3
Nature of the problem............................................................................................................................3
Functions the model must perform........................................................................................................3
Use interface and navigation..................................................................................................................3
Success criteria........................................................................................................................................4
Spreadsheet model design.........................................................................................................................3
Producing worksheet structurediagrams for layout presentation.............................................................3
Processing and Output................................................................................................................................3
Test data................................................................................................................................................3
Test data................................................................................................................................................3
Test data................................................................................................................................................3
Data entry and Validation...........................................................................................................................3
Test data................................................................................................................................................3
Test data...............................................................................................................................................3
Reviewing and refining data model designs...............................................................................................3
Communicating with Clients.................................................................................................................3
Gathering feedback from Clients..........................................................................................................3
Scheduling and documenting meetings................................................................................................3
Adjusting timescales.............................................................................................................................3
Refining ideas and solutions.................................................................................................................3
Updating design specification documentation.....................................................................................3
Conclusion................................................................................................................................................... 3
Learning aim - C - Developing a data model solution.................................................................................3
Processing features and requirements.......................................................................................................3
Formulae..............................................................................................................................................3
Functions..............................................................................................................................................3
Logical functions...................................................................................................................................3
Data manipulation (sorting, grouping, filtering, Pivoting data..............................................................3
, Importing and exporting data...............................................................................................................3
Cell referencing and autofill..................................................................................................................3
Using macros........................................................................................................................................3
Using buttons to initiate procedures....................................................................................................3
Use of data entry forms........................................................................................................................3
Protecting cells (locking and password protection)..............................................................................3
Automated data transfer......................................................................................................................3
User prompts and messages................................................................................................................3
Output requirements..................................................................................................................................3
Testing functional requirements specification........................................................................................3
Test data...............................................................................................................................................3
Test data...............................................................................................................................................3
Test data...............................................................................................................................................3
Other factors to consider........................................................................................................................3
Reviewing and refining data model solution..........................................................................................3
Skills and behaviour...............................................................................................................................3
Media & communication skills...............................................................................................................3
References and ibliography ........................................................................................................................3
edit
Abstract
