Posted: August 6th, 2022

YO19_IntegratedProject_1_LaundryProposal 1.1

YO19_IntegratedProject_1_LaundryProposal_

Instructions

xUrgessa_YO19_IntegratedProject_1_LaundryProposal.zip

 

YO19_IntegratedProject_1_LaundryProposal 1.1

  
YO19_IntegratedProject_1_LaundryProposal 1.1

Project Description:

As a student at the university, you have an entrepreneurial spirit and have dreamed of starting your own business. You have noticed that the coin laundry in your dorm is always full and crowded. You saw an opportunity to start a business that picks up laundry at the dorms, launders the clothes, folds the clothes, and returns the laundry in a single day. The first step to starting this business is to create a proposal for the university to approve the service to have some operations within the dorms. You started by conducting a survey of your fellow students. The next step is to process the survey results and create a proposal for the university.

Step

s to Perform:

   

Step
Instructions

Points    Possible

 
1
Start   Word. Download and open the file named IntegratedProject_1   – LaundryUProposal x. Grader has automatically added your last name to   the beginning of the filename. Click Enable Editing, if necessary.
0
 
2

Branding is always important both internally and   externally. Images and logos can help you brand.
 

  Press CTRL+HOME to place the cursor at the beginning of the document. insert   the image LaundryULogo . Change   the width of the image to 1.5 inches. Change the layout to In Front of Text   and then align the image Right relative to the margin.
  Hint: On the Picture Format tab, use the tools in the Arrange group and the   Size group to format the picture.
4
 
3

Change   the document theme to Feathered and the theme colors to Blue Warm. Change the   margins to Narrow.
 

  If the theme is not available, click Browse for Themes, and then select the   downloaded theme file Feathered.thmx.

2.4

 
4

Spelling mistakes are unprofessional as they make   the author appear to be unable to spell properly.
 

  Check the spelling to correct all spelling errors. LaundryU is the name of the business and is spelled correctly.

2
 
5

Styles   help you format even if you are not very good with design.
 

  Set the style for the first three lines in the document to Heading 1.
  On the sixth line down change the salutation of Dear Director, to a style of Heading 2. Change the line that   reads We did a survey of 100 students   in the dorm and found: style to be Heading 2.

4
 
6

A name should look like a signature.
 

  On the next to last line, change the font of Matthew Thomas to Lucida Handwriting.

0.8

 
7

Open   the downloaded LaundryUSurvey.xlsx   file. On the Q1 worksheet, in cell E2, enter a function that calculates how   many students answered yes to the survey using the data in cell B2:B101.
  Hint: You will be using the COUNTIF Function. See Excel Chapter 2: Activity   2.08

 

2
 
8

On the Q1 worksheet, in cell E3, enter a function   that calculates how many students answered no to the survey using the data in   cell B2:B101.

2
 
9

Using   the data in cells D2:E3, insert a 3-D Pie Chart. Change the chart title to Interested in   LaundryU Service?   Change the chart style to Style 3.

4
 
10
Select the chart and copy it. Display the IntegratedProject_1 –   LaundryUProposal x file, and be sure your insertion point is   positioned on the line underneath Would   you be interested in a laundry service that picks up and delivers to your   dorm? On the Home tab, in the Clipboard group, click the Paste arrow, and   then under Paste Options, click Use Destination Theme & Link Data.
4
 
11
In the IntegratedProject_1 –   LaundryUProposal x file, center the chart. Set the width of the chart   to 4 inches and the height to 2 inches. Change the font size of the chart   title to 12.
2.4
 
12

When looking at results of this survey, it is   important to look at more than just the average price the students are   willing to pay to get an idea of distribution of the results. Considering   just an average in a decision could lead to erroneous or poor decisions.
 

  Display LaundryUSurvey.xlsx. On the   Q2 worksheet using the data in cells B2:B40, calculate the following:
  In cell F2 calculate the average price students were willing to pay.
  In cell F3 calculate the standard deviation of the sample.
  In cell F4 calculate the sample size.
  In cell H3 calculate the minimum price students were willing to pay.
  In cell H4 calculate the maximum price students were willing to pay.
  Hint:
  For Standard Deviation, use the STDEV.S Function
  For the Sample Size, use the COUNTA Function

6
 
13

On the   Q2 worksheet, format cells F2, F3, H3, and H4 to Accounting. Format cell F2   to bold. Set the fill color for cells F2:H4 to White, Background 1.

2.4
 
14
Select cells   E2:H4 and copy the range. Display the IntegratedProject_1   – LaundryUProposal x file, and be sure your insertion point is   positioned on the line underneath If   yes, how much would you be willing to pay per bag (approximately 1 load of   laundry)? On the Home tab, in the Clipboard group, click the Paste arrow,   and then click Paste Special. In the Paste Special dialog box under As, click   Microsoft Excel Worksheet Object. Then, click OK. Center the embedded Excel   Worksheet Object.
4
 
15
Save   and Exit Excel. Save and close IntegratedProject_1   – LaundryUProposal x. Exit Word. Submit your Word file as directed.
0
  

Total   Points

40

Grader – Instructions Integrated Word 2019 Project

YO19_IntegratedProject_1_LaundryProposal 1.1

Project Description:

As a student at the university, you have an entrepreneurial spirit and have dreamed of starting your own business. You have noticed that the coin laundry in your dorm is always full and crowded. You saw an opportunity to start a business that picks up laundry at the dorms, launders the clothes, folds the clothes, and returns the laundry in a single day. The first step to starting this business is to create a proposal for the university to approve the service to have some operations within the dorms. You started by conducting a survey of your fellow students. The next step is to process the survey results and create a proposal for the university.

Steps to Perform:

Step

Instructions

Points Possible

1

Start Word. Download and open the file named IntegratedProject_1 – LaundryUProposal x. Grader has automatically added your last name to the beginning of the filename. Click Enable Editing, if necessary.

0

2

Branding is always important both internally and externally. Images and logos can help you brand.
Press CTRL+HOME to place the cursor at the beginning of the document. insert the image LaundryULogo . Change the width of the image to 1.5 inches. Change the layout to In Front of Text and then align the image Right relative to the margin.
Hint: On the Picture Format tab, use the tools in the Arrange group and the Size group to format the picture.

4

3

Change the document theme to Feathered and the theme colors to Blue Warm. Change the margins to Narrow.
If the theme is not available, click Browse for Themes, and then select the downloaded theme file Feathered.thmx.

2.4

4

Spelling mistakes are unprofessional as they make the author appear to be unable to spell properly.
Check the spelling to correct all spelling errors. LaundryU is the name of the business and is spelled correctly.

2

5

Styles help you format even if you are not very good with design.
Set the style for the first three lines in the document to Heading 1.
On the sixth line down change the salutation of Dear Director, to a style of Heading 2. Change the line that reads We did a survey of 100 students in the dorm and found: style to be Heading 2.

4

6

A name should look like a signature.
On the next to last line, change the font of Matthew Thomas to Lucida Handwriting.

0.8

7

Open the downloaded LaundryUSurvey.xlsx file. On the Q1 worksheet, in cell E2, enter a function that calculates how many students answered yes to the survey using the data in cell B2:B101.
Hint: You will be using the COUNTIF Function. See Excel Chapter 2: Activity 2.08

2

8

On the Q1 worksheet, in cell E3, enter a function that calculates how many students answered no to the survey using the data in cell B2:B101.

2

9

Using the data in cells D2:E3, insert a 3-D Pie Chart. Change the chart title to Interested in LaundryU Service? Change the chart style to Style 3.

4

10

Select the chart and copy it. Display the IntegratedProject_1 – LaundryUProposal x file, and be sure your insertion point is positioned on the line underneath Would you be interested in a laundry service that picks up and delivers to your dorm? On the Home tab, in the Clipboard group, click the Paste arrow, and then under Paste Options, click Use Destination Theme & Link Data.

4

11

In the IntegratedProject_1 – LaundryUProposal x file, center the chart. Set the width of the chart to 4 inches and the height to 2 inches. Change the font size of the chart title to 12.

2.4

12

When looking at results of this survey, it is important to look at more than just the average price the students are willing to pay to get an idea of distribution of the results. Considering just an average in a decision could lead to erroneous or poor decisions.
Display LaundryUSurvey.xlsx. On the Q2 worksheet using the data in cells B2:B40, calculate the following:
In cell F2 calculate the average price students were willing to pay.
In cell F3 calculate the standard deviation of the sample.
In cell F4 calculate the sample size.
In cell H3 calculate the minimum price students were willing to pay.
In cell H4 calculate the maximum price students were willing to pay.
Hint:
For Standard Deviation, use the STDEV.S Function
For the Sample Size, use the COUNTA Function

6

13

On the Q2 worksheet, format cells F2, F3, H3, and H4 to Accounting. Format cell F2 to bold. Set the fill color for cells F2:H4 to White, Background 1.

2.4

14

Select cells E2:H4 and copy the range. Display the IntegratedProject_1 – LaundryUProposal x file, and be sure your insertion point is positioned on the line underneath If yes, how much would you be willing to pay per bag (approximately 1 load of laundry)? On the Home tab, in the Clipboard group, click the Paste arrow, and then click Paste Special. In the Paste Special dialog box under As, click Microsoft Excel Worksheet Object. Then, click OK. Center the embedded Excel Worksheet Object.

4

15

Save and Exit Excel. Save and close IntegratedProject_1 – LaundryUProposal x. Exit Word. Submit your Word file as directed.

0

Total Points

40

Created On: 12/02/2020 1 YO19_IntegratedProject_1_LaundryProposal 1.1

Urgessa_IntegratedProject_1 – LaundryUProposal x

Proposal for: LaundryU
To: Director of Residential Dorms
Date: 8/1/2021

Dear Director,

Currently, 3000 students live in the north quad dorms. Each dorm has a small laundry room that accepts coins. Those facilities are currently busy and in demand. Many college students have never done laundry before or are too busy to do laundry. What if we could provide a service that is affordable, non-intrusive, and helps solve the students’ laundry needs?

We propose to start a service to do precisely this! We would provide students with a laundry bag and designated day of the week. The student would simply put the bag in the basement stairwell that is currently unused space. A delivery driver would pick up the laundry in the morning. We will then launder and fold the clothes all for only $12 per bag!

We did a survy of 100 students in the dorm and found:

Would you be interested in a laundry service that picks up and delivers to your dorm?

If yes, how much would you be willing to pay per bag (approximately 1 load of laundry)?

We are excited to help the university to allevate the overfilled dorm laundries at no cost to the university. We will follow up in a few days to schedule a time to meet and discuss this in person!

Thanks,

Matthew Thomas

LaundryU

YO19_IntegratedProject_1_LaundryProposal_Instructions x
Grader – Instructions Integrated Word 2019 Project

YO19_IntegratedProject_1_LaundryProposal 1.1

Project Description:

As a student at the university, you have an entrepreneurial spirit and have dreamed of starting your own business. You have noticed that the coin laundry in your dorm is always full and crowded. You saw an opportunity to start a business that picks up laundry at the dorms, launders the clothes, folds the clothes, and returns the laundry in a single day. The first step to starting this business is to create a proposal for the university to approve the service to have some operations within the dorms. You started by conducting a survey of your fellow students. The next step is to process the survey results and create a proposal for the university.

Steps to Perform:

Step

Instructions

Points Possible

1

Start Word. Download and open the file named IntegratedProject_1 – LaundryUProposal x. Grader has automatically added your last name to the beginning of the filename. Click Enable Editing, if necessary.

0

2

Branding is always important both internally and externally. Images and logos can help you brand.
Press CTRL+HOME to place the cursor at the beginning of the document. insert the image LaundryULogo . Change the width of the image to 1.5 inches. Change the layout to In Front of Text and then align the image Right relative to the margin.
Hint: On the Picture Format tab, use the tools in the Arrange group and the Size group to format the picture.

4

3

Change the document theme to Feathered and the theme colors to Blue Warm. Change the margins to Narrow.
If the theme is not available, click Browse for Themes, and then select the downloaded theme file Feathered.thmx.

2.4

4

Spelling mistakes are unprofessional as they make the author appear to be unable to spell properly.
Check the spelling to correct all spelling errors. LaundryU is the name of the business and is spelled correctly.

2

5

Styles help you format even if you are not very good with design.
Set the style for the first three lines in the document to Heading 1.
On the sixth line down change the salutation of Dear Director, to a style of Heading 2. Change the line that reads We did a survey of 100 students in the dorm and found: style to be Heading 2.

4

6

A name should look like a signature.
On the next to last line, change the font of Matthew Thomas to Lucida Handwriting.

0.8

7

Open the downloaded LaundryUSurvey.xlsx file. On the Q1 worksheet, in cell E2, enter a function that calculates how many students answered yes to the survey using the data in cell B2:B101.
Hint: You will be using the COUNTIF Function. See Excel Chapter 2: Activity 2.08

2

8

On the Q1 worksheet, in cell E3, enter a function that calculates how many students answered no to the survey using the data in cell B2:B101.

2

9

Using the data in cells D2:E3, insert a 3-D Pie Chart. Change the chart title to Interested in LaundryU Service? Change the chart style to Style 3.

4

10

Select the chart and copy it. Display the IntegratedProject_1 – LaundryUProposal x file, and be sure your insertion point is positioned on the line underneath Would you be interested in a laundry service that picks up and delivers to your dorm? On the Home tab, in the Clipboard group, click the Paste arrow, and then under Paste Options, click Use Destination Theme & Link Data.

4

11

In the IntegratedProject_1 – LaundryUProposal x file, center the chart. Set the width of the chart to 4 inches and the height to 2 inches. Change the font size of the chart title to 12.

2.4

12

When looking at results of this survey, it is important to look at more than just the average price the students are willing to pay to get an idea of distribution of the results. Considering just an average in a decision could lead to erroneous or poor decisions.
Display LaundryUSurvey.xlsx. On the Q2 worksheet using the data in cells B2:B40, calculate the following:
In cell F2 calculate the average price students were willing to pay.
In cell F3 calculate the standard deviation of the sample.
In cell F4 calculate the sample size.
In cell H3 calculate the minimum price students were willing to pay.
In cell H4 calculate the maximum price students were willing to pay.
Hint:
For Standard Deviation, use the STDEV.S Function
For the Sample Size, use the COUNTA Function

6

13

On the Q2 worksheet, format cells F2, F3, H3, and H4 to Accounting. Format cell F2 to bold. Set the fill color for cells F2:H4 to White, Background 1.

2.4

14

Select cells E2:H4 and copy the range. Display the IntegratedProject_1 – LaundryUProposal x file, and be sure your insertion point is positioned on the line underneath If yes, how much would you be willing to pay per bag (approximately 1 load of laundry)? On the Home tab, in the Clipboard group, click the Paste arrow, and then click Paste Special. In the Paste Special dialog box under As, click Microsoft Excel Worksheet Object. Then, click OK. Center the embedded Excel Worksheet Object.

4

15

Save and Exit Excel. Save and close IntegratedProject_1 – LaundryUProposal x. Exit Word. Submit your Word file as directed.

0

Total Points

40

Created On: 12/02/2020 1 YO19_IntegratedProject_1_LaundryProposal 1.1

Feathered.thmx

LaundryULogo

LaundryUSurvey.xlsx
Q1

SurveyID Would you be interested in a Laundry service that picks up and delivers to your dorm?

1 Yes # Interested

2 Yes # Not Interested

3 Yes

4 No

5 No

6 No

7 No

8 Yes

9 Yes

10 Yes

11 Yes

12 No

13 Yes

14 No

15 No

16 No

17 No

18 No

19 Yes

20 No

21 Yes

22 No

23 No

24 No

25 No

26 Yes

27 No

28 No

29 Yes

30 Yes

31 No

32 No

33 Yes

34 No

35 No

36 Yes

37 Yes

38 Yes

39 No

40 No

41 No

42 No

43 No

44 No

45 No

46 No

47 No

48 No

49 Yes

50 No

51 No

52 Yes

53 No

54 No

55 No

56 No

57 No

58 No

59 Yes

60 No

61 Yes

62 Yes

63 No

64 Yes

65 Yes

66 No

67 Yes

68 No

69 No

70 Yes

71 Yes

72 Yes

73 Yes

74 No

75 Yes

76 No

77 No

78 No

79 Yes

80 Yes

81 No

82 Yes

83 No

84 No

85 No

86 No

87 Yes

88 Yes

89 Yes

90 No

91 Yes

92 No

93 No

94 Yes

95 Yes

96 No

97 No

98 No

99 No

100 No

Q2

SurveyID If yes, how much would you be willing to pay per bag (approximately 1 load of laundry)?

1 $ 11 Average Price

2 $ 5 Stdev Min Price

3 $ 13 Sample Size Max Price

8 $ 10

9 $ 11

10 $ 12

11 $ 14

13 $ 10

19 $ 11

21 $ 15

26 $ 20

29 $ 10

30 $ 12

33 $ 12

36 $ 11

37 $ 12

38 $ 10

49 $ 13

52 $ 12

59 $ 14

61 $ 13

62 $ 14

64 $ 10

65 $ 5

67 $ 12

70 $ 14

71 $ 14

72 $ 10

73 $ 12

75 $ 12

79 $ 14

80 $ 13

82 $ 14

87 $ 11

88 $ 10

89 $ 10

91 $ 13

94 $ 14

95 $ 20

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00