Exp22_Word_Ch02_CumulativeAssessment – Space

Exp22_Word_Ch02_CumulativeAssessment – Space

  

Project Description:

In this project, you will use Word to prepare a document publicizing a series of space camp programs, designed for families and individuals. You will format the document as appropriate and include graphics to enhance document content 

     

Start Word. Download and open   the file named Exp22_Word_Ch02_CumulativeAssessment_Space.docx.   Grader has automatically added your last name to the beginning of the   filename. Ensure that nonprinting characters are displayed.

 

Select Underwater Astronaut Trainer in the first body paragraph and bold   it. Select Thermal Design Challenge   in the first body paragraph and bold it. Select all text from Space Academy on page 1 through Pack your bags on page 2 and change   the font to Cambria with a font size of 14. Change the alignment of selected   text to Justify.

 

Select the bulleted activities   in the Space Academy section on   page 1 and adjust the line spacing to 1.15. Ensure that paragraph spacing   before and after is 0 pt for the selected paragraphs.

 

Use Format Painter to copy the   format of the bulleted items in the Space   Academy section to bulleted items in the Space Camp section and also in the Adult Space Academy   section.

 

Select the final three   paragraphs that are shown above the boxed area at the end of the document,   beginning with Sign up online and   ending with Pack your bags. Apply   numbering, selecting numbers that are followed by a period. Decrease the   indent so that the items begin at the left margin.

 

Display the ruler. Click or   select the blank paragraph above the bordered text at the end of the   document. Press ENTER. Set a left tab at 1″ and a right tab at 6″. Ensure that the right   tab includes a dash leader. Ensure that the font is 14 pt Cambria.

 

Press TAB and type SPACE   ADVENTURE. (Do   not type the period.) Press TAB and type DAVIDSON SPACE CENTER. (Do not type the period.) Drag   or move the 6” tab back to 5.5” on the ruler. Bold the tabbed line of text.

 

Select the tabbed line of text   and apply a Box border, choosing the first double-line style and ¾ pt width.

 

Select the Space Camp Programs heading at the top of the document. Insert   WordArt, choosing Fill: Gray, Accent Color 3; Sharp Bevel (row 2, column 5).   Ensure that the font size of the WordArt heading is 36.

 

Click or place the insertion at   the end of the third bulleted item at the top of page 2, Compete in camp-wide Challenge nights! Press ENTER. Remove the   bullet from the new line. Insert SmartArt, selecting Circle Arrow Process from the Process group. Type Space Academy   in the top text   placeholder. Type Space Camp in the middle text placeholder. Type Adult Space   Academy in the   lower text placeholder.

 

Adjust the SmartArt height to   2″ and width to   2”. Change colors to Colorful Range – Accent Colors 2 to 3. Position the   SmartArt object, choosing Position in Middle Right with Square Text Wrapping.

 

Click or position the insertion   point at the top of the document, beside the Space Academy heading. Insert a Star: 4 Points shape from the Stars and Banners   category. Draw the shape approximately 1″ wide and 1″ high, near   the left margin on the top line of the document. Using the Shape Format tab,   adjust the height and width to exactly 1.

 

Click or press Align in the   Arrange group on the Shape Format tab. Ensure that Align to Page is selected.   Click or select Align and align the shape in the center. Send the star to the   back so that it is located behind the WordArt heading object.

 

Change the shape fill of the   star to Gray, Accent 3, Lighter 80%. Change the Shape Outline to Black, Text   1. Apply a glow effect of Glow: 5 point, Orange, Accent color 2.

 

Group the star and WordArt items   into one object. Change text wrapping of the grouped object to Top and   Bottom.

 

Select the text Space Academy is the place for trainees to   experience first-hand the future of space travel, and train to solve   technically challenging problems the first sentence in the document. Copy   the selection. Deselect the text. Draw a text box of any size near the middle   of page 1 and paste the copied sentence in the text box. End the sentence   with a period. Adjust text box height to 2″ and width to 4″.

 

Change the font size of text in   the text box to 20 and change the font to Baskerville Old Face. Center the text.   Adjust text wrapping of the text box to Square. Drag or move the text box to   position it at the left margin above the Space   Camp heading near the bottom of page 1. Two bulleted items should wrap on   the right side of the text box. Apply a shape fill of Gray, Accent 3, Lighter   80%.

 

View the document in Multiple   Pages and check for any poorly placed headings or shapes. Insert a page break   before Activities at the bottom of   page 1. Insert a page break before It’s   as easy as 1-2-3 at the bottom of page 2.

 

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

Cryptography – Milestone

In the initial milestone writing assignment, you will evaluate the history of cryptography from its origins.  Analyze how cryptography was used and describe how it grew within history.  The writing assignment requires a minimum of two written pages to evaluate the history.  You must use a minimum of three scholarly articles to complete the assignment.  The assignment must be properly APA formatted with a separate title and reference page.

IT345 Week 9 B

Discussion 9B

Summarize what you have learned over the last 9 weeks. Has it changed your opinion about technology? Do you believe technology will continue to evolve? What businesses should concerned about being “phased” out due to new technology?

Post your reply by Wednesday at midnight. Your response should be at least 200 words and appropriately cite your resources.

Respond to two of your classmates by Sunday at midnight. Your responses should be at least 100 words and should be substantive. You should offer additional resources, insight, or other helpful feedback. A simple “I like your post” will result in a 0.

You will not be able to see other posts until you make your first post.

Programming Java

Question 1:

Write a program that asks the user for a positive nonzero integer value. The program should use a loop (while loop) to get the sum of all the integers from 1 up to the number entered. For examples, if the user enters 50, the loop will find the sum of 1,2,3,4,….50.

Hint: You need two while loops here. One to make sure the user enters a positive number (keeps on asking the user for a number till heshe enters a positive nonzero number).  And two to find the sum.

Question 2:

The distance a vehicle travels can be calculated as follows:

                Distance = Speed * Time

For example, if a train travels 40 miles per hour for 3 hours, the distance traveled is 120 miles. Write a program that asks for the speed of a vehicle (in miles per hour) and the number of hours it has traveled. It should use a loop to display the distance a vehicle has traveled for each hour of a time period specified by the user. For example, if a vehicle is traveling at 40 mph for a 3 hour time period, it should display a report similar to the one that follows:

Hours                                    Distance

                1                                              40
                2                                              80
                3                                              120

Input validation: Do not accept a negative number for speed and do not accept any value less than 1 for time traveled (i.e. use a loop to keep on asking the user till heshe gives you an acceptable value for both).

Question 3:

Write a program that will predict the size of a population of organisms. The program should ask for the starting number of organisms, their average daily population increase (as a percentage), and the number of days they will multiply. For example, a population might begin with two organisms, have an average daily increase of 50 percent, and will be allowed to multiply for seven days. The program should use a loop to display the size of the population for each day. So for the previous example, the output should look like:

Day                        Organisms

—————————–

1                              2.0

2                              3.0

3                              4.5

4                              6.75

5                              10.125

6                              15.1875

7                              22.78125

Input validation: Do not accept a number less than 2 for the staring size of the population. Do not accept a negative number for average percent daily population increase. Do not accept a number less than 1 for the number of days they will multiply.

Question 4:

Write a program with a loop that lets the user enter a series of integers. The user should enter -99 to signal the end of the series. After all the numbers have been entered, the program should display the largest and smallest numbers entered.

Question 5:

Write a program that displays a table of centigrade temperatures 0 through 20 and their Fahrenheit equivalents. The formula for converting a temperature from centigrade to Fahrenheit is:

                F =  95 * C + 32

Where F is the Fahrenheit temperature and C is the centigrade temperature. Your program must use a loop to display the table.

Question 6:

Write a multiplication tutor program. Ask user to solve problems with random numbers from 1-20. The program stops after an incorrect answer. The output should look like:

14 * 8 = 112

Correct!

5 * 12 = 60

Correct!

8 * 3 = 24

19 * 14 = 256

Incorrect; the answer was 266

You solved 2 correctly

Lab

Lab # 7 part 2 – DATABASE AUDITING (lab)

This lab has been tested in Oracle 10g express.  You may copy and paste directly from this file. Note that if you need to edit this file, it is better to do so in NOTEPAD (copy & paste it to notepad),  word sometimes puts in characters that Oracle will not recognize it.  Also, note that as you copy & paste the stored procedures and triggers, you may need to copy & paste everything except for the slash and then paste the slash. Your job is to create an audit table in MS-SQL Server. Then create a trigger that puts data into the table. Then issue the command that will activate the trigger. You can translate some of the triggers in this assignment, copy and paste triggers from the web-site or create your own trigger. Regardless, your deliverable should be: a small text in English explaining what the trigger is doing and why is it useful, the Audit table, the Trigger, the command that execute the trigger.

Part  0 – only if you are doing it on a newly installed version

— Open an SQL window. Create a user & grant the user dba privileges. Example:

CREATE  USER  cit540 IDENTIFIED BY  c; 

GRANT  DBA   TO  cit540;  — In SQL Server, you grant all privileges to this user through login/security

— Create another user and grant this user create session privileges. Example:

CREATE  USER   smith  IDENTIFIED  BY  s;

GRANT    CREATE  SESSION   TO  smith;

Part  1 – audit login and logout

— Login as the user CIT540 with dba privileges 

CONNECT  cit540/c;

— Create a table to keep track of user login and logoff  

CREATE TABLE  login_logoff

(

      USERIDVARCHAR2(30),

      SESSIONIDNUMBER(8),

      HOSTVARCHAR2(30),

      LOGIN_DAYDATE,

      LOGIN_TIME            VARCHAR2(10),

      LOGOUT_DAYDATE,

     LOGOUT_TIME         VARCHAR2(10)

);

/

— Create a trigger that will insert a row in the login_logoff table every time user logs in

CREATE OR REPLACE TRIGGER

     audit_login

AFTER  LOGON  ON  DATABASE

BEGIN

INSERT  INTO  login_logoff  values (

         USER,

         sys_context (‘USERENV’,’SESSIONID’),          

​  sys_context (‘USERENV’,’HOST’),

                          sysdate,

                          to_char(sysdate, ‘hh24:mi:ss’),

                          null,

                          null  );

                 COMMIT;

                 END;          

/

— Create a trigger that will insert data in a row in the login_logoff table every time user logs out

CREATE OR REPLACE TRIGGER

    audit_logoff

BEFORE  LOGOFF ON DATABASE

BEGIN

  UPDATE  login_logoff

  SET

    logout_day = sysdate, logout_time=to_char(sysdate,’hh24:mi:ss’)

WHERE

  sys_context(‘USERENV’,’SESSIONID’)=sessionid;

END;

/

–Do not close your  SQL session. Open another SQL window and login as the user that does — not have dba privilege.

connect  smith/s; 

— leave the SQL session

Exit;

— connect as administrator (in this example, cit540

Connect  cit540/c;

— From the user CIT540 session that does have DBA privileges, verify the login

SELECT USERID, SESSIONID, HOST, LOGIN_DAY, LOGIN_TIME FROM LOGIN_LOGOFF;

Display. Your results.  Howe many rows did you see ?

You should see something like (but with CIT540 and Smith) :

Logout and type in:

SELECT  *  FROM  LOGIN_LOGOFF;

—————————————–

Creating Audit table and Audit Trigger

You will copy and paste everything that is in green. Deliverable: Screenshots of query with results.

1) get current date and current user

select  getDate();

select  suser_sname();

2) Create an audit table

CREATE TABLE UpdateProductAudit (date_updated  date,  who  varchar(50));

3) Create a trigger that inserts a row into the AuditProductChanges every time the Products table is updated

create trigger AuditProductChanges on Products

after update

as

begin

insert into dbo.UpdateProductAudit values(getDate(), suser_sname()); 

end

go

4) udate the Products table

UPDATE Products set quantity = quantity * 1.1;

5) view the update in the audit table

SELECT * from dbo.UdateProductAudit;

6) Do the exercises in the link below. Your professor will discuss the link in class.

https://www.mssqltips.com/sqlservertip/4055/create-a-simple-sql-server-trigger-to-build-an-audit-trail/

Submit the screenshots of the results. Create the table inside your own database. Alter each table name and trigger name to have your initials.  Consequently , you also need to order each reference to the table to have your initials also.

7) Go to https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/create-a-server-audit-and-database-audit-specification?view=sql-server-2017

And create a server audit specification (either in SSMS or SQL)

Cloud computing and virtualization

 For your written assignment this week, complete a case study of the organization you work for (use a hypothetical or “other” organization if more applicable) that will address the following prompts: 

  • Describe the organization’s environment, and evaluate its preparedness for virtualization. 
  • Explain Microsoft (or another product) licensing for virtualized environments. 
  • Recommend a configuration for shared storage; make sure to discuss the need for high availability and redundancy for virtualization for the organization. 
  • Explain Windows Azure capabilities for virtual machines and managing a hybrid cloud, including Windows Azure’s Internet as a Service (IaaS) and storage capabilities 

Make a recommendation for cloud computer use in the organization, including a justification for your recommendations. 

Submit your midterm research paper as a single document. Your paper should meet the following requirements: 

  • Be approximately four to six pages in length (1200-1800 words), not including the required cover page and reference page. 
  • Follow APA7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion. 
  • Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook.  

Asset Tables

please review template first. i did most of table one, just need #19 to 26 filled out along with table 2 and description.