#Exp19_Word_Ch02_HOEAssessment Maintenance

#Exp19 Word Ch02 HOEAssessment Maintenance

Word Chapter 2 Hands-On Exercise Assessment – Maintenance 

Project Description:

As an intern in your school’s maintenance department, you have been asked to prepare a communication that specifies the schedule of several services and reminders for staff and faculty during the upcoming break. The department’s supervisor has provided details for you to include in your document. The document will be posted to the school’s intranet as well in different areas on campus, so you’ll need to make sure it looks professional.

1

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

0

2

Change   the document theme to Organic, theme colors to Blue, and theme fonts to   Office. Apply the Lines (Simple) style set.

Note, Mac   users, apply Simple style set.

1.2

3

Select the first paragraph in the document, Winter Break:, bold it, change the   font color to Blue, Accent 1, Darker 50% (sixth row, fifth column), and font   size to 44.

Create a new paragraph style named Reminder   Title based on the Title style, which is applied to the first   paragraph.

1.4

4

Format the second paragraph Maintenance Reminders as bold and   small caps.

0.8

5

Select the paragraph Note to supervisors: Please post a hard copy of this reminder on the   bulletin board in the coffee room. and highlight it in yellow.

0.6

6

Select   most of the document beginning with the HVAC   Schedule paragraph and ending with the [email protected] email link, and apply the following formats:

a) a line spacing of 1.15

b) paragraphs as Justify

c) paragraph spacing after of 6 pt, and

d) a first line indent.

1.6

7

Select   the paragraph below the heading HVAC   Schedule and set a right and left indent of 0.5”. Center the text. Apply   6 pt paragraph spacing before the paragraph. Apply a top and bottom double   paragraph border of ½ pt in Blue, Accent 1, Darker 25%, and set the shading   to Blue, Accent 1, Lighter 60%.

1.8

8

Apply Heading 1 to HVAC Schedule and Reminders.   Change the paragraph spacing before for Heading 1 to 6 pt.

1.2

9

Apply Heading 2 to Dorms, Academic Buildings, Administrative   Buildings, General Tasks, Break Areas, and Office Spaces and Other Areas.

1.2

10

Select the five paragraphs under the General Tasks heading,   starting with Set thermostats and   ending with Turn off lights, and apply the default numbered-list   format (1., 2., 3.). Decrease the indent so the bullets begin at the left   margin.

1.2

11

Select   the four paragraphs under the Break   Areas heading, starting with Empty   refrigerators

and ending with in the middle shelf of the refrigerator, apply a checkmark   bullet, with a font

1.8

Step

Instructions

Points Possible

color of Blue, Accent 1, Darker 25%.   Decrease the indent so the bullets begin at the left margin. Create a new   style named Bullet   Paragraph based on this new format.

Apply the   Bullet Paragraph style to the three paragraphs in the Office Spaces and Other Areas

section,   starting with Unplug chargers and   ending with products from the area.

12

Insert   a page break (not a section break) immediately before the Reminders heading. Select all text   starting from the General Tasks heading   to the last bullet Remove any cardboard   boxes or flammable products from the area and format the selected text   into two columns with a line in-between.

1.6

13

Display the document in   Outline view. Collapse all paragraphs so only Heading 1 or Heading 2 display. Move the General Tasks section   to below the Break Areas section.   Close Outline view. Insert a column break so that General Tasks appears   at the top of the right column.

0.8

14

Insert the Digital.jpg image file at the bottom of the document next to the If you have any questions paragraph.   Size the picture with a width of 2″. Apply a Top and Bottom text   wrapping and a picture style of Rounded Diagonal Corner, White (third row,   fourth column). Remove the Background. Position the picture so that it is   above the If you have any questions paragraph.

1.6

15

Format the paragraph Maintenance Department as a WordArt object using the Fill: Blue,   Accent color 1; Shadow (first row, second column) style. Change the font size   of the WordArt object to 24.

Change the wrapping style of the WordArt object to   Top and Bottom. Format the WordArt object with Shape Style Subtle Effect –   Blue, Accent 1 (second row, fourth column). Visually position the WordArt   object in the center.

1.6

16

Scroll   to the end of the document. Draw a text box, with a height of 1” and a width   of 3”, and apply the Shape style Light 1 Outline, Colored Fill – Blue, Accent   1 (third row, second column) to   the text box. Select the three paragraphs consisting of the tel number, website url, and email address,   and cut and paste them into the text box. Apply a Top and Bottom wrapping, and remove the hyperlinks for the website and the email address. Visually position the text box in the center.

1.6

17

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

0

Total Points

20

Discuss:

• Different perspectives on number (6,7,8 or less or more) of hats
• Your perspective on the ideal number of hats for a data visualization project
• Your perspective on the realistic number of people used to fill “hats” for a data visualization project in real working environment. 

Use this link: https://www.visualisingdata.com/2012/06/talk-slides-the-8-hats-of-data-visualisation/

Read chapter 6 and use Visual logic tutorial for help. 

• Procedure in Visual Logic YouTube Video 

1. In your own words, describe a procedure used in programming. Why is it important to use procedures?

Private individuals and businesses use information all the time and have different information security needs.

Respond to the following in a minimum of 175 words:

• Discuss some examples of how an individual’s or business’s fundamental need for privacy, confidentiality, integrity, and/or availability might infer an IT professional’s work in ensuring infrastructure security.

Influence of Computer Networking- PowerPoint slides- 20 slides

refer to the attached document.

Term Project – week 8 – (17%):

You were just hired by an airline industry to create a database to record the various airlines and the pilots that work for them
Discussions with the industry representatives focused on two initial entities, Airlines and Pilots; the following key points were agreed:
1. Each pilot is assigned a unique PilotID.
2. Each AirlineID is unique
3. Each pilot may work for one airline, each airline can have many pilots.
4. FName, LName, JobTitle and Salary describe each pilot (with the obvious meaning)
5. AirlineID, NPlanes, NRoutes, NPilots describe each airline (NPlanes number of planes, NRoutes number of routes, NPilots number of pilots)
6. No fields beyond those in the report are needed.

The objective of this exercise is to demonstrate an understanding of some basic concepts covered in the course. The exercise is a straight forward application of those concepts – there are no “hidden” complexities – should you identify something in the key points or data that adds complexity, contact the instructor before submission – you may be over thinking the exercise.

The sample data may not represent all possible values of each field – consider each field’s domain during the design.

The objective is to replace the following report with a relational database. The submission will consist of a word compatible document to record the design process, and an Access DB.

Here is the relational schema (table notation) for the above report / table:
PilotAirlines (PilotID, FName, LName, JobTitle, Salary, AirlineID, NPLanes, NRoutes, NPilots)

The functional dependencies are:
PilotID – – > FName, LName, JobTitle, Salary, AirlineID, NPLanes, NRoutes, NPilots
PilotID – – > FName, LName, JobTitle, Salary, AirlineID
AirlineID – – > NPLanes, NRoutes, NPilots

The specific tasks are listed below, the percentage in parenthesis corresponds to the grade weight for each task.
Name your document Last Name_TermProject (i.e. Smith_TermProject). When you are asked to provide an explanation or description, include enough content to demonstrate that you understand the definition, term, concept, etc. and how it applies to this exercise.

SUGGESTION: Review the Terms and Concepts Discussion, especially the One-to-Many Normalization Process: Parts and Suppliers example. There is also a normalization MP4 file that can be downloaded from the Resources section.

Incorporate the following outline in your submission – include the section numbers – not the questions or other content from the instructions.

1) Review the existing report, functional dependencies provided and the sample data (as well as field domains and common knowledge) and document any assumptions you feel are appropriate (beyond those in the key points) and identify initial entities (person, place, thing). (10%)

2 Define functional dependency, and explain one row of the functional dependencies provided above in plain English (use field names). (15%) (you do not need to explain partial or transitive dependency)

3) Based on multiplicity – explain the relationship between the initial Entities in plain English – (either one-to-many, or many-to-many). (15%)

4) Design: specify all tables and fields at each normal form level
a) First Normal Forum (1NF) assessment / action – if needed 10%
Copy the 1NF definition from the text (include quotes and page number)
Assess the UNF table provided and if necessary, make the changes needed to conform to the 1NF definition. Document the resulting 1NF table(s) using relational schema notation or spreadsheet format (see the above example or page 111 Figure 4.2.6 of the text).
Explain how each table(s) meets the 1NF definition (use field names)
b) Second Normal Form (2NF) assessment / action – if needed 10%
Copy the 2NF definition from the text (include quotes and page number)
Assess the 1NF table(s) in the previous section and if necessary, make the changes needed to conform to the 2NF definition. Document the resulting 2NF table(s) using relational schema notation or spreadsheet format.
Explain how each table meets the 2NF definition (use field names)
c) Third Normal Form (3NF) assessment / action if needed 10%
Copy the 3NF definition from the text (include quotes and page number)
Assess the 2NF table(s) in the previous section and if necessary, make the changes needed to conform to the 3NF definition. Document the resulting 3NF table(s) using relational schema notation or spreadsheet format.
Explain how each table meets the 3NF definition (use field names)

5) Use the 3NF tables in your design, to create an new MS Access database, load the sample data provided,
Name your database Last Name_TermProject (i.e. Smith_TermProject). (5%).

6) Create a Query, that provides the results for the following request: List each PilotID, FirstName, LastName, the Airline each pilot works for, sorted by pilot. (5%)

7) Create a Form: New Pilot Input (5%)

8) Create a Report: Pilot List – list all pilots, their first and last names, and Salary (5%)
Upload the database to the assignment area as one of the deliverables

9) Submission content organization, clarity, spelling and grammar (10%)

A disaster recovery plan describes scenarios for resuming work  quickly and reducing interruptions in the aftermath of a disaster. It is  an important part of the business continuity plan and it allows for  sufficient IT recovery and the prevention of data loss.

1. Write a 1-page paper describing the difference between Business Continuity and Disaster Recovery. Your paper should also: 
   • Identify why it is important for an organization to have a BCDR plan.
   • Describe the advantages and disadvantages of using a cloud provider  for disaster recovery computing, as opposed to maintaining your own  failover systems.
2. Remember to use proper APA formatting, including citations and references for all resources used.

Evaluate how organizational performance changes leadership behaviors.

 write a one-page, proposal that addresses the following:

1. A description of the problem domain (written using terminology that a user of the system would use; no need for technical database terminology.)
2. Choose a domain with which you are familiar. Your domain should be different than examples provided in the textbook and in class.
3. Identify a set of requirements for a system that is appropriate for your domain. If you wish, you may choose an appropriate sub-set of a larger domain.
4. Your work should be original. Do not copy or download from the Internet. If you do search the Internet to get ideas, you must cite your sources in an APA-style reference page. 

please find attachment