Exp22_Word_AppCapstone_IntroAssessment – Research 1.1

Exp22_Word_AppCapstone_IntroAssessment – Research 1.1

  

Exp22_Word_AppCapstone_IntroAssessment – Research 1.1

Project Description:

As you near graduation from college, you plan to apply to various graduate schools. You have prepared a draft of a statement of purpose that you will include in an application packet to each university to which you apply. You modify the statement of purpose so that it is attractive and error free. In addition, you include such items as a table, picture, header, footer, and footnote, formatting text in columns where appropriate. Finally, you use mail merge to prepare personalized copies.

     

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

 

Apply the Slice document theme.   Select all text in the document and change the font to Bookman Old Style.   Change the font size to 12. Adjust the right and left margins to 1.5″.
 

  If the theme is not available, click or select Browse for Themes, and then   select the downloaded theme file Slice.thmx.

 

Insert a header (select Edit   Header) that includes a left-aligned page number. Close the header.

 

Insert a manual page break   before the second paragraph on the second page, beginning with On behalf of the faculty and staff.

 

Select all text that displays   before the newly inserted page break and double-space the selected text.   Remove any paragraph spacing from the selected text.

 

Move to the beginning of the   document and press ENTER. Remove the First line indent from the newly   inserted blank paragraph. At the new paragraph, type Statement of Purpose and apply bold formatting to the   title. Center the title.

 

In the second paragraph on the   first page, place the insertion point after the period at the end of the   sentence that ends with by the   University of Arizona. Insert a footnote that reads The Three Minute Thesis Competition is open to all   academic disciplines at the university. (include the period).

 

Modify the Footnote Text style,   changing the font to Bookman Old Style and the font size to 12.

 

Find all occurrences of the word   sophomore in   the document and change the word to student.

 

Insert a footer (select Edit   Footer) and type 2024 Fall in the footer space. Change the   footer font to Bookman Old Style and change the footer font size to 12. Close   the footer.

 

Select all text on pages 4 and 5   and format it in two columns. Insert a Continuous section break before the   words On behalf of the faculty and   staff at the top of the fourth page.

 

Click or position the insertion   point before the newly inserted section break at the top of the fourth page   and change the column setting to One. Type Welcome to   the College of Business and press ENTER twice. Select Welcome to   the College of Business and apply the Title style. Reduce the font size   to 22. Center the newsletter title.

 

Add a bottom border with a   weight of 1 1/2 to the text Welcome to   the College of Business.

 

Place the insertion point before   the words The College of Business at   the beginning of the second body paragraph on the fourth page. Insert the University.jpg picture, downloaded with this   project. Change the picture style to Reflected Rounded Rectangle. Resize the   picture height to 1″ and select Square text wrapping.

 

Place the insertion point after   the period ending the first paragraph on the second page (ending in upon graduation). Press ENTER. Remove   the First line indent. Insert a 2-column by 6-row table. Change the width of   the second column to 1″.

 

Type Course in the top left cell and press TAB. Type Grade in the next cell on the first   row. Press TAB. Complete the table as shown below:
 

  Course Grade
Int.   Microeconomics A
Int.   Macroeconomics  B
Public   Finance B
Business   Calculus A
Contemporary   Economics A

 

Insert a row above the first row in the table. Merge all cells in row   1 and type Major Courses   Completed in row 1. Apply Align Center   alignment to row 1. Apply a table style of Grid Table 4 – Accent 6 (row 4,   column 7 under Grid Tables). Center the table horizontally.

 

Add a caption below the table.   The caption should read Table 1: Major Courses Completed at the University of Arizona. (Do not include the period.) Center the caption.

 

Create a custom watermark to   display at a diagonal, with the text Copy in Blue (column 8 in Standard colors). 

 

Check spelling and grammar in   the document. Correct the misspelling of analyzed   and the hyphenation of first-time.   If the check does not suggest a change for   first time, manually correct it in the second to last paragraph in the   left column on page 5, changing first   time to first-time. Ignore all   other grammatical and clarity concerns.

 

Replace the dash dividing the   words organization and Fortune 500 in the first paragraph on   the fourth page with an Em Dash symbol. In the same paragraph, replace the   dash following the word restaurants   with an Em Dash symbol.

 

Select the paragraph beginning   with I hope you will accept the   challenge on the last page (including the paragraph mark). Apply shading   of Red, Accent 6, Lighter 60% (last column, third row under Theme Colors) to   the selected paragraph.

 

Click or select the References   tab and ensure that the writing style is MLA. Place the insertion point after   the words 600 graduate students and before the ending   punctuation mark at the end of the first sentence in the right column on page   4. Insert a citation to a new source, selecting Report as the type of source.   Complete the entry as follows:
  Corporate Author: University of Arizona
  Title: State   of the University
  Publisher: University Press
  City: Peoria
  Year: 2024

 

Begin a mail merge based on   Letters, selecting recipients from an existing list—Graduate_Schools.xlsx, using Sheet1$. Filter to select only those   universities with an Area equal to W.

 

Replace [University Name] in the first paragraph on the third page with   the merge field of University. Be   sure to include the brackets with text to be replaced. Ensure that a space   precedes and follows the newly inserted University placeholder. Preview the   results and then finish the merge, choosing to edit individual documents and   merging all records.

 

Select the entire 10-page merged   document and copy it. Switch to Exp22_Word_AppCapstone_IntroAssessment_Research,   move the insertion point to the end of the document, and insert a manual page   break. At the top of the new page, paste the copied text. The original   document to which you pasted the merged data now contains 15 pages. Save Exp22_Word_AppCapstone_IntroAssessment_Research   and close all open documents without saving.

 

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

Activity 7- Project Risk & Quality

#1. What is Six Sigma – what does it mean mathematically? What tools, techniques, and methods would you traditionally use in a Six Sigma facilitation? What do you envision as the roles and responsibilities for a Six Sigma centered project? Provide 8 Six Sigma tools and explain what they are used for.Requirements:

  • There is no minimum or maximum required number of pages. Your response will be considered complete, if it addresses each of the components outlined above.
  • Use of proper APA formatting and citations – If supporting evidence from outside resources is used those must be properly cited. A minimum of 7 sources (excluding the course textbook) from scholarly articles or business periodicals is required.
  • Include your best critical thinking and analysis to arrive at your justification.

Text

Title: Managing Project Risks ISBN: 9781119489733 Authors: Peter J. Edwards, Paulo Vaz Serra, Michael Edwards Publisher: John Wiley & Sons Publication Date: 2019-08-13

Objectives

  

I. Objectives:

  • Practicing      with Binary Search (Chapter 16) and Sorting Algorithms (Chapter 16 and      Chapter 8)
  • Practicing      writing a small-to-medium size program that is modularized (using      functions) and deals with lists

II. Instructions:

You job is to write a menu-based program to manipulate a patient database in a hospital. I do not provide any skeleton code for this assignment. You will have to design all the data structures and program structure yourself. The designing of your program will be a big part of your grade in this assignment.

1. Your program should do the following

(a)    Show the user a menu that has the following options.

1. Print patients

    2. Add a patient

    3. Sort patients by last name

    4. Sort patients by ID

5. Search patient by last name

    6. Search patient by ID

    7. Exit the program

(b)  Allow the user to select an option from the menu, perform the requested option, show the user the results, and finally show menu to the user again to let picking another option.

2.  Design-Needs of your program

(a)  Your program should create a struct or class called patientType to hold information about a single patient: first name (string), last name (string), patient ID (int).

(b) You also need to define an array to hold the list of patients. Each element of the array will of type struct or class patientType that you created in step 2(a) above. You can create a static array (like in Chapter 8) with a max size = 10.  

(c)  Your program must be a modular one: That is, printing of the menu (in step 1a above) on the screen as well as each operation in the menu should have a corresponding function. Then, the main function of your program should be mostly composed of function calls. That is, your main function should be a short function that mainly calls other functions!

(d) Sorting: For options 3 and 4 in the menu (that is sorting the patient list by last name or ID), you have to use and adapt one of the sorting algorithms in the text book: Bubble Sort (Chapter 16 , page 1019), Insertion Sort (Chapter 16, pg 1024) or Selection Sort (Chapter 8, pg 533).

(e) Searching: For option 5 and 6 (searching the patients by last name or ID), you have to use the binary search algorithm and adapt it to your program (Chapter 16, pg 1026).

3.  Other Important Notes

(a)  The outputs of your program should be nicely formatted. You should provide the user enough explanations to use your program comfortably.

1. If your program handles the patient list (in step 2b) and all the corresponding operations (step 2c) using a vector (Chapter 16) of struct or class patientType, you will get up to +20 points.

2. If your menu also has a working delete option as well, you will get up to a total of +10 points. You can delete a patient using last name or ID. Handling each will be an extra +5 point.

         3.      We studied Bubble Sort in detail in class, you are responsible to study Selection and Insertion Sort on your own for the exam. For this assignment, if you complete part 2d above (that is both the sorting  options in the menu) either using Selection Sort (Chapter 8, pg 533) or Insertion Sort (Chapter 16, pg 1024) you will get an extra +5 points.  

III. What to Submit:

1.      Your assign4-yourName.cpp file for the program.

2.      You also have to submit a README file named README-yourName.txt. Your README should include the following

a.       Explain what works what does not work in your program – If your program has extra features, you can mention it too.

b.      Include several test cases that you used to test the correctness of your code.

You can upload your files to this Angel drop box as a single .zip file or one by one  (note that you should do one submission but you can attach multiple .cpp files to your submission!).

IV. Grading:

100 pts in total. See the Assignment rubric on how your assignment will be evaluated.

1.     90% – Your .cpp file, its content, and programs execution

2.     10% – The README file and its content

3.     Extra Credit: Up to 32 points of extra credit for additional features (that is use of vector’s in the program and adding delete option).

Paper

  

Research Paper: Securing Data

Overview

IT infrastructure of an enterprise has: 

a) Database servers, storage systems (SAN & NAS) for data storage

b) Computers, applications to process the data

c) Network components to enable connectivity among computers and servers

In this research, your goal is to secure the data processed by these IT components. 

Prepare

· Review the APA Citation Style guide if necessary. You can also consult the Learning Commons for writing support and library resources.

· Carefully review the Chapter 8, Chapter 11, and Chapter 12 of the textbook. The textbook is your primary source of information. 

Research

· Research and analyze potential vulnerabilities and security challenges that are associated with these IT components and that eventually threatens confidentiality, integrity, and availability of data. Consider both the technical and non-technical vulnerabilities.

· Research and analyze various security countermeasures and solutions to secure data. Think about countermeasures in policy, human, database, application, computer, storage, server, network, data, object, and application dimensions.

Write

Prepare a two to three-page APA formatted research paper. Your paper should be well-organized in terms of matching each stated vulnerability with at least one countermeasure. Real-world examples are a plus.

Cite

APA citation and referencing is required for this assignment. You must use in-text citations and a reference list to accurately cite the sources of information that you use to write your assignment. 

Failure to use proper citations and references will be considered plagiarism. If you need further information about APA style and format, see the APA Citation Style guide. The Purdue OWL is another useful source of APA help.

Submit

1. Turnitin will automatically and transparently check your submission after you submit it. Turnitin is integrated into Canvas; therefore, you don’t need to sign up for Turnitin. After Turnitin completed processing your submission, you will be able to see your similarity result on Canvas.

2. Review your Submission Details and access your Turnitin report. Revise your work as needed based on the feedback. 

3. By the due date indicated, re-submit the final version of your work.

BEFORE submitting your assignment for final grading, ensure that you have completed ALL of the steps above.

Turn in word document, including SQL

  

(Turn in word document, including SQL commands and Screen shots from mySQL)

Write SQL queries for the books database  that perform each ofthe following tasks:

a) Select all authors from the Authors table with the columns in the order lastName,

firstName and authorID.

b) Select a specific author and list all books for that author. Include the title, year and

ISBN number. Order the information alphabetically by title.

c) Add a new author to the Authors table.

d) Add a new title for an author (remember that the book must have an entry in the

AuthorISBN table).

Some suggestions on installing Apache and setting up database file in mySQL are attached.

Survey Instrument

One of the ways in which usability professionals collect data, and for that matter academic professionals, is the use of a Survey Instrument

Create a paper-based survey instrument evaluating the Amazon Website. 

In the assignment, you are expected to include: 

1. Participant Demographic Data (Name, Age, Gender, Location, Education etc.) 

2. Participation Consent

3. 8 – 10 Measurable Quantitative Questions (Using a scale to support measurement, i.e., Likert)

4. 2 – 4 Qualitative Questions 

This survey is a PAPER PROTOTYPE not to be completed using a survey instrument such as Survey Monkey.

WRITING

 

Writing Assignment:

From the Technical Communication textbook, under “Projects” (p. 14) at the end of Chapter 1, Item #1 under the ‘General’ category: “Write a memo to your boss, justifying reimbursement for this course. Explain how the course will help you become more effective on the job. (See Chapter 15 for memo elements and format.)”

In addition, request reimbursement for all the courses in the BS-CSIA Program, up to whatever dollar limit might be set by your employer (if there is such a limit). Be sure to provide a brief summary of each of the courses and how completion of the overall program will make you a better asset for the company.

If you are not currently employed (or in the military), or you do not want to use your real employer as the target audience, just write the assignment using a fictitious, medium-sized company where they have you and a few other cybersecurity staff and you are addressing the memo to the InfoSec supervisor/manager.

Strictly for identification purposes of this assignment, use the following information in the heading of the memo:

  • From – Your Name
  • To – Professor _________ (don’t write the memo ‘to’ the professor, your audience is your boss)
  • Date – Use the date of the assignment
  • Subject – Enter something appropriate for the topic
  • REF: – “CYB320 Week One Writing Assignment”

Other criteria:

  • Margins all 1 inch
  • Use 12pt font size only
  • Use a standard font style (e.g., Times Roman, Arial, Calibri)
  • Use 1.5 line spacing
  • Written memo should be 1.5 to 2 pages (no more than 2 pages)
  • CYB320 Week 1 Writing Assignment – Grading Rubric – PDF Document (138 KB)

Computer Program Design

 

I want you to create something based on what you’ve learned so far in this course

Visit https://corallanguage.org/simulator/ and write a program using:

variables

branches

loops

arrays

functions

Come up with your own program that contains your own user-defined functions and variables. Be creative. No need to be too complicated but be a useful program with a function and array.