Project12_Requirements

ICS-101 M. Bauer Project 12 Integrating Excel, Word & PowerPoint (10 Points) Download the Project 12 MS-Excel spreadsheet and MS-PowerPoint presentation files from the Project 12 learning page in Laulima. Points Task 1 Use one of the three methods for sharing data to place the pie chart showing data for “The Lone Ranger” on the slide titled, “The Lone Ranger Data”. 3 In a similar manner, use any of the three methods for sharing data to place the pie charts showing the data for each of the other three movies on the slides that pertain to them. Save the MS-PowerPoint presentation file. You are done with it after this step. 2 Start MS-Word and type the memo on the next page into a new document. Replace the words “Your Name” with your first name followed by your last name. 1 Use one of the three methods for sharing data to place the attendance column chart under the first paragraph and resize the image so it fits on the paper. 0.5 Insert a page break (CTRL & Enter) after the column chart. 1 Use one of the three methods for sharing data to place the revenue pie chart under the second paragraph and resize the image so it fits on the paper. 0.5 Insert a page break (CTRL & Enter) after the pie chart. 1 Use one of the three methods for sharing data to place the Spreadsheet data on the last page under the sentence at the top of the page and resize the image so it fits on the paper. Save the MS-Word document file. You are done with it after this step. Submit BOTH your completed MS-PowerPoint presentation and MS-Word document using the link provided on the Project 12 learning page in Laulima.

Memorandum To: Sally Au, Vice President From: Brooke Hart, Manager Re: Recaps for the Week of 11/06/2023 – 11/10/2023 Dated: 11/10/2023 Sunshine Movie Theaters featured the following four movies this week: The Lone Ranger, Grown Ups 2, Monsters University, and Man of Steel. The following charts details the attendance for the week. It shows The Lone Ranger had the highest attendance (6,457) and Monsters University had the lowest attendance (5,011). The Lone Ranger Grown Ups 2Monsters UniversityMan of Steel 0 1000 2000 3000 4000 5000 6000 7000 Attendance (7/22 - 28/2013)

Summary data for the week follows: 7/22/201 3 7/23/201 3 7/24/201 3 7/25/201 3 7/26/201 3 7/27/201 3 7/28/201 3 Tota l Revenue The Lone Ranger Adult Matinee 142 387 176 181 327 681 571 246 5 $20,336.2 5 Adult 108 272 142 168 409 601 572 227 2 $23,856.0 0 Military 48 31 92 72 41 105 123 512 $ 3,840.00 Child 108 205 124 97 128 193 184 103 9 $ 6,493.75 Senior Citizen 21 14 32 16 18 27 41 169 $ 1,225.25 645 7 $55,751.2 5 Grown Ups 2 Adult Matinee 161 321 148 192 297 503 499 212 1 $17,498.2 5 Adult 126 301 172 199 359 497 503 215 7 $22,648.5 0 Military 52 40 71 58 46 121 116 504 $ 3,780.00 Child 117 182 104 96 134 227 201 106 1 $ 6,631.25 Senior Citizen 28 11 26 17 25 32 48 187 $ 1,355.75 603 0 $51,913.7 5 Monsters University Adult Matinee 167 277 148 167 297 519 376 195 1 $16,095.7 5 Adult 97 176 138 167 304 421 477 178 0 $18,690.0 0 Military 27 19 71 34 37 49 68 305 $ 2,287.50 Child 107 177 138 67 94 148 127 858 $ 5,362.50 Senior Citizen 19 8 16 27 18 17 12 117 $ 848.25 501 1 $43,284.0 0 Man of Steel Adult Matinee 189 367 191 172 276 601 504 230 0 $18,975.0 0 Adult 124 306 189 172 367 521 497 217 6 $22,848.0 0 Military 19 28 62 51 68 197 104 529 $ 3,967.50 Child 67 110 137 68 94 176 148 800 $ 5,000.00 Senior Citizen 14 16 8 4 12 16 2 72 $ 522.00 587 7 $51,312.5 0 Price Adult Matinee $ 8.25 Adult $ 10.50 Military $ 7.50 Child $ 6.25 Senior Citizen $ 7.25