The sample table below shows 11 of the students enrolled in an MIS course. Organize the data in a relational format, and use Microsoft Access to list all ACC majors, all ACC majors with a GPA higher than 3.7, all students who are MIS or ACC majors, and all students who aren’t ACC majors. Repeat this assignment, this time using Excel, and generate the same results.

Sample table

Transcribed Image Text:

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