Q 1.          Using Microsoft Excel, you are requested to create a table to look like the sample below and save it as Student First and Last name.                

 

The table below contains data for the number of pedestrians that were killed in the United States during 1994 in motor vehicle crashes. Perform the following procedures in Excel.

1.   Calculatethetotalnumberofpedestrianfatalitiesthatoccurredduringweekdays.Calculatethepercentofallweekdayfatalitiesthatoccurredduringeachofthe giventimesof day.                 

2.   Calculatethetotalnumberofpedestrianfatalitiesthatoccurredduringweekends.Calculatethepercentofallweekend fatalitiesthatoccurredduringeachofthe giventimesof day.               

3.   Calculatethetotalnumberoffatalitiesthatoccurredduringeachtimeofday(i.e.,addweekdayandweekendfatalitiesforeachtimeofday).Calculatethepercentofallpedestrianfatalitiesthatoccurduringeachtimeofday(weekdaysandweekendscombined).   

4.   Formatyourpercentagedatasothatpercentagesignsandonlyonedecimalplaceis shown.

5.   Createabargraphforthepercent ofallfatalitiesbythetimeofday.     

6.   Create a graph to compare between thepercentofallweekdayfatalities and thepercentofallweekends fatalities thatoccurredduringeachofthe giventimesof day.                             

PedestriansKilledbyTimeofDayandDayofWeek

 

 

 

Q 2.          Using Microsoft Access, you are requested to define a United State database consisting of one table called Student first and last name.                                             

In this question you are requested to do the following:

A.    Design the table structure and enter the information below:

Your table has the following fields with the following properties:               

·         State - data type is Text, field size is 20. It is also the primary key.

·         Population is Number

·         Area is Number

·         Union is Date, Short date

·         State Bird is Text, field size is 30

·         Region is Text. field size is 15

 

 

 

 

B.     Create queries                                                                        

·         List State and Union fields of the states that entered the union between1/1/1850-1/1/1920, sorting by union date.

·         List State, Area and Population fields of the states with areas less than 60,000 square miles that also have more than 10,000,000 people, sorting by Population.

·         List State and State Bird fields of the states that their State bird is bluebird or meadowlark.

C.    Create reports:                                                                                    

·         The first report prints States, Area, Population and Region. (Grouping by Region, and sorting by Area).

·         The Second report prints States, Union, and Region. (Grouping by Union, and sorting by Region).