computer sciences projects

>Documentation

, please download a new copy of the file from the SAM website.

Shelly Cashman Excel 2

Chapters 1-3: SAM Capstone Project 1a

Island Recycling

MODIFY A SERVICE REPORT AND CREATE A CHART

Author:

Dominica Esono Nseng

Note: Do not edit this sheet. If your name does not appear in cell B

Statistics

16 16 15

28 16 13 4 12

15 13 16 21 16

26 50 21 60

5 2 1 3 3 4 6 8 2 1 1 3

0 0 0 0 0 0 0 0 0 0 0 0

13 13 16 23

Fir Recycling
	12	2	8					16
Bin Prices
Quarter 2
Quarter 1	Quarter 3	Quarter		4
Number of Bins	January
Retunable bottles/cans	40	2		5			21		23	60	78	9	121	50	26	10	61
Plastic containers/bags			15		13	18	24
Mixed paper	27	11
	Glass
Total Bins
Revenue: Bottles/Cans
Revenue: Plastics
Revenue:		Mixed Paper
Revenue: Glass
Total Revenue
Average bins per month	19	32	31	42	22	34
Avrage revenue per month
Maximum revenue
Minimum revenue
Revenue Rank
Quarter 3 Glass

Volunteer
Educators

Volunteer Educators

Volunteer

Sharon Nelson 206-555-1289

9:00 to 11:00 John Courtney 206-555-3344

11:00 to 1:00

1:00 to 3:00

206-555-3901

Mary Marshal 206-555-5411

Slot #	Day	Time		Phone Number
		Thursday		9:00 to 11:00		John Courtney	206-555-3344
	11:00 to 1:00		Mary Marshal		206-555-5411
	1:00 to 3:00		Sharon Nelson		206-555-1289
	Friday	Rick Lamark	206-555-1799
Glenn Vazquez	206-555-5900
Saturday
Christie Shea		206-555-3901
Bree Shea
Sunday	Randy Hodgkins	206-555-4190
Charmaine Lobb	206-555-8122

Recycling Companies

Phone Number

Glass

Waste Not

1503 Seaview Lane Seattle WA 98102 206-555-3367

Thursday

Mixed Paper Thursday

Seattle WA

Friday

Mixed Paper

Service Companies

Company

Contact First Name

Contact Last Name

Street Address

City

State

Zip

Email Address

PROJECT DESCRIPTION

The small island community of Fir Island off the Washington coast, is justifiably proud of its recycling facility. Built entirely through the efforts of a band of dedicated volunteers, Island Recycling is committed to providing a convenient and welcoming location on Fir Island for the drop-off and distribution of recycled materials. Island Recycling is run by a non-profit society (Fir Island Recycling Society or F.I.R.S.) that manages the recycling facility, schedules volunteers, liaises with the local municipality, and sells recycled materials to companies located on the mainland. All revenues produced from the sale of recycled materials are invested back into Island Recycling. You are on the Board of the Fir Island Recycling Society and have volunteered to put together a spreadsheet to analyze the past year of activities at F.I.R.S. You have already inputted data about the recycling activities into Excel. Now you need to format the worksheet, use formulas and functions to analyze the data, and create charts to display selected data.

GETTING STARTED

· Download the following file from the SAM website:

· SC_Excel2013_CS_C1-3_P1a_FirstLastName_1.xlsx

· Open the file you just downloaded and save it with the name:

· SC_Excel2013_CS_C1-3_P1a_FirstLastName_2.xlsx

· Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically.

· With the file SC_Excel2013_CS_C1-3_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

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

a. Use AutoFit Column Width to change the width of column A to make all the contents visible.

b. Change the row height of Row 1 to 48.00 points.

c. Change the widths of columns B through M to 10.00 characters.

In cell A1, apply the formatting options described below:

d. Change the font to Arial Black font and a font size of 24 pt.

e. Change the font color to Turquoise, Accent 3, Darker 50% (7th column, 6th row in the Theme Colors palette).

f. Change the fill color of the cell to Turquoise, Accent 3, Lighter 80% (7th column, 2nd row in the Theme Colors palette).

Merge and center the contents of cells A2:M2 and then apply the Heading 2 cell style to the merged cells. Format the merged cells with the Long Date Number format.

Enter the contents in bold shown in Table 1 below into the range

C4

:

F5

Table 1:

Value

s for Range C4:F5

Cell	Value
C4	Bottles/Cans
D4	Plastics
E4	Mixed Paper
F4	Glass
C5	25
D5	80
E5	50
F5	15

Format the cells in the range C5:F5 with the Currency Number format with 2 decimal places.

Apply the following formatting options, as described below:

a. Bold and Center the content of cell B4.

b. Use Format Painter to apply the formatting of cell B4 to the range C4:F4.

c. Merge the contents of cells B4:B5.

d. Apply the All Borders border style to the range B4:F5.

Move the content of cell E6 to cell E7 and then apply the formatting options described below:

a. Merge and center the cells E7:G7

b. Apply the fill color Blue, Accent 2, Lighter 60% (6th column, 3rd row in the Theme Colors palette) to the merged cells.

Use the January label in cell B8 to fill the range C8:M8 with the months of the year.

In cell B13, use the SUM function to total the values in the range B9:B12. Use the Fill handle to copy the formula from B13 into the range C13:M13.

Perform a Goal Seek Analysis to determine the number of bins of Plastic containers/bags (cell B10) needed in January to change the value in cell B13 to 100. (Hint: Cell B10 will be the changing cell.) Keep the results of the Goal Seek Analysis as the new value for cell B10.

In cell B14, use the keyboard to enter a formula that multiplies the value in cell B9 (the number of returnable bottles) by the value in cell C5 (the value of each returnable bottle) Use an absolute cell reference to cell C5 and a relative reference to cell B9. Copy the formula from cell B14 to the range C14:M14.

Calculate the revenue for the remaining three recyclables (Plastics, Mixed Paper, and Glass) as described below. Remember to use absolute references to the cells in the range D5:F5 in the formulas.

g. In cell B15, enter a formula that multiples the value in cell B10 by the value in cell D5. Copy the formula from B15 to the range C15:M15.

h. In cell B16, enter a formula that multiples the value in cell B11 by the value in cell E5. Copy the formula from B16 to the range C16:M16.

i. In cell B17, enter a formula that multiples the value in cell B12 by the value in cell F5. Copy that formula from B17 to the range C17:M17.

Format the values in the range B9:M13 with the Comma Style Number format, decrease the number of decimal places to 1. Format the range B14:M18 with the Accounting Number format and 2 decimal places.

Apply a new conditional formatting rule to the range B18:M18. The rule should format cells with a values greater than $4,000 with Standard Light Green fill color (5th column of the Standard Colors palette) and Standard Dark Blue font color (9th column of the Standard Colors palette).

In cell B21, use the AVERAGE function to calculate the average monthly revenue generated for the range B14:B17. Copy the formula from cell B21 to the range C21:M21.

In cell B22, use the MAX function to calculate which value in the range B14:B17 is the largest. Copy the formula from cell B22 to the range C22:M22.

In cell B23, use the MIN function to calculate which value in the range B14:B17 is the smallest. Copy the formula from cell B23 to the range C23:M23.

In cell B24, use the IF function to check whether the value of cell B21 is greater than 1000.

a. If this condition is true, the cell value should be set to Good. (Tip: For the value if true, use “Good”)

b. If this condition is false, the cell value should be set to Poor. (Tip: For the value if false, use “Poor”)

Copy the formula created in cell B24 to the range C24:M24

In cell B26, create Column Sparklines from the data in the range H12:J12, and then change the style of the Sparklines to Sparkline Style Accent 3, (no dark or light) (3rd column, 3rd row of the Sparkline Style gallery).

Check the Spelling in the workbook to identify and correct any spelling errors. (Hint: You should find and correct at least 2 spelling errors.)

Format the worksheet for printing as described below:

a. Change the orientation to Landscape.

b. Change the worksheet margins to Narrow.

c. Insert a header in the Center section with the text Island Recycling 2016 Statistics.

d. Set the print area as the range A4:M26.

e. Scale the worksheet so that it prints on one page.

Create a 3-D pie chart from the non-adjacent ranges B8:M8 and B18:M18. Move the chart you just created to its own chart sheet. Use Revenue by Month Chart as the name of the new chart sheet.

Format the 3-D Pie chart with the following options:

a. Change the chart title to Revenue by Month.

b. Select the Chart Style 6.

c. Add data labels using the Data Callout positioning option.

d. Remove the legend from the chart.

Switch back to Statistics. Use the Recommended Chart tool to create a Clustered Column chart based on the range A8:D12. Move the chart to its own chart sheet. Use the name Quarter 1 Chart as the name of the new chart sheet.

Format the Clustered Column chart with the following options:

a. Change the chart title to Bins collected in Quarter 1.

b. Add Number of Bins as the Primary Vertical Axis Title

c. Add Months in Quarter 1 as the Primary Horizontal Axis Title

Go to the Volunteer Educators worksheet and make the following formatting changes:

a. Rotate the labels in the range B3:B14 by 45 degrees.

b. Use the entries in the range A3:A4 to fill the range A5:A14 with the number series from 3 to 12.

c. Copy the range C3:C5, then paste it into the ranges C6:C8 and C12:C14. Use the paste option that pastes the values, but not the cell formatting.

d. Remove the fill color from the range C3:C5.

In the Recycling Companies worksheet, select cell B3 and use the Freeze pane option to freeze the rows and columns to the left and above cell B3, respectively. Zoom out on the Recycling Companies worksheet to 60%.

Select Statistics, Recycling Companies, and Volunteer Educators worksheets and then change the color of the sheet tabs to Turquoise, Accent 3 (7th column, 1st row in the Theme Colors palette).

Your workbook should look like the Final Figures below and on the following page. Save your changes, close the workbook, and exit Excel. Follow the directions on the SAM website to submit your completed project.

Final Figure 1: Revenue by Month Chart Worksheet

Microsoft product screenshot reprinted with permission from Microsoft Incorporated.

Final Figure 2: Quarter 1 Chart Worksheet

Final Figure 3: Statistics Worksheet

Final Figure 4: Volunteer Educators Worksheet

Final Figure 5: Recycling Companies Worksheet

Documentation

and Graphs

Shelly Cashman Excel 2013

Chapter 3: SAM Project 1a

Flex Cab Company

Format a Revenue Report with

Charts

Author:

Dominica Esono Nseng

Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

11 May 2015
Revenue Detail

Flex Cab Company

Revenue Detail
Total

10%

13% 12% 10%

Charts

Week of May 11, 2015
	Date		Zone 1		Zone 2		Zone 3		Zone 4		Zone 5		Zone 6	Zone 7	Zone 8	Zone 9	Total
5/11/15	$ 12,690.65	$ 16,322.10	$ 13,533.75	$ 19,503.00	$ 17,206.45	$ 20,502.20	$ 19,419.05	$ 19,171.10	$ 16,524.60	$154,872.90
12,047.90	16,702.25	10,779.85	18,819.20	18,579.35	21,793.50	18,639.05	17,774.80	13,625.65	$148,761.55
13,418.35	14,694.90	12,092.10	18,557.70	16,378.30	19,402.95	19,683.30	18,149.25	15,536.40	$147,913.25
18,907.46	13,074.95	17,834.35	19,620.35	15,806.75	18,634.65	20,539.65	19,730.15	15,285.55	$159,433.86
23,865.94	17,894.20	21,485.02	19,848.40	18,985.90	22,629.75	22,933.15	19,646.10	18,397.20	$185,685.66
15,841.15	21,254.55	14,733.00	22,983.40	20,131.40	20,738.00	23,234.40	21,513.45	19,384.00	$179,813.35
11,801.30	14,314.60	12,696.85	20,235.25	17,762.90	21,932.45	21,680.35	20,111.85	18,079.40	$158,614.95
$ 108,572.75	$ 114,257.55	$ 103,154.92	$ 139,567.30	$ 124,851.05	$ 145,633.50	$ 146,128.95	$ 136,096.70	$ 116,832.80	$1,135,095.52
	Percent of total					10%	9%			12%		11%			13%

Share of Total Revenue

Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 9.5650760739501475E-2 0.10065897361659926 9.0877743927665219E-2 0.12295643630062075 0.10999166836637676 0.12830065614213682 0.12873713923212382 0.11989889626205204 0.10292772541292386

4 May 2015 Revenue Detail

Flex Cab Company
Revenue Detail

Date Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 Total

154,158.90

147,641.55

146,942.25

141,768.46

169,337.70

178,129.35

157,918.95

Total

Percent of total

10% 8% 13% 11% 13% 13% 12% 10%

Charts

Week of May 4, 2015
5/4/15	$ 12,172.65	$ 16,718.10	$ 13,392.75	$ 19,215.00	$ 17,439.45	$ 20,143.20	$ 19,825.05	$ 19,364.10	$ 15,888.60	$	154,158.90
5/5/15	11,946.90	16,742.25	11,063.85	18,526.20	18,361.35	21,325.50	18,628.05	17,719.80	13,327.65	$	147,641.55
5/6/15	13,300.35	14,466.90	12,014.10	18,158.70	16,344.30	18,919.95	19,746.30	18,569.25	15,422.40	$	146,942.25
5/7/15	12,104.40	12,892.95	12,574.80	19,516.35	15,450.75	14,222.86	20,698.65	19,428.15	14,879.55	$	141,768.46
5/8/15	14,650.65	18,106.20	14,182.35	19,895.40	18,834.90	22,506.75	23,292.15	19,637.10	18,232.20	$	169,337.70
5/9/15	15,249.15	20,927.55	14,763.00	22,793.40	19,916.40	20,685.00	23,528.40	21,450.45	18,816.00	$	178,129.35
5/10/15	11,829.30	14,397.60	12,449.85	20,333.25	17,994.90	21,723.45	21,784.35	19,988.85	17,417.40	$	157,918.95
$ 91,253.40	$ 114,251.55	$ 90,440.70	$ 138,438.30	$ 124,342.05	$ 139,526.71	$ 147,502.95	$ 136,157.70	$ 113,983.80	$1,095,897.16
	8%

Share of Total Revenue

Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 8.3268214692699835E-2 0.10425389732737333 8.2526630509746027E-2 0.12632417078259423 0.1134614218728334 0.12731733879116905 0.13459561296791753 0.12424313609864636 0.10400957695702033

Revenue Per Dispatch Center

5/4/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 12172.65 16718.100000000002 13392.75 19215 17439.45 20143.2 19825.05 19364.100000000002 15888.6 5/5/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 11946.9 16742.25 11063.85 18526.2 18361.350000000002 21325.5 18628.05 17719.8 13327.650000000001 5/6/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 13300.35 14466.900000000001 12014.1 18158.7 16344.300000000001 18919.95 19746.3 18569.25 15422.400000000001 5/7/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 12104.4 12892.95 12574.800000000001 19516.350000000002 15450.75 14222.86 20698.650000000001 19428.150000000001 14879.550000000001 5/8/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 14650.650000000001 18106.2 14182.35 19895.400000000001 18834.900000000001 22506.75 23292.15 19637.100000000002 18232.2 5/9/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 15249.150000000001 20927.55 14763 22793.4 19916.400000000001 20685 235 28.400000000001 21450.45 18816 5/10/2015 Zone 1 Zone 2 Zone 3 Zone 4 Zone 5 Zone 6 Zone 7 Zone 8 Zone 9 11829.300000000001 14397.6 12449.85 20333.25 17994.900000000001 21723.45 21784.350000000002 19988.850000000002 17417.400000000001

2016
Revenue Projection

Flex Cab Company

2016 Revenue Projection

$13,163,152

Weekly Citywide Revenue (Estimated)	$1,100,598
	Area	Share of Revenue (Estimated)	Annual Revenue (Estimated)
	Downtown	23%		$13,163,152
	North of Downtown	18%
	South of Downtown	20%
	East of Downtown	22%
	West of Downtown	17%
Citywide Total	100%

Credit Card Transactions

Flex Cab Company

Area 2016

Downtown

North of Downtown

South of Downtown

East of Downtown

West of Downtown

Total

Projected Number of Credit Card Transactions
2017	2018
30,405	33,446	36,790
15,676	17,244	18,968
9,512	10,463	11,509
6,329	6,962	7,659
7,300	8,030	8,833
69,222	76,144	83,758
Flat Transaction Cost

Shelly Cashman Excel 2013

Chapter 3: SAM Project 1a

Shelly Cashman Excel 2013
Chapter 3: SAM Project 1a

Flex Cab Company

Format a revenue report with charts and graphs

Project Goal

M Project Name

Project Goal

PROJECT DESCRIPTION

Simone Kisawa works in the accounting department of Flex Cab Company, a taxi service in Toronto, Ontario. Simone has begun work on a revenue detail report for the first half of May 2015. She would like you to make some changes and additions to complete the report.

GETTING STARTED

· Download the following file from the SAM website:

· SC_Excel2013_C3_P1a_FirstLastName_1.xlsx

· Open the file you just downloaded and save it with the name:

· SC_Excel2013_C3_P1a_FirstLastName_2.xlsx

· Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically.

· With the file SC_Excel2013_C3_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

Move the sheet 4 May 2015 Revenue Detail to the left of the sheet 11 May 2015 Revenue Detail.

On the 4 May 2015 Revenue Detail sheet, freeze rows 1 through 3. (Hint: Select cell A4 as the cell on which to freeze panes.)

Delete column M.

Create a Line Sparkline in cell L5 based on the data in B5:J5. Copy the Line Sparkline you create in cell L5 into the range L6:L11.

In the stacked column chart with the title Revenue Per Dispatch Center, add a primary horizontal axis title of Dispatch Center and a primary vertical axis title of Revenue.

Change the style of the stacked column chart to Chart Style 3 (3rd column, 1st row of the Chart Styles palette).

In the stacked column chart, change the number format of the vertical axis to Accounting style with 0 decimal places.

In the 3-D pie chart titled Share of Total Revenue, add data labels to this chart using the Outside End style.

Switch to the 11 May 2015 Revenue Detail sheet. Select the range A4:K4 and rotate the text to 45 degrees.

Change the Sparkline style for the range L5:L11 to Sparkline Style Accent 6, (no dark or light).

Use the entry in cell A5 to fill the range A6:A11 with consecutive dates.

Change the fill color of the range A12:K12 to Standard Yellow (4th column in the Standard Colors palette).

Use the Recommended Charts tool to create a Clustered Column chart based on the range A4:J11. Move the chart to its own chart sheet. Use 11 May 2015 Revenue Chart as the name of the new chart sheet.

In the clustered column chart created in step 13, change the chart title to Revenue per Dispatch Center – Week of May 11, 2015. Add a primary horizontal axis title of Dispatch Center and a primary vertical axis title of Revenue.

In the clustered column chart, change the number format of the vertical axis to the Accounting style with 0 decimal places. (Tip: The vertical axis will already be formatted with the Accounting style, so only change the number of decimal points displayed.)

Switch to the 2016 Revenue Projection sheet. Edit the formula in cell C7 so that the reference to cell C4 is an absolute reference. Copy the formula in cell C7 to the range C8:C11.

Perform a goal seek analysis to determine what value of cell C4 would result in the Citywide Total Annual Revenue (cell C12) equaling $60,000,000. (Tip: Cell C4 will be the changing cell.) Keep the result of the goal seek analysis as the new value for cell C4.

Zoom the 2016 Revenue Projection sheet to 150%

Switch to the Credit Card Transactions sheet. In cell B11, use an IF function to check whether the value of cell B9 is less than 70000.

a. If this condition is true, the function should multiply cell B9 by 0.03. (Tip: For the value if true, use B9*0.03)

b. If this condition is false, the function should multiply the value in cell B9 by 0.025 and then add 350. (Tip: For the value if false, use B9*0.025+350)

Copy the formula you entered in cell B11 to the range C11:D11.

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

Final Figure 1: 4 May 2015 Revenue Detail

Microsoft product screenshots used with permission from Microsoft Corporation.
Copyright © 2014 Cengage Learning. All Rights Reserved.

Final Figure 2: 11 May 2015 Revenue Chart

Copyright © 2014 Cengage Learning. All Rights Reserved.

Final Figure 3: 11 May 2015 Revenue Detail

Copyright © 2014 Cengage Learning. All Rights Reserved.

Final Figure 4: 2016 Revenue Projection

Copyright © 2014 Cengage Learning. All Rights Reserved.

Final Figure 5: Credit Card Transactions

Copyright © 2014 Cengage Learning. All Rights Reserved.

2

>Documentation

, please download a new copy of the file from the SAM website.

Shelly Cashman Excel 2

Chapter 2: SAM Project 1a

Flex Cab Company

ADD FORMULAS AND FORMAT A REVENUE REPORT

Author:

Dominica Esono Nseng

Note: Do not edit this sheet. If your name does not appear in cell B

Sheet1

Flex Cab Company

1 2 3

5 6

Total 0

Dispatch Center 1 2 3 4 5 6 7 8 9 Total

Revenue Detail
Week of April 13, 201		5
	Dispatch Center		4		7		8		9		Total
Monday, April 13, 2015	11810	15040	12826	18050	17124	19980	19417	18767	14495	147509
Tuesday, April 14, 2015	10536	14985	11399	17783	16524	19423	18556	17399	13130	139735
Wednesday, April 15, 2015	12955	14436	11971	18100	16218	18015	18393	17653	13871	141612
Thursday, April 16, 2015	11083	12090	12550	18099	15533	17899	19528	18982	14908	140672
Friday, April 17, 2015	13664	17830	13908	19253	18490	21044	21368	19577	16737	161871
Saturday, April 18, 2015	14347	19921	14757	21539	19832	20354	22935	21189	18353	173227
Sunday, April 19, 2015	10870	14368	12110	19962	17883	20512	20743	19688	16367	152503
Average
Highest
Lowest
Revenue Change
Week of April 6, 2015 to Week of April 13, 2015
Total Revenue – Week of April 6, 2015	$83,620.00	$109,801.00	$94,090.00	$128,357.00	$121,604.00	$138,002.00	$138,632.00	$136,628.00	$104,346.00	$1,060,080.00
Change in Revenue
Percent Change in Revenue

ShellyCashman Excel 2013

Chapter 2: SAM Project 1a

Shelly Cashman Excel 2013
Chapter 2: SAM Project 1a

Flex Cab Company

Add formulas and format a revenue report

Project Goal

M Project Name

Project Goal

PROJECT DESCRIPTION

Simone Kisawa works in the accounting department of Flex Cab Company, a taxi service in Toronto, Ontario. Simone has created a revenue detail report for the week of April 13, 2015. She would like you to complete the report by adding formatting and calculations.

GETTING STARTED

· Download the following file from the SAM website:

· SC_Excel2013_C2_P1a_FirstLastName_1.xlsx

· Open the file you just downloaded and save it with the name:

· SC_Excel2013_C2_P1a_FirstLastName_2.xlsx

· Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically.

· With the file SC_Excel2013_C2_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

1. Switch to worksheet Sheet1 and, in cell B13, use the SUM function to total the values in the range B6:B12.

2. Using the fill handles, transfer the formula you just created in cell B13 to all the cells in the range C13:J13.

3. In cell B14, use the AVERAGE function to determine the average daily income for the range B6:B12. Using the fill handle, transfer the formula you just created in cell B14 to all the cells in the range C14:K14.

4. In cell B15, use the MAX function to determine the maximum daily income for the range B6:B12. Copy the formula you just created in cell B15 to the range C15:K15.

5. In cell B16, use the MIN function to determine the minimum daily income for the range B6:B12. Copy the formula you just created in cell B16 to the range C16:K16.

6. Format the range B7:K12 with the Comma Style Number format with two decimal places.

7. Format the range B6:K6 with the Accounting Number format with two decimals places. Also format the range B13:K13 with the Accounting Number format with two decimal places. (Hint: Your number format should use the $ symbol with no special regional formatting options like $ English (United States).)

8. Format the range A6:A12 with the Short Date (like 4/13/2015) Number format.

9. Center the contents of cells in the range A5:K5.

10. Change the fill color of the range A13:K13 to Standard Yellow (4th column in the Standard Colors palette).

11. Apply a Top and Thick Bottom Border cell border to the range A13:K13.

12. Change the width of Column A to 32.00.

13. In cell B23, create a formula without using a function that subtracts the value of B22 (Dispatch Center 1’s total revenue for the previous week) from the value of cell B13 (Dispatch Center 1’s total revenue for the current week.) Copy the formula you created in cell B23 to the range C23:K23.

14.

In cell B24, create a formula without using a function that divides the value in B23 (weekly change in revenue) by the value in cell B22 (revenue for the previous week). Copy the formula you created in cell B24 to the range C24:K24.

15. Format the range B24:K24 with the Percentage Number format with two decimal places.

16. Apply a new conditional formatting rule to the range B24:K24. The rule should format cells with a cell value less than 0 with a Standard Orange fill color (3rd column, 7th row in the Background Color palette).

17. Change the orientation of the worksheet to Landscape.

18. Change the name of the worksheet to Revenue Detail.

Your workbook should look like the Final Figure on the following page. Save your changes, close the workbook, and exit Excel. Follow the directions on the SAM website to submit your completed project.

Final Figure: Revenue Detail worksheet

Microsoft product screenshots used with permission from Microsoft Corporation.
Copyright © 2014 Cengage Learning. All Rights Reserved.

Documentation

Shelly Cashman Excel		2013
Chapter 1: SAM Project 1a
Flex Cab Company
MODIFY A SERVICE REPORT AND CREATE A CHART
Author:	Dominica Esono Nseng
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

Pickup Analysis

2013

Area 2012 2013 2014 2015
Downtown

North of Downtown

South of Downtown

East of Downtown

West of Downtown

	Area		2012		2014	2015	2016
	Downtown	20574	22856	23686	27958
	North of Downtown	10123	11582	13058	15025
	South of Downtown	7294	8184	8245	8624
	East of Downtown	5591	5312	5883	6121
	West of Downtown
Total
On-time Pickup Percentages
60.6%	62.3%	71.5%	84.6%
50.2%	55.1%	63.9%	73.2%
23.8%	28.9%	49.6%	65.1%
57.1%	60.4%	68.8%	72.2%
66.0%	68.9%	72.5%	79.8%

Number of Pickups

2012 Downtown North of Downtown South of Downtown East of Downtown West of Downtown Total 20574 10123 7294 5591 2013 Downtown North of Downtown South of Downtown East of Downtown West of Downtown Total 22856 11582 8184 5312 2014 Downtown North of Downtown South of Downtown East of Downtown West of Downtown Total 23686 13058 8245 5883 2015 Downtown North of Downtown South of Downtown East of Downtown West of Downtown Total 27958 15025 8624 6121

On-Time Pickup Percentages in 2015

2015 Downtown North of Downtown South of Downtown East of Downtown West of Downtown 0.84599999999999997 0.73199999999999998 0.65100000000000002 0.72199999999999998 0.7980000000 0000004

Recycle Your E-Waste!

Are you feeling wieghed down by all the electronic equipment in your home? Do you have electronic equipment you no long use stuffed in closets and out-of-the-way corners of your house? Are you wondering what to do with all of your electronic waste? Well wonder no more!! The Evergreen Park District is hosting its 5th annual e-waste drop off.

What can you drop off?

Bateries, household not car

Desktops

Copiers

Cell phones

Keyboards

Laptops

Mice

Monitors

Personal electronic devices, such as CD players and iPods

Scanners

TVs, including CRTs, LCDs, and Plasma

Do you have something not on the list?

Call Rita at 815-555-3182 and she will let you know if we can take the item.

This file created specifically for Dominica Esono Nseng

This file created specifically for Dominica Esono Nseng
This file created specifically for Dominica Esono Nseng
This file created specifically for Dominica Esono Nseng
This file created specifically for Dominica Esono Nseng
This file created specifically for Dominica Esono Nseng
This file created specifically for Dominica Esono Nseng
This file created specifically for Dominica Esono Nseng
This file created specifically for Dominica Esono Nseng

ShellyCashman Word 2013

| SAM Capstone Project 1a

Shelly Cashman Word 2013|

Chapters 1-3: SAM Capstone Project 1a

Shelly Cashman Word 2013
Chapters 1-3: SAM Capstone Project 1a

E-Waste Drop Off

completing a flyer

Project Goal

M Project Name

Project Goal

PROJECT DESCRIPTION

For your local park district, you are helping to promote the fifth annual e-waste drop off event. The head of public relations has created a document with the details of the event. You will format the document as a one-page flyer that presents the main information in a bulleted list. You will add formatting, a clip art image, a table, a shape with text, and a photo to enhance the text.

GETTING STARTED

· Download the following file from the SAM website:

· SC_Word2013_CS_C1-3_P1a_FirstLastName_1 x

· Open the file you just downloaded and save it with the name:

· SC_Word2013_CS_C1-3_P1a_FirstLastName_2 x

· Hint: If you do not see the x file extension in the Save file dialog box, do not type it. Word will add the file extension for you automatically.

· To complete this Project, you will also need to download and save the following support files from the SAM website:

· support_SC_W13_CS_C1-3_P1a_recycling_globe

· support_SC_W13_CS_C1-3_P1a_bench

· With the file SC_Word2013_CS_P1a_FirstLastName_2 x still open, ensure that your first and last name is displayed in the footer. If the footer does not display your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

Change document margins to Normal.

Change theme colors to Green (8th row in the Office section of the Colors palette).

Select the text “Recycle Your E-Waste!” and format it with the following attributes:

a. Center-align the text.

b. Change the font to 36 pt. Arial Black.

c. Apply the Fill – Green, Accent 1, Shadow text effect (2nd column, 1st row in the Text Effects and Typography palette).

Add a bottom paragraph border to the text “Recycle Your E-Waste!” using the following attributes:

a. Use the Aqua, Accent 5, Darker 25% border color (9th column, 5th row in the Theme Colors palette).

b. Use a 3 pt. width.

Move the insertion point to the left of the text, “Are you feeling…” and insert the picture support_SC_W13_CS_C1-3_P1a_recycling_globe , available for download from the SAM website. Next, make the following formatting changes to the picture:

a. Apply Square text wrapping.

b. Resize the image proportionally so it has a height of 0.83”.

c. Change the Before paragraph spacing of the paragraph beginning “Are you feeling weighed down…” to 12 pt. and the After spacing to 18 pt.

Format the text “What can you drop off?” with the following attributes:

a. Change the font size to 15 pt.

b. Apply bold and the font case Capitalize Each Word.

c. Apply Green, Accent 1, Darker 25% paragraph shading (5th column, 5th row in the Shading palette).

d. Apply the White Background 1 font color (1st column, 1st row in the Theme Colors palette).

Format the text from “Batteries” through “…Plasma” as a bulleted list. (Hint: Your list should contain exactly 11 list items.)

Move the insertion point to the right of the first bulleted list item, after the word “car”, and insert the picture support_SC_W13_CS_C1-3_P1a_bench , available for download from the SAM website. Next, make the following formatting changes to the picture:

a. Resize the picture so it has a height of 1.8” and a width of 2.4”.

b. Apply Square text wrapping.

c. Apply the Bevel Rectangle picture style.

d. Move the image horizontally toward the right edge of the document. Refer to Figure 1 on the following page.

Figure 1: Final position of bench picture

Insert a Rounded Rectangle (2nd column, 1st row in the Rectangles area of the Shapes gallery) that is 0.54” tall and 2.37” wide positioned immediately below the picture inserted in Step 8. Then:

a. Apply Square text wrapping to the shape.

b. Add text to the shape that reads:

Picture yourself here enjoying a greener world!

c. Format the text in bold and UPPERCASE.

Right-align the text that begins “Do you have…” and ends with “…take the item.”, and then format it in bold with 14 pt. font size. Set the paragraph’s After spacing to 0.

Place the insertion point after the text that ends “…if we can take the item.”, press Enter two times, and select left-align. Then, insert a table with 2 columns and 5 rows at that point.

Merge the cells in row 1, and then enter the text exactly as shown in Table 1 below.

Table 1: Remember to mark your calendars

Format the table with the following attributes:

a. Apply the Grid Table 4 – Accent 1 table style and AutoFit Window.

b. Format the text in column 2 with a Green, Accent 1, Darker 50% font color (5th column, 6th row in the Theme Colors palette).

c. Format all of the text in the table 16 pt.

Insert a footnote at the end of the first paragraph following the period in the text “…5th annual e-waste drop off.” with the following text:

In case of rain, the drop off will be moved inside the Park District warehouse at the same address as noted in the table. Use the southwest entrance, which will be clearly marked.

Add a blank header to the document with the text:

Distributed by the Evergreen Park District

Apply bold formatting and center-align the header text.

Check the Spelling & Grammar in the document to identify and correct any spelling errors. (Hint: You should find and correct at least 2 spelling errors.)

Your document should look like the Final Figure on the following page. Save your changes, close the document, and exit Word. Follow the directions on the SAM website to submit your completed project.

Final Figure

Recycle Your E-Waste!

What can you drop off?

Bateries, household not car

Desktops

Copiers

Cell phones

Keyboards

Laptops

Mice

Monitors

Personal electronic devices, such as CD players and iPods

Scanners

TVs, including CRTs, LCDs, and Plasma

Do you have something not on the list?

Call Rita at 815-555-3182 and she will let you know if we can take the item.

This file created specifically for Dominica Esono Nseng

ShellyCashman Word 2013

| SAM Capstone Project 1a

Shelly Cashman Word 2013|

Chapters 1-3: SAM Capstone Project 1a

Shelly Cashman Word 2013
Chapters 1-3: SAM Capstone Project 1a

E-Waste Drop Off

completing a flyer

Project Goal

M Project Name

Project Goal

PROJECT DESCRIPTION

GETTING STARTED

· Download the following file from the SAM website:

· SC_Word2013_CS_C1-3_P1a_FirstLastName_1 x

· Open the file you just downloaded and save it with the name:

· SC_Word2013_CS_C1-3_P1a_FirstLastName_2 x

· Hint: If you do not see the x file extension in the Save file dialog box, do not type it. Word will add the file extension for you automatically.

· To complete this Project, you will also need to download and save the following support files from the SAM website:

· support_SC_W13_CS_C1-3_P1a_recycling_globe

· support_SC_W13_CS_C1-3_P1a_bench

PROJECT STEPS

Change document margins to Normal.

Change theme colors to Green (8th row in the Office section of the Colors palette).

Select the text “Recycle Your E-Waste!” and format it with the following attributes:

a. Center-align the text.

b. Change the font to 36 pt. Arial Black.

c. Apply the Fill – Green, Accent 1, Shadow text effect (2nd column, 1st row in the Text Effects and Typography palette).

Add a bottom paragraph border to the text “Recycle Your E-Waste!” using the following attributes:

a. Use the Aqua, Accent 5, Darker 25% border color (9th column, 5th row in the Theme Colors palette).

b. Use a 3 pt. width.

a. Apply Square text wrapping.

b. Resize the image proportionally so it has a height of 0.83”.

c. Change the Before paragraph spacing of the paragraph beginning “Are you feeling weighed down…” to 12 pt. and the After spacing to 18 pt.

Format the text “What can you drop off?” with the following attributes:

a. Change the font size to 15 pt.

b. Apply bold and the font case Capitalize Each Word.

c. Apply Green, Accent 1, Darker 25% paragraph shading (5th column, 5th row in the Shading palette).

d. Apply the White Background 1 font color (1st column, 1st row in the Theme Colors palette).

Format the text from “Batteries” through “…Plasma” as a bulleted list. (Hint: Your list should contain exactly 11 list items.)

a. Resize the picture so it has a height of 1.8” and a width of 2.4”.

b. Apply Square text wrapping.

c. Apply the Bevel Rectangle picture style.

d. Move the image horizontally toward the right edge of the document. Refer to Figure 1 on the following page.

Figure 1: Final position of bench picture

Insert a Rounded Rectangle (2nd column, 1st row in the Rectangles area of the Shapes gallery) that is 0.54” tall and 2.37” wide positioned immediately below the picture inserted in Step 8. Then:

a. Apply Square text wrapping to the shape.

b. Add text to the shape that reads:

Picture yourself here enjoying a greener world!

c. Format the text in bold and UPPERCASE.

Right-align the text that begins “Do you have…” and ends with “…take the item.”, and then format it in bold with 14 pt. font size. Set the paragraph’s After spacing to 0.

Place the insertion point after the text that ends “…if we can take the item.”, press Enter two times, and select left-align. Then, insert a table with 2 columns and 5 rows at that point.

Merge the cells in row 1, and then enter the text exactly as shown in Table 1 below.

Table 1: Remember to mark your calendars

Format the table with the following attributes:

a. Apply the Grid Table 4 – Accent 1 table style and AutoFit Window.

b. Format the text in column 2 with a Green, Accent 1, Darker 50% font color (5th column, 6th row in the Theme Colors palette).

c. Format all of the text in the table 16 pt.

Insert a footnote at the end of the first paragraph following the period in the text “…5th annual e-waste drop off.” with the following text:

In case of rain, the drop off will be moved inside the Park District warehouse at the same address as noted in the table. Use the southwest entrance, which will be clearly marked.

Add a blank header to the document with the text:

Distributed by the Evergreen Park District

Apply bold formatting and center-align the header text.

Check the Spelling & Grammar in the document to identify and correct any spelling errors. (Hint: You should find and correct at least 2 spelling errors.)

Your document should look like the Final Figure on the following page. Save your changes, close the document, and exit Word. Follow the directions on the SAM website to submit your completed project.

Final Figure

Jordan Desai

Professor Mayes

Planetary Science 200

23 September 2015

Comparing three Mars rovers

Mars is not easy to reach or explore. Nearly two-thirds of all missions have failed. However, in recent years, the United States has had more success landing rovers. Of recent missions, two rovers essentially crash-landed in a cocoon of airbags and one soft-landed.

The next missions were the twin rovers Spirit and Opportunity, which were launched a few weeks apart and landed on opposite sides of the planet in the summer of 2003, also using airbag technology. They both were the size of golf carts and outlasted their scheduled missions many times over.

Curiosity landed in August 2012 and is the largest and most ambitious rover. The size and mass of a Mini Cooper, it survived a complex soft landing. Curiosity also supports the most complex science, containing drills, lasers, and a small analytical laboratory.

Curiosity can communicate with Earth in three ways. First, Curiosity can engage in direct communication from the rover to Earth’s Deep Space Network. Second, Curiosity can use a fast relay via the orbiting Mars Odyssey spacecraft. Finally, Curiosity can utilize a slow relay to communicate via the Mars Reconnaissance Orbiter.

The sceintific missions have focused on whether Mars once harbored flowing water. Specifically, the science studies Martian geology to determine how the rocks and soils formed. Based on how they form on Earth, many Martian discoveries appear to have followed a similar path, such as a long exposure to water or geology formed by intense heat and water.

NASA has engaged in a few popular public relations efforts with the rover missions. One has been to invite students to name its rovers by submitting a short essay. Each naming invitation generates over 10,000 entries. Recent winners are listed below.

Sojourner, submitted by a 12-year-old boy

Spirit and Opportunity, submitted by a 9-year-old girl

Curiosity, submitted by a 12-year-old girl

The winner was also invited to see the launch.

This file created specifically for Dominica Esono Nseng

Band needs bassist: homeless shelter fundraiser

Join Campus Creatures, a well-respected local band for this one-time concert and maybe more. We are headlining the benefit for the homeless shelter, but our bassist broke her hand. We have a Fender you can use.

looking for a bassist and maybe a drummer. Best if you can do both (as we are multi-instrumentalists)!

We play the following types of music:

Bluegrass

Classic Rock

Rockabilly

Funk

Prepare for classic riffs and odd time signatures.

Call 555.006.0987

This file created specifically for Dominica Esono Nseng

ShellyCashman Word 2013

Chapter 2: SAM Project 1a

Shelly Cashman Word 2013
Chapter 2: SAM Project 1a

Comparing Mars Rovers

creating a short research paper

Project Goal

M Project Name

Project Goal

PROJECT DESCRIPTION

Your professor in Planetary Science has asked you to research Mars rovers and how NASA encourages public interest in Mars exploration. You will write a short paper using the MLA format. To credit your sources, you will include a Works Cited page at the end.

GETTING STARTED

· Download the following file from the SAM website:

· SC_Word2013_C2_P1a_FirstLastName_1 x

· Open the file you just downloaded and save it with the name:

· SC_Word2013_C2_P1a_FirstLastName_2 x

· Hint: If you do not see the x file extension in the Save file dialog box, do not type it. Word will add the file extension for you automatically.

· With the file SC_Word2013_C2_P1a_FirstLastName_2 x still open, ensure that your first and last name is displayed in the footer. If the footer does not display your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

1. Modify the document’s Normal style by changing its font to Times New Roman, font size to 12 pt., and line spacing to double with no blank space after paragraphs.

2. Select all of the text in the document and apply the Normal style to it.

3. Insert a header:

a. Insert a blank header at the top of the page.

b. Right-align the blank paragraph in the header.

c. Type the text Desai, press the SPACEBAR, and then insert a Plain Number page number from the Current Position gallery.

d. Close the header view.

4. Center-align the title paragraph “Comparing three Mars rovers” and then change the case to Capitalize Each Word.

5. Select the body paragraphs starting with “Mars is not easy…” and ending with “NASA has engaged…” and create a First Line indent at 0.5”.

6. Move the insertion point to the end of the sentence “Of recent missions…one soft-landed.” Press the ENTER key to begin a new line and then type a new body paragraph with the following text:

The first lander, Sojourner, part of the Mars Pathfinder mission, was about the size of a milk crate and weighed 33 pounds. It landed using airbags on July 4, 1997, and stayed active 10 times longer than scheduled.

(Hint: Italicize the name of the rover, but do not bold the body text.)

7. Change the Citations & Bibliography Style of the document to MLA Seventh Edition.

8. Find the phrase “…using airbag technology” in the third body paragraph. Move the insertion point before the period in that sentence and insert a citation using the source information shown in Figure 1 below.

Figure 1: Web Citation

Microsoft product screenshots used with permission from Microsoft Corporation.

Copyright © 2014 Cengage Learning. All Rights Reserved.

9. Edit the citation to add the page number 1.

10. Find the phrase “…survived a complex soft landing” in the fourth body paragraph. Move the insertion point before the period in that sentence and insert a citation using the source information shown in Figure 2 on the following page.

Figure 2: Journal Citation

Copyright © 2014 Cengage Learning. All Rights Reserved.

11. Edit the second citation to add the page number 289.

12. Find the phrase “…the rocks and soils formed” in the sixth body paragraph. Move the insertion point before the period in that sentence and insert a citation using the source information shown in Figure 3 below.

Figure 3: Book CitationCopyright © 2014 Cengage Learning. All Rights Reserved.

13. Edit the third citation to add the page numbers 46-47.

14. Move the insertion point after the period in the sentence “NASA has engaged…with the rover missions.” Insert a footnote with the text:

Some rovers even have Twitter accounts to engage the public.

15. Modify the Footnote Text style by changing its font size to 12 pt., the line spacing to double, and adding a First Line indent at 0.5”. Apply the modified style to the footnote text.

16. Select the three paragraphs starting with “Sojourner, submitted by a 12-year-old boy” and ending with “Curiosity, submitted by a 12-year-old girl” and create a bulleted list.

17. Move the insertion point to the end of page two and insert a manual page break to create a new page three.

18. On page three, apply the Normal style to the first blank paragraph and then center-align the paragraph. Type the title Works Cited, press ENTER, and then left-align the blank paragraph.

19. Use the Insert Bibliography command to insert a list of sources.

20. Check the Spelling & Grammar in the document to identify and correct any spelling errors. (Hint: You should find and correct at least 1 spelling error.)

Your document should look like the

Final Figure

on the following pages. Save your changes, close the document, and exit Word. Follow the directions on the SAM website to submit your completed project.

Final Figure

Copyright © 2014 Cengage Learning. All Rights Reserved.

Copyright © 2014 Cengage Learning. All Rights Reserved.

Copyright © 2014 Cengage Learning. All Rights Reserved.

2

Turn in your highest-quality paper
Get a qualified writer to help you with

“ computer sciences projects ”
Get high-quality paper
Guarantee! All work is written by expert writers!

Calculate your order

Type of paper

Academic level

Deadline

Pages
275 words

Total price: $0.00

computer sciences projects

Statistics

Volunteer Educators

Recycling Companies

PROJECT DESCRIPTION

GETTING STARTED

PROJECT STEPS

Documentation

11 May 2015 Revenue Detail

4 May 2015 Revenue Detail

2016 Revenue Projection

Credit Card Transactions

PROJECT DESCRIPTION

GETTING STARTED

PROJECT STEPS

Final Figure 1: 4 May 2015 Revenue Detail

Microsoft product screenshots used with permission from Microsoft Corporation. Copyright © 2014 Cengage Learning. All Rights Reserved.

Final Figure 2: 11 May 2015 Revenue Chart

Sheet1

PROJECT DESCRIPTION

GETTING STARTED

PROJECT STEPS

Documentation

Pickup Analysis

PROJECT DESCRIPTION

GETTING STARTED

PROJECT STEPS

PROJECT DESCRIPTION

GETTING STARTED

PROJECT STEPS

Band needs bassist: homeless shelter fundraiser

PROJECT DESCRIPTION

GETTING STARTED

PROJECT STEPS

Figure 1: Web Citation

Figure 2: Journal Citation

Figure 3: Book CitationCopyright © 2014 Cengage Learning. All Rights Reserved.

Final Figure

Top-quality papers guaranteed

100% original papers

Confidential service

Money-back guarantee

Enjoy the free features we offer to everyone

Calculate how much your essay costs

How to place an order

What we are popular for

Ask experts to write you a cheap essay of excellent quality

Volunteer
Educators

11 May 2015
Revenue Detail

2016
Revenue Projection

Microsoft product screenshots used with permission from Microsoft Corporation.
Copyright © 2014 Cengage Learning. All Rights Reserved.