Excel Homework

/in /by

Office 2013 – myitlab:grader – Instructions Excel Project

YOF EM03 H1 – Fitness Classes 1.1

Project Description: The hotel has started facilitating fitness classes for hotel guests. Guests can register for classes prior to their arrival or when they arrive to the hotel. Several instructors lead the classes, and each instructor has multiple skills. The fitness center manager would like to have a spreadsheet developed that will track class enrollment. The spreadsheet will provide an overview of guest enrollment with some analysis, which will be used for better decision-making.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Open the downloaded Excel file named e03ps1_grader_h1_start.xlsx. Save the file with the name e03ps1Fitness_LastFirst replacing LastFirst with your name. 0.000 2 Click the Input Data worksheet tab. Select range B11:H14. Create named ranges using the top row as the name for your named ranges. Each range is the list of instructors that can teach individual classes. 6.000 3 Select range B4:H8. Create named ranges using the top row as the name for your named ranges. Each range includes fitness class details. 6.000 4 Click the Enrollment worksheet tab. In cell A14, insert a table using range A13:D55 and the top row as the headers. 5.000 5 In cell D14, enter a HLOOKUP function that will look up the class number in cell B14 and use the ClassInfo table to return the Fee from the fifth row of the table with an exact match. Copy the formula down to cell D55, if necessary. 7.000 6 In cell E13, create a new column header named Class Name. In cell E14, enter a HLOOKUP function that will look up the class number in cell B14 and use the ClassInfo table to return the Class Category name from the second row of the table with an exact match. Copy the formula down to cell E55, if necessary. 7.000 7 Select A13:E55, and then name the entire range Enrollment. Create the range so that it refers to the cell range itself and not the table name. Create named ranges using the top row as the name for your named ranges. Copy range A13:E13, and then paste in range A1:E1 to set up the advanced filter criteria area. In cell C2, type F. In cell E2, type Yoga. 7.000 8 In cell B6, create a DCOUNTA function to count the Student_ID field in the Enrollment table that meet the filter criteria specified in range A1:E2. In cell B7, create a DAVERAGE function to average the Fee field in the Enrollment table that meet the filter criteria specified in range A1:C2. This will average all fees collected from females. In cell B8, create a DSUM function to sum the Fee field in the Enrollment table that meet the filter criteria specified in range A1:E2. This will total all yoga fees collected from females. 10.000 9 Click the Report worksheet tab. Use the following information to create calculations that will help hotel employees manage the fitness class enrollments. The user will put an “x” in range E4:E10, indicating which class to report upon and an “x” in range H4:H5 if employees want a report on a specific gender. In cell A4, use a MATCH function nested in an INDEX function to retrieve the Class that was selected in E4:E10. The MATCH should find the row where the “x” is located and would be used within the INDEX to pull the associated Class value from the same row within range F4:F10. In cell B4, use a MATCH nested in an INDEX function to retrieve the Gender that was selected in H4:H5, looking at the “x” in column H and returning the F or M for the Gender criteria. Using a MATCH nested in an INDEX function, retrieve the gender that was selected in H4:H5. Nest the MATCH and INDEX formula inside of the IFERROR function, in case the user does not select a specific gender. The IFERROR should leave the cell blank, using “” , if a gender is not selected. 8.000 10 In cell C4, create a COUNTIF formula that counts the enrollment for the named range Class that has the class number listed in A4. The range criteria should reference the Class named range. In cell B7, create a HLOOKUP formula that will look up the Class in A4 within the ClassInfo named range and return the maximum enrollment, which is in the third row of that table. The value should be looking for an exact match. 8.000 11 In cell B8, create a HLOOKUP formula that will use the Class in A4 and retrieve the Class Category type from the ClassInfo named range in row 2, also looking for an exact match. In cell B11, create an IF function to indicate the availability of reservations. If the number enrolled in C4 is greater than or equal to the maximum enrollment in B7, then FULL OR OVERBOOKED should display. Otherwise, Spots Available should display. 8.000 12 The instructors for each class are listed on the Input Data worksheet in range B12:H14. The instructors for the Aerobics class need to be counted. In cell B12, create a complex function that will determine the number of instructors for the class listed in A4. Use the COUNTA, INDIRECT, INDEX, and MATCH functions. Click cell B13. Using an HLOOKUP nested in an AND function nested in an IF function, return either Split Class or Can’t Split based on business options. Two conditions are needed to determine if a class can be split. Using the ClassInfo table, one row shows if a class can be split. That condition can be determined with a HLOOKUP. The second is if there is more than one instructor as shown in cell B12. If both conditions are met, the class can be split. Otherwise, the class cannot be split. 8.000 13 Insert a PivotTable using the Enrollment named range on the Enrollment worksheet. Insert the PivotTable on a new worksheet named Pivot Analysis. Add the Student_ID, Gender, and Class Name fields to the PivotTable. Move Gender to the COLUMNS area. Move Student_ID to the VALUES area. In cell B3, replace Column Labels with Gender. In cell B4, replace F with Female. In cell C4, replace M with Male. In cell A3, replace Count of Student_ID with Total Students. In cell A4, replace Row Labels with Classes. Resize the column widths as needed. Apply Pivot Style Light 10 to the PivotTable. 10.000 14 Insert a Clustered Column PivotChart on the Pivot Analysis worksheet. Reposition the PivotChart so the upper left corner is in the top left corner of cell F3. Drag the lower right corner so the PivotChart fills column N. Change the color of the PivotChart to Color 13. Apply Style 8 to the PivotChart. Add a chart title above the chart. Replace Chart Title with Enrollment by Class and Gender. 10.000 15 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Pivot Analysis, Enrollment, Input Data, Report. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0.000 Total Points 100.000

Updated: 03/10/2015 1 Current_Instruction.docx

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Exploring_w02_grader_h1.Docx

/in /by

The Interview Process

 

Project Description:

In the following project, you will format a document prepared for managers involved in the hiring process. You will create, modify, and apply styles. To enhance the document’s readability and appearance, you will include bullets and numbering. Finally, you will insert two pictures that depict processes described in the paper.

 

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step Instructions Points Possible
1 Download and open the file named exploring_w02_grader_h1.docx. 0
2 Ensure that the insertion point is on the first line of the document. Open the Styles pane. Create a New Style. Change the name to Title_Page_1. The Style type is Paragraph. The style should include 22 pt font size, and a font color of Blue, Accent 1, Darker 50%. (row 6, column 5). The new style is applied to the first line of the document. 8
3 Select the second line, A Study for Managers Involved in the Hiring Process, and change the font size to 16 pt. Change the font color of the selected line to Blue, Accent 1, Darker 50% (row 6, column 5). 6
4 Show nonprinting characters, if they are not already displayed. Click before the first paragraph mark following Updated by: and type Laura Sims. Change the case of Laura Sims to UPPERCASE. 5
5 Select document text from the line beginning The Personal Interview through the end of the document. Justify the selected text and change line spacing to 1.15. 6
6 Place the insertion point at the left of The Personal Interview on page 1 and insert a page break. Apply Heading 1 style to The Personal Interview. Modify Heading 1 style to use Dark Red font color (row 1, column 1 under Standard Colors). 8
7 Apply Heading 2 style to the Introduction heading. 5
8 Modify Heading 2 style to use Dark Red font color (row 1, column 1 under Standard Colors). Close the Styles pane. 5
9 Select five paragraphs in the Introduction section on page 2, beginning with Pre-Interview Impressions and ending with Trait Configurations. Apply a four-sided star bullet (v Character code: 118, under the Wingdings Font (decimal)) to the selected text. 5
10 Select the second paragraph in the Introduction section, beginning with Personal interviewing continues and apply these formats:
• 0.6” left and right indent
• 6 pt spacing after the paragraph
• Boxed 1 1/2 pt border using the color Blue, Accent 1, Darker 25%
• Shading of Blue, Accent 1, Lighter 80%		 8
11 Apply the first numbered-list format (1., 2., 3.) to the three phases in the Pre-Interview Impression Effects section. The phrases are The Pre-Interview Phase, The Interview Phase, and The Post-Interview Phase. (Hint: Click the Numbering arrow and select the first list format—the second selection on the first row—in the Numbering Library.) 5
12 Select the final paragraphs in the Pre-Interview Impression Effects section, beginning with Hakel, in 2002 and ending with negative aspects of their credentials. Display the selected text in two columns with a line between the columns. 7
13 Insert the picture file w02c1Perceptions.jpg at the beginning of the line that contains First, we discuss some of the psychological pitfalls, near the bottom of page 2. Change the height of the picture to 3”. Apply Top and Bottom text wrapping. 7
14 Position the picture so that it appears near the top of page 3, above the line that contains First, we discuss some of the psychological pitfalls. Align the picture so that it is centered horizontally. Apply the Rounded Diagonal Corner, White picture style. The picture displays at the top of page 3. Do not reposition it. 7
15 Insert the picture file w02c1Phases.jpg at the beginning of the line on page 3 that begins Hakel, in 2002. If necessary, position the picture so it appears immediately above the line that begins Hakel, in 2002. 6
16 Change the picture height to 0.5” and change text wrapping to Top and Bottom. Apply Offset Center Shadow picture effect (row 2, column 2 under Outer). 5
17 Display the document in Outline view. Collapse all paragraphs so only lines formatted as Heading 1 or Heading 2 display. Move the Stereotypes section immediately above Physical Characteristics. Close Outline view. 7
18 Save the document and exit Word. Submit the file as directed. 0
  Total Points 100

 

 

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Carpenter Family Camp CREATING Tables, Queries, Forms, And Reports In A Database

/in /by

Shelly Cashman Access 2016 | Modules 1–3: SAM Capstone Project 1a

 

C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.png Shelly Cashman Access 2016 | Modules 1–3: SAM Capstone Project 1a

Carpenter Family Camp

CREATING Tables, Queries, forms, and reports in a database

GETTING STARTED

Open the file SC_AC16_CS1-3a_FirstLastName_1.accdb, available for download from the SAM website.

Save the file as SC_AC16_CS1-3a_FirstLastName_2.accdb by changing the “1” to a “2”.

· If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

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

· Support_SC_AC16_CS1-3a_Activity.xlsx

 

PROJECT STEPS

Carpenter Family Camp operates summer camps for youth as well as families on a lake in Maine situated near the coast. The camp includes activities for families as well as separate activities for adults and children. Optional adventures to nearby attractions are also available. Create a new table in Datasheet View with the following options:

a. Rename the default primary key ID field to AdventureID, and then change its data type to Short Text. (Hint: The AdventureID field should remain the primary key.)

b. Change the field size of the AdventureID field to 4.

c. Add a new field with the name AdventureName and the Short Text data type.

d. Add another field to the table with the name AdultPrice and the Currency data type.

e. Add a fourth field to the table with the name ChildPrice and the Currency data type.

f. Save the table using Adventure as the name.

With the Adventure table still open in Datasheet View, change the font in the table to Arial Narrow and the font size to 12 pt.

 

With the Adventure table still open in Datasheet View, add the records shown in Table 1 below. If necessary, resize the AdventureName field so that all field values are completely visible. Save and close the Adventure table.

 

Table 1: Adventure Table Records

AdventureID AdventureName AdultPrice ChildPrice
BB01 Bike & Beach $28.00 $20.00
HR01 Horseback Ride $30.00 $25.00
WJ01 Windjammer Cruise $45.00 $35.00
WW01 Whale Watching $32.00 $26.00

 

Open the Reservation table in Design View and make the following changes:

g. Change the data type for the LodgingFee field to Currency.

h. Specify that the SessionID field is a Required field.

i. Save the changes to the Reservation table, and then close it. (Hint: Because you made changes to data types and field sizes, the “Some data may be lost” warning message appears. The data fits within the valid ranges, so ignore this message and continue saving the table.)

Open the Relationships window, and then add the Camper table to it. Create a one-to-many relationship between the ParentID field in the Parent table and the ParentID field in the Camper table. Make the relationship enforce referential integrity and cascade update related fields. Do not make the relationship cascade delete related records. Save the relationships, and then close the window.

Open the Counselor table in Design View and make the following changes:

j. Add a new field following the Specialty field. Assign the name CPR Certification to the field.

k. Set the data type for the field to Yes/No.

l. Set the Caption property to CPR.

m. Enter CPR certification current? as the description for the field.

n. Save the changes to the Counselor table, and then close it.

Open the Reservation table in Datasheet View, and then find or navigate to the record with the ReservationID field value 1700012. Change the LodgingFee field value to $140.00.

With the Reservation table still open in Datasheet View, apply a filter by selection to locate all records where the SessionID field value equals 1. Change the AdultPrice field value for ParentID 101 to $245.00. Change the ChildPrice field value for the same record to $215.00. Clear all filters. Save and close the Reservation table.

Open the Counselor table in Design View. Use the Lookup Wizard to change the Specialty field to a Lookup field. Type in the following four values (in the order shown) as the list of possible values for the field: Arts & Crafts, Land Sports, Nature Studies, and Water Sports. Limit the field values to only the items in the list, and do not allow multiple values for the field.

With the Counselor table still open in Design View, delete the HomePhone field. (Hint: If a message appears concerning deleting an index, continue with the deletion.) Save the Counselor table.

Switch to viewing the Counselor table in Datasheet View, and then change the SpecialCertification field value for Susan Kiley (who has a CounselorID field value of KS01) to Wilderness First Aid. Close the table.

Import the data from the file Support_SC_AC16_CS1-3a_Activity.xlsx, available for download from the SAM website. Append the records to the Activity table. Do not create a new table, and do not save the import steps.

Carpenter Family Camp requires all campers to submit a signed liability waiver from their parents. Create an update query to change the Waiver field value to No for all records currently in the Parent table. Run the query, and then save it using Waiver Update Query as the name. (Hint: 21 records will be updated by this query.) Close the query.

Use the Simple Query Wizard to create a query based on the Counselor table with the following options:

o. Include the CounselorID, FirstName, LastName, and CellPhone fields (in that order).

p. Save the query with the name Counselor Contact Query, and then close the query.

Create a new query in Design View based on the Counselor and Counselor_Session tables with the following options:

q. Include the SessionID field from the Counselor_Session table.

r. Include the LastName, FirstName, and CellPhone fields (in that order) from the Counselor table.

s. Sort the records in ascending order based on the SessionID field and then by the LastName field.

t. Save the query using Session Contact Query as the name.

u. Run the query, and then close it.

Use the Crosstab Query Wizard to create a crosstab based on the Reservation table with the following options:

v. Use only data from the Reservation table in the query.

w. Use SessionID as the row heading.

x. Use Children as the column heading.

y. Use a sum of the ChildPrice field as the calculated value for each row and column intersection in the crosstab query.

z. Save the crosstab query using Session-Child Crosstab as the name.

aa. View the query, and then close it.

Create a new query in Design View based on the Reservation table and the Session 1 Payments table with the following options:

ab. Select the ParentID field from the Reservation table.

ac. Select the ReservationID, SessionID, AdultTotal, ChildTotal, and Lodging fields (in that order) from the Session 1 Payments table.

ad. Move the ParentID field to the right of the SessionID field.

ae. Add a calculated field after the Lodging field with the alias TotalFees that calculates the sum of the AdultTotal, ChildTotal, and Lodging fields.

af. Save the query using Session 1 TotalFees Query as the name.

ag. View the query, confirm that it matches Figure 1 below, and then close it.

 

Figure 1: Session 1 TotalFees Query

 

Open the States Query in Design View, and then add the criteria to select only those records with a State field value of NY or NJ. Save and run the query, and then close it. (Hint: This query should return records that meet one or more of the query conditions.)

Open the Younger Males Query in Design View, and then add the criteria to select only those records with a Gender field value of M and an Age field value of less than 10. Hide the Gender field. Save and run the query, and then close it. (Hint: This query should only return records that meet both of the query conditions.)

Open the Sessions Total Query in Design View, and then modify it by adding Totals to the query. For the SessionID field, set the Total row to Group By. For the ReservationID field, set the Total row to Count. Save and run the query, and then close it.

Create a Split Form based on the Parent table. Save the form as Parent Update Form, and then close the form.

Open the Parent Update Form, and then add a new record to the Parent table, using the values shown in Figure 2 below. Close the form.

 

Figure 2: New Record for the Parent Update Form

Create the simple report shown in Figure 3 below for the Adventure table. Save the report with the name Adventure Report, and then close the report.

 

Figure 3: Adventure Report

 

Use the Report Wizard to create a new report based on the Parent table with the following options:

ah. Include the ParentID, FirstName, LastName, HomePhone, and CellPhone fields (in that order) from the Parent table.

ai. Use no additional grouping in the report.

aj. Sort the report in ascending order by the ParentID field.

ak. Use the Tabular layout and Portrait orientation for the report.

al. Assign the name Parent Contact Report to the report.

am. Preview the report to ensure that it matches Figure 4 below, and then save and close the report.

 

Figure 4: Parent Contact Report

Open the Session 1 Report in Layout View, and then make the following changes to the report:

an. Remove the City and State columns from the report.

ao. Add a Totals row that calculates the sum of the values in the Adults column and the sum of the values in the Children column. If necessary, expand the size of the total control so that it appears completely.

ap. Change the title of the report using Session 1 Camper Report as the name.

aq. View the Session 1 Report in Report View, confirm that it matches Figure 5 below, and then save and close the report.

 

Figure 5: Session 1 Report

Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.

 

2

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Powerpoint Presentation

/in /by

SIMnet 2016: PowerPoint 2016 Capstone Project Level 1

 

1 | Page Last Modified: 4/30/18

PowerPoint 2016 Capstone Project PP-1 Creating a Company’s Presentation In this project, you will modify a presentation for the Top’t Corn popcorn company. You will change the look of the

entire presentation by applying a theme and theme variant. You will add content to the presentation including text (in

Normal view and Outline view), pictures, and a table of information. You will add a transition to all the slides in the

presentation as well as animate objects on a slide. You will add information to the footer area of the slides. Finally, you

will practice running the presentation.

Skills needed to complete this project:

• Change the presentation theme

• Apply a theme variant

• Add text to slides

• Add a picture

• Move an image

• Enter text in Outline view

• Align text

• Create a table on a slide

• Add an online picture

• Apply a picture Quick Style

• Apply and modify a slide transition

• Apply an animation effect

• Modify an animation

• Add custom text to the footer

• Start the slide show

• Navigate the slide show using the mouse and keyboard

 

This image appears when a project instruction has changed to accommodate an update to

Microsoft Office 365. If the instruction does not match your version of Office, try using the alternate

instruction instead.

IMPORTANT: Download the resource file needed for this project from the Resources link. Be sure to

extract the file after downloading the resources zipped folder. Please visit SIMnet Instant Help for step-by-

step instructions.

1. Open the start file PP2016-Capstone-Level1. If the document opens in Protected View, click the Enable

Editing button in the Message Bar at the top of the document so you can modify it.

2. The file will be renamed automatically to include your name. Change the project file name if directed to

do so by your instructor, and save it.

3. Change the presentation theme to Integral.

If the Integral theme is not available in your version of Microsoft Office, apply a

different theme of your choice.

4. Change the variant to use the solid aqua option (the third option in the Variants gallery).

If you applied a different theme than Integral for instruction 3, select a variant option of

your choice for instruction 4.

5. On Slide 1, click in the subtitle placeholder and type the text Gourmet popcorn with capitol

topping

Step 1

Download start file

 

 

SIMnet 2016: PowerPoint 2016 Capstone Project Level 1

 

2 | Page Last Modified: 4/30/18

6. On Slide 1, insert the Logo.png image from the location where you saved the data files for this project.

(Downloaded from the Resources link.)

7. Move the logo to the top-left corner of the slide, so it looks like the figure below.

 

 

8. Switch to Outline view and add the following bullet points to the fifth slide (Future Flavors):

Key Lime

Mocha Delight

Raspberry Bliss

Spiced Buffalo

9. Switch back to Normal view and navigate to Slide 4. Center align the bulleted list on the slide.

10. Add the following information in a table on Slide 7:

a. Georgetown

Farragut

Square

George

Washington K Street

b. Old Bay 950 2130 1212 1910

c. Sea Salt and

Caramel 1325 2480 1980 2115

d. Truffle 1135 2240 935 2234

 

11. Navigate to Slide 2. Insert an online picture using the search word Capitol. Insert a picture of

your choice.

12. Apply the Rounded Diagonal Corner, White picture style to the online picture you inserted.

13. Navigate to Slide 1 and add the Wipe transition to the slide. Change the direction of the transition so it

animates from the left. Apply the transition to all the slides in the presentation.

Download Resources

 

 

SIMnet 2016: PowerPoint 2016 Capstone Project Level 1

 

3 | Page Last Modified: 4/30/18

14. Animate objects on a slide.

a. Navigate to Slide 6 and select the food truck image on the left. Apply the Float In (Entrance)

animation to the picture and change the direction so image floats down.

b. Select the second truck on the slide. Apply the Apply the Float In (Entrance) animation to the

picture and change the direction so image floats down. Change the Start option so the truck will

animate with the previous animation plays.

15. Add information to the footer of all slides.

a. Navigate to slide 1, and open the Header and Footer dialog.

b. Add The Top’t Corn Enterprise as the footer text.

c. Apply the footer to all slides in the presentation.

16. Start the slide show from the beginning and navigate through the presentation. Use a combination of

keyboard and mouse commands to navigate to different slides.

Note: When you are finished with this project, your presentation should contain 10 slides. If it does not, your

project will not grade properly and you may lose a significant number of points. Check your work carefully.

17. Save and close the presentation.

18. Upload and save your project file.

19. Submit project for grading.

Step 2

Upload & Save

Step 3

Grade my Project

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

UFO Sightings- Building Website

/in /by

Do certain areas have higher concentrations of sightings?

What is the most common shape of a sighting?

What is the average duration of a sighting?

Is there a higher concentration of sightings at night?

Data sets are here:

https://www.kaggle.com/NUFORC/ufo-sightings/metadata (Century of data)Attached

http://www.nuforc.org/webreports/ndxe202004.html (April sightings 2020)

Sketch ideal visuals 

Bubble Map to view concentration levels of sightings (Leaflet)

example: https://www.d3-graph-gallery.com/bubblemap.html

Lollipop Chart to view the most common shapes of a sighting

example: https://www.d3-graph-gallery.com/lollipop.html

Violin Chart to view the bins of duration for a sighting

example: https://www.d3-graph-gallery.com/violin.html

Word Cloud of submitted summaries for each sighting (D3)

example: https://www.d3-graph-gallery.com/graph/wordcloud_size.html

Requirements: 

Your assignment should: 

Include A dashboard page with multiple charts that updates from the same data

Should include Json amCharts (https://www.amcharts.com/javascript-maps/)

Must include some level of user-driven interaction(e.g, menus, dropdowns. textboxes)

Main web page with navbar (possible separate pages for charts as well)

Main page with a filter for selected dates/locations with a collective chart change

Main Chart on top of screen – Map of locations (Bubble)

Secondary chart below or beside Bubble: Amchart pictorial

(This chart will show how many sightings per period selected)

Filtered charts per date or location:

Violin, Lollipop, Word Cloud

A combination of web scraping and Leaflet or Plotly 

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

NP_EX19_7a

/in /by

NP_EX19_7a_FirstLastName_1

 

* GETTING STARTED

· Open the file NP_EX19_7a_FirstLastName_1.xlsx, available for download from the SAM website.

· Save the file as NP_EX19_7a_FirstLastName_2.xlsx by changing the “1” to a “2”.

o 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.

· With the file NP_EX19_7a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.

o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

* PROJECT STEPS

1. Lael Masterson works in the Student Activities Office at Valerian State College in Illinois. Lael has started compiling information on students who are interested in helping run student organizations at Valerian State, and she needs your help completing the workbook.
Switch to the Student Representatives worksheet. In cell E2, enter a formula using the HLOOKUP function as follows to determine a student’s potential base hourly rate (which is based on the number of years of post-secondary education):

a. Use a structured reference to look up the value in the Post-Secondary Years column. Retrieve the value in the 2nd row of the table in the range P13:U14, using an absolute reference. Because base hourly rate is tiered based on the number of years of education, find an approximate match.

b. Fill the formula into the range E3:E31, if necessary.

2. Student organizations sometimes require transportation for off-campus activities, and school policy requires students to be over 23 years old to serve as transport.
Lael wants to determine how many of the active students will be eligible to transport other group members. In cell J2, enter a formula using the IF function and structured references as follows to determine if Kay Colbert can serve as authorized transport:

a. The function should use a reference to the Age column to determine if the student’s age is greater than 23, and should return the text Yes if true and No if false.

b. Fill the formula into the range J3:J31, if necessary.

3. To be eligible for the leadership training program offered by the office, a student must have at least 2 years of post-secondary education or have gone through the organization finance training.
In cell K2 enter a formula using the IF and OR functions and structured references as follows to determine if Kay Colbert can join the leadership training program:

a. The IF function should determine if the student’s Post-Secondary Years is greater than or equal to 2 OR if the student’s finance certified status is “Yes”, returning the text Yes if a student meets one or both of those criteria or the text No if a student meets neither of those criteria.

b. Fill the formula into the range K3:K31, if necessary.

4. Experienced students may serve as mentors if they are at least age 21 and have at least 3 years of post-secondary education. In cell L2, enter a formula using the IF and AND functions and structured references as follows to determine if Kay Colbert is eligible to serve as a mentor:

a. The IF function should determine if the student’s age is greater than or equal to 21 AND the student’s post-secondary years are greater than or equal to 3, and should return the text Yes if a student meets both of those criteria or the text No if a student meets none or only one of those criteria.

b. Fill the formula into the range L3:L31, if necessary.

5. Lael is always on the lookout for students who might be interested in running for office in student groups.
In cell M2, enter a formula using a nested IF function and structured references as follows to determine first if a student has already been elected to office in a student group, and if not, whether that student meets the qualifications to run in the future:

a. If the value in the Elected column is equal to the text “Yes”, the formula should display Elected as the text.

b. Otherwise, the formula should determine if the value in the Finance Certified column is equal to the text “Yes” and return the text Yes if true And No if false.

6. Students who work with student organizations are also considered for employment at the Student Activities Office. Students with more than 4 years of post-secondary education are qualified for more complex Tier 2 jobs.
In cell N1, enter the text Tier as the column heading.

7. In cell N2, enter a formula using the IF function and structured references as follows to determine which work tier Kay Colbert is qualified for:

a. The IF function should determine if the student’s Post-Secondary Years is greater than or equal to 4, and return the value 2 if true or the value 1 if false.

b. Fill the formula into the range N3:N31, if necessary.

8. Lael wants a quick way to look up students by their Student ID.
In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text Invalid Student ID should display.

9. Lael wants to determine several totals and averages for active students.
In cell Q8, enter a formula using the COUNTIF function and structured references to count the number of students who have been elected to offices in student organizations.

10. In cell R8, enter a formula using the AVERAGEIF function and structured references to determine the average number of post-secondary years for students who have been elected.

11. In cell R9, enter a formula using the AVERAGE function and structured references to determine the average number of years of post-secondary education of all students as shown in the Post-Secondary Years column.

12. Switch to the Academic Groups worksheet. In cell A14, use the INDEX function and structured references to display the value in the first row and first column of the AcademicGroups table.

13. In cell A17, use the SUMIF function and structured references to display the total membership in 2023 for groups with at least 40 members.

14. Lael is also planning for student groups that the office will be working with in the coming year. She decides to create a PivotTable to better manipulate and filter the student group data.
Switch to the Academic PivotTable worksheet, then create a PivotTable in cell A1 based on the AcademicGroups table. Update the PivotTable as follows so that it matches Final Figure 2:

a. Change the PivotTable name to: AcademicPivotTable

b. Add the Activities field and the Group Name field (in that order) to the Rows area.

c. Add the 2021, 2022, and 2023 fields (in that order) to the Values area.

d. Change the display of subtotals to Show all Subtotals at Top of Group.

e. Change the report layout to Show in Outline Form.

f. Update the Sum of 2021 field in the Values area to display the name 2021 Membership with the Number number format with 0 decimal places.

g. Update the Sum of 2022 field in the Values area to display the name 2022 Membership with the Number number format with 0 decimal places.

h. Update the Sum of 2023 field in the Values area to display the name 2023 Membership with the Number number format with 0 decimal places.

15. Lael wants to summarize data for all student groups in a PivotTable. To do so, she must first update the AllGroups table.
Switch to the All Groups worksheet then edit the record for the Astronomy Society to use 76 as the 2023 field value.

16. Switch to the All Groups PivotTable worksheet. Refresh the PivotTable data, then verify that the 2023 Membership value for the Astronomy Society in row 6 reflects the change you made in the previous step.

17. Apply the Light Blue, Pivot Style Medium 2 PivotTable style to the PivotTable.

18. Add the Office field to the Filters area of the Pivot Table. Filter the table so that only organizations with private offices are visible.

19. Filter the PivotTable as follows:

a. Create a Slicer based on the Activities field value.

b. Resize the slicer so that it has a height of 2.2″ and a width of 3.2″.

c. Move the slicer so that its upper-left corner appears within cell F3 and its lower-right corner appears within cell J14.

d. Use the slicer to filter the PivotTable so that only Fraternal groups are visible.

Lael also wants to summarize membership data for all organizations using a PivotChart to help determine which groups are showing the most interest from students.
Switch to the Activities PivotTable worksheet. Based on

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Java Graded Projects And One Program

/in /by

1.Solve graded projects of pages 133-139, 165-168 and 195-200 of file 402943.pdf

2.Graded project of other file final graded project.pdf

3.This program:(you can take help for it at http://stackoverflow.com/questions/18216716/java-abstract-classes-and-inheritance)

Write an application named UseLoan that uses an abstract class named PersonalLoan and subclasses to display two different types of loans -home and car- and the cost per month for each. Each of the subclasses contains a constructor that sets the cost per month based on the loan type, after prompting the user for at least one data-entry item that is used in the cost-determining decision. (For example, with a car loan, you might ask the age of the car, or whether it is a sports car.) Include an abstract toString() method in the PersonalLoan class that constructs a String containing all the relevant data. Prompt the user for the type of insurance, and then create and display the appropriate object. Save the files as PersonalLoan.java, CarLoan.java, homeLoan.java, and UseLoan.java.

 

total 4 graded projects and one program

Price is final…and i want work asap… (do not ask me to raise the price)

Deliverables are mentioned in the graded projects

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Modeling And Simulation With Arena

/in /by

Exercise 1-

 

/Users/khashayarbehdinan/Desktop/Screen Shot 2016-06-20 at 11.01.16 AM.pngSuppose that 7.3, 6.1, 3.8 ,8.4, 6.9 ,7.1, 5.3, 8.2, 4.9, and 5.8 are 10 observations from a distribution (not highly skewed) with unknown mean µ,. Compute (10) , S2 (10), and an approximate 95 percent confidence interval for µ . For above data, test the null hypothesis

H0: µ= 6 at level =0.05.

Exercise 2-

Parts arrive at a single workstation system according to an exponential interarrival distribution with mean 21.5 seconds; the first arrival is at time 0. Upon arrival, the parts are initially processed. The processing-time distribution is TRIA(16, 19, 22) seconds. There are several easily identifiable visual characteristics that determine whether a part has a potential quality problem. These parts, about 10% (determined after the initial processing), are sent to a station where they undergo a thorough inspection. The remaining parts are considered good and are sent out of the system. The inspection-time distribution is 95 plus a WEIB(48.5, 4.04) random variable, in seconds. About 14% of these parts fail the inspection and are sent to scrap. The parts that pass the inspection are classified as good and are sent out of the system (so these parts didn’t need the thorough inspection, but you know what they say about hindsight). Run the simulation for10,000 seconds to observe the number of good parts that exit the system, the number of scrapped parts, and the number of parts that received the thorough inspection. Animate your model. Put a text box in your model with the output performance measures requested, and make just one replication.

 

Exercise 3-

 

An acute-care facility treats non-emergency patients (cuts, colds, etc.). Patients

arrive according to an exponential interarrival-time distribution with a mean of 11 (all times are in minutes). Upon arrival they check in at a registration desk staffed by a single nurse. Registration times follow a triangular distribution with parameters 6, 10, and 19. After completing registration, they wait for an available examination room; there are three identical rooms. Data show that patients can be divided into two groups with regard to different examination times. The first group (55% of patients) has service times that follow a triangular distribution with parameters 14, 22, and 39. The second group (45%) has triangular service times with parameters 24, 36, and 59. Upon completion, patients are sent home. The facility is open 16 hours each day. Make 200 independent replications of 1 day each and observe the average total time pa­tients spend in the system. Put a text box in your Arena file with the numerical results requested.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Module-8 Discussion

/in /by

Include at least 250 words in your posting and at least 250 words in your reply.  Indicate at least one source or reference in your original post. Please see syllabus for details on submission requirements.

Module 8 Discussion Question

Search “scholar.google.com” or your textbook. Discuss the issues organization’s face with regards to the protection of its customer information. How might an organization notify its users that all communications are being monitored and preserved? How will end users typically respond to such announcements?

Reply(Shiva)

 

It is normal for organizations to collect their customers’ data and store it in their databases. This act always comes with a price. The organizations have a duty to diligently protect the information at all costs. Even though organizations promise that they will protect their customers’ data, sometimes they fail to do so (Karjoth, Scunter, & Waidner, 2003).

Most organizations face problems for failing to protect their customers’ information. Take the example of a situation where the data is stolen by attackers. The customers’ run to courts demanding compensation. In other cases, organizations are accused of misusing personal data. This is done by selling customers’ data to third parties or using the data for marketing purposes. Sometimes they fail to observe disclosure requirements.

It also happens that some firms delete data accidentally or let unauthorized personnel access it. The end result is that the organization spends millions trying to retrieve the data. Poor handling of clients’ data leads to a bad reputation. Firms should notify their users whenever a breach occurs (Schwartz & Janger, 2007). Organizations have a role of informing their clients that they do collect, monitor and store their data. This can be done by including it in websites where clients are expected to submit their data. They can also send a notification to clients letting them know what time of information is being collected and monitored. If calls are affected, customers should be notified before they start giving their details.

On their side, customers can respond to this by accepting or declining to share their information. They can unsubscribe from services their dislike. Furthermore, they can seek clarification in case there is ambiguity. They can also ask firms to delete their data after the contractual terms.

References

Karjoth, G., Scunter, M., & Waidner, M. (2003, June 24). Platform for Enterprise Privacy Practices: Privacy-Enabled Management of Customer Data. Retrieved December 4, 2018, from https://link.springer.com/chapter/10.1007/3-540-36467-6_6

Schwartz, P. M., & Janger, E. J. (2007). Notification of Data Security Breaches 105 Michigan Law Review 2006-2007. Retrieved December 4, 2018, from https://heinonline.org/HOL/LandingPage?handle=hein.journals/mlr105&div=36&id=&page=

Reply(venu)

 

Organization have the right to monitor their employee’s use of the information and internet including visiting social networking sites, checking e-mails, and instant messaging on computers owned by the organization, during employee’s on-duty hours. Organization need to have a plan to ensure the security of your information assets. Failure to protect your data’s confidentiality might result in customer credit card numbers being stolen, with legal consequences and a loss of goodwill. Lose your clients’ confidential information and you may have fewer of them in the future.

Designated security officer: organizations for security regulations and standards, having a Designated Security Officer is not optional it’s a requirement. Security officer is the one responsible for coordinating and executing our security program. The officer is our internal check and balance. This person or role should report to someone outside of the IT organization to maintain independence.

Policies and Procedures: The policies and procedures component is the place where we get to decide what to do about them. Physical security documents how you will protect all three C-I-A aspects of your data from unauthorized physical access. Authentication, authorization, and accountability establishes procedures for issuing and revoking accounts. It specifies how users authenticate, password creation and aging requirements, and audit trail maintenance. Security awareness makes sure that all users have a copy of your acceptable use policy and know their responsibilities; it also makes sure that your IT employees are engaged in implementing your IT-specific policies.

Risk assessment: This component identifies and assesses the risks that your security program intends to manage. Unauthorized access to your own data and client or customer data. Remember, if you have confidential information from clients or customers, you’re often contractually obliged to protect that data as if it were your own.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Business Ethics

/in /by

 

4th question

Summary:

Pick one of the following terms for your research: Stakeholder, corporate citizenship, reputation, corporate governance, or executive compensation.

Journal article I need two copys

Plz follow this instructions

DEFINITION: a brief definition of the key term followed by the APA reference for the term; this does not count in the word requirement. SUMMARY: Summarize the article in your own words- this should be in the 150-200 word range. Be sure to note the article’s author, note their credentials and why we should put any weight behind his/her opinions, research or findings regarding the key term. DISCUSSION: Using 300-350 words, write a brief discussion, in your own words of how the article relates to the selected chapter Key Term. A discussion is not rehashing what was already stated in the article, but the opportunity for you to add value by sharing your experiences, thoughts and opinions. This is the most important part of the assignment. REFERENCES: All references must be listed at the bottom of the submission–in APA format.

5th question

Summary:

Read Wells Fargo Banking Scandal and complete the questions at the end of the case study.

Plz click the link you got questions

““““““““““————————————————————–

6th question

Summary:

Pick one of the following terms for your research: Integrity, ethical dilemma, conflict of interest, bribery, or fraud.

Journal article I need two copys

Plz follow this instructions

DEFINITION: a brief definition of the key term followed by the APA reference for the term; this does not count in the word requirement. SUMMARY: Summarize the article in your own words- this should be in the 150-200 word range. Be sure to note the article’s author, note their credentials and why we should put any weight behind his/her opinions, research or findings regarding the key term. DISCUSSION: Using 300-350 words, write a brief discussion, in your own words of how the article relates to the selected chapter Key Term. A discussion is not rehashing what was already stated in the article, but the opportunity for you to add value by sharing your experiences, thoughts and opinions. This is the most important part of the assignment. REFERENCES: All references must be listed at the bottom of the submission–in APA format.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!