Year 11 ICT
DUE Date: Thursday, December 1
0 Comments
Excel Task 12b:
Produce a graph or chartIn the examination, you may be asked to select an appropriate chart for a purpose. Which chart is the most appropriate is often very difficult to work out. For the practical examination, the choice will be between a pie chart, a bar chart and a line graph. Pie charts:
Creating a chartTo create a chart, you have to highlight the data that you wish to use. This is highlighted in the same way as before. If all the data is together (contiguous data) this is easy. Sometimes in the practical examinations you will need to highlight data that is not kept together in the spreadsheet (non-contiguous data). To do this, hold down the <Ctrl> key whilst making your selections.
Before you try to sort any data, make sure that you select all of the data for each item to be sorted. One common error in practical examinations is to select and sort on a single column. If you were to do this, the integrity of the data would be lost. Table 4.6 gives an example showing correct and incorrect sorting on the student’sname for a spreadsheet containing their test results in Maths and English. Theyellow shaded cells show the areas selected for the sort. Note how the results foreach person have been changed when sorting without highlighting all the data.
Excel Task 10:
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):
The term ‘look up’, as used in the practical examinations, means to look up from a list. It does not mean that you should use the LOOKUP function, as there are three variations of the LOOKUP function that can be used within Excel. These are: LOOKUP, HLOOKUP and VLOOKUP. LOOKUP HLOOKUP VLOOKUP
You will be starting a touch typing program which will form part of your mark for Year 10 ICT.
The ability to touch type is vital in order to speed up your working efficiency. In order to do this, you will need to create an account by clicking here. Following this link will join you to the Year 11 class. The IF Function: An IF function contains a pair of brackets and within the brackets three parts, each separated by a comma. An example of an IF function is =IF(A1=5,A2*0.05,"Nodiscount"). The first part is a condition; in this example, it is testing to see if cell A1 contains the number 5. The other two parts are what to do if the condition is met,and what to do if it is not met. If the condition is met a number or label could be placed in the cell, or a reference to another cell, or even a calculation that needs to be performed. The same range of options applies if a condition is not met. In this example, if the condition is met, the result of multiplying the contents of cell A2 by the figure 0.05 is displayed in this cell. If the condition is not met this cell will display the text ‘No discount’.
Nested IF Statement - Spreadsheet Task 6:
Use the same file that you created in Task 5. Change the formulae in cells D3 to D21 to display ‘Not experienced’ if they have less than five years’ experience, ‘Experienced’ if they have five or more years’ experience and ‘Very experienced’ for employees with ten or more years’ experience. Save the document as a pdf showing formulae as [Spreadsheet_Task6_YOURNAME_form] Upload both your files to your Google Drive in the Spreadsheet/Excel folder. |
LINKSPractical Archives
May 2017
Categories
All
|
ContactTelephone:
+974 4450 2172 School Mobile +974 5536 9675 |
|