Need to add payment option (via Coding) which links in this website on the zip folder. TO get it ready for presentation. If you could make this website interesting it would be great.
network administration
After a history of nearly anyone configuring and reconfiguring printers throughout the firm, the management has decided to centralize coordination of five new centrally located printers in the hands of the two computer support staff. The computer support staff wants to turn one of the servers into a print server from which to manage the five new printers. Create a short report that describes the basic steps for installing a Windows Server 2016 print server. In your report, also discuss two tools that can be used to set up and manage printers that the support staff will be able to use with the print server.
Data Science and Big data Analytics
Question 1 :
There is still much confusion regarding what Blockchain is and what it is not. Please discuss your explanation of Blockchain to include why it has been gaining so much popularity.
Please make your initial post and two response posts substantive. A substantive post will do at least two of the following:
- Ask an interesting, thoughtful question pertaining to the topic
- Answer a question (in detail) posted by another student or the instructor
- Provide extensive additional information on the topic
- Explain, define, or analyze the topic in detail
- Share an applicable personal experience
- Provide an outside source that applies to the topic, along with additional information about the topic or the source (please cite properly in APA)
- Make an argument concerning the topic.
At least one scholarly source should be used in the initial discussion thread. Be sure to use information from your readings. Use proper citations and references in your post.
Question 2 :
Practical Connection Assignment: On Data Science and Big Data analytics course
Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. Requirements:
- Provide a 500 word (or 2 pages double spaced) minimum reflection.
- Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited.
- Share a personal connection that identifies specific knowledge and theories from this course.
- Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment.
- You should not provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.
Question 3 :
This paper centered around Bitcoin Economics. For this research paper, search the Internet and explain why some organizations are accepting and other organizations are rejecting the use of Bitcoins as a standard form of currency. Your paper needs to identify two major companies that have adopted Bitcoin technology as well as one that has refused accepting Bitcoin as a form of currency. Be sure to discuss each organization, how they adopted (or why they won’t adopt) Bitcoin, and what recommendations you have for them to continue to support Bitcoin (or why they should support Bitcoin).Your paper should meet these requirements:
- Be approximately four to six pages in length, not including the required cover page and reference page.
- Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
- Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook.
- Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.
Homework week 1
This week we focus on the introductory chapter in which we review data mining and the key components of data mining. In an essay format answer the following questions:
- What is knowledge discovery in databases (KDD)?
- Review section 1.2 and review the various motivating challenges. Select one and note what it is and why it is a challenge.
- Note how data mining integrates with the components of statistics and AL, ML, and Pattern Recognition.
- Note the difference between predictive and descriptive tasks and the importance of each.
In an APA7 formatted essay answer all questions above. There should be headings to each of the questions above as well. Ensure there are at least two-peer reviewed sources to support your work. The paper should be at least two pages of content (this does not include the cover page or reference page).
Oracle DB
Oracle DB
•Report 5 – A list of each channel (both channel name and channel number) and a count of the number of customers who picked that channel as a favorite channel.
•Report 6 – A summary of sales for any given day, categorized by package type (i.e., the total sales written on the specified day for each package subscribed to by customers, not bills paid). This report should give details about each package type, the package price, the number of packages sold, and then the total sales amount for that package. This is going to be a date driven report.
Marketing and product development
- Briefly describe in a word document; awareness, trial, availability, and repeat business
- Using the ATAR forecasting method (and template), create a forecast for the new Apple AirPower Mat.
The ATAR process consists of; projections, predictions, and planning for a new product launch. You will; predict growth, awareness, trial, availability, and repeat for a five-year period.
In addition, determine; price, sales volume, investment to develop the product and the cost of marketing support. Optionally, there is Cannibalization if the new product will impact the sales of an already existing product along with Discount Rate.
Helpful hint; how many people own an Apple product?
- Apple AirPower wireless charging pad: Everything you need to know (Links to an external site.)
- AirPower Preview: Apple’s next-generation charging pad… currently MIA (Links to an external site.)
- Apple’s AirPower wireless charging mat is rumored to be in production (Links to an external site.)
APA format is applicable for both Written and Presentations. The paper should be between 1-2 pages (not including title and references).
Exp19_Access_Ch03_HOEAssessment – Property Sales 1.0
Exp19_Access_Ch03_HOEAssessment – Property Sales 1.0
Exp19 Access Ch03 HOEAssessment Property Sales 1.0
Exp19_Access_Ch03_HOEAssessment – Property Sales 1.0
Project Description:
In the following project, using data on homes for sale that Amy and Zac acquired, you are able to target properties that meet specific criteria. As you examine the data, you discover other ways to analyze the properties. You create several queries and present your results to the two investors for their comments. You also create several totals queries to evaluate the property lists.
Start Access. Open the downloaded Access file named Exp19_Access_Ch03_HOEAssessment_Property_Sales. Grader has automatically added your last name to the beginning of the filename. Click Enable Content on the Security Warning message bar.
Now that you have opened the database, you begin your analysis by creating a query using the Properties and Agents tables from the Property database. The Properties table contains all the properties the investors will evaluate; the Agents table contains a list of real estate agents who represent the properties’ sellers. In this exercise, you will add requested fields and only show properties that have not been sold. You will then build an expression to calculate the price per square foot for each property.
Use Query Design to create a new query. The Show Table dialog box opens so you can specify the table(s) and/or queries to include in the query design. Add the Agents table then the Properties table. Close the Show Table dialog box.
Add the FirstName and LastName fields from the Agents table to the query. Add the ListPrice, SqFeet, and Sold fields from the Properties table to the query. Run the query and view the 23 properties that display in the query results.
Switch back to Design view and add No in the Criteria row of the Sold field. Sort the query in Ascending order by the ListPrice field. Run the query and view the 17 unsold properties in order from least expensive to most expensive.
Save the query as Price Per Square Foot.
Switch to Design view. In the Field row of the first blank column of the query design grid, right-click and select Zoom. Add PricePerSqFt: xListPrice/xSqFeet and click OK. Access inserts square brackets around the fields for you. Be sure that you added the extra x’s to the field names. You are intentionally misspelling the field names to see how Access will respond.
Run the query. In the first Enter Parameter Value dialog box, enter 200000 and click OK. Access does not recognize xListPrice in the tables defined for this query in the first record. When Access does not recognize a field name, it will ask you to supply a value.
Another Enter Parameter Value dialog box displays, asking that you supply a value for xSqFeet. Again, this error occurs because the tables defined for this query do not contain an xSqFeet field. Type 1000 in the second parameter box and press ENTER. The query has the necessary information to run and returns the results in Datasheet view. Examine the results of the calculation for Wrong Price Per Sq Ft. All of the records show 200 because you entered the values 200000 and 1000, respectively, into the parameter boxes. The two values are treated as constants and give the same results for all records.
Return to Design view and display the Zoom window. Correct the errors in the PricePerSqFt field by changing the formula to PricePerSqFt: [ListPrice]/[SqFeet] and click OK.
Run the query and adjust column widths as necessary. The new calculated field, PricePerSqFt, is displayed. The new field divides the values in the ListPrice field by the values in the SqFeet field.
Save and close the query.
Now, Amy and Zac would like to see the field formatted with two decimal places. You will change the format to Currency and add a caption to the calculated field.
Make a copy of the Price Per Square Foot query and name it Price Per Square Foot Formatted.
Open the Price Per Square Foot Formatted query in Design view. Display the Property Sheet (in the Show/Hide group on the Design tab) for the PricePerSqFt calculated field. Change the field format to Currency then change the Caption to Price Per Sq Ft (no period). Close the Property Sheet.
Run the query to view your changes. The calculated field values are formatted as Currency, and the column heading displays Price Per Sq Ft instead of PricePerSqFt.
Save and close the query.
You will create a copy of the Price Per Square Foot Formatted query from the previous step and paste it using a new name. You will add a few more calculated fields to the new query. You will create one calculation to determine the price per bedroom for each house. You will create a second field to calculate the price per room. For this calculation, you will assume that each property has a kitchen, a living room, a dining room, and the listed bedrooms and bathrooms.
Create a copy of the Price Per Square Foot Formatted query and name it List Price Calculations.
Open the List Price Calculations query in Design view. Display the Builder window for the PricePerSqFt column (in the Query Setup group). The Expression Builder dialog box opens, displaying the current formula.
Change the PricePerSqFt field name to PricePerBR and remove the [SqFeet] field. In the Expression Elements box, select Properties table from the Exp19_Access_Ch03_HOEAssessment_Property_Sales database.
The fields from the Properties table are now listed in the middle column (Expression Categories). Add the Beds field to the expression box.
The expression now reads PricePerBR: [ListPrice]/[Properties]![Beds].
Delete the [Properties]! prefix in front of Beds.
The expression now reads PricePerBR: [ListPrice]/[Beds].
As the Beds field name is unique within our query, the table name is not necessary. Removing this makes the query easier to read. If a field named Beds appeared in more than one table in our query, removing the table name would cause problems.
Close the Expression Builder. Run the query. Notice that the column heading still reads Price Per Sq Ft. Also notice that the column’s contents are formatted as Currency. These settings were copied when the query was copied.
Switch to Design view and ensure that the PricePerBR field is selected. In the Property Sheet, change the Caption to Price Per Bedroom. Close the Property Sheet and run the query. The PricePerBR column now has an appropriate caption.
Switch to Design view. Make a copy of the PricePerBR expression and paste it in the next blank column. You will edit the copied expression so that it reflects the price per room, assuming that the kitchen, living room, dining room, and the bedrooms and bathrooms will make up the number of rooms.
In the Builder window, change the PricePerBR field name to PricePerRoom. Add an opening parenthesis before the [Beds] portion of the formula and a plus sign after [Beds]. Because you want the addition to be done first, you will enclose the addition part in parentheses.
The expression box should read PricePerRoom: [ListPrice]/([Beds]+
In the Expression Elements box, select Properties table from the Exp19_Access_Ch03_HOEAssessment_Property_Sales database and add the Baths field to the expression box. Type another plus sign after [Baths] and type 3 followed by a right parenthesis. In other words, you will type +3) in the expression box. Delete the [Properties]! portion of the expression and click OK.
The expression now reads PricePerRoom: [ListPrice]/([Beds]+[Baths]+3).
Your final formula is the list price divided by the total number of rooms. The total number of rooms is the number of bedrooms (in the Beds field), plus the number of bathrooms (found in the Baths field), plus 3 (a constant representing the kitchen, living room, and dining room).
In the Property Sheet, change the caption to Price Per Room and change the Format to Currency. Close the Property Sheet.
Run the query, adjusting the column widths as necessary, then save and close the query.
Amy and Zac feel like they are close to making an offer on a house. They would like to restrict the query to houses that cost $210,000 or less. They would also like to calculate the estimated mortgage payment for each house. You create this calculation using the Pmt function. You make the following assumptions: 75% of the sale price to be financed, a 30-year term, monthly payments, and a fixed 3.65% annual interest rate.
Make a copy of the Price Per Square Foot Formatted query and call it Mortgage Payments. Open the Mortgage Payments in Design View. Add <=210000 to the Criteria row of the ListPrice column. The query, when it is run, will show only the 7 houses that haven’t been sold that cost $210,000 or less.
In the first blank column, display the Builder window. Add the Pmt function to the expression builder window (Functions ? Built-In Functions ? Financial).The expression box displays:
Pmt(«rate», «num_periods», «present_value», «future_value», «type»)
Position the insertion point before the Pmt function. Type Payment: to the left of the Pmt function, with a space after the colon. The expression box now displays:
Payment: Pmt(«rate», «num_periods», «present_value», «future_value», «type»)
Substitute the appropriate information in each argument ensuring that there is a comma between each argument.
Argument
Value
«rate»
.0365/12
«num_periods»
30*12
«present_value»
[ListPrice]*.75
«future_value»
0
«type»
0
Note that the loan is a 30-year loan with 12 payments per year, hence the calculation for the number of payments. Also note, Amy and Zac plan on financing 75% of the cost, putting 25% down. Therefore, you will multiply the list price by .75 (75%).
Change the format of the Payment field to Currency then close the Property Sheet and run the query. Notice that the payment amounts are negative numbers (displayed in parentheses). You will edit the formula to change the negative payment values to positive.
Switch back to Design View. In the Builder window of the Payment field, add a minus sign (-) to the left of [ListPrice] then click OK. By adding the negative sign in front of the ListPrice field, you ensure that the value is displayed as a positive number. The expression now reads:
Payment: Pmt(.0365/12,30*12, -[ListPrice]*.75,0,0)
Run the query, adjusting the column widths as necessary. The query now displays a column containing the calculated monthly mortgage payment, formatted as currency.
Save and close the query.
Amy and Zac decide it would be helpful to analyze the property lists they purchased. Some of the lists do not have homes that match their target criteria. The investors will either purchase new lists or alter their criteria. You create several totals queries to evaluate the property lists. You begin your property list analysis by creating a total row in Datasheet view of the Mortgage Payments query. This will give you a variety of aggregate information for important columns.
Open the Mortgage Payments query in Design view. Drag the ListingID field from the Properties table to the fifth column. The ListingID field is now in the fifth column, between the SqFeet and Sold fields. The other columns shift to the right.
In Datasheet view, click Totals in the Records group on the Home tab. In the Total row, display the Average List Price for all the properties that have not sold. Adjust column widths as necessary to ensure that all values are displayed.
The average list price of these properties is $165,294.36.
In the Total row, display the Count of ListingIDs.
The count of properties in this datasheet is 7.
In the Total row, display the Average Price Per Sq Ft.
The average price per square foot is $115.32.
Save and close the query.
Now, you create a totals query to help Amy and Zac evaluate the properties in groups.
Create a new query, via Query Design, and add the Properties table.
Add the SalePrice and Sold fields to the query (in that order) then Display the Total row (Show/Hide group of the Design tab). A new row labeled Total displays in the query design grid, between the Table and Sort rows. Each field has Group By listed in the new row by default.
In the SalePrice column Total row, change Group By to Avg. In the Sold column Total row, change Group By to Where then type Yes in the Criteria row. This criterion will limit the results to sold houses only.
Change the SalePrice format to Currency. Close the Property Sheet. Run the query and adjust the column width, if necessary. The results show an overall average of $333,838.77 for the sold properties in the database.
Save the query as Overall Results then close the query.
Create a new query, via Query Design, and add the Properties and Lists tables. Add the NameOfList field from the Lists table and the SalePrice, ListingID, and Sold fields from the Properties table to the query.
Display the Total row then change the Total row to Avg for SalePrice and to Count for ListingID. Next, change the Total row for Sold to Where then type Yes in the Criteria row. This criterion will limit the results to sold houses only.
Change the SalePrice format to Currency then the caption for the ListingID field to Number Sold. Close the Property Sheet and run the query. Adjust column widths as necessary. Notice that Minor Houses has the lowest average sale price. As Amy and Zac are hoping to focus on inexpensive properties, they can focus on properties offered by this source. Notice also that the query results show the number of properties sold in each source, in addition to the average sale price. This will help determine which sources have been more effective.
Save the query as Results By Listing Company.
The previous query shows the average value of the properties by listing company. However, Amy and Zac learned at the seminar they attended that the longer a property has been on the market, the better your chances of negotiating a better price. You will revise the query to show, on average, how long each listing company takes to sell a house.
Copy the query, save it as Results By Listing Company Revised and click OK.
Display the Total row then change the Total row for the Number Sold column to Sum. The total number of houses sold (6) now displays at the bottom of the Number Sold column.
Switch to Design view. In the first blank column, type DaysOnMarket: [DateSold]-[DateListed] to create a new calculated field. Change the Total row from Group By to Avg then change the Format to Fixed and close the Property Sheet. The DaysOnMarket field will show the average number of days on the market for each sold listing.
Run the query and adjust the column widths as necessary. Minor Houses listings have an average of 28.00 days on the market. Since this is lower than their competitors, it lets you know they are fast with sales.
Save and close the query.
Technical Report
Methods used in cyber warfare/attack
wk8
This discussion topic is to be reflective of the course material. Therefore, use your own words to respond to the following questions:
- What other topics would you have liked to have covered in this course?
- What reading did you find most interesting and why?
- How has this course changed your perspective or outlook moving forward?
- Any other topic of interest that you would like to add.
Database Marketing Strategy
1. Compare the use of simple selects versus regression analysis for choosing the customers on the house file most likely to respond in a certain way to an offer.
2. What is the basic mathematical concept behind simple linear regression?
3. What is extrapolation and why should it be used with caution?
4. Give an example of a potential linear relationship that a direct marketer may examine and attempt to estimate.
5. What is the coefficient of determination and how is it used in model building?
6. Describe the scatter plots for a low R2 and a high R2 relationship
Please read chapter 9 and submit end of chapter 9 questions
