All posts must be a minimum of 250 words. APA reference. 100% original work. no plagiarism.
A number of web based firms offer what they describe as a free online security check of your PC or network. Some require download of executable software for the check. Would you trust such an offer? Why or why not?
Several firms offer fee based professional network security evaluation. Locate the web page for one such firm and briefly describe some of the services offered.
Directions: Students will watch a Customer Service video and then answer questions:
Questions:
1) Professionalism – How could Lee have been more helpful to the customer, Karen Tom?
2) Communication – What did the supervisor, Christine, do to calm the customer?
3) Critical Thinking – What might SunTel do company-wide to create a better customer service experience?
Attached is the question doc and reading recommendation
1) What is the purpose of a database and what benefits are there to using them?
2) What is normalization and how does it affect database design?
Exp19_Word_Ch01_ML1 – Water 1.2
Word Chapter 1 Mid-Level 1 – Water
Exp19 Word Ch01 ML1 Water 1.2
Your student organization has adopted the cause of supplying clean drinking water to developing nations as a fundraising effort. You design an informational handout, formatting a draft document so that it is attractive and informative.
Start Word. Download and open the file named Exp19_Word_Ch01_ML1_Water.docx. Grader has automatically added your last name to the beginning of the filename.
Change the orientation to Portrait. Display nonprinting characters. Delete the first two lines (Water for Life and Changing Lives Daily).
Change margins to Moderate. Insert a page break at the beginning of the document.
At the beginning of the document, insert text from Title.docx.
Insert a footer containing a page number. The page number should be placed at the Current Position and as a Plain Number. Ensure that the footer does not show on the first page. Close the footer.
Note, Mac users, insert the default page number in the footer, aligned to the left.
Insert the word adversely between the word that and the word affect in the first line of the second page. Ensure that a space precedes and follows the inserted word. Replace the words As long as in the second paragraph on the second page with the word When.
Use the thesaurus to replace the word reliable in the third paragraph on the second page with a synonym beginning with the letter d.
Add Flyer for Water for Life in the Comments box in Document Properties.
Insert a header. Type Subject: and press SPACEBAR. Include the contents of the Comments section in Document Properties. Use the Quick Parts command on the Header & Footer Tools Design tab to include the information. Close the header.
Note, Mac users, use the Field button to add the Comments to the header.
Check spelling and correct any errors that are identified.
Check for accessibility, correcting for any alerts that are shown.
Save and close Exp19_Word_Ch01_ML1_Water.docx. Exit Word. Submit the file as directed.
Exp22_Excel_Ch12_HOE – Invoice 1.0
Exp22 Excel Ch12 HOE Invoice 1.0
Excel Chapter 12 Hands-On Exercise – Invoice
Recently, you took a position as the senior account manager at Wilhelmina’s Total Lawn Care (WTLC), a lawn care company located in Leland, Michigan. WTLC specializes in full service lawn care ranging from landscaping to weekly maintenance. The previous manager used a paper-based system to prepare expense reports, invoices, and payroll statements. However, this was a time-consuming process and required manual recalculation when any values changed. You want to start automating tasks using your extensive experience with Excel. You decide to start with the client invoice report form. Because each of the company’s billing representatives utilizes the same procedures, you will adapt an Excel template to use as a model for creating invoices. The template needs to be generic enough to accommodate a range of options, but it also needs to maintain a standard design to facilitate easy data entry. You will download an existing Excel invoice template, customize the template for your business needs, and inspect the worksheet for accessibility. Finally, you will create macros to perform a series of tasks, such as clearing the values to reset the form and finalizing the invoice for management approval.
Start Excel. Download and open the file named Exp22_Excel_Ch12_HOE_Invoice.xlsx. Grader has automatically added your last name to the beginning of the filename.
The Invoice template provides the basic design you need, but you want to add your company’s contact information. You also want to delete the sample data and remove the developer’s data validation comments.
Make the following edits to the template:
Type Wilhelmina’s Total Lawn Care in cell B2
Type Every Lawn Needs TLC in cell B3
Type Lot Area in cell C5
Type 1234 Caesar Parkway, Leland, MI 49654 in cell B27
Apply Italics format to cell B3
Delete the values in the range D6:D10
Continue editing the template by making the following structural changes.
Insert a row before row 1
Insert a column before column A
Set the column width of column A to 2
Add an outside border to the range B2:F29
Clear all data validation that was included in the original template
Rename the worksheet Customer Invoice
Prior to distributing your template, you want to remove all personal information. You will use the Document Inspector to complete the task.
Use the Document Inspector to remove all Document Properties and Personal Information.
Mac users, on the Excel menu, click Preferences and then click the Security icon. In the Security dialog box, click Remove personal information from this file on save.
The invoice will be sent electronically, and you want to make sure the Invoice template does not contain content that might cause difficulties for users. To ensure this document is compliant with accessibility standards, you will check accessibility.
Use the Accessibility Checker to check the template for issues. Once completed, make the following changes to improve the template’s accessibility.
Unmerge the following ranges C27:D27, C28:D28, C4:C5, C2:F2, D12:E12, D13:E13, D6:E6.
Set the text in cell C2 to left alignment.
Type Due on: in cell D13.
You know that some of remote staff members are using Excel 2010. You want to make sure the workbook does not have critical features that might not display when opened with the older version of the software.
Use the Compatibility Checker to check the template for compatibility with Excel 2010-2016 versions.
Mac users, on the Tools menu (or the Review tab), click Check Accessibility.
You want to add notes to the template to provide instruction to your staff. To do this you will annotate the worksheet using comments.
Clear the contents of cell C13. Then add the following comments to the template.
Cell C13 – Enter Business or Residential
Cell E3 – Insert Date
Cell E6 – Use the custom area function to calculate lot area
Cell E13 – Business jobs are due in 30 days, all others due upon receipt
After inserting comments, you decide you will automate the insertion of the date in a later step. Therefore, you will remove the comment from cell E3. You also want to edit the comment in cell E13 to make a small grammatical change.
Delete the comment in cell E3.
Edit the comment in cell E13 to reflect the following changes Business jobs are due in 30 days. All others due upon receipt
For your last step, you want to hide the comments to reduce screen clutter. Once the comments are hidden, the comment indicators will still be visible.
Hide all comments in the template.
You do not want to assume the level of Excel expertise throughout your company; therefore, you want to craft a macro that will automate as much as possible. The macro you will create automatically clears existing values in the workbook. Although the template is empty to start, users might open the template, save a workbook, and then want to use that workbook to prepare more invoices. Therefore, you want the macro to clear cells even though the original template has no values. Once completed, save the workbook as a macro enabled template.
Record a macro named ClearInvoice. Add the description: This macro clears existing values in the current invoice. when creating the macro. When run, the macro should do the following:
Delete the values in the cells E6, C13, E13, and the ranges C7:C11 and C15:E25. After deleting the values, the macro should enter the following default values.
C7 = Name
C8 = Company Name
C9 = Street Address
C10 = City, ST Zip Code
C11 = Phone
You want to make sure the ClearInvoice macro does what you want it to do. You will add some sample data and run the macro.
Enter the following sample values, then run the ClearInvoice macro.
C8 = John Doe Inc.
C9 = 123 Sample Street
C10 = Leland, MI 49654
C11 = (231) 555-5555
Your sales reps may not be Excel experts and not know how to run a macro. To make it easier to clear values from the form, you want to assign the ClearInvoice macro to a button. The users can click the button to clear the form to use it for another customer. You will also add a button to be utilized later in the project.
Insert a Button (Form Control) in the range H2:J2. Edit the button label to display the text Clear Form and assign the ClearInvoice macro. Next insert a Button (Form Control) spanning the range H4:J5. Edit the button text to display the text Insert Date.
Type Customer Name in cell C7 and then click the Clear Form button to run the macro.
In order to use VBA to automatically insert and format the date, you will first create a new module. You will then use the range object to insert the current date and adjust the font property to bold the current date.
Create a new module in the VBA Editor named DateStamp. Enter the following code to create the desired sub procedure.
Sub DateStamp ()
‘Unprotect worksheet for editing
Worksheets(“Customer Invoice”).Unprotect Password:=”Expl0r!ng”
‘Insert current date in cell E3
Range(“E3”)=Date
‘Adds bold format to cell E3
Range(“E3”).Font.Bold=True
‘Protects worksheet using the password Expl0r!ng
Worksheets(“Customer Invoice”).Protect Password:=”Expl0r!ng”
End Sub
After entering the code exit the VBA Editor and run the macro to test your work.
After running the sub procedure, you decide that the inserted date should be italic instead of bold. You will make this change in the VBA Editor by changing the Italic property. You will also add a statement to the ClearInvoice Macro to unprotect the worksheet when clearing its data.
Open the DateStamp module in the VBA Editor. Locate the code Range(“E3”).Font.Bold=True and replace the word Bold with italic.
Next open Module 1. Press enter twice at the end of the first line (Ln1, Col9) and type the following code.
‘Unprotect worksheet for editing.
Worksheets(“Customer Invoice”).Unprotect password:=”Expl0r!ng”
After entering the code save and exit the VBA Editor. Next assign the DateStamp macro to form control button 2.
You decide to create a custom function to enable users to manually calculate the area of a yard being serviced.
Open the VBA Editor and create a new module named CustomFunction then enter the following code:
FunctionArea(Length,Width)
‘This function will calculate the area of the lawn being serviced
Area = Length * Width
End Function
Save and exit the VBA Editor. Type =area(20,45) in cell E6 to test your work.
Insert a new worksheet named Code.
Open the VBA Editor, open the ClearInvoice module, and copy the code. Paste the code in the Code worksheet starting in cell A1 then remove any rows containing blank cells. When complete, the code block should appear continuous with no blank cells between lines.
Open the DateStamp module, and copy the code. Paste the code in the Code worksheet starting in cell A31 then remove any rows containing blank cells. When complete, the code block should appear continuous with no blank cells between lines.
Open the Function module, and copy the code. Paste the code in the Code worksheet starting in cell A44 then remove any rows containing blank cells. When complete, the code block should appear continuous with no blank cells between lines.
Close EXP22_Excel_Ch12_HOE_Invoice.xlsx. Be sure to save the copy as a .xlsx file, not a macro-enabled workbook. Exit Excel. Submit the .xlsx file as directed.
Personal Information ProgramDevelop a program, in which you’ll design a class that holds the following personal data: name, address, age, and phone number. As part of the program, you’ll then create appropriate accessor and mutator methods. Also, set up three instances of the class. One instance should hold your information, and the other two should hold your friends’ or family members’ information.Input:
NOTE: The input data do not need to be real data; they need to be entered at the keyboard, when program is run.Processing: Develop the following:
Output:Set up a loop and display data within each object:
==================================================================================NOTE: A sample program run is attached below. It illustrates user’s interactions with the program: Extra-Credit Lab – Sample Program Run.pdf Extra-Credit Lab – Sample Program Run.pdf – Alternative Formats==================================================================================You need to set up a Python solution that is complete and workable.
For your solution to be complete, you must
For your solution to be workable,
========================================================================Grading rubric:
In the following project, you will format a newsletter by inserting pictures and screenshots, applying two-column formatting, and adding a border to a paragraph. You will edit and format a research paper by inserting footnotes, creating citations, and formatting a bibliography. You will also create mailing labels.
#Start Word. Download and open the file named Student_Word_3G_Environmental_Newsletter_and_Research_Paper.docx.
#On Page 1, click at the beginning of the newsletter title. From the files downloaded with this project, insert the picture w03G_Recycle.jpg.
#Set the Height of the picture to 0.4 inches, and then change the Text Wrapping to Square. Change the Horizontal Alignment to Left relative to Margin and the Vertical Alignment to Top relative to Margin.
#Starting with the paragraph Research on Environmental Economics, select all of the text from that point to the end of the first page—do not include the Page Break in your selection (select only to the end of MEEC). Format the text in two columns, and then apply Justify alignment. Insert a Column break before the paragraph The Hard Costs of Pollution. Save your file.
#Start your internet browser and navigate https://ehp.niehs.nih.gov Redisplay your document, and then click at the end of the paragraph that begins Research topics include. Insert a Screen Clipping of the website—do not include the address bar or the taskbar. To the inserted screenshot, apply a Black, Text 1 Picture Border and change the Weight to 1 pt.
#Select the subheading Research on Environmental Economics. Use the Font dialog box to apply Small Caps. Display the Font color gallery, and in the fourth column, click the first color. Apply the same formatting to the subheadings The Hard Costs of Pollution and Environmental Economics Conference.
#Select the last two paragraphs in the newsletter, which begin For more information, and end with MEEC, and then from the Borders and Shading dialog box, apply a 1 pt Shadow border using Black, Text 1. From the Shading tab, display the Fill color gallery, and then in the fourth column, click the second color. Center the two paragraphs of text.
#On Page 2, change the line spacing for all of the text on the page to 2.0. For the same text, change the spacing after to 0 pt.
#On Page 2, apply a first line indent of 0.5 inches to the paragraph that begins Environmental economics is.
#In the paragraph that begins Environmental economics also studies, in the second line, immediately following the comma after Kyoto Protocol, insert the footnote The Kyoto Protocol is an international agreement that aims to reduce carbon dioxide emissions. Be sure to type the period at the end of the footnote.
#Modify the Footnote Text style to set the Font Size to 11 and the format of the Footnote Text paragraph to include a first line indent of 0.5” and double spacing.
#On Page 2, at the end of the paragraph that begins Environmental economists have, click to the left of the period, and then using MLA format, insert a citation for an article in a periodical with the following information:
Author: Abboud, Leila S.
Title: Economist Strikes Gold
Periodical Title: The Wall Street Journal
Year: 2008
Month: March
Day: 13
Pages: A1
Medium: Print
Edit the Abboud citation to include A1 as the page number.
#On Page 4 of the research paper, click to place your insertion point in the blank paragraph. On the References tab, click Bibliography, and then at the bottom of the list, click Works Cited. Select the paragraph Works Cited. Change the font to Calibri, change the font size to 11, and change the font color to Black, Text 1. With the text still selected, center the paragraph, and then from the Paragraph dialog box, change the Spacing Before to 0 pt, if necessary change the Spacing After to 0 pt, and set the Line spacing to Double. Move to the top of the document.
Save and close the file, and then submit for grading.
In this assignment, you will design a program to perform the following task:
Write a program, using functions, that calculates the area and perimeter of a rectangle whose dimensions (Length and width) are provided by a user.
Before attempting this exercise, be sure you have completed all of chapter 8 and course module readings, participated in the weekly conferences, and thoroughly understand the examples throughout the chapter. There are 3 main components of your submission including the problem analysis, program design and documentation, and sample test data.
1. Provide your analysis for the following problem statement: You need to write a program that calculates the area and perimeter of a rectangle whose dimensions (Length and width) are provided by a user.
Your analysis should be clearly written and demonstrate your thought process and steps used to analyze the problem. Be sure to include what is the required output? What is the necessary input and how you will obtain the required output from the given input? Also, include your variable names and definitions. Be sure to describe any necessary formulas and sample calculations.
2. Provide your program design for the problem you analyzed for calculating and displaying the area and perimeter of a rectangle. Always work for modular design where possible. Be sure to use separate functions for calculating the area and perimeter of the rectangle. Other subprograms for Input and Output should be included as needed. Be sure to describe the fundamental tasks (i.e., things your program must do) needed to solve the problem so you can use a modular design. Provide pseudocode of your overall design that includes the Main module and the order of the module calls, and a Hierarchy chart for the program (see figure 3.8 page 148). Finally, display the flow charts (using Raptor, or your favorite graphics editor) for each module. (See figure 5.3 page 225 as an example.)
Include header and step comments in your pseudocode, using a similar approach as the example provided in section 2.3 (textbook page 86). See example 2.8 on pages 87-88).
3. Prepare at least 3 sets of input data (Test data) along with expected output for testing your program. Your test data can be presented in the form of a table as was shown in Assignment 1.
PLEASE PUT THE ANSWERS IN THIS FORMAT
Problem definition: Write a program, using functions, that calculates the area and perimeter of a rectangle whose dimensions (Length and width) are provided by a user.
A. Problem Analysis – Following the directions in the assignment, clearly write up your problem analysis in this section.
B. Program Design – Following the directions in the assignment, clearly write up your problem design in this section and comment your pseudocode.
C. Program Comments and Test Data – Following the directions in the assignment, include your test data and expected results in this section.
