Database Applications.
Each student has been assigned a type of database activity to research on. Your findings should be categorized as below.
a) Describe how the database is used, giving atleast the name of the database and who uses it.

b) Mention the benefits of using the idenitified database

c) what are the challenges of using the database identified

d) Mention at least 4 issues or concerns arising from the use of the database in the given area.

Anita: Databases and crime prevention e.g as used by the police.

Yasmina : Databases in airports

Roshni: Databases in Transporting companies.

Halpreet: Databases in used in Ports Authorities

Tefiro: Databases in schools or other learning institutions

Harsh:Database in Hospitals

Nicole: Databases used by Government.

Susan: Databases in research institutions; e.g NASA

Namara: Databases Used by Governments

for IB2s

Database Task " Murder on the Mountain" for IB2s
We are going to use the following site for the class task today.
(Credit to the VHS Mr. Moore)
http://britvillager.com/db.html

1. Download the xls file into your folder or desktop.

2. Create a new database by importing the excel file downloaded

3. carry the tasks in the worksheet provided.


Please note that all the saved work will be checked.

Find some summary database notes on http://www.geekgirls.com/databasics_01.htm

Word processing Activites and Spreadsheet (revision for IB2s)

Word processing Activites (revision for IB2s)
Attempt the following word processing and save the work in the student folder.

Task one
Type the following document in the PDF document in the link below in a word processing document.
http://www.teach-ict.com/ecdl/module_3/resources/Watertext.pdf


Follow the instructions in the next link to act on the document typed.

http://www.teach-ict.com/ecdl/module_3/resources/Watertask.pdf



Task Two
You may type the following document in the PDF document in the link below or search for it and copy in a word processing document.
http://www.teach-ict.com/ecdl/module_3/resources/mobile_phones.pdf


Follow the instructions in the next link to act on the document typed.

http://www.teach-ict.com/ecdl/module_3/resources/Mobile_Phones_Task.pdf



Task Three
Mail Merge
Type the letter below and save it in your folder
http://www.teach-ict.com/ecdl/module_3/resources/fancydress.pdf


then mail merge with the addresses in the following database
http://www.teach-ict.com/ecdl/module_3/resources/fancydress.mdb

Spreadsheet Terminologies
Please refer to the links below for spreadsheet terms.

http://spreadsheets.about.com/od/excel101/tp/080726_ten_spreadsheet_terms.htm


http://www.rcs.k12.va.us/bles/spreadsh.htm


Attempt the following exercises
Task 1
http://www.homeandlearn.co.uk/ME/mes1p8.html


Task 2
Click on the link below for the activity instructions and the next link for the spreadsheet. Save your the work in your students folder.

http://www.teach-ict.com/ecdl/module_4/resources/Ski.pdf


http://www.teach-ict.com/ecdl/module_4/resources/Ski.xls


Task 3
http://www.homeandlearn.co.uk/ME/mes5p3.html


Find other revision task next
http://www.teachnet.ie/mhickey/2005/worksheetquizzes.html

Spreadsheet "What if" analysis exercises
Attempt the following task on "what if" analysis

http://web.utk.edu/~dhouston/excel/exer3.pdf

For IB2

Telemedicine (Area of Impact Health) HL
1.
Define Telemedicine? [2 marks]
2.
Describe two of the technologies involved in telemedicine [4 marks]
3.
Explain two barriers to the use of telemedicine? [4 marks]
4.
Discuss three advantages of telemedicine. Evaluate your arguments[10 marks]
1. Pick any of the news articles on health in the following link http://www.ehealthnews.eu/ and Prepare a presentation following the format below

a) Describe the technology
b) State any social/ethical issues arising
c) State the effects of the technology
d) Desrcibe at least a solution to a single problem identified.

2.
a) What is meant by the term ‘telemedicine’?

b) Outline the different tasks the doctor can do with telemedicine.

c) Describe the different hardware and software requirements for successful telemedicine.

d) Find a range of news articles that mention telemedicine – what issues are raised in these articles.
http://home.businesswire.com/portal/site/google/index.jsp?ndmViewId=news_view&newsId=20060424005120&newsLang=en
http://bjournal.com/2005/content/article_views.php?ID=1300&Author=121
http://home.businesswire.com/portal/site/google/index.jsp?ndmViewId=news_view&newsId=20060419005571&newsLang=en\
http://www.kfmb.com/features/healthcast/story.php?id=44895
http://news.bbc.co.uk/2/hi/uk_news/england/4313353.stm
http://news.bbc.co.uk/2/hi/uk_news/scotland/3727779.stm

e) Privacy of patient information is always a concern for both patients and doctors. Create a table below which included the possible risks for data being accessed by unauthorized people and the solutions to this
SECTION 2
Perform the task given below on Robotic Surgery

1. What is Robotic Surgery?

2. Describe the Worlds First Telesurgery.http://findarticles.com/p/articles/mi_m0EIN/is_2001_Sept_20/ai_78427951

3. How does it Work?

Read How Stuff Works: How Robotic Surgery will work and either photocopy the article and highlight the main points or summarise it into your own words.

Also visit the following website:
http://www.xvivo.net/ and visit Animations / robotics, DARPA http://www.blinkx.com/burl?v=MqGnJNB2puKXdJiOLcCMeY1WlwmjBhpQLPHL5w for a short video and do some of your own research

EHR Medical Systems
1. Define an EHR system? [2 marks]
2. Explain two ways an EHR system benefit society? [4 marks]
3. Explain two of the reasons why EHR's are not yet widely used. [4 marks]
4. Discuss three social or ethical concerns people have with EHR? [10 marks]