ICT oxford school Azuero

 Legal framework / Data Protection Act Data Protection Act The Data Protection Act (DPA) is a law designed to protect personal data stored on computers or in an organised paper filing system. The need for the Data Protection Act During the second half of the 20th century, businesses, organisations and the government began using computers to store information about their customers, clients and staff in databases. For example: names addresses contact information employment history medical conditions convictions credit history Databases are easily accessed, searched and edited. It’s also far easier to cross reference information stored in two or more databases than if the records were paper-based. The computers on which databases resided were often networked. This allowed for organisation-wide access to databases and offered an easy way to share information with other organisations. The  data, information and databases  section has more on  searching databases . Misuse ...

  Sort a Table To sort by Last Name first and Sales second, execute the following steps. 1. Click the arrow next to Sales and click Sort Smallest to Largest. 2. Click the arrow next to Last Name and click Sort A to Z. Result. Filter a Table To filter a table, execute the following steps. 1. Click the arrow next to Country and only check USA. Result.

  Charts A simple chart in Excel can say more than a sheet full of numbers. As you'll see, creating charts is very easy. Create a Chart To create a line chart, execute the following steps. 1. Select the range A1:D7. 2. On the Insert tab, in the Charts group, click the Line symbol. 3. Click Line with Markers. Result: Note: enter a title by clicking on Chart Title. For example, Wildlife Population. Change Chart Type You can easily change to a different type of chart at any time. 1. Select the chart. 2. On the Design tab, in the Type group, click Change Chart Type. 3. On the left side, click Column. 4. Click OK. Result: ...

  Drop-down List   Drop-down lists  in  Excel  are helpful if you want to be sure that users select an item from a list, instead of typing their own values. Create a Drop-down List To create a drop-down list in Excel, execute the following steps. 1. On the second sheet, type the items you want to appear in the drop-down list. Note: if you don't want users to access the items on Sheet2, you can hide Sheet2. To achieve this, right click on the sheet tab of Sheet2 and click on Hide. 2. On the first sheet, select cell B1. 3. On the Data tab, in the Data Tools group, click Data Validation. The 'Data Validation' dialog box appears. 4. In the Allow box, click List. 5. Click in the Source box and select the range A1:A3 on Sheet2. 6. Click OK. Result: Note: to copy/paste a drop-down list, select the cell with the drop-down list and press CTRL + c, select another cell and press CTRL + v. 7. You can also type the items directly into the Source box, instead of using a range...