OCR-Estate Agents

Keywords Topic

Data protection act
Personal information
E Safety

Copy the Database

Starter-Effective participators

Worksheet-Discuss in pairs

Task 1(Pass/L5)-Effective participators

Inserting and Deleting Rows

Task 2(Pass/L5)-Effective participators

Changing Data

Task 3(Pass/L5)-Team workers

Queries

Peer assessment-Discuss your query with the person next to you. Does the query display the information it is supposed to? If the answer is no discuss what you have done wrong, and how to fix it.

Task 4(Merit/Distinction-L5/6)-Team workers

Complex Queries

Peer assessment-Discuss your queries with the person next to you. Do the queries display the information they are supposed to? If the answer is no discuss what you have done wrong and how to fix it.

ICT Challenge 1 (L6)-Independent enquires, Creative thinkers

Now create a query of your own. Think of a question a customer may ask then create the query for it. Ensure you print screen your query into work then fully explain it.

Peer assessment-Discuss your query with the person next to you. Does the queries display the information it was supposed to? If the answer is no discuss what you have done wrong and how to fix it.

ICT Challenge 2 (L6)-Independent enquires, Creative thinkers

Create a Data Collection form to help input new clients data into the Database

Forms

Task 5(Merit/Distinction) (L6/7)-Independent enquires

Reports-For distinction print all queries in report form

Task 6(Distinction/L7)-Independent enquires

Address Labels

Task 7 (Distinction/L7)-Team workers

Sort a query on two fields

Peer assessment-Discuss your query with the person next to you. Does the query display the information it is supposed to? If the answer is no discuss what you have done wrong, and how to fix it.

ICT Challenge 3 (L6)-Independent enquires, Creative thinkers

You need to consider how the Estate agents Database could be improved. Consider what things a customer may require in a property that the Database will not tell them. Visit the website below for help, then complete the Database planning form.

http://www.battandbrown.co.uk/

Planning Form

Extension 1

-Add the new fields to your Database

ICT Challenge 4 (L6/7)-Independent enquires, Creative thinkers

E-Safety

Click on the links below and read the information about keeping your personal information secure.

http://www.ncl.ac.uk/students/wellbeing/finance/information/protectingyourdetails.htm

http://portal.igindex.co.uk/support/HelpSolution?SolNumber=00001768&category=02n200000001UmaAAE&topCategory=02n200000001UmuAAE

In word explain how you can help protect your personal details

Peer assessment-In pairs read each others answers. Do you notice any spelling mistakes? Discuss and correct all spelling mistakes.

In word copy out all spelling mistakes 3 times to ensure you get them right next time.