All posts by : chebby

Exp22_Excel_Ch05_HOE – Sociology 1.1

Exp22 Excel Ch05 HOE Sociology 1.1

Excel Chapter 5 Hands-On Exercise – Sociology

Project Description:

You are the vice president of the Sociology Division at Ivory Halls Publishing Company. Textbooks are classified by an overall discipline. Books are further classified by area. You will use these classifications to see which areas and disciplines have the highest and lowest sales. The worksheet contains wholesale and retail data. You want to analyze sales for books published in the Sociology Division. To do this, you will organize data by discipline and insert subtotal rows. You will also create PivotTables to gain a variety of perspectives of aggregated data. Finally, you will create a PivotChart to depict the aggregated data.

Start Excel. Download and open   the file named Exp22_Excel_Ch05_HOE_Sociology.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

Your first task is to sort the   dataset on the Books Subtotal worksheet.
 

  Ensure the Books Subtotal worksheet is active. Sort the data by Discipline in   alphabetical order and further sort it by Area in alphabetical order.

You want to subtotal the dataset   by Discipline and then add a second set of subtotals by Area.
 

  Use the Subtotal feature to insert subtotal rows by Discipline to calculate   the totals for the Sales Wholesale, Sales Retail, and Total Book Sales   columns. Without removing the first subtotals, insert subtotals by Area to   calculate totals for the same columns.

Next, you want to apply an   outline to the columns so that you can collapse or expand the Units Sold and   Unit Price columns.
 

Create an automatic outline. Collapse   the outline above columns H and K.

Next, you want to create a   recommended PivotTable and then name it.
 

  Display the Books Data worksheet and create a recommended PivotTable using   the Sum of Units Sold thumbnail. Change the name of the worksheet to PivotTable. Name the PivotTable Total Book   Sales. 

You want to compare total book   sales by discipline and copyright year.
 

  Make sure these fields are in the respective areas. Remove extra fields.   Place the Discipline field in rows, Total Book Sales field as values, and   Copyright field in columns.

You will format the values in   the PivotTable to look more professional and change the custom names that   display as column headings.
 

  Click or select cell B5, display the Value Field Settings dialog box, and   type Sales   by Discipline   as the custom name. Apply Accounting Number Format with zero decimal places.

You want to replace the generic   Row Labels and Column Labels headings with meaningful headings.
 

  Type Discipline in cell A4 and Copyright   Year in cell   B3. Select the range B4:E4 and center the labels horizontally.

On the Books Data sheet, you   want to insert functions that will display the total sales and the total   Introductory discipline sales data from the PivotTable. You will change the   retail unit price rate from 30% to 25% and then refresh the PivotTable.
 

  Display the Books Data worksheet. In cell B1, enter the GETPIVOTDATA function   to get the value from cell F10 in the PivotTable worksheet. In cell B2, enter   the GETPIVOTDATA function to get the value from cell F7 in the PivotTable.   Change the value in cell J1 to 125 in the Books Data worksheet, and then refresh the PivotTable. 

You will add a field to the   Filters area so that you can filter the list by Edition.
 

  Add the Edition field to the Filters area. 

Because you plan to distribute   the workbook to colleagues, you will insert a slicer to help them set   filters.
 

  Insert a slicer for Discipline. Move the slicer so that the top-left corner   is just inside the corner of cell A13.

After inserting the slicer, you   want to change the dimensions and appearance of it.
 

Change the slicer to   display 2 columns. Change the button width to 1.5 inches. Change the slicer height to 2 inches. Apply Light Blue, Slicer Style Dark 1.

You want to calculate the amount   of the sales returned to the authors as royalties.
 

  Create a calculated field with the name Author Royalties. Multiply Total Book Sales by *.1. In cell C5, use the Field   Settings to type the custom name Authors’ Royalties.

Format cells C5, E5, G5, and I5   with Center horizontal alignment and wrap text. Change the height of row 5 to   30. Change the width of columns C,   E, G, and I to 12.

You want to display the Total   Book Sales as a percentage of the grand total.
 

  Select the Total Book Sales and show the values as a percentage of the grand   total.

To enhance the readability of   the sociology textbook PivotTable, you will change the PivotTable style.
 

  Apply Light Blue, Pivot Style Medium 2 to the PivotTable. Display banded   columns.

The Books, Disciplines, and   Editors worksheets contain tables You will create relationships between the   Books table and the other two tables.
 

  Display the Books worksheet. Create a relationship between the BOOKS table   using the Discipline Code field and the DISCIPLINE table using the Disc Code.   Create a relationship between the BOOKS table using the Editor ID field and   the EDITOR table using the Editor ID field.

Now that you built a   relationship between the tables, you can create a PivotTable using fields   from all three tables.
 

  Create a blank PivotTable from within the Books worksheet and add the data to   the data model. Name the worksheet as Relationships.

You are ready to add fields from   the three tables to the PivotTable.
 

  Display all tables within the PivotTable Fields pane. Place the Total Book   Sales field from the BOOKS table in the Values area. Place the Discipline   field from the DISCIPLINE table in the Rows area. Place the Editor Last field   from the EDITOR table below the Discipline field in the Rows area.

Format the Total Book Sales   field with Accounting Number Format with zero decimal places.

You want to create a PivotChart   to display percentages in a pie chart.
 

  Create a PivotChart from the PivotTable you just created. Change the chart   type to a pie chart. Cut the chart and paste it just inside the top-left   corner of cell C1.

The PivotChart has too much   detail. You will filter the chart to display only one discipline.
 

  Filter the PivotChart by displaying only the Family discipline. Sort the   PivotTable by the Total Book Sales from largest to smallest.

The chart needs a meaningful   title.
 

  Change the chart title to Family Discipline Book Sales.

You want to add data labels to   provide more details to the chart.
 

  Display data labels in the best fit position with only the Percentage labels.   Deselect the Values data labels.

Save and close Exp22_Excel_Ch03_ HOE_Sociology.xlsx.   Exit Excel. Submit the file as directed.

 Develop a Complete Disaster Recovery Plan to be submitted to the executive board of your company. 

***5 minimum peer-reviewed references***

Instructions:

 1.5 Spacing , 10 pages, Times Roman font.

***no Plagiarism, APA format***

!!!! No money Negotiations after accepting the Bid !!!!!!!

Topic: Perform a LEED (Leadership in Energy and Environment Design) Certification Assessment of your local living area or work location. Remember to get permission from security. If you wish you may approach the subject in terms of Best Practices. 

Instructions: Please download the Assignment 6 LEED Certification Asssessment template (MS Word), which is already in APA 7 format, using size 12 Times New Roman font, 1-inch margins, TOC, Headings and Reference page. If you insert images or tables in your report make sure you label them appropriately according to APA. Once completed name your file: YourName_Assignment_6_LEED_Assessment.docx and submit to the appropriate assignment folder. 
Also review any additional files attached for more information.

There are many operating systems that are used to run networks. Name at least three of them, but do not include different versions of a single operating system. For each operating system, list its name, the platform or network on which it operates, and its distributor or manufacturer. Define any jargon you use so your answers will be understandable to the average high school student and cite your sources.

Help a fellow student out eh? : D

One of the greatest methods for automatic data capture is OCR (optical character recognition). With the aid of this technology, data may be quickly and effectively extracted from a variety of information sources, including documents. OCR technology is used by data entry firms to extract data from files in any kind of electronic or paper format and then transform this data into the necessary electronic format. The OCR technique includes turning scanned images of typewritten or handwritten text into computer text. OCR-enabled automated data input programmes aid in optimising templates for data reformatting from scanned documents. The system also works to transform the data into searchable and editable formats, making it simpler to retrieve the material in the future.

Using OCR technology has several benefits. Businesses benefit from increased productivity and effectiveness of work. Its ability to quickly search through enormous content is helpful for office environments that deal with large document intake and high volume scanning. Other advantages of using OCR for automated data capture include higher productivity, lower costs, high accuracy, fewer mistakes, more storage space, greater data security, complete text searchability of digitised documents, improved customer service, and data security even in emergencies.

According to a Transparency Market Research (TMR) analysis, the global OCR market is anticipated to grow at a CAGR of 14.8% from 2017 to 2025, reaching a value estimate of US $25.1 billion at that time.

A Guide to OCR-based Data Capture Best Practices

 Start from the Base-  Analyze the data in the printed source material from the ground up. The data entry team should do this. The quality of data capture may be impacted by aspects such as paper quality, language, font, layout, and graphical elements. Additionally, this will give the data entry team information they may use to assess how readily they can complete the data capture. For instance, lexical information is needed for OCR data entry on historical documents. Similar to this, it may be necessary to take specific steps to prepare image-rich documents for OCR or it may be necessary to use improvised OCR data collection to properly digitise the papers.

 Set Up OCR Project Goals-  To Establish OCR Project Goals Every OCR-based data capture project needs to have distinct, well-defined goals. The data entry team must choose the approach that best meets the project’s needs and can produce the kind of output for data capture that is necessary. Depending on the degree of precision required for the work, the post-OCR output can also need additional manual correction or processing. Here are a few important factors to think about to achieve the objectives of the OCR data collection project.

Identifying the necessary output type and its function

determining the degree of data capture accuracy.

Does the data capture project require text-only data capture, or should extra components be added for enhanced searchability in addition to the text?

What is the user’s level of error tolerance?

Whether consumers would need to see the OCR text files displayed

 Have a Well-charted Work Flow-  The success or failure of the OCR data input endeavour may not be determined by a well-charted process workflow. Instead, a carefully planned flow ensures that data collection and conversion go as planned.OCR

 Perform OCR Quality Check Processes-  Quality assurance (QA) procedures must be implemented as a level of control in every successful data capture project. The data collection project will be on track and the goals will be met in the allotted period thanks to this QA programme. The QA team should conduct a thorough examination of all of the acquired data or a segmented examination. QA methods also involve monitoring and fixing data entry problems. A knowledgeable OCR service provider can complete all of these tasks effectively. It is crucial to make sure that the QA plan is correctly developed, and put into practice, and that all staff members are informed of the quality requirements.

Be adaptable to changes in project size and cost.

 Be Flexible to Project Scale and Cost Variations-  OCR-based data capture initiatives may have different requirements depending on the project. Additionally, there could be unforeseen changes that arise during the project that calls for adjustments. As a result, data entry teams must consider some degree of flexibility while developing their OCR data capture plans to deal with and adjust as necessary. Planning at the proper level is necessary since changes in scale may affect project budgets and timetables. The difference between anticipated and actual expenditures for an OCR data collection activity can be substantial. In actuality, the prices might be larger. The duration of the OCR data capture project may change due to unforeseen and unplanned circumstances. But with careful planning, time can be set aside for these possibilities.

OCR data collection can be made effective and reliable by working with a data entry provider with experience with the technology. For more clear information you can also visit:      https://it-s.com/    

Penetration testing is a simulated cyberattack against a computer or network that checks for exploitable vulnerabilities. Pen tests can involve attempting to breach application systems, APIs, servers, inputs, and code injection attacks to reveal vulnerabilities. In a well-written, highly-detailed research paper, discuss the following:

• What is penetration testing
• Testing Stages
• Testing Methods
• Testing, web applications and firewalls

Your paper should meet the following requirements:

• Be approximately four to six pages in length, not including the required cover page and reference page.
• Follow APA7 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. The UC Library is a great place to find resources.
• 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.

 What are baseline security requirements that should be applied to the design and implementation of applications, databases, systems, network infrastructure, and information processing when considering cloud computing within an enterprise risk management framework?Your paper should meet the following requirements:

• Be approximately four to six pages in length, not including the required cover page and reference page.
• Follow APA7 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. The UC Library is a great place to find resources.
• 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.

Download The Attachment and Message Me Please for Detailed Instructions

I will be uploading the required information, you need to work according to it. 

I need a rough draft about Amazon like a summary of 1000 to 1500 words. 

needed in APA format. 

I have uploaded another file in which there are some links and information which should be co-related to topic Amazon