Computer-Based Decision Modeling – Module 3 Discussion

I need a study guide that discuss how data mining, clustering and statistical inference can apply within a specific workplace setting.

Provide at least two examples you have used.  Are these techniques more likely to be done by a specialist within the organization?  What about your work experience, what have you observed?

2 Weekly Summary and 2 Discussions

1. Week 1 Weekly Summary based on chapter 1 and 2

2.Week 2 Weekly Summary based on chapter 3 and 4

Chapters attached 

Each weekly summary should be 2 pages.

Each weekly summary should be 2 pages.

Discussions

Discussion 3.1

Do you think that it is important for a company to have a career management program?  Why or why not?  Have you ever participated in such a program?  If so, how was it?  If not, do you think you would want to?  Why?

Discussion 3.2

Do you believe that economic, social and political forces have had more of an impact on employee training now than it did in the past?  Why or why not?

discussion post

 You are a Black Hat about to attack a victim.  Choose a mode of attack -Sniffing, Session Hijacking, DoS,  or DDoS.  Explain your type of attack.  What is the process?  What tool(s) or exploit you will use, how does it work?  The steps you will take.  What will be the outcome if you are successful?  How can the victim have prevented this type of attack?  Go into as much detail as possible.  Minimum 200 words. 

5.1 Mock Dissertation: Chapter 1 Introduction

 Task:  Write a condensed (2.5 – 3 pages or more is fine) chapter 1 for your mock dissertation topic.  You will use the section headers required from the university dissertation handbook.  See examples provided and the rubric. The following section headings are required:

  • Overview (1-2 well developed paragraphs)
  • Background and problem statement (1-2 well developed paragraphs)
  • Purpose of the study (1 well developed paragraph)
  • Significance of the study (1 well developed paragraph) 
  • Research Questions (numbered list)
  • Theoretical Framework (1 well developed paragraph)
  • Limitations of the Study (1 short paragraph)
  • Assumptions (1 short paragraph)
  • Definitions (list)
  • Summary (1 well developed paragraph)

Solved Carpenter Family Camp

  

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

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

o Support_SC_AC16_CS1-3a_Activity.xlsx 

PROJECT STEPS 

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

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

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

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

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

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

c. 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.) 

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

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

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

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

c. Set the Caption property, using CPR as the value. 

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

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

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

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

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

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

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

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

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

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

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

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

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

a. Include the SessionID field from the Counselor_Session table. 

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

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

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

e. Run the query, and then close it. 

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

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

b. Use SessionID as the row heading. 

c. Use Children as the column heading. 

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

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

f. View the query, and then close it. 

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

a. Select the ParentID field from the Reservation table. 

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

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

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

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

f. 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.) 

19. 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.) 

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

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

22. 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 Figure 3: Adventure Report

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

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

b. Use no additional grouping in the report. 

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

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

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

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

Figure 4: Parent Contact Report

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

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

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

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

Assignment

 

Building Secure Web Apps
Breakout Activity #32 – The Dark Web

The Impact Of The Dark Web On Internet Governance And Cyber Security – The surface Web, which people use routinely, consists of data that search engines can find and then offer up in response to queries. This is only the tip of the iceberg — a traditional search engine sees about 0.03 percent of the information that is available (Bergman 2001). Much of the rest is submerged in what is called the deep Web. Also known as the “Undernet,” “invisible Web” and the “hidden Web,” it consists of data that cannot be located with a simple Google search.

Learn more about the Dark Web 

·  Is it a valid resource for legitimate research and investigation?

Group 1

You are a criminal organization specializing in drugs and human trafficking. How can you use the Dark Web to further your criminal endeavors?

Group 2

You are a cyber team working for the FBI. How can you use the Dark Web to investigate and stop crime?

Tasks

·  Write PPT

·  Prepare to debate

Exp19_Access_Ch03_ML2 – Investment Properties 1.2

 Exp19_Access_Ch03_ML2 – Investment Properties 1.2 

 Exp19 Access Ch03 ML2  Investment Properties 1.2 

 Access Chapter 3 Mid-Level 2 – Investment Properties 

  

Project Description:

You are in charge of Dysan Investment ‘s database, which contains all of the information on the properties your firm has listed and sold. Your task is to determine the length of time each property was on the market before it sold. You also need to calculate the sales commission from each property sold. Two agents will receive commission on each transaction: the listing agent and the selling agent. You also need to summarize the sales data by employee and calculate the average number of days each employee ‘s sales were on the market prior to selling and the total commission earned by the employees 

     

Start Access. Open the   downloaded Access file named Exp19_Access_Ch03_ML2_Investment_Properties.accdb.   Grader has automatically added your last name to the beginning of the   filename.

 

Create a new query in Design   view using all three tables. Add the following fields, in the order given:   from the Agents table, add the LastName field; from the Properties table, the   DateListed, DateSold, SalePrice, SellingAgent, and ListingAgent fields; and   from the SubDivision table, the Subdivision field.

 

Add criteria to the query to   ensure that the DateSold field is not empty (hint: you will need to use NULL   as part of the criteria). Run the query to ensure empty fields are not   displayed for the DateSold field. Return to Design view.

 

Format the SalePrice field as   Currency. Save the query as Sales Report.

 

Create a calculated field in the   first empty field named DaysOnMarket that will calculate the number of days each sold   property was on the market when it sold. Add a caption of Days on   Market.

 

Create another calculated field   in the first empty field named ListComm that will calculate the listing agent’s commission based on the   sales price and a listing commission rate of 3.5%. Add a caption of Listing Commission and format the field as   Currency.

 

Create another calculated field   in the first empty field named SellComm that will calculate the selling agent’s commission based on the   sales price and a selling commission rate of 2.5%. Add a caption of Selling Commission and format the field as   Currency.

 

Save the query and switch to   Datasheet view. Add a Total row. Calculate the average number of days on the market   and the sum for the SalePrice and the two commission fields. Save and close   the query.

 

Create a copy of the Sales   Report query named Sales Summary by Last Name. Switch to Design view and   remove the DateListed, SellingAgent, ListingAgent, and Subdivision fields.

 

Display the Total row in Design   view. Group by LastName and change the DateSold field Total row to Where.   Show the sum of SalePrice, the average of DaysOnMarket, and the sum for both   ListComm and SellComm.

 

Change the caption for the   SalePrice field to Total Sales and format of the DaysOnMarket field as Fixed. Run   the query. Adjust column widths as necessary. Adjust the Total row in the   Datasheet view so it shows the sum of Total Sales. Save and close the query.

 

Create a copy of the Sales   Summary by Last Name query named Sales Summary by Subdivision. Open the query in Design view   and replace the LastName field with the Subdivision field, ensuring the Total   row is set to Group By

 

Sort the query results so the   lowest average Days on Market is first and the highest average Days on Market   is last. Limit the results to the top five values

 

Close all database objects.   Close the database and then exit Access. Submit the database as directed.

The following list contains components

  

The following list contains components you would find in both a wired and a wireless network:
• Wireless router
• Computer
• Firewall
• Wireless access point
• Hub
• Modem
• Printer
• Server
• Switch
• Wireless network interface card (NIC)
• Router
• Scanner
• Multiplexer
In a 1- to 2-page paper, address the following:
• Describe the function and purpose of each component above.
• Explain how the components are related to each other. For example, does the component depend on another to operate? Is it connected to the network physically or wirelessly?
• Identify whether the component is optional or required in a wireless network. If it is an optional component, explain why it would or would not be used in a WLAN.
• Complete an Internet search for the average cost of each component and include the cost in your description. Reference the website(s) you used to locate this information.
Format your paper consistent with APA guidelines.