Docstoc

Chrysler Corporation Stock Symbol

Document Sample
Chrysler Corporation Stock Symbol Powered By Docstoc
					                                                                HOMEWORK ASSIGNMENT

                                                Microsoft Access I
                                                Vehicle Fuel Economy Problem

Background Information
As fuel prices have increased over the past few years, there
has been much new interest in the fuel economy of our
vehicles. Vehicles with higher fuel economy cost less to
operate and help to reduce our dependence upon foreign oil.

In the U.S., the Corporate Average Fuel Economy (CAFE)
specifies minimum miles per gallon (MPG) rates that each manufacturer must meet.
CAFE figures are weighted by the sales of each type of vehicle and are divided into
two categories. As of 2004, passenger cars must have an average of at least 27.5
MPG and light trucks and SUVs require an average of at least 20.3 MPG. In 2004,
the average for all vehicles was 20.8 MPG; the best fuel economy average was 22.1
MPG in 1987.

Problem Statement
In this project, we wish to create a database to store and analyze fuel economy for
vehicles in the compact, midsize, and large sedan, SUV, and minivan categories
from Chrysler, General Motors, Ford, Honda, and Toyota.

Project Instructions
IMPORTANT: Complete the below steps in the order they are given. Completing the
steps out of order may complicate the project or result in an incorrect result.

1.    Begin by creating a new Microsoft Access database named
      lastname_firstname_vfep.accdb .
2.    We would like to begin by making a table to store the vehicle manufacturers.
      a.     Create a table named Manufacturers to store the names of the car
             manufacturers and their stock ticker symbols. Designate the ticker
             symbol as primary key.




Introduction to Computer Applications   Page 1 of 8                            Version 14.0
West Virginia University                                                Modified 3/27/2009
                                                                       HOMEWORK ASSIGNMENT

                                                       Microsoft Access I
                                                       Vehicle Fuel Economy Problem
      b.     Enter records for all vehicle manufacturers below.

             HINT: The Manufacturers table will contain 5 records.
                 Manufacturer Name                Manufacturer Ticker Symbol
                 Chrysler LLC                     C
                 Ford Motor Company               F
                 General Motors                   GM
                 Toyota Motor Corporation         TM
                 Honda Motor Company              HMC

             NOTE: Chrysler LLC is currently a private company owned by Cerberus
             Capital Management and Fiat Group, and as such, technically does not
             have a ticker symbol. The ticker symbol used in this project is the
             historical ticker symbol of Chrysler Corporation used prior to 1998.
3.    We also must store information on the vehicle makes in our dataset.
      a.     Create a table named Makes to store the car makes, their make
             abbreviations and their manufacturer’s ticker symbol. Designate the
             make abbreviation as primary key.

             For the manufacturer ticker symbol, create a relationship to the primary
             key of the Manufacturers table to indicate which manufacturer owns each
             make. Enforce referential integrity and enable cascade updates, but
             do not enable cascade deletes.
      b.     Enter records into the Makes table corresponding to the below makes.

             HINT: The Makes table will contain 8 records.
                 Make Name              Make Abbreviation    Manufacturer Ticker Symbol
                 Chevrolet              CHEV                 GM
                 Dodge                  DODG                 C
                 Ford                   FORD                 F
                 Honda                  HOND                 HMC
                 Toyota                 TOYT                 TM
                 Buick                  BUIC                 GM
                 Jeep                   JEEP                 C
                 Chrysler               CHRY                 C




Introduction to Computer Applications          Page 2 of 8                            Version 14.0
West Virginia University                                                       Modified 3/27/2009
                                                                     HOMEWORK ASSIGNMENT

                                                   Microsoft Access I
                                                   Vehicle Fuel Economy Problem
4.    We need to create an additional table to store vehicle category information.
      a.     Create a new table named Categories to store the car categories and a
             separate ID number to serve as primary key.
      b.     Enter records into the Categories table corresponding to the below
             categories.

             HINT: The Categories table will contain 5 records.
             •      compact sedan
             •      midsize sedan
             •      large sedan
             •      minivan
             •      SUV
5.    To finish adding our dataset, we must store the vehicle model information.
      a.     Create a table named Models to store information on each car model
             (listed below under Step 5b). Some requirements for this table appear
             below.

             IMPORTANT: Completely define the Models table before entering records.
             i.     For the primary key, use an AutoNumber-type field to store an ID
                    number.
             ii.    Using a lookup field to the Makes table, allow the user to specify the
                    make of each car model (e.g., the make of the Chrysler Sebring is
                    Chrysler). The user should be able to select the make name (e.g.,
                    “Chrysler”) from the lookup field dropdown list.

                    The LOOKUP WIZARD field will create a relationship automatically to
                    the Makes table. Edit this relationship to enforce referential integrity
                    and enable cascade updates, but do not enable cascade deletes.
             iii.   Provide a field to store the model name of the car (e.g., “Stratus” if
                    the car is a Dodge Stratus).
             iv.    Using a lookup field to the Categories table, allow the user to specify
                    the vehicle category. The user should be able to select the full
                    vehicle category name (e.g., “SUV”) from the lookup field dropdown
                    list.

                    The LOOKUP WIZARD will create a relationship automatically to the
                    Categories table. Edit this relationship to enforce referential
                    integrity and enable cascade updates, but do not enable cascade
                    deletes.

Introduction to Computer Applications     Page 3 of 8                               Version 14.0
West Virginia University                                                     Modified 3/27/2009
                                                                     HOMEWORK ASSIGNMENT

                                                   Microsoft Access I
                                                   Vehicle Fuel Economy Problem
             v.    Provide a fixed-type number field with one decimal place to specify
                   the engine size in liters.
             vi.   Provide a currency field with no decimal places to store the MSRP
                   (manufacturer’s suggested retail price) of the model.
             vii. Provide an appropriately-formatted field to store the city MPG
                  estimate.
             viii. Provide an appropriately-formatted field to store the highway MPG
                   estimate.
             ix.   Create a lookup field that will allow us to specify the type of
                   transmission. You must provide the possible values shown below:
                   •      Automatic
                   •      CVT (Continuously-Variable)
                   •      Manual
             x.    Include a yes/no field to specify if the car is a hybrid.




Introduction to Computer Applications     Page 4 of 8                                 Version 14.0
West Virginia University                                                       Modified 3/27/2009
                                                                     HOMEWORK ASSIGNMENT

                                                   Microsoft Access I
                                                   Vehicle Fuel Economy Problem
      b.     Enter the below vehicle data into your Models table as appropriate. The
             below information is from 2009 model year vehicles.

             HINT: The Models table will contain 25 records.
        Make          Model             Category   Eng.   MSRP      City   Hwy   Trans.      Hybrid
                                                   Size             MPG    MPG
        Chevrolet     Cobalt            Compact    2.2    $15,660   25     37    Manual      N
        Dodge         Caliber           Compact    1.8    $16,210   24     30    Manual      N
        Ford          Focus             Compact    2.0    $14,995   24     33    Manual      N
        Honda         Civic             Compact    1.8    $15,505   26     34    Manual      N
        Honda         Civic Hybrid      Compact    1.3    $23,650   40     45    CVT         Y
        Toyota        Corolla           Compact    1.8    $15,350   26     35    Manual      N
        Toyota        Prius             Compact    1.5    $22,000   48     45    CVT         Y
        Buick         Lucerne           Large      3.9    $29,265   17     26    Auto        N
        Chrysler      300               Large      2.7    $26,665   18     26    Auto        N
        Ford          Taurus            Large      3.5    $25,170   18     28    Auto        N
        Ford          Escape            SUV        2.5    $21,645   20     28    Auto        N
        Ford          Escape Hybrid     SUV        2.5    $29,645   34     31    CVT         Y
        Jeep          Liberty           SUV        3.7    $22,715   16     22    Auto        N
        Honda         Element           SUV        2.4    $20,275   20     25    Auto        N
        Toyota        RAV4              SUV        2.5    $21,500   22     28    Auto        N
        Chevrolet     Malibu            Midsize    2.4    $21,605   22     30    Auto        N
        Chevrolet     Malibu Hybrid     Midsize    2.4    $25,555   26     34    Auto        Y
        Chrysler      Sebring           Midsize    2.4    $22,640   21     30    Auto        N
        Ford          Fusion            Midsize    2.3    $19,035   20     28    Manual      N
        Honda         Accord            Midsize    2.4    $20,905   22     31    Manual      N
        Toyota        Camry             Midsize    2.4    $19,145   21     31    Manual      N
        Toyota        Camry Hybrid      Midsize    2.4    $26,150   33     34    CVT         Y
        Dodge         Grand Caravan     Minivan    3.3    $24,230   17     24    Auto        N
        Honda         Odyssey           Minivan    3.5    $26,355   16     23    Auto        N
        Toyota        Sienna            Minivan    3.5    $24,540   17     23    Auto        N
6.    Create separate queries to provide the information requested below. Name
      each query after the step in which it appears (e.g., name the query in Step 6a
      as Query6A ).

      HINT: Run your queries to test them. Make sure that they display all and only
      the records that you would expect to appear.
      a.     Create a query that lists all model names, their full make name, MSRP,
             city and highway MPG estimates, and whether the vehicle is a hybrid.

             Sort by MSRP in ascending order.

             HINT: This query returns 25 records.



Introduction to Computer Applications     Page 5 of 8                              Version 14.0
West Virginia University                                                    Modified 3/27/2009
                                                                 HOMEWORK ASSIGNMENT

                                                Microsoft Access I
                                                   Vehicle Fuel Economy Problem
      b.     Create a query that shows each car’s full make name and model name, its
             MSRP, engine size, highway MPG estimate, and transmission type. You
             must also create a calculated field to calculate the dollar cost per liter
             MPG, which helps us to analyze the cost of a vehicle relative to its
             purchase price, engine size, and fuel economy.

             You can calculate the dollars per liter MPG using the formula:
                                                     .
                                     .                       .

             Format the calculated field as a fixed-type number with 2 decimal places.
             Sort by the calculated field in ascending order.

             HINT: This query returns 25 records.
      c.     Create a new query to list the model name, full make name, MSRP, city
             and highway MPG estimates, and whether the vehicle is a hybrid.

             Only display vehicles which get at least 28.0 highway MPG and are made
             by a domestic manufacturer (Chrysler LLC, Ford Motor Company, and
             General Motors).

             Sort the results by make and then by model, both in ascending order.

             HINT: This query returns 10 records.
      d.     Copy Query6A to create a new query. Only display non-hybrid models.
             Leave all other settings the same.

             HINT: This query returns 20 records.
      e.     Create a new query. Group by the full manufacturer name and display
             the average highway MPG estimate and the average city MPG estimate for
             each manufacturer.

             Format the MPG averages as fixed-type numbers with 3 decimal places.
             Sort by the highway MPG average in ascending order.

             HINT: This query returns 5 records.
7.    Using the FORM WIZARD, create a form with subform. The main form should
      display the full make name. The subform must display a datasheet with all
      Models table fields.

      Use a design style of your choice.   Name the main form CarData and the
      subform CarDataSubform .


Introduction to Computer Applications   Page 6 of 8                             Version 14.0
West Virginia University                                                 Modified 3/27/2009
                                                                 HOMEWORK ASSIGNMENT

                                                Microsoft Access I
                                                 Vehicle Fuel Economy Problem
8.    Using the REPORT WIZARD, create a report to show the results of Query6A.
      Display all fields from the query.

      View by make and sort by model name in ascending order. Use a stepped
      layout, portrait page orientation, and a design style of your choice. Name the
      report VehicleSummary .

      NOTE: The Hybrid column on the generated report might be too narrow to
      display its full name. You should manually adjust this column’s width if
      needed.
9.    Create a table named AnalysisQuestions . This table will need to be able to
      store which question is being answered and your answer to that question in
      each record.

      Answer four of the five below questions, one question per record. Specifically
      indicate the question you are answering for each record.
      a.     What sort of relationship exists between car MSRP and its MPG estimate?
             Note that hybrid cars will affect this relationship somewhat.
      b.     What sort of relationship exists between engine size and the MPG per liter
             achieved?
      c.     Pick and identify one of the pairs of hybrid/conventional vehicles (Ford
             Escape, Chevrolet Malibu, Honda Civic, or Toyota Camry). Average their
             city and highway MPG figures together to get a combined MPG estimate.

             Next, determine roughly how many miles you drive each year. If you
             drive under 5,000 miles per year, use the figure of 15,000 miles per year.
             Using the national average regular gas price available from the Energy
             Information Administration (http://eia.doe.gov) and the distance you
             drive annually, calculate how much you would spend on gasoline each
             year for each car. How long would it take for the gasoline savings to
             recoup the increased purchase price of the hybrid?

             Based on the cost information and any other factors you feel are
             appropriate, do you think that a hybrid vehicle is a worthwhile choice?
             Explain your decision.
      d.     There has been much interest recently in plug-in hybrid vehicles which
             can run on electric power much or all of the time. How would plug-in
             hybrids affect road construction funding, which is largely paid for by
             gasoline taxes presently? What sort of alternative funding mechanisms
             might be used to compensate for the changes?
      e.     If large numbers of people were to switch to hybrid vehicles, what effect
             might this have on fuel prices? What impact could there be on the cost-
             effectiveness of the hybrids themselves?
Introduction to Computer Applications   Page 7 of 8                             Version 14.0
West Virginia University                                                 Modified 3/27/2009
                                                                          HOMEWORK ASSIGNMENT

                                                       Microsoft Access I
                                                       Vehicle Fuel Economy Problem
10. Run the COMPACT AND REPAIR DATABASE utility on your database.

Curriculum Information
Project Type
Microsoft Access database

Relationship to GEC Objective 2
In addition to providing basic research and data analysis skills, this assignment
allows students to explore the relationships involved in automobile fuel economy
and the potential benefits of hybrid vehicles.

Relationship to GEC Objective 4
Due to ongoing concerns with energy costs and national security, it is important
that we in the U.S. work to improve our energy efficiency to save money and allow
us to be more self-sufficient for our needs. In this project, students explore the
costs and impacts of hybrids and different classes of vehicles from both domestic
and foreign manufacturers.

Grading Rubric
This project will be graded based upon the following components. The instructor
may adjust the below percentages as he or she feels appropriate:
Steps 2a-b                              7.5% total   Steps 6a, 6b, 6c and 6e          7.5% each
Steps 3a-b                                5% total   Step 6d                                5%
Steps 4a-b                                5% total   Step 7                                 5%
Step 5a                                      10%     Step 8                                 5%
Step 5b                                     7.5%     Steps 9a-e (pick 4 of 5)           5% each




Introduction to Computer Applications        Page 8 of 8                               Version 14.0
West Virginia University                                                        Modified 3/27/2009

				
DOCUMENT INFO
Description: Chrysler Corporation Stock Symbol document sample