Design presentation of your collection and analysis of data

Assignment Help Civil Engineering

Reference no: EM132171665

Scenario: PORTSMOUTH ROAD DEVELOPMENT

In this assignment you will pretend to be working for Portsmouth City Council on a new road scheme. This will include a flyover bridge linking Portsmouth City Centre directly to Gosport to make travel from the City towards Southampton much easier for motorists. The Council wants to sample residents' views first. Your role is to create an electronic questionnaire in Microsoft Word using Word controls to gather data. This will then be analysed using Access and Excel and incorporated into the design of a PowerPoint presentation.

Task 1: Microsoft Word

First you will sample ideas using a questionnaire, developed in Microsoft Word, containing questions similar to these:

How important do you rate the scheme on a scale 1-5?

Should the Royal Navy be consulted first?

What impact is the scheme likely to have on tourism?

Could naval vessels dock in Southampton Water instead?

Would a tunnel be a better idea than a bridge?

How much money should the UK Government contribute?

Include a minimum of 10, and maximum of 15, questions in your questionnaire. Ensure that, overall, these questions result in both text and numerical data being provided for your subsequent analysis. The questionnaire should be designed so that it could be sent as an email attachment. It must contain these Microsoft Word controls: option buttons, check boxes, date picker and drop-down lists. You will then generate data from twenty such questionnaires.

Task 2: Microsoft Access

You will now design a Microsoft Access database for the raw data from your questionnaire. The database will include a table including fields of appropriate data type. Analysis of the data you have gathered in Task 1 must be carried out, producing a query and a report.

Task 3: Microsoft Excel

Next you will analyse numerical data gathered from your questionnaires using Microsoft Excel. This analysis will be statistical and include the mean, median and mode of relevant data. The spreadsheet should show that you can calculate standard deviation and perform correlation between different datasets. In addition you will insert appropriate graphs and charts into your spreadsheet.

Task 4: Microsoft PowerPoint

Using PowerPoint, you will design a presentation of your collection and analysis of data. This presentation should enable informed and sensible decisions to be made about how viable the new road scheme would be.

Attachment:- Assignment File.rar

Reference no: EM132171665

Questions Cloud

Period of the great inflation : How come in period of the great inflation that there was increases in other countries inflation too simultaneously in line with the U.S. increase?

Review a range of information system applications : ITECH1100 Understanding the Digital Revolution - Week One – Ethics and ePortfolios - Review a range of information system applications

How come in period of the great recession : How come in period of the great recession that there was increases in other countries inflation too simultaneously in line with the U.S. increase?

Xalculate the profit-maximizing price : Use this information, along with the marginal cost for each channel, to calculate the profit-maximizing price for each of these channels.

Design presentation of your collection and analysis of data : Scenario: PORTSMOUTH ROAD DEVELOPMENT. Using PowerPoint, you will design a presentation of your collection and analysis of data

Main goals of monetary policy in australia : 1. Define monetary policy and describe the main goals of monetary policy in Australia?

Analyse and manipulate complex numbers : Determine and manipulate ODE equations, both numerically and with symbolic software, analysing the results of the software simulations, comparing

Corresponding average total cost function : Suppose the manager of a firm operating in a competitive market in the short-run has estimated the firm's average variable cost (AVC) function to be

What is profit- maximizing price : What is your profit-maximizing price if you control 5 percent of the market? What is your profit- maximizing price if you control 15 percent of the market?

Reviews

len2171665

11/20/2018 2:54:07 AM

Your assignment work will be carried out in four stages, or 'Tasks', like this: Task 1 will gather data about residents' views on the proposed road development. Task 2 will analyse some of the text data that has been gathered. Task 3 will analyse numerical data. Task 4 will give a PowerPoint presentation about this analysis.

11/20/2018 2:54:01 AM

Important point: Although your questionnaire should theoretically be capable of being emailed do NOT actually do this. Instead 'make up' your own answers from twenty imaginary people. This will save time. IMPORTANT: All of your tasks must be uploaded to Moodle as a single Word document. You will use screen capture to show relevant material developed in Access, Excel and PowerPoint. This document must be uploaded by 4.00pm of semester week 8. (You will also copy a back-up of your work to a (provided) USB flash drive.)

Write a Review

Required(*) Message

User Account

All Pages