Investigate Stage: BANKING DATA

Please respond to the following activities in word. These work should be submitted by Friday 1st Oct 2010. Keeping a process journal will be compulsory. Always make entries to process journal and carry it with you for checking in all the CT lessons.

Problem Identification
In your immediate environment, there are many individuals who can benefit from using database programs. At the end of this unit you will be expected to create database product for an identified client.

Problem Description:
a) Identify and describe your problem in 300 words.
- Who have you identified as you client?
- What does your client do currently in terms of data organization and storage?
- How is what the client is doing now a problem?
- What are challenges faced by your client? Give examples where possible.

Design Brief: (200 words)
• What will you create to address the problem identified above?
• What do you foresee the product will do? How will it work?
• What are the benefits/advantages of creating the stated product?

Research:(350 words)
Each of your researched sources should have an author. All sources must be written in the standard APA format of citation. I will expect to see the following sources for your research.
- 6 Internet sources.
- 3 Books sources.
- 2 Newspaper sources
- 2 Magazine sources.
Refer to the link below for citation examples;
http://www.sciencebuddies.org/science-fair-projects/project_apa_format_examples.shtml
a)Find any articles with issues related to those of your client. Discuss each issue briefly?
b)Describe briefly the different database careers.
c)Describe two database frauds. What are some examples of the crimes that have been committed using database or people hacking into databases.
d)Describe the advantages and disadvantages of using databases.
e)Describe some examples of databases formats and structures.

Interview/ Questionnaire: Part of data collection involves primary data collection. You be expected to carry out an interview. (Your interview document should have the following headings: Name of the interviewed, his/ her position, place of interview and date) 200 words.
- Identify a person within school or outside who uses a database e.g a doctor
- Develop 10 open ended questions that you will need to ask the person identified.
- Set an appointment and interview that person or use the questionnaire
- Write down all the responses from the interview process.

Design Specification
Design specification describes the details of what the final product should have based on the client problem. For examples it may have two tables instead of one; a receipt report; querries to filter something records etc.( looking at different database formats over the internet will guide you in reponding to this)

-Outline some of the design specification that we want to see in our final database product.

Test Strategy
Any product must tested before being handed over to the client or users.

- Describe the different strategies that you will use to test the product once it is finished.

UNIT TITLE: BANKING DATA

AOI: Human Ingenuity

Unit question: What are the impacts of using organized digital data?

AKA Strand: Global economics: What role do databases play in the process of decision making?

Assignment (Respond by posting your own comments in the comments box)

Describe a situation where a database or databases have been used to help in decision making or to streamline operations.

The Cars database Exercise

Download the database below depending on the version of access and answer the questions in the worksheet provided

Access 2003
http://www.teach-ict.com/ecdl/module_5/resources/cars/cars.mdb


Access 2007
http://www.teach-ict.com/ecdl/module_5/resources/cars/cars%20data.accdb


Submit your task and the end of the lesson.

Database Activity

Copy the link below and load the file and attempt the tasks posted

http://www.oneil.com.au/pc/access/UsingMicrosoftAccess1-GettingStarted.pdf

Click on the link below and attempt the activities provided

http://sorana.academicdirect.ro/pages/doc/Eng/LP_04.pdf

Year 9 MYP

Welcome to the Year 9 MYP CT class.

Our unit this term will focus on databases. Since i will be away till 10th of Sept, I expect that each of you familirize yourself with databases.

Use the following links below and others of your choice to make short notes and attempt the activities posted.

http://teach-ict.com/gcse/software/db/miniweb/index.htm


http://teach-ict.com/gcse/software/db/tasks/worksheet1.doc


http://teach-ict.com/gcse/software/db/tasks/worksheet2.doc


http://teach-ict.com/gcse/software/db/tasks/worksheet3.doc


http://teach-ict.com/gcse/software/db/tasks/worksheet4.doc



http://teach-ict.com/gcse/software/db/tasks/worksheet6i.doc


All the tasks should be emailed to serem@yahoo.com

I hope the tasks above have worked on. Please attempt the following activities in Ms access, in CT lessons this week.

Read and make short notes in the link below and answer the questions following

http://www.teach-ict.com/ecdl/module_5/resources/introduction/miniweb/index.htm


Open the database in the link below

http://www.teach-ict.com/ecdl/module_5/resources/dvds/dvds.mdb


and answer the following questions in the link following

http://www.teach-ict.com/ecdl/module_5/resources/dvds/Queries.pdf

Evaluation Stage

You are expected to evaluate the product/solution against the design specification in an objective manner based on testing, and to evaluate its impact on life, society and/or the environment.

You are expected to explain how the product/solution could be improved as a result of these evaluations.

Students are expected to evaluate their own performance at each stage of the design cycle and to suggest ways in which their performance could be improved.

Please Respond to the questions below for your evaluate stage.

a) How did you perform in each stage of the design cycle? What were your strengths and what were your weakness? How did you address your weekness? How did the results of testing help you? (100 words minimum)

b) How did the blog impact on them that used it? What were the strengths and weakness of using blogs for addressing your problem? (70 words minimum)

c)Which stage of the design cycle did you perform well and which stage did you perform poorly and what were your reasons? How did address those weakness as a student? (100 words Minimum)

d) Reflect on one the area of interaction: How does the blog created relate to the Area of interaction? What are the strengths and weakness of using blogs in the stated area of interaction? (100 words Minimum)

Create Stage

0
• Has not reached standard of any descriptors below.

1-2
• The Blogging contains some features and reflections.
• Some techniques and skills in blogging have been used.
• Comments to the topic of discussion are brief and a few people have commented.
• The process journal provides minimal evidence that the plan has not been considered fully.

3-4
• The Blogging is of a good quality, covers most required content and contains appropriate features.
• The student demonstrates some ability in the use of blogging software tools.
• Comments to the topic of discussion are detailed and more people have commented.
• The process journal provides some evidence that the plan has been regularly followed and mentions any changes made to the plan and/or design if applicable.

5-6
• The Blogging competently includes material from all required areas and uses high quality features.
• The student demonstrates competent use of blogging techniques and tools
• Comments to the topic of discussion are thorough and related to the topic and different stakeholders have commented
• The process journal provides clear evidence that the plan has been consistently followed and gives reasons for any changes to the plan and/or design if applicable