excel sam capstone project 1 campus fitness center

Academia.edu no longer supports Internet Explorer.

To browse Academia.edu and the wider internet faster and more securely, please take a few seconds to  upgrade your browser .

Enter the email address you signed up with and we'll email you a reset link.

• We're Hiring!
• Help Center

Instructions SC EX16 CS1-3a

Related Papers

ADLFI. Archéologie de la France - Informations

Charles Cambe

Gastroenterology Review

Maciej Gonciarz

produksibenihjagung distributorbenihjagung

KLIK https://wa.me/62811-3566-622, Benih Jagung Cocok Di Musim Hujan, Benih Jagung yang Unggul dan Berkualitas di Musim Kemarau, Benih Jagung yang Tahan Air, Benih Jagung yang Tahan Panas, Benih Jagung yang Tahan Bulai PT. SOEBANDI RAJA AGRICULTURE merupakan Produsen Benih Jagung Hibrida yang menggunakan bahan baku berkualitas terbaik dan dikemas dalam desain PREMIUM. Bahan kemasan menggunakan polyethylene dengan ketebalan minimal 0,8 micron sehingga kedap udara dan tahan terhadap perubahan suhu sehingga dapat mencegah penurunan kualitas Benih Jagung. Keunggulan Produk Raja 45 : • Potensi Hasil 12 Ton/Ha • Tahan Bulai • Hasil dari Rendemen Tinggi Kami siap melayani sepenuh hati dan memberikan pengalaman berbelanja dengan mudah dan aman. Untuk informasi lebih lanjut bisa langsung menghubungi nomor di bawah. Terimakasih Head Office : Permata Jingga Blok Anggrek I No.10, Tunggulwulung, Kec. Lowokwaru, Kota Malang, Jawa Timur 65143 (Dekat PJ Global Primary School) Bapak Rendarta 0811-3655-622 #ungguldanberkualitas, #benihjagung, #benihjagunghibrida, #benihjagungmurah, #benihjagungandalan, #benihjagungdimalang, #benihjagungdirendamsebelumditanam, #benihjagungterbaiksaatini bibit jagung unggul 2021, benih jagung unggul terbaru, bibit jagung hibrida terbaik 2021, bibit jagung unggul terbaik, macam-macam varietas jagung hibrida, bibit jagung unggul 2021, keunggulan jagung hibrida, benih jagung hibrida umur pendek

Aaron Jansen

Procedia - Social and Behavioral Sciences

Ana Botella

First approach of invariant densities of a Perron Frobenius operator. Asymptotic behaviours of ODE or PDE, as, are most interesting. The associed infinitesimal iteration is. If is partially linear, a random distribution can be asymptotic solution. Among applications, are asymptotic profiles of of Lorenz, Navier Stokes or Hamilton's \'equations.

MRS Proceedings

Philippe Bergonzo

In this paper, we present the results of investigations on the use of semiconductors deposited by chemical vapour deposition (CVD) for the fabrication of neutron detectors. For this purpose, 20 μm thick hydrogenated amorphous silicon (a-Si:H) pin diodes and 100 μm thick polycrystalline diamond resistive detectors were fabricated. The detectors were coupled to a neutron-charged particle converter : a layer of either gadolinium or boron (isotope 10 enriched) deposited by evaporation. We have demonstrated the capability of such neutron detectors to operate at neutron fluxes ranging from 101 to 106 neutrons/cm2.s. The fabrication of large area detectors for neutron counting or cartography through the use of multichannel reading circuits is discussed. The advantages of these detectors include the ability to produce large area detectors at low cost, radiation hardness (∼ 4 Mrad for a-Si:H and ∼ 100 Mrad for diamond), and for diamond, operation at temperatures up to 500°C. These properties...

Biochemistry

The New Zealand medical journal

Vidit Singh

To collect data on tobacco brand visibility on packaging on outdoor tables at bars/cafes in a downtown area, prior to a proposed plain packaging law. The study was conducted in the Central Business District of Wellington City in March 2014. Observational data were systematically collected on tobacco packaging visibility and smoking by patrons at 55 bars/cafes with outdoor tables. A total of 19,189 patrons, 1707 tobacco packs and 1357 active smokers were observed. One tobacco pack was visible per 11.0 patrons and the active smoking prevalence was 7.1% (95%CI: 4.9-9.2%), similar to Australian results (8.3%). Eighty percent of packs were positioned face-up (showing the brand), 8% face-down (showing the large pictorial warning), and 12% in other positions. Pack visibility per patron was significantly greater in areas without child patrons (RR=3.1, p<0.0001). Both smoking and pack visibility tended to increase from noon into the evenings on weekends. Inter-observer reliability for key...

RELATED PAPERS

Liuvan Herrera Carpio

Journal of Digestive Endoscopy

Gaurav Patil

Muhammad Zaky

Bangladesh Journal of Pharmacology

Shafiq ur Rahman 4382

Juan Carlos Mendoza Velasquez

Manoel Otacílio

Journal of Functional Analysis

Julio cesar Itamari flores

Advances in Research

jitendra singh Rajput

Sriraam Natarajan

Jurnal Revenue : Jurnal Ilmiah Akuntansi

Trinandari P. Nugrahanti

Journal of Arts and Humanities

Yahaya Bello

Continental Shelf Research

George Voulgaris

tyghfg hjgfdfd

Erika Tapia Nava

Greek, Roman, and Byzantine Studies 64

Benny Kozian

See More Documents Like This

•   We're Hiring!
•   Help Center
• Find new research papers in:
• Health Sciences
• Earth Sciences
• Cognitive Science
• Mathematics
• Computer Science
• Academia ©2024

• Solved Assignments
• Request Solution
• Perdisco Request
• Make Payment

Campus Fitness Center

Modify a service report and create a chart, getting started.

• Open the file SC_EX16_CS1-3a_ FirstLastName_1. xlsx , available for download from the SAM website.
• If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

• Stella Scott has a work-study position at the fitness center on campus. Her manager has asked her to create a worksheet to keep track of attendance and revenue for the fitness center’s classes.

Open the Class Statistics worksheet. Modify the column widths and row heights as described below:

• Use AutoFit to change the width of column A to make all the contents visible.
• Change the row height of row 1 to 00 pts .
• Change the widths of columns B through M to 25 characters.
• Change the font to Tw Cen MT and the font size to 26 pt .
• Change the font color to Turquoise, Accent 3, Darker 50% (7 th column, 6 th row of the Theme Colors palette).
• Change the fill color of the cell to Turquoise, Accent 3, Lighter 80% (7 th column, 2 nd row of the Theme Colors palette).
• Use Merge Cells to merge the contents of the range A2:M2 and then apply the Heading 1 cell style to the merged range. Format the merged range with the Short Date number format.
• Enter the contents in bold shown in Table 1 below into the range C4:G5.

Table 1: Data for Range C4:G5

• Format the cells in the range C5:G5 with the Currency number format with two decimal places and $ as the symbol.
• Bold and center the content of cell B4.
• Use the Format Painter to copy the formatting of cell B4 to the range C4:G4.
• Use Merge Cells to merge the contents of the range B4:B5.
• Apply the All Borders border style to the range B4:G5.
• Merge and center the range G7:K7.
• Apply the fill color Blue, Accent 2, Lighter 60% (6 th column, 3 rd row of the Theme Colors palette) to the merged range.
• Use the September label in cell B8 to fill the range C8:M8 with the months of the year.
• In cell B14, use the SUM function to total the values in the range B9:B13 . Use the Fill handle to copy the formula from B14 into the range C14:M14.
• In January, the hip-hop class is the center’s least attended class, but Stella’s manager hopes to boost attendance so that they can reach their budget goals.

Perform a Goal Seek analysis to determine the number of hip-hop class attendees needed in January ( F10 ) to change the value in cell F14 to 400 . ( Hint : Cell F10 will be the changing cell.) Keep the results of the Goal Seek Analysis as the new value for cell F10.

• In cell B15, use the keyboard to enter a formula that multiplies the value in cell B9 (the number of students attending the cardio class) by the value in cell C5 (the cost of each cardio class). Use an absolute cell reference to cell C5 and a relative reference to cell B9 . Copy the formula from cell B15 to the range C15:M15.
• In cell B18, enter a formula that multiples the value in cell B12 by the value in cell F5 . Copy the formula from B18 to the range C18:M18.
• In cell B19, enter a formula that multiples the value in cell B13 by the value in cell G5 . Copy that formula from B19 to the range C19:M19.
• Format the values in the range B9:M14 with the Comma Style number format with zero decimal places. Format the range B15:M20 with the Accounting number format with two decimal places.
• To help see where the most profitable months are, apply a new conditional formatting rule to the range B20:M20. The rule should format only cells that contain cell values greater than $62,000 with Light Green fill color (5 th column, 1 st row of the Standard Colors palette) and Dark Blue font color (9 th column, 1 st row of the Standard Colors palette).
• In cell B23, use the AVERAGE function to calculate the average monthly revenue generated for the range B15:B19 . Copy the formula from cell B23 to the range C23:M23.
• In cell B24, use the MAX function to calculate which value in the range B15:B19 is the largest. Copy the formula from cell B24 to the range C24:M24.
• In cell B25, use the MIN function to calculate which value in the range B15:B19 is the smallest. Copy the formula from cell B25 to the range C25:M25.
• If this condition is true, the cell value should be set to Over ( Hint : For the value if true, use “Over”).
• If this condition is false, the cell value should be set to Under ( Hint : For the value if false, use “Under”).

Copy the formula created in cell B26 to the range C26:M26.

• In cell B28, create a Line Sparkline from the data in the range G11:K11, and then change the style of the Sparkline to Turquoise, Sparkline Style Accent 3 (no dark or light) . ( Hint : Depending on your version of Office, the sparkline style may be written as Sparkline Style Accent 3 (no dark or light).)
• Check the Spelling in the workbook to identify and correct any spelling errors. ( Hint : You should find and correct at least two spelling errors.)
• Change the orientation to Landscape .
• Change the worksheet margins to Narrow .
• Insert a header in the center section with the text 2018 Class Statistics .
• Scale the worksheet so that it prints on one page.

Switch back to Normal View.

• Stella’s manager would like to emphasize certain visuals in the worksheet.

Create a Line chart from the nonadjacent ranges B8:M8 and B20:M20. Move the chart you just created to its own chart sheet. Use Monthly Revenue Chart as the name of the new chart sheet.

• Change the chart title to Total Revenue by Month .
• Format the data labels using the Above positioning option.
• Switch back to the Class Statistics Use the Recommended Chart tool to create a Clustered Column chart based on the range A8:F13. Move the chart to its own chart sheet. Use the name Fall Attendance Chart as the name of the new chart sheet.
• Change the chart style to Chart Style 2 .
• Change the chart title to Fall Semester Class Attendance .
• Add Number of Attendees as the primary vertical axis title.
• Add Fall Semester Months as the primary horizontal axis title.
• Stella’s manager was very impressed with her work and would like her to include and format some other information as well.

Go to the Personal Trainers worksheet and make the following formatting changes:

• Rotate the labels in the range B3:B17 to 0 degrees .
• Copy the range C3:C5, then paste it into the range C6:C17. Use the paste option that pastes the values, but not the cell formatting.
• Set the fill color in cell C3 and the range D6:D8 to No Fill .
• The center uses special codes to keep track of hours and process payments. These codes are made by typing the first three letters of the day followed by a dash, the start and end times separated by a colon, a dash, and then the first two letters of the first and last name of the trainer.

In cell E4, type Mon-11:1-LoWa . Select the range E3:E17, and use Flash Fill to fill the values in the range. [Mac Hint: Flash Fill is not available in Excel 2016 for Mac, so refer to the Final Figures to enter the text.]

• In the Physical Therapists worksheet, select cell B3 and use the Freeze Panes option to freeze the rows and columns above and to the left of cell B3.
• Select the Class Statistics , Personal Trainers , and Physical Therapists worksheets and then change the color of the sheet tabs to Turquoise, Accent 3 (7 th column, 1 st row of the Theme Colors palette).

Your workbook should look like the Final Figures on the following pages. (The value in cell F10 generated by the Goal Seek analysis has intentionally been blurred out in Final Figure 3.) Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.

Final Figure 1: Monthly Revenue Chart Worksheet

Final Figure 2: Fall Attendance Chart Worksheet

Final Figure 3: Class Statistics Worksheet

Final Figure 4: Personal Trainers Worksheet

Final Figure 5: Physical Therapists Worksheet

Click on Buy Solution and make payment. All prices shown above are in USD . Payment supported in all currencies . Price shown above includes the solution of all questions mentioned on this page. Please note that our prices are fixed (do not bargain).

After making payment, solution is available instantly .Solution is available either in Word or Excel format unless otherwise specified.

If your question is slightly different from the above question, please contact us at [email protected] with your version of question.

Choose your currency:

• USD US Dollars ($)