Exercise 1

Week 1 Database Application Requirements

Points Possible

Create new database in Access named FrequentFlier

15

Import FrequentFliers.txt data using External Data Wizard:

Tab delimited

Keep first row as field names

Create primary key field

Name table FrequentFliers

40

Create report from Frequent Fliers table:

Display first name, last name, and address

30

Save report as Frequent Fliers

15

Submit completed Access database file FrequentFlier.accdb (or .mdb) to the application project dropbox. Work not submitted in the correct format will be returned for revision.

Week 1 Excel Application Project Requirements

Points Possible

Open EthicsSurvey.csv starting data file in Excel

10

Add labels in column A beneath survey data for each of the statistics to be calculated

20

Add appropriate formulas to perform the following calculations for each survey item (column):

Mean (average) (example: =AVERAGE(B2:B31))

Standard Deviation (example: =STDEV(B2:B31))

Mode (example: =MODE(B2:B31))

Minimum (example: =MIN(B2:B31))

Maximum (example: =MAX(B2:B31))

50

Format the means (averages) to highlight items needing attention (such as lower values): Use conditional formatting to highlight values for specified criteria (values below 6.5, for example)

20

Submit completed Excel workbook file EthicsSurvey.xlsx to the application project dropbox. Work not submitted in the correct format will be returned for revision.