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]

Road Traffic surveillance

Check Smart cars

IB1- We are goiing to start on Bussiness and Employement as Area of Impact so Prepare
E-commerce
Prepare a presentation on the following
CLAIRE BETZ and JESHANI SAHMIT
a) What is online marketing?
b) How do you market online?
c) What are the effects of marketing online?
d) Discuss any social / ethical issues that arising from online marketing

LINDA AMUNA LAPENGA and TIHTINA HAILEAB
a) What is data mining?
b) How does data mining work?
c) What are the effects of data mining?
d) Discuss any social / ethical issues that arising from data mining

AISHWARYA SRINIDHI and ALICIA RAMOS
a) What is a spyware?
b) How has spyware been used in E-commerce?
c) What are the effects of using spyware in business?
d) Discuss any social / ethical issues that arising from using spyware in e-commerce

DHARTI G.PATEL and KALGI DESAI
a) How has IT systems been used in retailing, advertising and in the media?
b) What are the effects of using IT systems in retailing, advertising and in the Media?
d) Discuss any social / ethical issues that arising from the above


Banking and Finance
Take the first 2o minutes to research on the following and share your findings in the next 5 minutes. You may use www.howstuffworks.com to learn some of the terms

DHAVAL PATEL AND MAULIK RUPARELIA
a) What is an ATM?
b) How are ATM's Used?
c) What are the effects of using ATMS
d) Mention any issues arisings from the use of ATM's

SHUKLA VISHAL and CHRISPTOPHER LUBWAMA TENDO
a) What is EFT?
b) How are EFT's used?
c) What are the effects of using EFT's?
d) Mention any social/ ethical issues that relate to EFT's

MARAKA SAMSON TENDO And JESSANI HASMITA
a) What is internet banking?
b) How does internet banking work?
c) what are the effects of internet banking?
d) Mention any social / ethical issues related to internet banking

RAVI MASHRU and DAVID KIBIRIGE KASULE
a) What is Electronic cash?
b) How is electronic cash used?
c) what are the effects of using electronic cash?
d) Mention any social / ethical issues related to electronic cash

SHERINA MUTULUUZA and JOAN KIRABO NABUKEERA

a) What is internet brokerage?
b) How does internet brokerage work?
c) what are the effects of internet brokerage?
d) Mention any social / ethical issues related to internet brokerage

ZARAH DHARANI and SOLOMON KASUMBA

a) What is Electronic insuarance?
b) How does electronic insuarance work?
c) what are the effects of electronic insuarance?
d) Mention any social / ethical issues related to elctronic insuarance

Vernon and Martha
a) What is international commerce?
b) How are IT systems used in the management of transnational corporations?
c) What are the effects of using IT systems in management of transnational corporation
d) Mention any issue that relate to the use of IT system in transnational corporations.

Nassa and Hilda
a) What is teleshopping?
b) How does teleshopping work?
c) What are the effects of teleshopping?
d) Share any social/ethical issues that arise from teleshopping.

Business And Employment (Employment)
Prepare a presentation on the following topics, bring out important information such as, areas in use or applied, the effects and social/ethical issues that arise;
NOTE: USE A NEW ITEM

Sanyu and Carol
Job obsolescence as result of information technology

DHAVAL PATEL AND MAULIK RUPARELIA
Job retraining as result of Information technology

LINDA AMUNA LAPENGA and TIHTINA HAILEAB
Online job search

AISHWARYA SRINIDHI and ALICIA RAMOS and Kirabo
Employment surveillance

RAVI MASHRU and DAVID KIBIRIGE KASULE
Online Job recruitment

SHUKLA VISHAL and CHRISPTOPHER LUBWAMA TENDO and Sanyu
IT Jobs created as a result of IT

AISHWARYA SRINIDHI and ALICIA RAMOS and Kirabo
Jobs lost as a result of IT

CLAIRE BETZ and JESHANI SAHMIT and Vernon
Online job advertisement and teleworking

For all
Obtain individual notes and print a copy of the notes for marking on the following
a)
i) Internet service providers; Described.
ii) Examples of internet services providers in Uganda
iii) Social and ethical issues expected of internet service providers.
b) Internet Servers:Described and example given.
c) Internet browsers
i) Define a Internet browser,
ii) Name and describe the distinct features of 6 different types of internet browser,
d) Search engines
i) Define a search engine
ii) Name and briefly describe 6 types search engines stating their distinct features if any.
e) Electronic commerce
i) what is e-commerce
ii) How does e-commerce work
iii) What are the issues that arise from trading using e-commerce?


Business and Employment (Transportation)
Each individual student should prepare a presentation and handout on the following:

CLAIRE BETZ and JESHANI SAHMIT and Vernon
a) Identify the reservation systems used in different areas.

b) Describe the three organization or companies that use the reservation systems.

c) Discuss the effects of using the reservation systems( Advantages & disadvantages)

d) Analyse social/ethical issue that arise from using the reservation systems.

LINDA AMUNA LAPENGA and TIHTINA HAILEAB and Nassa

a) Identify the luggage processing systems used in different areas.
b) Describe the three organization or companies that use the luggage processing systems.
c) Discuss the effects of using the luggage processing systems( Advantages & disadvantages)
d) Analyse social/ethical issue that arise from using the luggage processing system .

AISHWARYA SRINIDHI and ALICIA RAMOS and Kirabo
a) Identify the navigation systems used in different areas.
b) Describe the three organization or companies that use the naviagtion systems.
c) Discuss the effects of using the navigation systems( Advantages & disadvantages)
d) Analyse social/ethical issue that arise from using the navigation systems.

DHARTI G.PATEL and KALGI DESAI and Shelina
a) Identify the scheduling and distribution systems used in different areas
b) Describe the three organization or companies that use the scheduling and distribution systems.
c) Discuss the effects of using the scheduling and distribution systems( Advantages & disadvantages)
d) Analyse social/ethical issue that arise from using the scheduling and distribution systems.

DHAVAL PATEL AND MAULIK RUPARELIA and Hilda
a) Identify the traffic simulation systems used in different areas
b) Describe the three organization or companies that use the traffic simulation systems.
c) Discuss the effects of using the traffic simulation systems( Advantages & disadvantages)
d) Analyse social/ethical issue that arise from using the traffic simualtion systems

SHUKLA VISHAL and CHRISPTOPHER LUBWAMA TENDO and Sanyu
a) Identify the different types smart roads and smart systems used in different countries.
b) Describe the three organization or companies that designed either smart cars or smart roads.
c) Discuss the effects of using the reservation systems( Advantages & disadvantages)
d) Analyse social/ethical issue that arise from using the reservation systems.


MARAKA SAMSON TENDO And JESSANI HASMITA and Martha

a) Identify the transport security systems used in different areas.
b) Describe the three organization or companies that use such security systems.
c) Discuss the effects of using the security systems( Advantages & disadvantages)
d) Analyse social/ethical issue that arise from using the security systems.

ZARAH DHARANI and SOLOMON KASUMBA and Carol
a) Identify the shipping systems used in different areas.
b) Describe the three organization or companies that use the shipping systems.
c) Discuss the effects of using the shipping systems( Advantages & disadvantages)
d) Analyse social/ethical issue that arise from using the shipping systems.