• 1500+ Experts
  • A+ Grade
  • Free Turnitin Report

5N1977: You are the Class Rep and the Student Council have Asked: Spreadsheet Methods Assignment, DCU,

University Dublin City University (DCU)
Subject 5N1977: Spreadsheet Methods

You are the class rep and the Student Council have asked you to do their annual survey of students to establish how they are coming to college and whether they have part-time jobs. You are asking a minimum of 12 students to fill in a survey that the Student Council have provided you with, and you have decided to present the information in a spreadsheet as this can be used in the following years.

Presenting the information in a spreadsheet gives you the best possibility of analysis of the data using graphs, filtering etc, also by protecting the workbook, all the calculations will be in place for next year and only the respondent information needs to be changed.

Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.

Workbook 1

Create a workbook called Survey Results & Your initials to record answers to the questions in the survey.

Spreadsheet 1- Data Capture Form

You have to create the template Survey form in worksheet 1 renamed Data capture form.

Lay it out using your cell styles and make it look attractive, it should fit on one page in portrait orientation.

Spreadsheet 2- Survey Response

1. In Sheet 2 create a spreadsheet to present the results under the following headings: Respondent No., Travels by Train/ Dart/ Luas, Age, Gender, Part-time job Y/N? Days worked, No. of hours worked per week, Length of a journey to college (in minutes), Travel by bus, Drives, Walks, Cycles, Uses motorbike.

2. Calculate the total time travelled per week for each respondent.

3. Use a clear font that is not calibri to present your data.

4. Apply modified cell styles to your headings and to your data.

5. Rename sheet 2 Survey Responses.

spreadsheet 3

spreadsheet 4

report

Get Help By Expert

Are you facing a problem with finishing your excel/ spreadsheet assignments? Don't worry, you can get online assignment help from us. Our experts have years of experience in providing quality writing services to DCU students at different academic levels. Buy online readymade assignments for survey report spreadsheet topic at irelandassignments.ie. Our team of dedicated expert Irish writers is always available to help you with the best assignment work. They will provide you with a good quality solution that helps you in achieving good grades.

Submit Your Assignment Questions & Get Plagiarism Free Answers.

Assignment-Help-Ireland.jpg

Submit Your Assignment