Data Analysis from Information Systems Course:

(using Microsoft Access)

	Table
	Fname	Lname	ID	Major	GPA	Age	Status
	Mary	Jones	111-1	MIS	2.79	19	Freshman
	Tom	Smith	222-7	ACC	3.60	22	Senior
	Alan	Bidgoli	333-9	ACC	3.86	21	Junior
	Brian	Stark	444-6	MKT	3.45	20	Sophomore
	Steve	Kline	555-6	MGT	3.75	24	Junior
	Susan	Brown	666-1	MIS	3.90	21	Junior
	Moury	Bidgoli	777-2	MIS	3.90	22	Junior
	Janet	Jeffrey	888-0	MGT	4.00	20	Junior
	Andy	Thomas	999-2	MKT	3.65	29	Senior
	Jack	Tucker	234-1	ACC	3.92	23	Senior
	Query 1:	ACC majors
	Fname	Lname	ID	Major	GPA	Age	Status
	Tom	Smith	222-7	ACC	3.60	22	Senior
	Alan	Bidgoli	333-9	ACC	3.86	21	Junior
	Jack	Tucker	234-1	ACC	3.92	23	Senior
	Query 2:	ACC majors with GPA > 3.7
	Fname	Lname	ID	Major	GPA	Age	Status
	Alan	Bidgoli	333-9	ACC	3.86	21	Junior
	Jack	Tucker	234-1	ACC	3.92	23	Senior
	Query 3:	MIS or ACC majors
	Fname	Lname	ID	Major	GPA	Age	Status
	Mary	Jones	111-1	MIS	2.79	19	Freshman
	Tom	Smith	222-7	ACC	3.60	22	Senior
	Alan	Bidgoli	333-9	ACC	3.86	21	Junior
	Susan	Brown	666-1	MIS	3.90	21	Junior
	Moury	Bidgoli	777-2	MIS	3.90	22	Junior
	Jack	Tucker	234-1	ACC	3.92	23	Senior
	Query 4:	All students who arent ACC majors
	Fname	Lname	ID	Major	GPA	Age	Status
	Mary	Jones	111-1	MIS	2.79	19	Freshman
	Brian	Stark	444-6	MKT	3.45	20	Sophomore
	Steve	Kline	555-6	MGT	3.75	24	Junior
	Susan	Brown	666-1	MIS	3.90	21	Junior
	Moury	Bidgoli	777-2	MIS	3.90	22	Junior
	Janet	Jeffrey	888-0	MGT	4.00	20	Junior
	Andy	Thomas	999-2	MKT	3.65	29	Senior

Data Analysis from Biology course:

(using Microsoft Excel)