Introduction to Spreadsheets

Use the link below for spreadsheet tutorials.

https://www.gcflearnfree.org/excel2010/

Attempt the following spreadsheets exercise.

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

Using Spreadsheets for Modeling and Simulations

http://www.teach-ict.com/gcse_new/spreadsheets/modelling_simulation/miniweb/pg2.htm

http://itgsopedia.wikispaces.com/3.8+Spreadsheets%2C+modelling+and+simulations

Database Project

Your task will be to identify a client with a problem that requires a database solution using the most appropriate software.

You will then develop the database with the following evidence;

At least three appropriately related tables with sufficient data for testing;

Appropriate use of data validation, input masks

Proficient integration of complex queries, calculated fields, forms, sub-forms, macros, and modules

Structured Query Language (SQL) to develop a back-end database

Proficient use of techniques to enable easy navigation (such as menus or buttons)

The following should be uploaded on managebac

1. Functioning product
2. A screencast lasting for less than 5 minutes showing how the product function and the complex techniques applied in the development of the solution.

Assessment Rubric

CATEGORY	6 Points	4 Points	2 Points	0
Relevance of	Information is organized	Most information is	Some information is	There is no clear plan for
information in	in a clear, logical way. It is	organized in a clear,	logically sequenced.	the organization of
the database	easy to anticipate the	logical way. Some		information.
	type of material that	information seems out of
	might be in other tables.	place.
Tables/Relationships	At least three tables relationships are present in	Only two table relationship are present in	Two tables are present in	One table is present in
	the database with a	the database with	the database.	the database.
	minimum of 5 fields and	required fields. The
	a total of 10 records	number of records has
		not been met.
Forms/sub forms	Two forms have been	Two forms have been	Two forms have been	One form has been
	created to easily add	created, the order of	created. Fields are	created.
	information to the	information does not	missing for the data
	database. They are	match the order that you	entry.
	organized well and easy	would do the data entry.
	to read.
Queries/calculated fields	Query fits the data well	Query is adequate and	Query distorts the data	Query seriously distorts
	and makes it easy to	does not distort the data,	somewhat and	the data making
	interpret.	but interpretation of the	interpretation of the data	interpretation almost
		data is somewhat	is somewhat difficult.	impossible
		difficult.
Use Macros and Module	Detailed use and application of modules and macros	Partial use and application of modules and macros	Inappropriate  use and application of modules and macros	Fails to use and apply the  modules and macros
Originality	Database shows	Database shows some	Database shows an	Database is a rehash of
	considerable originality	originality and	attempt at originality and	other people's ideas and
	and inventiveness. The	inventiveness. The	inventiveness.	shows very little attempt
	content and ideas are	content and ideas are		at original thought.
	presented in a unique	presented in an
	and interesting way.	interesting way.
Use of Reports	All reports are attractive	One of the reports is not	The reports are generic	No reports have been
	(size and colors) and	attractive and has not	and have not been	created
	support the	been completely	formatted for proper
	theme/content of the	formatted for printing	printing functions
	presentation.	purposes.
Functionality and the use of screencast	The screencast shows in detail how the final product functions and how complex techniques are applied with the 5mins.	The screencast shows partially how the final product functions and with some techniques used shown.	Limited information is provided in the screencast submitted.	No Screencast is submitted
Total:	48
			Points Total:

Databases Applications

Your task is to describe in detail how the following technologies/Systems work in relations to databases. Ensure that relevant concepts and terminologies are used in the description of these systems.

• Facebook Entertainment Database
• Google maps
• GPS database
• Airline booking System
• Healthcare Database
• Naviance Scholarship database
• Amazon Cloud Database

Databases Concepts

Database Tutorial notes

https://www.cengage.com/school/corpview/RegularFeatures/DatabaseTutorial/db_elements/db_elements2.htm


Get notes for the following and post them on your OneNote page

Database Mining

• Define the term data mining;
• What are the benefits of data mining.
• What are the applications of  data mining.
• What are the challenges resulting from data mining processes
• Share an article taking about data mining.

Data Matching

• Define above term;
• What are the benefits of data matching.
• What are the applications of data matching.
• What are the challenges of data matching.
• Share an article taking about data matching.

Define the term database normalization

Database security;

• What are the common database security related issues.

• What the different solutions to the database related security issues.

Database Applications

Database Applications

Task1 

You have each been assigned a particular field to research for any database used there. For each database identified

a) Name and describe how the database is used or works

b) The benefits of databases in the field identified

c) Social and ethical issues arising from using the database in the identified field

d) Suggest some solutions to main problems identified

• Databases in education
• Database in health
• Military Databases
• Governance or government databases
• Business databases
• Medical database
• Databases used in transport
• Airline or eservation databases
• Databses used in entertainment
• Database used to monitor the environment or climate changes
• Databases for science and research institutions
• Business and employment

Task 2

Choose one article from those listed below and answer the following questions and post your findings in your OneNote Page;

Criterion A

     i) What is the main social / ethical issue from the article?

     ii) Who is the main primary stakeholder and why?

Criterion B

  i)

     - Name the technology/System stated in the article 

     - List the IT terms and concepts directly listed in the articles

     - List the IT terminologies that you would use provide more understanding on how the technology works.

  ii) What contributes to the social issue stated in Criterion A to easily occur?

Criterion C

  i) Name three explicitly stated stakeholders in the article and list advantages and disadvantages for each of using the technology

  ii)Name One implicit stakeholder listing the advantages and disadvantage of using the technology

Criterion D

  i) Name one main problem/ main disadvantage of the technology

  ii) State one solution that can be used to solve the problem

  iii) List the strengths and the limitations of your solutions

  iv) State how your proposed solution can be improved in future

a)

https://www.nytimes.com/2014/01/25/nyregion/fbi-audit-of-database-that-indexes-dna-finds-errors-in-profiles.html

b) http://time.com/4992849/china-voice-database-surveillance/

c) https://www.theguardian.com/technology/2017/mar/27/us-facial-recognition-database-fbi-drivers-licenses-passports

d) http://www.aljazeera.com/news/2018/01/india-probes-breach-biometric-identity-database-180105100602328.html

Databases News Articles

Use the articles in the links below to answer ITGS Paper 2  type questions. 

1. AP: Across US, police officers abuse confidential databases

http://www.usnews.com/news/politics/articles/2016-09-28/ap-across-us-police-officers-abuse-confidential-databases

2. Police database will share data on 15 million people

http://www.bbc.com/news/uk-13879683

3. Police building Private DNA databases

http://www.businessinsider.com/police-are-routinely-building-up-private-dna-databases-2016-9

4. Three Mobile cyber hack: six million customers' private information at risk after employee login used to access database 

http://www.telegraph.co.uk/news/2016/11/17/three-mobile-cyber-hack--six-million-customers-private-data-at-r/

5. Database Error leaves 150 million exposed

http://thehill.com/business-a-lobbying/284519-database-error-leaves-150-million-voter-records-exposed-online

6. 'No password' database error exposes info on 93 million Mexican voters

http://www.theregister.co.uk/2016/04/25/mexico_voter_data_breach/

7. Police increasing the use facial  recognition Technology

http://www.cbsnews.com/news/law-enforcement-increasing-use-of-facial-recognition-technology/

8. Data Democratization

https://www.infoworld.com/article/3246632/database/data-democratization-finally-living-up-to-the-name.html

9. Govt to use Databases track Academic qualifications

https://www.capitalfm.co.ke/news/2017/11/govt-develop-database-track-academic-qualifications/

10. When Cops commit Crime

https://news.vice.com/en_us/article/595kv3/police-crime-database

Other news on Databases

http://www.newser.com/tag/9648/1/database.html

Database Practice

Attempt the following practical tasks in the link below;

1. http://paulatisa.blogspot.co.ke/2015/03/ms-access-exercise-1.html

2. http://paulatisa.blogspot.co.ke/2015/03/ms-access-exercise-2.html

3. http://paulatisa.blogspot.co.ke/2015/03/ms-access-relationships-exercises-3.html