Year 11 ICT
Testing the data modelDesigning a test plan and choosing your test data are the most important parts of testing the data model. Choose data that will test every part of a condition. Be careful to test each part of the spreadsheet with normal data that you would expect to work with your formulae, with extreme data to test the boundaries and with abnormal data that you would not expect to be accepted. Carefully check that each formula and function works as you expect it to by using simple test data. For example, to test the look-up used in Excel Task 8b (your last Excel task):
Many marks are lost in practical examinations by careless use of ranges within formulae and functions. Check that everything works before using real data in your model. Selecting subsets of dataThis means getting Excel to search through data held in a spreadsheet to extract only rows where the data matches your search criteria. Filtering Task (Excel Task 9):
0 Comments
Your comment will be posted after it is approved.
Leave a Reply. |
LINKSPractical Archives
May 2017
Categories
All
|
ContactTelephone:
+974 4450 2172 School Mobile +974 5536 9675 |
|