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