Exp19_Excel_Ch06_Cap_High_West_Fashions

/in , /by

Exp19_Excel_Ch06_Cap_High_West_Fashions

Grader – Instructions Excel 2019 Project

Exp19_Excel_Ch06_Cap_High_West_Fashions

 

Project Description:

You are the digital marketing director for High West Fashions, a regional clothing company that specializes in custom t-shirts. Your company has decided to launch an online advertising campaign that gives customers the ability to purchase heavily discounted products. You have the task of determining the optimal amount of advertising to purchase in order to maximize profit and most effectively utilize resources.

 

Steps to Perform:

Step Instructions Points Possible
1 Start Excel. Download and open the file named Exp19_Excel_Ch06_Cap_DirectMarketing.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 On the Direct Marketing worksheet, create appropriate range names for Design_Fee (cell B8), Cost_Per_Ad (cell B9), Total_Clicks (cell B10), Profit_Per_Click (B11), and Gross_Profit (cell B12). 5
3 Edit the existing name range Design_Fee to Design_Fee2021 to reflect the current year. 4
4 Use the newly created range names to create a formula to calculate Gross Profit (cell B12) and Net Profit (cell B13). 6
5 Create a new worksheet named Range Names, paste the newly created range name information in cell A1, and resize the columns as needed for proper display. Mac users, use the Insert menu to insert a new worksheet and paste the range names. 5
6 On the Direct Marketing worksheet, use Goal Seek to determine the optimal click rate in order to earn a $5,000 net profit. 6
7 Starting in cell E4. Complete the series of substitution values ranging from 2% to 6.5% at increments of .50% vertically down column E. 5
8 Enter references to the Gross Profit and Net Profit in the correct location for a one-variable data table. 3
9 Complete the one-variable data table, and then format the results with Accounting Number Format with two decimal places. 6
10 Apply custom number formats to display Gross Profit in cell F3 and Net Profit in cell G3. 4
11 Copy the response rate substitution values from the one-variable data table, and then paste the values starting in cell I4. 4
12 Type 10000 in cell J3. Complete the series of substitution values from 10000 to 40000 at 5000 increments. 3
13 Enter the reference to net profit formula in the correct location for a two-variable data table. 4
14 Complete the two-variable data table and format the results with Accounting Number Format with two decimal places. 7
15 Apply a custom number format to make the formula reference appear as Net Profit. 3
16 Make the Direct Marketing 2 worksheet active. Create a scenario named Best Case, using Number of Ads and Click Rate. Enter these values for the scenario: 40000, and 6.5%. 4
17 Create a second scenario named Worst Case, using the same changing cells. Enter these values for the scenario: 10000, and 1%. 4
18 Create a third scenario named Most Likely, using the same changing cells. Enter these values for the scenario: 10000, and 6.83%. 4
19 Generate a scenario summary report using Gross Profit and Net Income. 4
20 Return to the Direct Marketing 2 worksheet. Load the Solver add-in if it is not already loaded. Launch Solver and set the objective to calculate a net profit of $20,000. 4
21 Use Number of Ads and Click Rate (B4:B5) as changing variable cells. 4
22 Set a constraint to ensure Number of Ads purchased is less than or equal to 40,000. 2
23 Set a constraint to ensure Click Rate is less than or equal to 7%. (Mac users should enter the value in decimal form. Example .07) 2
24 Solve the problem. Generate the Answer Report. 3
25 Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side. 4
26 Save and close Exp19_Excel_Ch06_CAP_DirectMarketing.xlsx. Exit Excel. Submit the file as directed. 0
Total Points 100

 

Created On: 04/09/2021 1 Exp19_Excel_Ch06_Cap – High West Fashions 1.6

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

Exp19_Excel_Ch06_ML1_Housing_Cost

/in , /by

Exp19_Excel_Ch06_ML1_Housing_Cost

Exp19_Excel_Ch06_ML1_Housing_Cost

 

Exp19_Excel_Ch06_ML1_Housing_Cost

Project Description:

Your friends, Elijah and Valerie Foglesong, want to build their dream house. They identified tentative costs, but they cannot afford the $414,717 estimated cost. You will use Goal Seek to determine an estimate of the total finished square footage they can afford. To help provide more flexibility in their decision-making, you will create a data table listing various finished square footages and their effects on the base house cost and total cost. Finally, you will create another data table showing combinations of square footages and lot prices to identify total costs.

 

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

 

Assign the range names B9 (Base), B15 (Interior), B21 (Exterior), B23 (Lot).

 

Enter a formula in cell B25 to   calculate the total estimated cost. The total estimated cost is the sum of   the base house price (B9), total interior upgrades (B15), total exterior   upgrades (B21), and lot fee (B23). Be sure to use range names in the formula.

 

Use Goal Seek to determine the   total finished square footage(B7) to meet the total cost goal of $350,000.

 

Enter a series of total square   footage ranging from 1,800 to 3,600 in increments of 200 in the range D6:D15. Apply Blue font and Comma Style with   zero decimal places to the series.

 

Enter a reference to the base   house price in cell E5 and a reference to the total estimated cost in cell   F5.

 

Complete the single variable   data table in the range D5:F15. Be sure to use total square footage as the   column input. Apply Custom number formats to give appropriate descriptions to   the second and third columns. Apply these formats to the headings: bold,   center, and Blue font color.

 

Identify the square footage,   base price, and total cost in the data table that comes closest to their   goal. Apply Yellow fill color to those cells.

 

Copy the square footage   substitution values, range D6:D15 to the range H6:H15 and remove the fill   color. Enter these lot price substitution values in the range I5:K5: 90000, 96000, and 102675. Format these values with Accounting Number Format with zero   decimal places and Blue font color.

 

Enter the reference to the total   estimated cost in the appropriate location for the second data table. Apply a   custom number format to display Total Sq Ft in that cell. Apply Blue font and bold to that   cell.

 

Complete the two-variable data   table using total square footage as the Column Input and lot price as the Row   Input. Apply a Custom number format to the reference to the formula cell.   Apply Yellow fill color to the total price in each column that comes closest   to their goal.

 

Format results in both tables   with Accounting Number Format with zero decimal places.

 

Create a scenario named Ideal Costs, using Base price per square   foot and Lot fee (use cell references). Enter these values for the scenario: 80, 102,675.

 

Create a scenario named Increased   Costs, using   Base price per square foot and Lot fee (use cell references). Enter these   values for the scenario: 100, 110,000.

 

Create a scenario named Low Costs, using Base price per square   foot and Lot fee (use cell references). Enter these values for the scenario: 60, 80,000.

 

Generate a scenario summary   report using the cell references for Price per square foot and Lot Fee. Add   the appropriate formatting to the newly created report

 

Save and close Exp19_Excel_Ch06_ML1_HW-Housing Cost.xlsx.   Exit Excel. Submit the file as directed.

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

Excel_Introductory_Capstone2_Annual_Report

/in /by

Excel_Introductory_Capstone2_Annual_Report

Grader – Instructions Excel 2019 Project

Excel_Introductory_Capstone2_Annual_Report

 

Project Description:

In this project, you will work with multiple worksheets and enter formulas and functions to calculate totals, averages, maximum values, and minimum values. Additionally, you will create a summary sheet, format cells, insert charts, insert sparklines, and create a table in a workbook.

 

Steps to Perform:

Step Instructions Points Possible
1 Open the Excel file named Student_Excel_Intro_Cap2_Annual_Report.xlsx downloaded with this project. 0
2 On the Net Sales worksheet, calculate totals in the ranges F4:F8 and B9:F9. Apply the Total cell style to the range B9:F9. 5
3 Using absolute cell references as necessary, in cell G4, construct a formula to calculate the percent that the Texas Total is of Total Sales, and then apply Percent Style. Fill the formula down through the range G5:G8. 5
4 In the range H4:H8, insert Line sparklines to represent the trend of each state across the four quarters. Do not include the totals. Add Markers and then in the first row, apply the first Sparkline style. 4
5 Select the range A3:E8, and then use the Recommended Charts command to suggest an appropriate chart. Click the first Clustered Column chart that uses the state names as the category axis. Align the upper left corner of the chart inside the upper left corner of cell A11, and then size the chart so that its lower right corner is slightly inside cell H24. Apply chart Style 6. As the chart title, type Quarterly Net Sales by State 10
6 To show the percent that each state contributes to the total sales, select the nonadjacent ranges that represent the state names and state totals (in column F). Insert a 3-D Pie chart, and then move the chart to a New sheet. Name the sheet Net Sales Chart. 6
7 Change the Chart Title to Annual Net Sales by State and then change the chart title Font Size to 32. Remove the Legend from the chart, and then add Data Labels that display only the Category Name and Percentage positioned in the Center. Change the data labels Font Size to 14 and apply Bold and Italic. Change the Font color to White, Background 1. 6
8 Select the entire pie and display the Format Data Series pane. From the 3-D Format gallery, modify the 3-D options by changing the Top bevel and Bottom bevel to the first bevel option in the first row. Set all of the Width and Height boxes to 256 and then change the Material to the fourth Standard type—Metal. 2
9 Insert a Custom Footer with the File name in the left section and then save your workbook. 3
10 On the Portland Inventory worksheet, in cell B5, enter a function that will display the average retail price. In cell B6, enter a function that will display the median retail price. In cell B7, enter a function that will calculate the lowest retail price. In cell B8, enter a function that will calculate the highest retail price. Format the range B5:B8 with Accounting Number Format. 5
11 On the Portland Inventory worksheet, in cell G14, enter an IF function to determine the items to be ordered. If the Quantity in Stock is less than 50, then the cell should display Order. If not, then the cell should display OK. Copy the function down through cell G19. 8
12 Format the range A13:G19 as a table with headers and then apply Teal, Table Style Light 13. If the style is not available, choose another style. Filter the table on the Sport column to display only the Hiking types. Display a Total Row in the table, and then sum the Quantity in Stock for Hiking items. Type the result in cell B11. Remove the total row from the table and then clear the Sport filter. 4
13 In cell B10, insert a COUNTIF function to count the number of Hiking items in the Sport column. 1
14 Add Gradient Fill Blue Data Bars to the range A14:A19. Add conditional formatting to the range G14:G19 so that the cells with text that contain the word Order are formatted with Bold and Italic. Sort the table by Item # from Smallest to Largest. 3
15 Display the Inventory Summary sheet. In cell B4, enter a formula that references cell B4 in the Portland Inventory sheet so that the Portland Total Items in Stock displays in cell B4. In cell B5, enter a formula that references cell B5 in the Portland Inventory sheet so that the Portland Average Price displays in cell B5. In cells B6, B7, and B8, enter similar formulas to reference the Median Price, Lowest Price, and Highest price in the Portland Inventory sheet. 5
16 In cell C4, enter a formula that references cell B4 in the Austin Inventory sheet so that the Austin Total Items in Stock displays in cell C4. In cells C5, C6, C7, and C8, enter similar formulas to reference the Average Price, Median Price, Lowest Price, and Highest price in the Austin Inventory sheet. Be sure that the range B5:C8 is formatted with Accounting Number Format. 5
17 On the Annual Expenses sheet, construct formulas to calculate Totals by Quarter in the range B10:E10 and the Annual Totals in the range F5:F10. Apply the Total cell style to the Totals by Quarter (B10:F10), and then center the column headings (B4:G4) and apply the Heading 4 cell style. If necessary, format the range F6:F9 with Comma Style, zero decimal places. 5
18 Using absolute cell references as necessary, in cell G5, construct a formula to calculate the % of Total by dividing the Sales Expense Annual Total by the Annual Totals by Quarter. Fill the formula down through the range G6:G9. 2
19 Using the data in the nonadjacent ranges A4:E4 and A10:E10, insert a Line with Markers chart. Position the upper left corner of the chart slightly inside the upper left corner of cell A12. Change the height of the chart to 1.75 inches and the width of the chart to 8 inches. (Mac users, change the chart height to 1.5.) 6
20 Apply chart Style 3. Change the chart title to Direct Expenses. Edit the Vertical (Value) Axis so that the Minimum is 6000000. 4
21 Use Format Painter to copy the formatting from cell A2 to A20. In cell B23, enter a formula that references the value in cell F10. 2
22 Using absolute cell references as necessary, in cell C23, construct a formula to calculate the projected expenses for 2021 after the Forecasted increase in cell B21 is applied. Fill the formula through cell F23. 4
23 Display the Sales Reps sheet. By using Flash Fill and deleting columns as necessary, place the last names in column A and the first names in column B. Widen both columns to 100 pixels, and then merge and center the title Sales Reps across the two columns. Apply the Heading 1 cell style to the title. 4
24 With any sheet except the chart sheet active, group the worksheets. Change the Orientation to Landscape, center the worksheets Horizontally, and insert a footer in the left section with the file name. (Mac users, click the Net Sales sheet, hold down SHIFT, and then click the Sales Reps sheet. Then apply the Page Layout options.) 1
25 Save and close the file, and then submit for grading. 0
Total Points 100

 

Created On: 06/29/2021 1 GO19_XL_INTRO_GRADER_CAP2 – Annual Report 1.4

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

Microsoft Excel Assignment – “Revenue”

/in , /by

Microsoft Excel Assignment – “Revenue”

Do Project 3E Revenue that begins on page 527 of your textbook. Submit the document by clicking the Attachments button to attach the file. Do not paste the document in the Message area.

You will need to download and use the following data file to complete your assignment:

Revenue Report

In addition to the assignment file, answer the following question with your submission.  This can be answered directly in your Submission comment area, or as a separate Word attachment file:

In this Week’s reading and prep work, In this week’s chapter, you utilized the “What-If Analysis” feature. Explain what this is and how you feel you might be able to use it in a personal finance worksheet of your own?  Please look to answer this in at least 3 complete sentences in order to address it adequately.

The picture on the right is what it should look like afterwards!!!!  

 

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

Exp19_Excel_Ch05_Cap_Apartments

/in , /by

Exp19_Excel_Ch05_Cap_Apartments

#Exp19ExcelCh05CapApartments 

#Exp19_Excel_Ch05_Cap_Apartments

Project Description:

You manage several apartment complexes in Phoenix, Arizona. You  created a dataset that lists details for each apartment complex, such as  apartment number, including number of bedrooms, whether the unit is  rented or vacant, the last remodel date, rent, and deposits. You will  use the datasets to aggregate data to analyze the apartments at the  complexes.

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

Before subtotalling the data,   you need to sort the data.
Select the Summary sheet. Sort the data by Apartment Complex in  alphabetical   order and further sort it by # Bed (the number of  bedrooms) from smallest to   largest.

You want to use the Subtotal   feature to display the average total deposit by number of bedrooms for each   apartment complex.
Use the Subtotal feature to insert subtotal rows by Apartment  Complex to   calculate the average Total Deposit. Add a second subtotal  (without removing   the first subtotal) by # Bed to calculate the  average Total Deposit by the   number of bedrooms.

Use the outline symbols to   display only the subtotal rows. Create  an automatic outline and collapse the   outline above Total Deposit.

You want to create a PivotTable to determine the total monthly rental   revenue for occupied apartments.
Display the Rentals sheet and create a blank PivotTable on a new  worksheet to   the left of the Rentals sheet. Change the name of the  worksheet to Rental Revenue. Name   the PivotTable Rental Revenue.

Display the Apartment Complex and # Bed fields in Rows and the Rental   Price field as Values.

Format the Sum of Rental Price   for Accounting Number Format with zero decimal places and enter the custom   name Total   Rent Collected.

Select the Occupied field for   the filter and set the filter to Yes to display data for occupied apartments.

You want to calculate the total   monthly rental revenue if the rates increase by 5% for the occupied   apartments.
Insert a calculated field to multiply the Rental Price by 1.05. Change the name to New Rental   Revenue. Apply   Accounting Number Format with zero decimal places.

Select the range B3:C3 and apply   these formats: wrap text, Align Right horizontal alignment, and 30 row height. Select column B and   set 9.29 column width. Select column C   and set 14.43 column   width.

Apply Light Orange, Pivot Style   Medium 10 to the PivotTable and display banded rows.

Insert a slicer for # Bed so that you can filter the dataset by    number of bedrooms. Change the slicer caption to # of Bedrooms.

Change the slicer height to 1.4 inches and width to 1.75 inches. Apply Light Orange,   Slicer Style Light 2. Cut the slicer and paste it in cell E2.

Insert a timeline for the Last   Remodel field. Change the time  period to YEARS. Apply Light Orange, Timeline   Style Light 2. Change  the timeline height to 1.4 inches and with to 3.75 inches.

The Databases sheet contains two   tables. You will create a relationship between those tables.
Display the Databases sheet. Create a relationship between the  APARTMENTS   table using the Code field and the COMPLEX table using the  Code field.

You want to create a PivotTable   from the related tables.
Create a PivotTable using the data model on a new sheet. Change the sheet   name to Bedrooms.   Name the PivotTable BedroomData.

Select the Apartment Name field   from the COMPLEX table for Rows,  the # Bed field for Columns, and the # Bed   field as Values. This will  display the number of apartments with the   specified number of bedrooms  per apartment complex. Display the values as a percentage   of row  totals.

Create a Clustered Column   PivotChart. Cut the chart and paste it in cell A13 using the Destination   Theme.

Select the 3-bedroom data series   and apply the Black, Text 1,  Lighter 50% solid fill color. Apply Black, Text   1 font color to the  vertical axis and category axis. Change the chart height   to 3 inches  and the   width to 5 inches, if necessary. Hide the field buttons in the  PivotChart.

Create a footer on all   worksheets with your name in the left, the  sheet name code in the center, and   the file name code in the right.

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

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

Excel_2E_Plants homework help

/in , /by

Excel_2E_Plants

Excel_2E_Plants

 

Open   the Excel workbook Student_Excel_2E_Plants.xlsx   downloded with this project.

 

To the right of column B, insert   two new columns to create new blank columns C and D. By using Flash Fill in   the two new columns, split the data in column B into a column for Item # in   column C and Category in column D. As necessary, type Item # as the column title in column C   and Category   as the column   title in column D. Delete column B.

 

By using the Cut and Paste   commands, cut column C—Category—and   paste it to column H, and then delete the empty column C. Apply AutoFit to   columns A:G.

 

In cell B4, insert a function to   calculate the Total Items in Stock by summing the Quantity in Stock data, and   then apply Comma style with zero decimal places to the result.

 

In each cell in the range B5:B8,   insert functions to calculate the Average, Median, Lowest, and Highest retail   prices, and then apply the Accounting Number Format to each result.

 

Move the range A4:B8 to the   range D4:E8, apply the 40% – Accent4 cell style to the range, and then select   columns D:E and AutoFit.

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

LAB 5 Toolwire LiveLabs Environment homework help

/in , /by

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

/in , /by

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

/in , /by

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

/in , /by

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!