Monthly Archives: June 2023

Weekly Assignment/Discussions via Unicheck Week 01

Complete the course prep.

Be prepared to demonstrate that your WEB Server work.

It must be able to run the HTML programs from chapter 1.

• ch01_01_canvas.html
• ch01_02_context.html
• ch01_03_attributes.html
• ch01_04_showroom.html
• ch01_05_attributes-final.html

 Exp19_Excel_Ch05_HOEAssessment_Fine_Art

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

Before using the Subtotal command, the data must be sorted by   categories.
 

  On the Subtotals worksheet, perform a three-level sort by Status, then by   Type, and finally by Title, all in alphabetical order.

You want to subtotal data to identify the highest issue prices,   estimated values, and percentage change by the Status category and the Type   of art work.
 

  Use the Subtotals feature to insert subtotal rows by Status to identify the   highest (max) Issue Price, Est. Value,   and Change. Then add a second-level subtotal by Type using the same function   and columns.

You want to apply an outline so that you can collapse values used for   the formula in column F. Then you will collapse the subtotaled rows.
 

  Apply an auto outline and click the collapse button above column F. Collapse   the data by displaying only the subtotals and grand total rows. Set a print   area for the range B1:F48.

A PivotTable can give additional perspective to data. You will use   the Art worksheet to create a recommended PivotTable.
 

  Use the Art worksheet to create the recommended PivotTable called Sum of   Issue Price by Type on a new worksheet named Sold   Out. Mac users create a PivotChart that includes   the Status field in the Filters area, the Est. Values field in the Columns   area, the Type field in the Rows area, and the Issue Price field in the Values   area.
 

  Name the PivotTable Art Type.

Currently, the PivotTable contains the Issue Price field. You will   add the Est. Value field to compare the difference between total value of the   art based on issue price and estimated value today.
 

  Add the Est. Value field below the Sum of Issue Price in the Values area.

You want to display the average   values instead of the sum of the values in each category.
 

  Modify the two Values fields to determine the average Issue Price and average   Est. Value by type. Change the custom name to Average Issue Price and Average Est. Value, respectively.

Format the two Values fields   with Accounting number type with zero decimal places.

The Summary sheet is designed to   display two key averages from the PivotTable on the Summary sheet.
 

  Display the Summary sheet. In cell B2, insert the GETPIVOTDATA function that   references cell C4 on the PivotTable in the Sold Out sheet. In cell B3,   insert the GETPIVOTDATA function that references cell C9 on the PivotTable in   the Sold Out sheet.

Some art is still available, but   most art is sold out. You want to create a filter to focus on the sold-out   art.
 

  Display the Sold Out sheet. Add the Status field from the field list to the   Filters area. Set a filter to display only art that is Sold Out.

Insert a slicer for the Type   field, change the slicer height to 2 inches, change the button width to 2 inches, and apply the Light   Blue, Slicer Style Dark 5. Cut the slicer and paste it in cell A11.
 

  Note, depending upon the Office version used, the style name may be Slicer   Style Dark 1.

Display the Totals sheet. Insert   a calculated field named Field1 to determine difference between the two   values, Est. Value   and   Issue Price.   Change the custom name to Value Increase.

With the PivotTable on the   Totals sheet displayed, change the Sum of Issue Price and Sum of Est. Value   fields to show values as percentage of column totals.

With the PivotTable on the   Totals sheet displayed, select Light Blue, Pivot Style Medium 6 and display   banded rows.

Display the Porcelains sheet.   Create a relationship between the PORCELAINS table using the Code field and the   CODES table using the Code field.

Create a blank PivotTable from   inside the PORCELAINS table. Add this data to the Data Model. Name the   worksheet Porcelain Pivot and name the PivotTable Porcelain   Values.

Display all tables in the   PivotTable Fields List task pane. Add the Description from the CODES table to   the Rows area and the Issue and Est. Value fields as Values from the   PORCELAIN table. Format the two value fields with Accounting number format   with zero decimal places.

Create a clustered column   PivotChart from the Porcelain Values PivotTable. Cut the PivotChart and paste   it in cell A7.

Add a chart title and type Porcelain   Values. Bold   the title. Change the value axis maximum bounds to $3,000.

Change the PivotChart height to 2.5 inches and the width to 3.7 inches.

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

Ensure that the worksheets are   correctly named and placed in the following order in the workbook: Subtotals,   Totals, Sold Out, Art, Summary, Porcelain Pivot, Porcelains.

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

Writing rules and guidelines 

WRITING CHECKLIST

Formatting

• The text in my written paper is double-spaced

• My font size is 11 or 12

• My font style is professional; for example, Arial or Times Roman

• The first sentences of all my paragraphs are indented

• My page count is within the Assignment limit (Do not count the Cover or Reference

pages)

Grammar

• All contractions have been replaced with the full item (e.g., replace Don’t … with Do

not …)

• All names of books and titles of articles in the body of my paper are italicized

• I have used MS Word’s Spelling and Grammar tool to check my paper for errors

• I have checked my paper with the online Grammarly tool

• I have read my paper through out loud to catch minor stylistic mistakes

Citations and References

• Citations with an author’s name in the sentence use just the source number: e.g., (1)

• Citations without an author’s name use the name and number: e.g., (Welch, 1)

• I included just a few direct quotations, and each one is no longer than 1-2 sentences

• Mostly, when using other writers’ ideas, I paraphrased them (i.e., explained in my own

words)

• I used an in-text citation every time I referred to another writer’s idea

• I used (1) for the first source to appear in my paper, (2) for the next source, and so on

• My in-text citations match the number of the source on my References or Sources

page

• I listed all my References (or Sources) on a final, separate page

Question 

Discuss ways in which information technology can affect

1. management, and
2. non-managerial work.

Which skills do you think are more important for information technology project managers to possess at various points in their careers: strong technical skills or strong communications skills?

Your assignment is to find a YouTube video presenting a Mind-Body technique in a professional manner. You can search using keywords like; mind-body, meditation, relaxation, guided imagery, Reiki, Body Talk, Therapeutic Touch, etc. 2. The video should be no longer than 10 minutes. Spend some time viewing different videos in order to provide your classmates with a good learning experience. Please be cautious of inappropriate or unprofessional videos. 3. Provide a transcript like a summary of the YouTube video addressing how the video correlates with the following course competencies: a. How natural systems of the human body function. b. The impact of humans on the environment. c. The impact of ethnicity and culture. d. Correlating illness prevention, health promotion, health restoration, patient education, and empowerment as it relates to alternative and complementary healthcare. 4. Your transcript/summary should use APA Style guidelines. ( include video link)

2.

Instructions

1. After reading the articles on meditation and viewing the videos, try out meditation. Here are the guidelines:
   1. Perform Self-Meditation for six (6) days.
   2. Monitor and record your heart rate before and after each meditation session.
   3. Then, video record yourself performing the self-meditation session, and attach to this post. (Optional)
2. After you have experienced practicing meditation, report on the following:
   1. How did you feel about this assignment?
      • Were you comfortable or not performing the task on meditation? Explain why or why not.
   2. Describe the health benefits and different types of meditation therapies available?
   3. Describe the effects of meditation throughout your day-to-day activities and work.
   4. Do you believe mediation is a useful alternative and complimentary alternative to healthcare? Explain why or why not.
   5. Would you continue to use meditation?
3. Find evidenced-based research article on meditation and attach to this post
4. Remember to include your heart rate tracking before and after each meditation section to this post.
5. Post must be 200-300 words.

This is a continuing assignment; you will be using this drop box until you and your faculty mentor approve your topic. 

In a 200-word document, describe your topic. Identify research in the area any models/theories developed in the area. Have you identified a cite problem/gap in this body of knowledge?

Are you considering doing a qualitative, quantitative, mixed method, project, etc., study, identify a possibly population to gather data from.

400 words+

Annette Jackson owns a small crafts store in central Missouri. She wants to expand her store’s reach outside the region to increase her profits and simultaneously reduce her inventory. Annette’s teenage daughter suggested that she consider selling online to expand her total sales. She asked you to help her estimate how much it might cost in the first year to create a simple store with a catalog of about 100 items. Annette wants you to investigate two CSP offerings and report back to her what you find. Because her store is small, limit your research to basic commerce and mall-style services. Annette would like to consider the following information for the two CSP offerings you examine:

NOTE: Please Choose any 4 item form the following list and discuss them ( DISCUSS ONLY 4)

• Costs: initial setup fee, monthly fee, and transaction fees

• Amount of disk space the CSP would provide for Annette’s 100-item store

• Promotion and marketing opportunities

• Customer communications capabilities, such as automated e-mail confirmation of orders

• Shopping cart or other order entry mechanism

• Storefront-building wizards for creating a new store

• Upload capabilities for product names, descriptions, images, and costs (Can they be uploaded from files or databases, or must the merchant enter each item individually?)

• Existence of an online user manual for the merchant

Use your favorite search engine to find CSPs that might meet Annette’s needs. Produce a report of about 400 words summarizing your findings.

1).What have researchers learned about the relationship between higher education and employment? 

2). Rising costs of information technology

Found 3 or 4 RESEARCH ARTICLES using the method taught in the video in this week’s folder

For this assignment, follow the directions CAREFULLY: 

Step 1: Download the EXCEL document below 

HOW, WHAT, who, when, where, why

Step 2: Fill in ONLY the BLUE portions
(If you have answers for how and what, your article IS a research article; if not, please go back to find one)
Submit the complete form here.

Part 2 

Please use the same EXCEL sheet that you used to input HOW and WHAT in the blue sections,

ADD the who, where, when, and why in the salmon sections

Submit the sheet with both the blue and salmon sections filled in.

Please create an APA-7-compliant References page with all 3 or 4 references you found. 

(the title page and references page must be one document, with numbered pages 1 and 2)

PLEASE use the resources in your manual pages 19-20 and page 28, also attached here, AND the template below. Remember, there are VERY specific rules about capitalization and italics. You have a “ways to get help” document in your content folder. 

Find an article from the past 90 days that talks about a security incident within a company. Complete the following:

• Describe the incident.
• What was the impact of this security breach?
• What gap or gaps may have been in the enterprise security plan that may have enabled this incident to occur?
• How would you modify the plan to prevent this from happening again?

Which type of homework you want and to which subject it is related??