All posts by : chebby

Exp22_Word_Ch01_Cumulative_Agriculture

Exp22 Word Ch01 Cumulative Agriculture

Word Chapter 1 Cumulative Assessment – Agriculture

Project Description:

As a student assistant in the Office of Academic Programs, you are charged with finalizing a one-page summary of a program change for your university. You will use styles and columns to format and arrange text. In addition, a watermark and document properties identify the document’s ownership and subject matter.

Start Word. Download and open   the file named Exp22_Word_Ch01_Cumulative_Agriculture.docx.   Grader has automatically added your last name to the beginning of the   filename.

Display nonprinting characters.   Insert text from Careers.docx in   the blank paragraph at the end of the document.

Scroll to the top of page 1.   Apply Heading 2 style to the paragraph heading ABOUT. Apply Heading 2 style to the paragraph headings RESEARCH and CAREERS. Modify the Heading 2 style to a font color of Black,   Text 1 (row 1, column 2) and a font size of 16.

Apply Title   style to the report heading CAREER   FOCUS and center the heading. Insert a hard return after the report   heading and type Agriculture in Your Future. (Do not type the period.)  

Apply Book Title style to the   subheading Agriculture in Your Future.   Change the font size of the subheading to 14.

Select all report text from ABOUT through the end of the document.   Do not select the two heading lines. Change the number of columns to 2.   Ensure that a line displays between the columns. 

Insert a Column break before the   RESEARCH heading near the end of the left column.

Change the document theme to   Facet. Change the theme colors to Grayscale.
 

  If the theme is not available, browse for the downloaded theme file Facet.thmx.

An informal document like a   flyer often includes a page border for a bit of color and style.
 

  Add a Shadow page border, selecting the first line style (single solid). The   color is Gray, Accent 4 (row 1, column 8), and the line weight is 1 1/2 pt.   Apply the page border to the whole document.

Include a custom watermark with   the text UAC. (Do not type the period.) The watermark should be horizontal.

Replace all occurrences of Department of Agricultural Science with   Department   of Agricultural Economics. (Do not include the period.) Two replacements should be made.

Find the word production. Delete the word in that precedes the word production.

Check the word count. If the   number of words is greater than 400, change the first paragraph heading from ABOUT to ABOUT US. However, make that change only   if the word count exceeds 400.

Check the document for spelling   and grammatical errors. Ignore all refinement concerns such as conciseness.

Modify document properties to   include Shazad Chabil as the author, replacing any existing author. Include a Subject   of Agriculture   degree.

Save and close Exp22_Word_Ch01_Cumulative_Agriculture.docx.   Exit Word. Submit the file as directed.

#Excel_1G_Regional_Sales

#Excel 1G Regional Sales

Change the Theme to Retrospect. (If the Retrospect theme is not  available on your computer, in the Themes gallery, click Browse for  Themes, and then select the theme from your downloaded project files.)  Set the width of column A to 80 pixels and the width of columns B:H to  110 pixels. If any columns are too narrow to display all the data, apply  AutoFit to the column.
Mac users: Set column A to 68 pixels and columns B:H to 95 pixels. If  any columns are too narrow to display all the data, apply AutoFit to the  column.

Merge and center the title across the range A1:H1, and then apply the  Title cell style. Merge and center the subtitle across the range A2:H2,  and then apply the Heading 1 cell style.

Select the seven column titles, apply Center formatting, and then apply the Heading 4 cell style.

By using the Quick Analysis tool, Sum the Quarter 1 sales, and then  copy the formula across for the remaining Quarters; the Quick Analysis  tool formats totals in bold.
Mac users: Instead of the Quick Analysis tool, use the AutoSum button, and then apply 
bold formatting to the results. 

Select the Northeast sales for the four quarters, and then display  the Quick Analysis gallery for Totals. Click the second Sum option—the  sixth item in the gallery—which displays the column selection in yellow.  Copy the formula down through cell F7; recall that the Quick Analysis  tool formats sums in bold.
Mac users: Instead of the Quick Analysis tool, use the AutoSum button, and then apply Bold formatting to the total.

Apply the Accounting Number Format to the first row of sales figures  and to the total row. Apply the Comma Style to the remaining sales  figures. Format the totals in row 7 with the Total cell style. Increase  the column widths as needed.

888

Insert a new row 6 with the row title Midwest and the following sales figures for each quarter: 110985.45 and 118674.91 and 100548.50 and 120621.17 Copy the formula in cell F5 down to cell F6 to sum the new row.

669

Using absolute cell references as necessary so that you can copy the  formula, in cell G4 construct a formula to calculate the Percent of  Total Sales for the first region. Copy the formula down for the  remaining regions.

101010

To the computed percentages, apply Percent Style with two decimal places, and then center the percentages.

6811

Insert Line sparklines in the range H4:H7 that compare the quarterly  data. Do not include the totals. Show the sparkline Markers and apply a  style to the sparklines using the second style in the second row.
 

Note, Mac users, select the first style in the second row.

5.6812

To compare the quarterly sales of each region visually, select the  range that represents the sales figures for the four quarters, including  the quarter names and each region—do not include any totals in the  range. With this data selected, by using the Recommended Charts command,  insert a Clustered Column chart with the regions as the category axis  and the Quarters as the legend.

Apply Chart Style 8. Change the colors by applying the third row of  colors under Colorful. Position the upper middle sizing handle of the  chart on the line between column D and column E and just below row 9.

Change the Chart Title to Regional Sales to Fitness Clubs

Deselect the chart. Change the page orientation to Landscape. Center  the worksheet horizontally on the page, and then insert a Footer with  the File Name in the left section.

Show the document properties. As the Tags, type fitness clubs, regional sales In the Subject box, type your course name and section number. Be sure your name displays as the Author.

Save and close the workbook, and then submit for grading

Need to be a lab kit to do it.

 Discuss why data structure is useful and important in programming.  Use your own examples to explain what an array is, and when to use the  array. You are welcome to discuss problems encountered in your  assignments while using arrays, and how you resolved them 

IT departments in organizations are often expected to define a company’s information security policy. Although much of the security that needs to be added into an organization may reside in IT, all of the departments are involved in implementing the policies.

Post the following to the discussion board:

Assess the authority structure in an organization that uses formal information systems by answering the following questions:

Which department in an organization do you believe should be responsible for the company’s information security, and why?

What are some advantages and disadvantages of your choice?

Compare the tools an information security manager has available to properly implement the necessary security within an organization?

1. Each student or student team of two will create a simple database from start to finish using the skills learned in the Database course. 
   Required Submissions: 
   Documentation (single document that includes: title page, table of contents, statement of work, ERD, business requirements and rules, a data dictionary, and any security rules that should be in effect for the database considering the database used to implement)
   Database (submit either access database or SQL script to create the database – must include sample data)

Executive Program Practical Connection Assignment – 100 points

Executive Program Practical Connection Assignment – 100 points

At UC, it is a priority that students are provided with strong educational programs and courses that allow them to be servant-leaders in their disciplines and communities, linking research with practice and knowledge with ethical decision-making. This assignment is a written assignment where students will demonstrate how this course research has connected and put into practice within their own career.

Assignment:
Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. 

 Requirements:

Provide a 500 word (or 2 pages double spaced) minimum reflection.

Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited.

· Share a personal connection that identifies specific knowledge and theories from this course.

· As this is a personal reflection, no citation from any reference will be accepted (Turnit percentage will be reflected in your grade as no reference at all should be included

· Include three main parts:

o In your own words, summarize the course content in the first third

o In your own words, summarize how is this relevant to your pass and current work/experience in the second third

o In the last third, summarize in your own words how will knowledge in this course, help you in enhancing your skills and profile.

Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment. 

You should NOT, provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.   You cannot submit a previous assignment that was written for another class.  This assignment will be checked by Safeassign for Plagiarism.

Assignment Content

1.     Overview
   The Appliance Warehouse case study is designed to practice systems analysis and design skills using a life-like scenario. Appliance Warehouse is facing a big business change: create a Service Department as one of their product offerings.

   They need you, the new systems analyst, to help them. You have been tasked to help develop a technological solution to help schedule service appointments and integrate it with existing systems. As a newly hired analyst, you report to Carlie Davis, the IT manager, who will guide you through the steps of this project.

   In the MindTap simulation environment, you will see email examples to your (simulated) Appliance Warehouse email inbox. These simulated emails will contain instructions for each session, and you will consult the Appliance Warehouse’s resource libraries and website for additional information.

   You will complete several weekly individual assignments based on this case study as well as the Signature Assignment: Case Study: Appliance Warehouse Services – Application Maintenance assignment in Week 5.

   For this week’s assignment, be sure to refer to the Appliance Warehouse Resources: Organizational Staffing Document, Appliance Warehouse website, Historical Analysis Phase Durations spreadsheet.

   Directions
   In MindTap, review the Appliance Warehouse Case, and do the following:

   • Read the Before You Begin Message and the Module 1-3 Appliance Warehouse Webmail Client Emails. Read the messages to help determine the tasks you must complete.
   • Review and analyze the weekly Appliance Warehouse case study content and resources.
   • Create a 2- to 3-page document (to submit in Blackboard) that includes the following:
   • An Organization Chart to support the Appliance Warehouse case study
   • The SWOT Analysis diagram you performed and created to support the Appliance Warehouse case study
   • The Mission Statement to support the Appliance Warehouse case study
   • The Problem/Opportunity Statement to support the Appliance Warehouse case study
   • Submit your document.

INTERNET OF THINGS (Topic)

Research paper 

At least five appropriate, properly cited sources . Your project (paper) will comprise 2500 to 3000 words (not including title and reference pages). Your project (paper) must be formatted according to APA guidelines as a Word document, double spaced, Times New Roman, 12-font, with one-inch margins.

Key Assignment

Part 1: Enterprise Content Management and Data Governance Policies and Procedures Manual ( 25–30 total pages)

In the last few weeks, you have prepared the foundation for the enterprise content management manual by writing the Project Outline and Content Requirements, Implementation Life Cycle, Information Infrastructure Evaluation, Information Infrastructure Improvements, and Data Governance Evaluation sections. The final step in developing the enterprise content management manual is to document the changes that are necessary to improve the governance in the areas of data quality, data management, data policies, business process management, and risk management. In addition, you will prepare an implementation plan for the ECM and data governance policies and procedures you have defined. You will also further refine the document to produce the final version for the project. Updates may be based on peer and instructor feedback.

The following are the project deliverables:

• Update the Enterprise Content Management and Data Governance Policies and Procedures Manual title page with a new date and project name.
• Update the previously completed sections based on instructor feedback.
• Data Governance Improvements
  • Data Quality
    • Document the changes that are necessary to improve the governance currently in place related to data quality in the organization.
  • Data Management
    • Document the changes that are necessary to improve the governance currently in place related to data management in the organization.
  • Data Policies Management
    • Document the changes that are necessary to improve the governance currently in place related to data policies in the organization.
  • Business Processes
    • Document the changes that are necessary to improve the governance currently in place related to business processes in the organization.
  • Risk Management
    • Document the changes that are necessary to improve the governance currently in place related to risk management in the organization.
• Implementation Plan
  • Define the team required for the implementation of the ECM and data governance policies and procedures.
  • Identify the key tasks required for implementation, including time and resource requirements.
  • Assign key tasks to implementation team members.
  • Develop a project timeline.
  • Establish key implementation milestones.

Complete the Enterprise Content Management and Data Governance Policies and Procedures Manual final version, by doing the following:

• Review the entire document for any changes and improvements you would like to make.
• Ensure that this final version of the document is sufficiently detailed to meet the requirements of the assignment.
• Any previous instructor feedback should be addressed with appropriate changes.
• Be sure to update your table of contents before submission.
• Name the document “yourname_IT621_IP5.docx.”

Worked Example

Please refer to the Worked Example below for an example of this assignment based on the Problem-Based Learning Scenario. The worked example is not intended to be a complete example of the assignment but will illustrate the basic concepts required for completion of the assignment and can be used as a general guideline for your own project. Your assignment submission should be more detailed and specific and should reflect your own approach to the assignment rather than just following the same outline provided in the worked example.

Note that the worked example includes material from previous worked examples. The new material will be found under the Week 5 sections of the Table of Contents.

The worked example is provided here to help with this assignment.

Part 2: Argumentation PowerPoint (5 slide, excluding Title and References slides)

Envision that you now have to present your solution to your client. You need to make a formal presentation to a group of stakeholders, and you need to be prepared to answer their questions. As a final step in the project, you will create a PowerPoint presentation in which you provide the following:

• In the Notes pages of each slide and based on the context of the information on that slide, provide a narrative of 2–3 paragraphs of your rationale for the data governance improvements that you are recommending.
• On each slide, identify the evidence that you have to support the argument(s).
• All sources used to support your argument and solution should be cited both in-text (on slide or in Notes section) and on a References slide in APA format.
• Name the document “yourname_IT621_IP5.pptx.”