Please do all the coding in python in “Your Code Here” and makes sure it pass all the test.
331f2
Check attachment
Software Project Management -1
What is project management? Briefly describe the project management framework, providing examples of stakeholders, knowledge areas, tools and techniques, and project success factors.
Exp19_Excel_Ch03_ML2_Grades
Exp19_Excel_Ch03_ML2_Grades
Exp19 Excel Ch03 ML2 Grades
Excel Chapter 3 Mid-Level 2 – Grades
Project Description:
You are a teaching assistant for Dr. Elizabeth Croghan’s BUS 101 Introduction to Business class. You have maintained her gradebook all semester, entering three test scores for each student and calculating the final average. You created a section called Final Grade Distribution that contains calculations to identify the number of students who earned an A, B, C, D, or F. Dr. Croghan wants you to create a chart that shows the percentage of students who earn each letter grade. Therefore, you decide to create and format a pie chart. You will also create a bar chart to show a sample of the students’ test scores. Furthermore, Dr. Croghan wants to see if a correlation exists between attendance and students’ final grades; therefore, you will create a scatter chart depicting each student’s percentage of attendance with his or her respective final grade average.
Start Excel. Download and open the file named Exp19_Excel_Ch03_ML2_Grades.xlsx. Grader has automatically added your last name to the beginning of the filename.
A pie chart is an effective way to visually illustrate the percentage of the class that earned A, B, C, D, and F grades.
Use the Insert tab to create a pie chart from the Final Grade Distribution data located below the student data in the range F35:G39 and move the pie chart to its own sheet named Final Grade Distribution.
You should enter a chart title to describe the purpose of the chart. You will customize the pie chart to focus on particular slices.
•Apply the Style 12 chart style.
•Type BUS 101 Final Grades: Fall 2021 for the chart title.
•Explode the A grade slice by 7%.
•Change the F grade slice to Dark Red.
•Remove the legend.
A best practice is to add Alt Text for accessibility compliance.
Add Alt Text: The pie chart shows percentage of students who earned each letter grade. Most students earned B and C grades. (including the period).
You want to add data labels to indicate the category and percentage of the class that earned each letter grade
Add centered data labels. Select data label options to display Percentage and Category Name in the Inside End position. Remove the Values data labels.
Apply 20-pt size and apply Black, Text 1 font color to the data labels.
You want to create a bar chart to depict grades for a sample of the students in the class.
Create a clustered bar chart using the ranges A5:D5 and A18:D23 in the Grades worksheet. Move the bar chart to its own sheet named Sample Student Scores
Customize the bar chart with these specifications: Style 5 chart style, legend on the right side in 11 pt font size, and Light Gradient – Accent 2 fill color for the plot area.
Type Sample Student Test Scores for the chart title.
Displaying the exact scores would help clarify the data in the chart.
Add data labels in the Outside End position for all data series. Format the Final Exam data series with Blue-Gray, Text 2 fill color.
Select the category axis and display the categories in reverse order in the Format Axis task pane so that O’Hair is listed at the top and Sager is listed at the bottom of the bar chart.
Add Alt Text: The chart shows test scores for six students in the middle of the list. (including the period).
You want to create a scatter chart to see if the combination of attendance and final averages are related.
Display the Grades worksheet. Select the range E5:F31 and create a scatter chart. Cut the chart and paste it in cell A42. Set a height of 5.5″ and a width of 5.96″.
Add Alt Text: The scatter chart shows the relationship of each student’s final grade and his or her attendance record. (including the period).
Titles will help people understand what is being plotted in the horizontal and vertical axes, as well as the overall chart purpose.
Make sure the scatter chart is selected. Type Final Average-Attendance Relationship as the chart title, type Percentage of Attendance as the primary horizontal axis title, and type Student Final Averages as the primary vertical axis title.
To distinguish the points better, you can start the plotting at 40 rather than 0.
Make sure the scatter chart is selected. Apply these settings to the vertical axis of the scatter chart: 40 minimum bound, 100 maximum bound, 10 major units, and a number format with zero decimal places.
Make sure the scatter chart is selected. Apply these settings to the horizontal axis: 40 minimum bound, 100 maximum bound, automatic units.
Adding a fill to the plot area will add a touch of color to the chart.
Make sure the scatter chart is selected. Add the Parchment texture fill to the plot area.
You want to insert a trendline to determine trends.
Make sure the scatter chart is selected and insert a linear trendline.
You want to add sparklines to detect trends for each student.
Select the range B6:D31 on the Grades sheet, create a column Sparkline, and type H6:H31 in the Location Range box. Display the Low Point. Set the Vertical Axis Minimum and Maximum Values to be the same for all Sparklines.
To make the Sparklines more effective and easier to read, you will increase the row height.
Change the row height to 22 for rows 6 through 31.
Insert a footer with Exploring Series on the left, the sheet name code in the center, and the file name code on the right on all the sheets. Group the two chart sheets together to insert the footer. Then insert the footer on the Grades sheet. Change to Normal view
Save and close Exp19_Excel_Ch03_ML2_Grades.xlsx. Exit Excel. Submit the file as directed.
VBScript Database Query
VBScript Database Query Lab
‘======================================================================
‘ NAME: ComputersDatabase.vbs
‘
‘ AUTHOR: jlmorgan ,
‘ DATE : 8/19/2011
‘
‘ COMMENT: Use 32 bit ODBC Microsoft Access Driver
‘
‘==========================================================================
recordsStr = “”
sqlStr = “SELECT * FROM Computers”
dataSource = “provider=Microsoft.ACE.OLEDB.12.0;” _
& “data source=C:ScriptsComputers.accdb”
Set objConnection = CreateObject(“ADODB.Connection”)
objConnection.Open dataSource
Set objRecordSet = CreateObject(“ADODB.Recordset”)
objRecordSet.Open sqlStr , objConnection
objRecordSet.MoveFirst
‘ Display Headers
recordsStr = “Computer HostName Room_Num” & _
” CPU_Type Speed Num_CPUs Bit_Size OS_Type ” & _
” Memory HDD_Size” & vbCrLf & _
“============================================================” & _
“=============================” & vbCrLf
Do Until objRecordSet.EOF
recordsStr = recordsStr & objRecordSet.Fields.Item(“Computer”) & _
vbTab & pad(objRecordSet.Fields.Item(“HostName”),12) & _
vbTab & pad(objRecordSet.Fields.Item(“Room_Num”),14) & _
vbTab & objRecordSet.Fields.Item(“CPU_Type”) & _
vbTab & objRecordSet.Fields.Item(“Speed”) & _
vbTab & objRecordSet.Fields.Item(“Num_CPUs”) & _
vbTab & objRecordSet.Fields.Item(“Bit_Size”) & _
vbTab & pad(objRecordSet.Fields.Item(“OS_Type”),12) & _
vbTab & objRecordSet.Fields.Item(“Memory”) & _
vbTab & objRecordSet.Fields.Item(“HDD_Size”) & vbCrLf
objRecordSet.MoveNext
Loop
objRecordSet.Close
objConnection.Close
WScript.Echo recordsStr
function pad(ByVal strText, ByVal len)
pad = Left(strText & Space(len), len)
end Function
Objective
In this lab, students will complete the following objectives.
• Create a connection to an Access database.
• Create various SQL queries to extract information from a database.
• Format extracted data with column headers.
Element K Network Connections
For this lab, we will only need to connect to vlab-PC1. The computer vlab-PC1 is the computer on the left side while vlab-PC2 is on the right. If you leave the cursor on the PC icon for a few seconds, a tool-tip message will appear indicating the hostname of the PC. Open vlab-PC1 and log in as Administrator with the password password.
Lab Overview
Even though we are only using vlab-PC1 to complete our lab assignment, the database we will be accessing (Computers.accdb) is actually located on the computer vlab-PC2 in the directory C:Database. This directory is shared as a ReadOnly network share by vlab-PC2. The Universal Naming Convention (UNC) name for this share is \vlab-PC2Database. Our VBScript program vlab-PC1 will have to open the \vlab-PC2Database share and map it to the local X: drive. The path specified fro the database will then be X:Computers.accdb.
The IT department maintains an Access database on vlab-PC2 that is used to inventory the computers in the various rooms. Fields in the database include: Computer Type, Hostname, Room Number, CPU Type, Number of Bits, Speed, Number of Processors, Operating System, Memory, and Hard Drive Size. We need to query this database to determine upgrades and replacements for existing computers.
Below (and on the following page) is a listing of the Computers.accdb database contents:
Task 1: Understanding the Net Use Commands in ComputerDatabase.vbs
• Open Notepad++. Use the menu option File/Open to open the VBScript program: C:ScriptsComputerDatabase.vbs.
Task 2: Understanding the ADODB.Connection and ADODB.Recordset Objects
• In NotePad++, look at the following code lines.
Line 11 contains the SQL Query String named sqlStr. This is the line you will have to modify to properly query the Computer database. The SQL Query “SELECT * FROM Computers” will select all fields from the database table Computers.
Lines 12 and 13 uses a string named dataSource to specify the Microsoft Driver and the name and location of the local database: X:Computers.accdb.
Line 14 Creates the “ADODB.Connection” object while line 15 opens the connection to the database.
Line 16 Creates the “ADODB.Recordset” object while line 17 provides access to the records using the SQL Query String and the Connection object. Line 18 moves the objRecordSet pointer to the first record.
Task 3: Displaying the Record Headers and Database Records
• In NotePad++, look at the following lines of the ComputerDatabase.vbs program.
Lines 20–24 display the Database fieldnames as column headers. Note the use of & to concatenate (add) string values together and _ which is the VBScript line continuation character.
Lines 25–37 are a Do Until loop that sequences through the database looking for records
that match the SQL Query String. The objRecordSet.EOF method checks to see if we have reached the last record in the database. This required because reading past the end of a database will cause an error. recordStr is a string variable initially set to “”. recordStr is used to create a multi-line string that contains the column headers and records that match the SQL query. The WScript.Echo recordStr statement in line 40 displays the column headers and records to the console or desktop windows depending on whether cscript or wscript is used to run the program.
Lines 38 and 39 close the database connections made by the ADODB.Connection and ADODB.Recordset objects.
The function pad(byVal strText, ByVal len) in lines 44–46 are used to format the field values with added spaces so the tab positions will line up correctly.
Task 4: Write and Run Database Query Program 1
In this scenario, we need to query the Computer database to determine which computers need to be replaced. Our decision will be based on the CPU speed, Number of Processors, and the size of the Hard Drive.
• Open the ComputerDatabase.vbs program in NotePad++ and Save As the program with the name ComputerReplace.vbs.
• Modify the SQL Query String (sqlStr) in line 11 to extract the following information from the database.
Fields Displayed from Computers Table (specified by the SELECT clause).
Computer
Room_Num
Speed
Num_CPUs
OS_Type
HDD_Size
Replacement Criteria (specified by the WHERE clause).
Any computer with a single CPU
Any computer with a CPU speed less than 2.1 GHz
Any Computer with a Hard Disk Drive size less than 300 GBytes
Sort Criteria (specified by the ORDER BY clause).
Sort the extracted records by the “Room_Num” field.
• Modify lines 20–24 to display the correct field headers for the fields being displayed.
• Modify the Do Until loop body to include only the fields being displayed. Use the pad( ) function as needed to make the header and field values line up.
• Press the
• This query should generate eight records displayed in order by room number. If you have any errors, do not get the correct results or your columns are mis-aligned; modify your program
as required until you get the correct output.
Copy and paste your ComputerReplace.vbs program sourcecode from NotePad++ and the desktop window from your Run into the spaces provided in your lab-report document. Answer the questions about the Replacement SQL Query in the lab-report document.
Task 5: Write and Run Database Query Program 2
In this scenario, we need to upgrade our company computers based on the Operating System and the amount of memory. We want to ensure that all Fedora 10 machines are upgraded to Fedora 14 and all Windows XP machines are upgraded to Windows 7. If we find any computers with only 2 GB of memory, we will upgrade the memory to 4 GB.
• Open the ComputerDatabase.vbs program in NotePad++ and Save As the program with the name ComputerUpgrade.vbs.
• Modify the SQL Query String (sqlStr) in line 11 extract the following information from the database.
Fields Displayed from Computers Table (specified by the SELECT clause).
Computer
HostName
Room_Num
OS_Type
Memory
Replacement Criteria (specified by the WHERE clause).
Note: String values in fields must be delimited by single quotes.
Any computer with the Fedora 10 Operating System (‘Fedora 10’)
Any computer with the Windows XP Operating System (‘Windows XP’)
Any computer with 2 GB of memory
Sort Criteria (specified by the ORDER BY clause).
Sort the extracted records by the “OS_Type” field.
• Modify lines 20–24 to display the correct field headers for the fields being displayed.
• Modify the Do Until loop body to include only the fields being displayed. Use the pad( ) function as needed to make the header and field values line up.
• Press the
• This query should generate 16 records displayed in order by OS_Type. If you have any errors, do not get the correct results, or your columns are mis-aligned; modify your program as required until you get the correct output.
Copy and paste your ComputerUpgrade.vbs program sourcecode from NotePad++ and the desktop window from your Run into the spaces provided in your lab-report document. Answer the questions about the Upgrade SQL Query in the lab-report document.
Student Name ____________________________ Date _____________
VBScript Database Query Lab Report
Task 4: Write and Run Database Query Program 1
In this scenario, we need to query the Computer database to determine which computers need to be replaced. Our decision will be based on the CPU speed, Number of Processors and the size of the Hard Drive.
• In the space provided in your Lab Report document, paste your modified VBScript program and the RUN.
In the table cell below, paste your ComputerReplace.vbs Program
In the table cell below, paste the desktop RUN from your ComputerReplace.vbs Program
How many Computers will be replaced due only to CPU Speed < 2 GHz?
How many Computers will be replaced due only to Number of CPUs = 1?
How many Computers will be replaced due only to HDD Size < 300?
How many Computers will be replaced due to 2 or more reasons?
Task 5: Write and Run Database Query Program 2
In this scenario, we need to upgrade our company computers based on the Operating System and the amount of memory. We want to ensure that all Fedora 10 machines are upgrade to Fedora 14 and all Windows XP machines are upgraded to Windows 7. If we find any computers with only 2 GB of memory, we will upgrade the memory to 4 GB.
In the table cell below, paste your ComputerUpgrade.vbs Program
In the table cell below, paste the desktop RUN from your ComputerUpgrade.vbs Program
How many Fedora 10 Computers will be upgraded?
How many Window 7 Computers will be upgraded due to 2 GB memory?
How many Windows XP Computers will need a Memory and OS upgrade?
Security Architecture and Design
Since it is so dangerous, why would designers install software into the kernel at all (or make use of kernel software)? If you were an antivirus designer or maker, what other methods do you utilize to prevent virus?
Weekly Journal 3
Each week you are to enter content into an online journal provided in Blackboard that briefly summarizes (1) the tasks you performed during your internship that week and (2) total hours worked with days/times. The content can be brief and in outline form and use bullet or another list styling, but keep in mind that this content will form the basis of the two major papers that you will write for this course. Therefore, the more detailed you are in your weekly journal, the easier it will be to finish the two papers. Specifically, your weekly journal should contain:
• The days and times you worked that week, as well as the total hours, worked. (Provide this information at the top of each weekly section so this will act as a de facto heading to separate each weekly entry that you make.)
• The skills or skillsets used/required to complete each task
• Each task you performed along with a brief description of what you did.
• A brief explanation of why the task needed to be done.
• Was there an outcome? If so, what was that outcome?
• What new terminology did you learn this week? Provide the term and its definition.
Research Report #1: Data Breach Incident Analysis & Report
Scenario
Padgett-Beale Inc.’s (PBI) insurance company, CyberOne Business and Casualty Insurance Ltd, sent an audit team to review the company’s security policies, processes, and plans. The auditors found that the majority of PBI’s operating units did not have specific plans in place to address data breaches and, in general, the company was deemed “not ready” to effectively prevent and/or respond to a major data breach. The insurance company has indicated that it will not renew PBI’s cyber insurance policy if PBI does not address this deficiency by putting an effective data breach response policy and plan in place. PBI’s executive leadership team has established an internal task force to address these problems and close the gaps because they know that the company cannot afford to have its cyber insurance policy cancelled.
Unfortunately, due to the sensitivity of the issues, no management interns will be allowed to shadow the task force members as they work on this high priority initiative. The Chief of Staff (CoS), however, is not one to let a good learning opportunity go to waste … especially for the management interns. Your assignment from the CoS is to review a set of news articles, legal opinions, and court documents for multiple data breaches that affected a competitor, Marriott International (Starwood Hotels division). After you have done so, the CoS has asked that you write a research report that can be shared with middle managers and senior staff to help them understand the problems and issues arising from legal actions taken against Marriott International in response to this data breach in one of its subsidiaries (Starwood Hotels).
Research
1. Read / Review the readings for Weeks 1, 2, 3, and 4.
2. Research the types of insurance coverage that apply to data breaches. Pay attention to the security measures required by the insurance companies before they will grant coverage (“underwriting requirements”) and provisions for technical support from the insurer in the event of a breach. Here are three resources to help you get started.
b. https://www.travelers.com/cyber-insurance
c. https://wsandco.com/cyber-liability/cyber-basics/
3. Read / Review at least 3 of the following documents about the Marriott International / Starwood Hotels data breach and liability lawsuits.
a. https://www.insurancejournal.com/news/national/2018/12/03/510811.htm
c. https://www.bbc.com/news/technology-54748843
d. http://starwoodstag.wpengine.com/wp-content/uploads/2019/05/us-en_First-Response.pdf
e. https://www.consumer.ftc.gov/blog/2018/12/marriott-data-breach
4. Find and review at least one additional resource on your own that provides information about data breaches and/or best practices for preventing and responding to such incidents.
5. Using all of your readings, identify at least 5 best practices that you can recommend to Padgett-Beale’s leadership team as it works to improve its data breach response policy and plans.
Write
Write a three to five (3-5) page report using your research. At a minimum, your report must include the following:
1. An introduction or overview of the problem (cyber insurance company’s audit findings regarding the company’s lack of readiness to respond to data breaches). This introduction should be suitable for an executive audience and should explain what cyber insurance is and why the company needs it.
2. An analysis section in which you discuss the following:
a. Specific types of data involved in the Starwood Hotels data breaches and the harm
b. Findings by government agencies / courts regarding actions Starwood Hotels / Marriott International should have taken
c. Findings by government agencies / courts regarding liability and penalties (fines) assessed against Marriott International.
3. A review of best practices which includes 5 or more specific recommendations that should be implemented as part of Padgett-Beale’s updated data breach response policy and plans. Your review should identify and discuss at least one best practice for each of the following areas: people, processes, policies and technologies. (This means that one of the four areas will have two recommendations for a total of 5.)
4. A closing section (summary) in which you summarize the issues and your recommendations for policies, processes, and/or technologies that Padgett-Beale, Inc. should implement.
Submit for Grading
Submit your research paper in MS Word format (.docx or .doc file) using the Research Report #1 Assignment in your assignment folder. (Attach your file to the assignment entry.)
Additional Information
1. To save you time, a set of appropriate resources / reference materials has been included as part of this assignment. You must incorporate at least five of these resources into your final deliverable. You must also include one resource that you found on your own.
2. Your research report should be professional in appearance with consistent use of fonts, font sizes, margins, etc. You should use headings to organize your paper. The CSIA program recommends that you follow standard APA formatting since this will give you a document that meets the “professional appearance” requirements. APA formatting guidelines and examples are found under Course Resources > APA Resources. An APA template file (MS Word format) has also been provided for your use.
3. You are expected to write grammatically correct English in every assignment that you submit for grading. Do not turn in any work without (a) using spell check, (b) using grammar check, (c) verifying that your punctuation is correct and (d) reviewing your work for correct word usage and correctly structured sentences and paragraphs.
4. You are expected to credit your sources using in-text citations and reference list entries. Both your citations and your reference list entries must follow a consistent citation style (APA, MLA, etc.).
Personal Reflection
Need help on Reflection.
MS Project
MS Project 2016 assignment