LAB 5 Toolwire LiveLabs Environment homework help

LAB 5 Toolwire LiveLabs Environment homework help

Each lab will be submitted based on the following:

  1. Log into the Toolwire LiveLabs environment.
  2. Complete the weekly labs described below using Toolwire LiveLabs.
  3. Provide deliverables in the form of documents, files, and / or screenshots for the steps specified in each lab assignment. Some labs require the use of Microsoft Word or OpenOffice for preparing and submitting deliverables.
  4. Answer the Lab Assessment questions for each of the individual labs completed in each week’s Lab Assignment. Lab Assessment questions are located here. Note: This is an academic writing assignment. Correct punctuation, grammar, and spelling are necessary. Points will be deducted for poor writing.
Toolwire LiveLabs Lab Submission Breakdown
Lab

Assignment

Week

Due

Toolwire Lab #: Title Deliverables for Submission
5 6 Lab 5 : Performing Packet Capture and Traffic Analysis 1.Lab Report file including screen captures of the following step(s): Part 2, Steps 18 and 33, and Part 3, Step 7

2.yourname_PacketCapture.pcap

3.Lab Assessments file

4.Optional: Challenge Questions file, if assigned by your instructor

Points: 35 Lab Assignments
Criteria  

Unacceptable

Below 60% F

Meets Minimum Expectations

60-69% D

 

Fair

70-79% C

 

Proficient

80-89% B

 

Exemplary

90-100% A

1. Complete the lab assignment.

Weight: 100%

Did not submit or incompletely completed the lab assignment. Insufficiently completed the lab assignment. Partially completed the lab assignment. Satisfactorily completed the lab assignment. Thoroughly completed the lab assignment.
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Project 2: Client Response Memo homework help

Project 2: Client Response Memo homework help

Faster Computing was impressed with your presentation. The company is interested in moving forward with the project, but the senior management team has responded to the presentation with the following questions and concerns:

(12.3.2: Describe the implementation of controls.)

  • How will security be implemented in the Linux systems—both workstations and servers?

(10.1.2: Gather project requirements to meet stakeholder needs.)

  • End users have expressed some concern about completing their day-to-day tasks on Linux. How would activities such as web browsing work? How would they work with their previous Microsoft Office files?

(12.4.1: Document how IT controls are monitored.)

  • The current Windows administrators are unsure about administering Linux systems. How are common tasks, such as process monitoring and management, handled in Linux? How does logging work? Do we have event logs like we do in Windows?

(2.3.2: Incorporate relevant evidence to support the position.)

  • Some folks in IT raised questions about the Linux flavor that was recommended. They would like to see comparisons between your recommendation and a couple of other popular options. What makes your recommendation the best option?

(10.1.3: Define the specifications of the required technologies.)

  • How does software installation work on Linux? Can we use existing Windows software?
  • How can Linux work together with the systems that will continue to run Windows? How will we share files between the different system types?

The deliverable for this phase of the project is a memo. There is no minimum or maximum page requirement, but all of the questions must be fully answered with sufficient detail. The recommended format is to respond to the questions in a bulleted format. Provide sufficient detail to fully address the questions. You must cite at least two quality sources.

(1.2.3: Explain specialized terms or concepts to facilitate audience comprehension.)

Create a memorandum template with a header of your own design or choosing, brief introduction, addresses Faster Computing, Inc’s questions, and summarizes your position on adopting the specific version of Linux.

(1.4.3: Write concise and logical sentences in standard academic English that clarify relationships among concepts and ideas.)

Your memorandum should not include spelling or grammatical errors. Any Linux commands must be displayed in lower case. Information technology acronyms (e.g., SSH or FTP) should be explained for the reader.

 

How Will My Work Be Evaluated?

In writing a clear and concise memo in response to senior management queries, you are demonstrating your communication skills, technical expertise, and responsiveness to customer/client needs and concerns.

The following evaluation criteria aligned to the competencies will be used to grade your assignment:

  • 1.2.3: Explain specialized terms or concepts to facilitate audience comprehension.
  • 1.4.3: Write concise and logical sentences in standard academic English that clarify relationships among concepts and ideas.
  • 2.3.2: Incorporate relevant evidence to support the position.
  • 10.1.2: Gather project requirements to meet stakeholder needs.
  • 10.1.3: Define the specifications of the required technologies.
  • 12.3.2: Describe the implementation of controls.
  • 12.4.1: Document how IT controls are monitored.
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Computer System Unit homework help

Computer System Unit homework help

Understanding the Computer System Unit

Schedule:Available now.Due 03/30/2018 11:59 PM EDTStarted:03/30/2018 5:10 PM EDTSubmitted:03/30/2018 5:30 PM EDTScore:100%Points:200 out of 200

Question 1

Points: 10 out of 10What type of computer would integrate the system unit (chassis and computer) with the display and keyboard?

  1. A desktop computer
  2. An all-in-one desktop computer
  3. A mobile computer
  4. A tower computer

Question 2

Points: 10 out of 10Which of the following type of system unit is not considered to belong to the family of PCs?

  1. Workstation
  2. Smart phone
  3. Notebook
  4. Desktop

Question 3

Points: 10 out of 10When purchasing a PC, you should upgrade –busesRAMROMinternal bays and slots to the largest amount or number your budget will afford.

Question 4

Points: 10 out of 10What is an expansion slot?

  1. A device that joins a cable to a peripheral
  2. A device that connects memory to the CPU
  3. A port used for special equipment
  4. A socket on the motherboard that can hold an adapter card

Question 5

Points: 10 out of 10What is the purpose of a heat sink?

  1. To keep the keyboard from overheating
  2. To absorb heat generated by the memory modules
  3. To absorb heat generated by the processor chip
  4. To keep the hard drive from overheating

Question 6

Points: 10 out of 10What is the purpose of the processor, which is also called the central processing unit (CPU)?

  1. This electronic component interprets and carries out the basic instructions that operate the computer.
  2. This hardware component communicates with the keyboard and monitor.
  3. This electronic component stores instructions waiting to be executed and data needed by those instructions.
  4. This component is software that communicates with the keyboard and monitor.

Question 7

Points: 10 out of 10How would a port most likely be used?

  1. To connect additional input, output, storage, and communication devices to a PC
  2. To provide a place for plugging in expansion cards
  3. To provide a place to insert a DVD drive via an opening in the system case
  4. To connect the battery to the computer’s internal circuitry

Question 8

Points: 10 out of 10Which of the following would be an example of a docking station?

  1. A peripheral component that can be used to link a desktop-sized monitor with a tablet PC
  2. An internal bay that can be used for inserting additional components such as a hard drive
  3. A USB port on a laptop or PC
  4. A slot on the motherboard that holds memory modules

Question 9

Points: 10 out of 10If mobility is the primary criteria for a buyer of a new PC, which of the following would be the most important criteria to consider?

  1. The size of the internal hard drive
  2. The number of USB ports for connecting peripherals
  3. The weight and size of the unit
  4. The type of software applications to be used—gaming, for instance, requires sophisticated graphics and sound adapter cards

Question 10

Points: 10 out of 10Marissa is a student taking classes in a face-to-face setting, a physical classroom. She needs to be able to take her computer to class to give presentations. Which of the following might you suggest?

  1. A laptop system with a 2.13 GHz processor, 4 gigabytes of RAM, and a 17″ monitor
  2. A workstation with a 1.6 GHz quad-core processor, 8 gigabytes of RAM, and a 20″ monitor
  3. A desktop system with a 2.33 GHz processor, 1 gigabyte of RAM and a 23″ monitor
  4. A handheld PC

Question 11

Points: 10 out of 10You have been diagnosed with carpal tunnel syndrome in your wrists (related to extensive computer usage). What might be a solution for reducing stress on your wrists?

  1. Use a keyboard with internal lighting to support work in low-light conditions.
  2. Use a flat waterproof keyboard.
  3. Use a keypad that is projected on an external flat surface.
  4. Use a split-style keyboard that separates and angles groups of keys into right- and left-hand portions.

Question 12

Points: 10 out of 10

Monitors with –LCDLED technology are considered to have better picture sharpness and brightness, are sleeker and lighter, consume less power, but are more expensive.

Question 13

Points: 10 out of 10Which of the following is not an input device?

  1. Mouse
  2. Printer
  3. Trackball
  4. Keyboard

Question 14

Points: 10 out of 10What is input?

  1. All processed data
  2. Data or instructions that have been processed into a useful form
  3. Any data or instructions entered into the memory of a computer
  4. Any data or information that is processed and presented to the user

Question 15

Points: 10 out of 10

Printers, monitors, and speakers are the three most commonly used–outputinputcommunicationsprocessing devices.

Question 16

Points: 10 out of 10Which of the following is not a capability of a multifunction printer?

  1. Printing
  2. Video
  3. Scanning
  4. Faxing

Question 17

Points: 10 out of 10A cable –modemrouterEthernet cardnetwork card is a digital device that sends and receives digital data over the cable television network.

Question 18

Points: 10 out of 10What communications device connects multiple computers together and transmits data to its correct destination on a network?

  1. A router
  2. An Ethernet card
  3. A modem
  4. A network card

Question 19

Points: 10 out of 10

The following diagram is an example of what type of home network?

  1. Completely wired
  2. Combination of wired and wireless
  3. Completely wireless

Question 20

Points: 10 out of 10To protect the information and data you send or receive over the network, what other component is critical to install in your home network?

  1. Wire, cable, or fiber optic connection between computers
  2. A hardware or software firewall
  3. Parental controls
  4. An uninterruptible power source

Close

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

Computer Science homework help

Computer Science homework help

Article 1:

Question:

Hypothetically speaking, you are assigned to a committee of three to decide on a dress code for Campbellsville University Staff and Faculty. Only two of the three votes are required to pass this policy. In this situation you are one of the two agreeing to a dress code. What steps might you take to gain the cooperation of the third party after the policy has been initiated.

 

The Dress code for Campbellsville University Staff and Faculty should be a Dark Maroon Tuxedo with white shirt which goes with the university corporate identity. We must consider few things before finalizing the dress code such as there shouldn’t be any gender/sex discrimination for selecting the dress code.

Present Study is focusing on the insights of the school teachers, leaders and students about their dress codes as one of the important factors of their education. Education effects each individual in our society, every individual has a right of equality and any type of discrimination will not be accepted at any level regarding the dress codes in schools. The study also focuses on how to contribute to get the solutions for the dress code problem. (Birel, 2016)

In 2009, Ceara Sturgis a senior student at Wesson filed a lawsuit in the following year against the county school district, the superintendent of the school, and the principal for removing her photograph from the year book, many other cases were filed in Indiana and Ohio for wearing the dresses which is associated with the opposite sex. (Johnson, 2017)

As I have been assigned to the committee of three, I will try to convince just one more member of the committee by providing sufficient ideas and examples paving way to the policy implementation and the rules and regulations that follows it. I will do a small-scale survey with the peers at my work place/staff and people with whom I interact to assess Campbellsville employees’s (both in teaching and non-teaching departments) thought process and opinion after sharing my ideas and thereafter I am planning to lay out my work in front of other committee members in negotiating and sorting out the differences.

 

Article 2:

Question:

Hypothetically speaking, you are assigned to a committee of three to decide on a dress code for Campbellsville University Staff and Faculty. Only two of the three votes are required to pass this policy. In this situation you are one of the two agreeing to a dress code. What steps might you take to gain the cooperation of the third party after the policy has been initiated.

 

University is an educational institution where students learn on different aspects of life apart from their academic programs. Students are supposed to learn how to interact and communicate with others across different settings. The mode of dressing plays an integral role in communication.  A person can be easily judged by his or her dress code. The staffs within the university are expected to serve as role models who are supposed to guide the young students in understanding the dressing influences their professional lives. The implementation of the dress code will provide a critical outline of a specific format within the university which can improve the perceptions among students regarding the need to adopt such measures.

The implementation of the dress code policy is expected to have a positive influence on the development of students who need guidance. Dress code within a professional setup is crucial in achieving a higher level of success or limit their chances of an individual to progress despite having the needed qualifications. Therefore, I will ensure that the students understand how their lives can be improved or ruined through their choice of dressing. An individual who has the authority must be able to dress sharply so that all can see the influence they have.

I will make emphasis on the need to outline essential concepts that define individual well being within a given setting. The reason why the policy has been initiated is to ensure that all the staff serves as a better example to students. The students look at their staff and the example they set regarding how they dress and interact with them. Therefore, adoption of the dress code policy is essential and considers that interests of all stakeholders within the institution. Students seek inspiration from different sources including the staff. Thus they should carry themselves in a much-organized manner to have a positive influence on student development.

 

Article 3:

Question:

Define and briefly discuss the following brainstorming techniques, the delphi technique, brainstorming, or nominal group technique.

 

Delphi Technique

Delphi Technique is unusual because it is based on group process using written responses from different locations to a bunch of questionnaires rather than a group of people making a decision by meeting physically in one room (Delbecq, 1975). The first question asks people to respond to a question, then the second question depends on the response to the first question, this process continues until all the group of people comes to the same point. The organizer of this event will decide whether to keep the responses from a group of people public or private. Michael Campion used this process when he was editor of the research journal Personnel Psychology to determine the qualities of a research article to become a great article. Using this technique, he gathered written responses from a number of top researchers from around the world and extracted good responses based on his criteria. He was able to finish the total process without even leaving out of his office (Campion, 1993).

Brainstorming Technique

Unlike Delphi technique, Brainstorming is a technique, where people gather together physically and share their ideas without any criticism during the process (Lewicki, 2015). Some research shows that the number of the ideas, the better idea comes at the end. In his process, if we can able to gather a different kind of people together from different backgrounds, then we will get great outcome or great decision at the end. We have another type of brainstorming, that is Wildstorming, where the group of people focuses more on the ideas that are not possible to implement or think, and then they discuss how to make it possible (Scott, 2004).

Nominal Group Technique

Nominal Group Technique is a technique that makes sure all the people in the group participate fully. If I’m not wrong, this technique is somewhat integration of both Delphi and Brainstorming technique. This technique is used people facing problems in solving some problem or generating ideas. This technique involves four steps (Delbecq, 1975). In the first step, each individual in the group write their ideas, then in the second step all the ideas will be shared with them, then in the third step, group members will discuss on each and every idea of theirs and in the fourth or final step, group members will vote for the idea which they will like most. By following this four-step method we can ensure that all the group members participated fully, this avoids the problem of free credits.

Article 4:

Question:

Define and briefly discuss the following brainstorming techniques, the delphi technique, brainstorming, or nominal group technique.

 

Brainstorming

Brainstorming is a popular group decision-making technique that is used for generating ideas. In brainstorming, the leader of the session presents a problem or question, clarifies the rules of the session and then the group offers ideas in a round-robin format. Ideas are written down so that every member can see them. Brainstorming does not solve the problem but helps generate creative ideas. As a result, quantity of ideas counts, and members do not criticize ideas. To be successful, the leader of a brainstorming session must understand the problem and be able to create a relaxed and creative air.

Delphi technique

The Delphi method helps the group reach consensus without the influence of strong members of the group and the tendency to rush for a decision at the end of a meeting. It is a structured variant of the traditional expert polls and is usually used in forecasting. In this method, a questionnaire is mailed to a group of experts; administrators aggregate the results and send a second questionnaire with the results of the first round. Several rounds of questionnaires and feedback help respondents reach consensus on the debated issue. The administrators of the Delphi method decide based on the results of the rounds.

Nominal Group Technique

This group decision-making technique is used to identify problems or to evaluate alternatives. In this technique, members of the group spend five to 10 minutes writing their ideas without discussion. Then, they report their ideas individually. Ideas are written on a flip chart, and individuals try to add to the ideas. In the next phase, group members vote or rank the ideas privately. With private voting, strong members of the group can not affect the results. After voting, the group discusses results and generates more ideas. The idea generation, voting and discussion cycle can continue until a satisfactory decision is reached.

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

Unit 1 Discussion 2: Client Access License Assignment Help

Unit 1 Discussion 2: Client Access License Assignment Help

POST I HAVE TO ANSWER

Conduct some research on the topic of Windows licensing, but focus your efforts on just ONE aspect of the subject. DO NOT RESPOND TO EACH TOPIC AND DO NOT SELECT A PREVIOUS DISCUSSED TOPIC UNTIL ALL TOPICS HAVE BEEN DISCUSSED

Possible topics for your thread might include:

· When is a CAL required, and when is it not?

· What kinds of licenses are there?

· Do you have to re-license each time a client or server system is upgraded?

· What is the VLSC?

· Other items you find of particular interest

Be sure to read other student thread topics that have already been posted.Try not to duplicate a licensing topic that has already been covered. We’re looking for a more narrow and in-depth discussion from you rather than a broad overview in this week’s forum.

Response Format

· Support each of your answers with at least one credible source. Please use the ECPI Online Library (Links to an external site.)Links to an external site., and your course e-book to conduct your research.

· Use in-text citations and a reference list in APA format.

· Your responses should demonstrate critical thinking and provide justification for your responses.

 

 

POST 1

For this class discussion, I have chosen to do what kinds of licenses are there? There are more than one types of software licenses. We all know that we have some type of software licenses but some may not know what they do so here’s a list of a few, individual licenses, perpetual licenses, subscription license, freeware licenses, shareware licenses, OEM (original equipment manufacturer) and more. Each license has it’s on meaning and do different things such as for the freeware license you get it for free and you don’t have to pay for anything. For shareware license, you get a time period where you don’t have to pay for anything until that time period is up you have to pay the fee or stop using it. Another example is the OEM for this license it covers software for all standalone PC’s and notebooks. With the computer systems, they all have to be bundled with the software.

https://ts.tulane.edu/content/software-license-types (Links to an external site.)Links to an external site.

 

 

POST 2

Do you have to re-license each time a client or system server is upgraded?

With a retail license you are able to use the license key to activate Windows after your client or system is upgraded several times (Huculak, 2018). An OEM license is only available for one use only (Huculak, 2018). You can use the command prompt in order to uninstall a license key with the slmgr.vbs /upk command in order to uninstall the current key (Course, n.d.). Then you can reinstall the license with the

slmgr.vbs /ipk #####‐#####‐#####‐#####‐#####

command on the new device in order to reactivate your license (Course, n.d. & Huculak, 2018).

Here is a video showing the process:

https://www.youtube.com/watch?v=8VKaw_X_xws (Links to an external site.)Links to an external site. https://ecpi.instructure.com/images/play_overlay.png

References

Course, M.O. A. 70-698 Installing and Configuring Windows 10. [ECPI]. Retrieved from https://ecpi.vitalsource.com/#/books/9781119331292/ (Links to an external site.)Links to an external site.

Huculak, M. (2018, July 16). How to transfer a windows to license to a new computer or hard drive. Retrieved from https://www.windowscentral.com/how-transfer-windows-10-license-new-computer-or-hard-drive (Links to an external site.)Links to an external site.

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

Computer Science homework help

Computer Science homework help

1. Using A Microsoft Word Document, Please Post One Federal And One State Statute Utilizing Standard Legal Notation And A Hyperlink To Each Statute.

1. Using a Microsoft Word document, please post one federal and one state statute utilizing standard legal notation and a hyperlink to each statute.

2. In the same document, please post one federal and one state case using standard legal notation and a hyperlink to each case.

Rubric for Assignment submission

Criterion

Description

Points possible

Content

Student posts one federal statute.

Student posts one state statute.

Student posts one federal case.

Student posts one state case.

5

5

5

5

Citation

Correct use of standard legal notation

 

 

I posted the question with the requirement which i need it no plaigarism

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

Write A Python Code On The Anaconda Navigator Assignment Help

Write A Python Code On The Anaconda Navigator Assignment Help

Resource Information

In this assignment, you should work with books.csv file. This file contains the detailed information about books scraped via the Goodreads . The dataset is downloaded from Kaggle website: https://www.kaggle.com/jealousleopard/goodreadsbooks/downloads/goodreadsbooks.zip/6

Each row in the file includes ten columns. Detailed description for each column is provided in the following:

  1. bookID: A unique Identification number for each book.
  2. title: The name under which the book was published.
  3. authors: Names of the authors of the book. Multiple authors are delimited with -.
  4. average_rating: The average rating of the book received in total.
  5. isbn: Another unique number to identify the book, the International Standard Book Number.
  6. isbn13: A 13-digit ISBN to identify the book, instead of the standard 11-digit ISBN.
  7. language_code: Helps understand what is the primary language of the book.
  8. num_pages: Number of pages the book contains.
  9. ratings_count: Total number of ratings the book received.
  10. text_reviews_count: Total number of written text reviews the book received.

Task

  1. Write the following codes:
    1. Use pandas to read the file as a dataframe (named as books). bookIDcolumn should be the index of the dataframe.
    2. Use books.head() to see the first 5 rows of the dataframe.
    3. Use book.shape to find the number of rows and columns in the dataframe.
    4. Use books.describe() to summarize the data.
    5. Use books[‘authors’].describe() to find about number of unique authors in the dataset and also most frequent author.
    6. Use OLS regression to test if average rating of a book is dependent to number of pages, number of ratings, and total number of written text reviews the book received.
  2. Summarize your findings in a Word file.

Instructions

 Please follow these directions carefully.

  1. Please type your codes in a Jupyter Network file and your summary in a word document named as follows:
    HW6YourFirstNameYourLastName.
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Computer Science homework help

Computer Science homework help

GO19_AC_CH02_GRADER_2F_HW – Student Publications 1.0

 

Project Description:

In this project, you will use a database to answer questions about student publications at a college. You will import an Excel spreadsheet as a new table in the database, create a relationship between two tables, and create queries using numeric, compound, and wildcard criteria using the fields in one or both tables. You will create calculated fields, group data when calculating statistics, create a crosstab query, and create a parameter query.

 

Start Access. Open the file Student_Access_2F_Student_Publications.accdb downloaded with   this project.

 

Import   the records from the downloaded Excel file named a02F_Student_Papers.xlsx as a new table named 2F Student Papers into the database. Use the first row   of the Excel worksheet as the table column headings, and set Paper ID as the   primary key. Complete the wizard and do not save the import steps. After   importing the records, open the 2F Student Papers table and change the data   type of the Student ID field to Short Text. Apply Best Fit to the table, and   then save and close the table.

 

Using   Publisher ID as the common field, create a one-to-many relationship between   the 2F Publishers table and the 2F Student Papers table. Enforce referential   integrity and enable both cascade options. Create a relationship report with   normal margins, and then save the report as 2F Relationship   Report.   Close all open objects.

 

Create   a query in Query Design view based on the 2F Student Papers table to answer   the question, What is the Student ID, Home Campus, Award Paid, and Publisher   ID for awards greater than or equal to $50, sorted in ascending order by the   Student ID field? Display the fields in the order listed in the question.   Five records match the criteria. Save the query as 2F Awards $50 or More Query.

 

Copy   the 2F Awards $50 or More Query to create a new query with the name 2F 2nd Qtr NW Students Query. Redesign the query to answer the   questions, Which students (Student ID) from the Northwest   campus had papers published between 4/1/22   and 6/30/22, and what was the Paper Name, the   Award Paid, and the Category, sorted in ascending order by the Publication   Date field? Do not display the Home Campus field in the query results, and   display the rest of the fields in the order listed in the question. Three   records display. Close the query, saving the changes to the query.

 

Create   a query in Query Design view based on the 2F Student Papers table to answer   the question, Which Paper IDs, Paper Names, and Category for students from   the Southeast and Northeast   campuses were published that had an Award Paid greater than $25, sorted in   descending order by the Award Paid field? Display the fields in the order   listed in the question. Six records match the criteria. Run the query (six   records display). Save the query as 2F SE OR NE Over   $25 Query,   and then close the query.

 

Create   a query in Query Design view based on both tables to answer the questions,   Which Paper Names were published with a Publisher Name that has Texas as part of its name, what is the   Contact Name and Contact Phone Number, and what was the Award Paid, sorted in   descending order by the Award Paid field? (Hint: Use a wildcard character in   the criteria row.). Run the query (eight records display). Save the query as 2F Texas Publishers Query, and then close the query.

 

Create   a query in Query Design view based on the 2F Student Papers table to answer   the question, In ascending order by the Paper ID field, what will be the Federation Donation to the Writing Lab if the Federation   donates an additional 50 (.5)   percent of each award paid to students? Run the query (the first record—Paper   ID P-01—has a Federation Donation of 20).

 

Display   the query in Design view. In the fourth column of the design grid, create a   new field named Total Donation   that will answer the question, What is the total value of each scholarship   after the alumni association donates an additional 50%? Run the query (the   first record—Paper ID P-01—has   a Total Donation of $60.00).

 

Display   the query in Design view. Use the Property Sheet to format the Federation   Donation field as Currency with 2 decimal places, and then close the Property   Sheet. Run the query (for the Paper ID P-20, the Federation Donation is   $22.50 and the Total Donation is $67.50). Apply Best Fit to the fields, save   the query as 2F Federation Donation   Query,   and then close the query.

 

Create   a query in Query Design view based on the 2F Student Papers table and the Sum   aggregate function to answer the question, What are the total awards paid for   each Category, sorted in descending order by the Award Paid field? Use the   Property Sheet to format the Award Paid field with 0 decimal places, and then   close the Property Sheet. Run the query (for the Category of Student Life,   the sum of the awards paid is $265). Apply Best Fit to the fields, save the   query as 2F Awards by Category   Query,   and then close the query.

 

Use   the Query Wizard to create a crosstab query based on the 2F Student Papers   table with the Home Campus field as row headings and the Category field as   column headings. Sum the Award Paid field, and name the query 2F Campus and Category Crosstab Query.   Display the query in Design view. Use the Property Sheet to format the last   two columns with 0 decimal places, and then close the Property Sheet. Run the   query, and then apply Best Fit to the fields. Save the changes to the query,   and then close the query.

 

Create   a query in Query Design view based on the 2F Student Papers table that   prompts you to Enter the Home Campus,   and then answers the question, What is the Home Campus, Student ID, Paper   Name, Category, and Publication Date for student publications, sorted in   ascending order by the Publication Date field? Run the query, and when   prompted, enter southwest   as the criteria (seven records display). Save the query as 2F Campus Parameter Query, and then close the query.

 

Save   and close the database, and then submit for grading.

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

Python Assignment Help

Python Assignment Help

PYTHON

Create a folder that identifies you and Assignment 2 such as smith_asst2 or asst2_jones. Save all Python programs to this folder. Zip the folder. No .rar files allowed. Upload the zip to the Assignment 2 drop box.

 

1.    Alphabetic Telephone Number Translator

 

 

Many companies use telephone numbers like 555-GET-FOOD so the number is easier for their customers to remember.  On a standard telephone, the alphabetic letters are mapped to numbers in the following fashion.

A, B and C = 2

D, E, and F = 3

G, H, and I = 4

J, K, and L = 5

M, N, and O= 6

P, Q, R, and S = 7

T, U, and V = 8

W, X, Y, and Z = 9

Write a program that asks the user to enter a 10-character telephone number in the format xxx-xxx-xxxx. The application should display the telephone number with any alphabetic characters that appeared in the original translated to their numeric equivalent. For example, if the user enter 555-GET-FOOD the application should display 555-438-3663

 

 

1.     Word separator

Write a program that accepts as input a sentence in which all of the words are run together but the first character of each word is uppercase. Convert the sentence to a string in which the words are separated by space and only the first word starts with an uppercase letter. For example the string “ StopAndSmellTherRoses.” Would be converted to “Stop and smell the roses.”

 

2.    Pig Latin

Write a program that accepts a sentence as input and converts each word to “Pig Latin.” In one version, to convert a word to Pig Latin you remove the first letter and place that letter at the end of the word. Then you append the string ”ay” to the word. Here is an example:

 

English:      I SLEPT MOST OF THE NIGHT

Pig Latin:   IAY LEPTSAY OSTMAY FOAY HETAY IGHTNAY

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

SQL Server 2012 Chapter 7 Assingment

SQL Server 2012 Chapter 7 Assingment

its due this saturday! feb 26th. sql server management studio needed to verify the code works! see attached document

 

 

1.      Write an INSERT statement that adds this row to the Categories table:

 

CategoryName:            Brass

 

Code the INSERT statement so SQL Server automatically generates the value for the CategoryID column.

 

2.      Write an UPDATE statement that modifies the row you just added to the Categories table. This statement should change the CategoryName column to “Woodwinds”, and it should use the CategoryID column to identify the row.

 

3.      Write a DELETE statement that deletes the row you added to the Categories table in exercise 1. This statement should use the CategoryID column to identify the row.

 

4.      Write an INSERT statement that adds this row to the Products table:

 

ProductID:                   The next automatically generated ID
CategoryID:                 4
ProductCode:               dgx_640
ProductName:              Yamaha DGX 640 88-Key Digital Piano
Description:                 Long description to come.
ListPrice:                      799.99
DiscountPercent:          0
DateAdded:                 Today’s date/time.

 

Use a column list for this statement.

 

5.      Write an UPDATE statement that modifies the product you added in exercise 4. This statement should change the DiscountPercent column from 0% to 35%.

 

6.      Write a DELETE statement that deletes the row in the Categories table that has an ID of 4. When you execute this statement, it will produce an error since the category has related rows in the Products table. To fix that, precede the DELETE statement with another DELETE statement that deletes all products in this category.

 

7.      Write an INSERT statement that adds this row to the Customers table:

 

EmailAddress:             rick@raven.com
Password:                    (empty string)
FirstName:                   Rick
LastName:                   Raven

 

Use a column list for this statement.

 

8.      Write an UPDATE statement that modifies the Customers table. Change the password column to “secret” for the customer with an email address of rick@raven.com.

 

9.      Write an UPDATE statement that modifies the Customers table. Change the password column to “reset” for every customer in the table.

 

10.  <<You don’t need to show this in your homework, but you should do it.>> Open the script named CreateMyGuitarShop.sql that’s in the Exercise Starts directory. Then, run this script. That should restore the data that’s in the database.

 

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