In this activity, you will design a computer system for a specific user with a specified budget. To create the computer system, you will need to determine the hardware, software, and peripherals that meet the needs of the specific user. You will make a list of the components and provide an explanation of the function of each. You must support your decision for including each component in the system by describing how it will effectively meet the needs of the user profile you selected.

Use the System Specifications Template (ATTACHED) to complete this assignment. Remember to include links or appropriate citations for the resources you use to support your selections.

Sites such as NewEgg, Micro Center, and Fry’s Electronics provide numerous options to consider when building a computer system. You may find it beneficial to use one of these sites, or you may choose to use other resources.

As you begin to build your computer system, consider the following basic questions and make decisions about items such as the system unit, CD/DVD drive, printer, monitor, speakers, microphone, keyboard, mouse, flash memory card reader, and storage (e.g., hard drive or solid state drive):

• What input devices will the user need for the system?
• What output devices will the user need for the system?
• How important is processing speed?
• How much memory and storage do they need?

Choose one user profile from the following list and create a computer system that meets the needs of that specific user.

Family (Budget: $800.00)

The family computer will need to meet the needs of a variety of users. They plan to use it to search the internet, stream videos, create a family budget, and support basic word processing tasks. They expect easy usability, the ability to connect to fast internet, clear picture, and the ability to print documents they create. In addition to the basic questions listed above, when building the computer system for this user, consider the following:

• How much RAM would be sufficient?
• What size hard drive would they need?
• What type of monitor do they need, and what resolution would you recommend?
• Connection to the internet is important, so what would you recommend to support the family’s needs?
• Which peripherals, such as keyboard, mouse, and printer, would you recommend?
• What email program would you suggest and why?
• What budgeting programs should they use?
• What internet browser would you recommend and why?

Remember to explain the function of each component you chose and support your decision for including it in the system.

Digital Art Student (Budget: $1,500.00)

The art student is creative and innovative. They not only focus on traditional school work but also rely on their computer for creating models, animation, and 3D printing projects for their major. In addition to the basic questions listed above, when building the computer system for this user, consider the following:

• Does the system allow them to work in a variety of places?
• Do they have the right amount of memory?
• Do they have enough permanent storage?
• Does the system allow them to draw directly on the screen?
• What software will they need to create presentations and animation projects?
• What peripherals would be essential for this student?

Remember to explain the function of each component you chose and support your decision for including it in the system.

Gamer (Budget: $2,500.00)

Most gamers want smooth, fast gameplay with sights and sounds that immerse them in the game. They are interested in streaming or recording video and communicating with other players. They do not want visuals that are grainy, pixelated, or stall mid-move. In addition to the basic questions listed above, when building the computer system for this user, consider the following:

• What components should be used to ensure smooth and quick gameplay (e.g., solid state hard drive, multi-core processors)?
• What components should be used to ensure the best visual experience (e.g., monitors and discrete graphics cards)?
• What components could impact the speed of play or amount of buffering (e.g., memory, internet connection)?
• How will you address the audio needs (e.g., microphone, speakers, headset, sound card)?
• What peripherals would be needed (e.g., joystick, gaming controller)? This may be based on the software/games being recommended.

Remember to explain the function of each component you chose and support your decision for including it in the system.

What to Submit: Submit the completed System Specifications Template.

Constructing a Computer System Rubric

Criteria	Exemplary (100%)	Proficient (85%)	Needs Improvement (55%)	Not Evident (0%)	Value
Hardware Components	Exceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner	Identifies all hardware components needed to create a system within a given budget	Shows progress toward proficiency, but with errors or omissions; areas for improvement may include accuracy, clarity, logic, or detail	Does not attempt criterion	20
Purpose	Exceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner	Describes the purpose/application of each component	Shows progress toward proficiency, but with errors or omissions; areas for improvement may include accuracy, clarity, logic, or detail	Does not attempt criterion	20
Software	Exceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner	Identifies specific software for a given user	Shows progress toward proficiency, but with errors or omissions; areas for improvement may include accuracy, clarity, logic, or detail	Does not attempt criterion	20
Supports Decision	Exceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner	Explains decision for inclusion of components	Shows progress toward proficiency, but with errors or omissions; areas for improvement may include accuracy, clarity, logic, or detail and correct use of concepts throughout the explanation	Does not attempt criterion	20
Articulation of Response	Exceeds proficiency in an exceptionally clear, insightful, sophisticated, or creative manner	Clearly conveys meaning with correct grammar, sentence structure, and spelling, demonstrating an understanding of audience and purpose	Shows progress toward proficiency, but with errors in grammar, sentence structure, and spelling, negatively impacting readability	Submission has critical errors in grammar, sentence structure, and spelling, preventing understanding of ideas	10
Citations and Attributions	Attributes sources where applicable using citation methods with very few minor errors	Attributes sources where applicable, but with consistent minor errors	Attributes sources where applicable, but with major errors	Does not attribute sources where applicable	10
Total:					100%

1. Create a MySQL schema named “accidents.”
2. Within the accidents schema, create a table named accidents_2016 with the following columns:
   • accident_index as a varchar(13),
   • accident_severity as an int
3. Within the accidents schema, create a table named vehicles_2016 with the following columns:
   • accident_index as a varchar(13),
   • vehicle_type as a varchar(10)
4. Within the accidents schema, create a table named vehicle_type with the following columns:
   • vcode int,
   • vtype as a varchar(100)
5. Next, you will load the data for the three tables.
   • Load the accidents data. Note that @dummy is a placeholder for a column in the .csv file that you want to ignore during the load.

load data local infile '…\data\Accidents_2016.csv'into table accidents_2016fields terminated by ','enclosed by '"'lines terminated by 'n'ignore 1 lines(@col1, @dummy, @dummy, @dummy, @dummy, @dummy, @col2,@dummy, @dummy, @dummy, @dummy, @dummy,@dummy, @dummy, @dummy, @dummy, @dummy,@dummy, @dummy, @dummy, @dummy, @dummy,@dummy, @dummy, @dummy, @dummy, @dummy,@dummy, @dummy, @dummy, @dummy, @dummy) set accident_index=@col1,accident_severity=@col2;

• Load the vehicle data.

load data local infile '…\data\Vehicles_2016.csv'into table vehicles_2016fields terminated by ','enclosed by '"'lines terminated by 'n'ignore 1 lines(@col1, @dummy, @dummy, @col2,@dummy, @dummy, @dummy, @dummy, @dummy,@dummy, @dummy, @dummy, @dummy, @dummy,@dummy, @dummy, @dummy, @dummy, @dummy,@dummy, @dummy, @dummy, @dummy, @dummy)set accident_index=@col1,vehicle_type=@col2;

• Load the vehicle type data.

load data local infile  '…\data\vehicle_type.csv'into table  vehicle_typefields  terminated by ','enclosed by  '"'lines  terminated by 'n'ignore 1  lines

1. After the data are loaded, you will perform the analysis. First, find the average accident severity and the number of accidents for vehicles of type motorcycle. Note the performance of your query. Your query may run so slowly that MySQL aborts running completing.
2. Improve Query Performance
   • Look at the explain tool output and save the results to a graphic file.
   • From the explain results, how many rows have to be read per join?
   • Add an index named “accident_index” of type “index” on the accident_index
   • column in the accidents_2016 table and another index named “accident_index” of type “index” on the vehicles_2106 table.

alter table accidents_2016add index accident_index (accident_index asc);

alter table vehicles_2016add index accident_index (accident_index asc);

After adding the indices, rerun the query explanation tool and determine the number of rows to be read per join.

1. Find the median accident severity.

MySQL does not have a median function so to find the median accident severity, you will have to write a Python script.

• You’ll need to install Python and the PyMySQL module.
• Install Python version 2.7 or 3.4 from www.python.org.

To install the PyMySQL module, run the following command in a Windows command prompt after Python has been installed:

python -m pip install  --index-url=https://pypi.python.org/simple/ --trusted-host pypi.python.org PyMySQL

b) Create an accident median table

create  table accident_medians(       vtype varchar(100),       severity int);

• Run the following Python script:

import pymysqlmyConnection  = pymysql.connect(host='localhost', user='****', passwd='****', db='accidents')cur = myConnection.cursor()cur.execute('SELECT vtype FROM vehicle_type WHERE  vtype LIKE "%otorcycle%";')cycleList = cur.fetchall()selectSQL = ('''                SELECT  t.vtype, a.accident_severity                FROM accidents_2016 AS a                JOIN vehicles_2016 AS v ON  a.accident_index = v.Accident_Index                JOIN vehicle_type AS t ON  v.Vehicle_Type = t.vcode                WHERE t.vtype LIKE %s                ORDER BY  a.accident_severity;''')insertSQL = ('''INSERT INTO accident_medians  VALUES (%s, %s);''')                for cycle  in cycleList:                cur.execute(selectSQL,cycle[0])                accidents = cur.fetchall()                quotient, remainder =  divmod(len(accidents),2)                if  remainder:                                med_sev =  accidents[quotient][1]                else:                                med_sev =  (accidents[quotient][1] + accidents[quotient+2][1])/2                print('Finding median  for',cycle[0])                cur.execute(insertSQL,(cycle[0],med_sev))myConnection.commit()myConnection.close()

Write each query you used in Steps 1 – 8 in a text file. If a query produced a result set, then list the first ten rows of each row set after the query.

Using the RMP template that you have been using for the last two weeks, work with your supervisor and complete the last section of your RMP – the Risk Treatment Plan by midnight Friday night.

Details of fields in the RMP Risk Treatment plan are described in this week’s seminar

1. Complete the last section of your RMP, the Risk Treatment plan

There are five columns to be completed in the Risk Treatment Plan:

1. Treatment Strategy,
2. Treatment Description,
3. Treatment Resources,
4. Risk owner, and
5. Deadline

A. Treatment Strategy

This is the risk response that you will apply to the risk. You will recall from week 6 that there are only 4 possible risk responses:

Avoidance

Changing the project plan (e.g. the scope statement, the schedule, etc) so that a particular risk can’t happen.

Typically this means removing something from the scope of the project to completely remove the risk, so it is 100% impossible. E.g. you have to produce website that will display on Windows Internet Explorer, Firefox, Chrome and Opera. There is a big risk that Opera will not display it correctly, so you remove “Opera” from the scope statement. Now that risk cannot happen.

Mitigation

Taking action to reduce the likelihood and/or the impact of an identified risk. E.g. there is a risk the project might be late because the team has not much expertise with SharePoint. You can mitigate the risk by providing training to the team and/or contracting a SharePoint specialist.

Transference

Paying someone to take the risk on your behalf (usually outsourcing or purchasing insurance)

Note that to transfer a risk, you must transfer it OUTSIDE the company. You can’t transfer to another team, or transfer by employing experts, because the company still owns all the risks of its employees.

Acceptance

You simply decide that you will accept the consequence of the risk if it occurs. This may be because you think:

• There’s virtually no chance of it happening (e.g. a major earthquake in London), or
• The impact would be negligible,
• It is too expensive to deal with (e.g. the cost of insurance may be more than the impact of the risk event), or
• You simply have no idea what you would do!

When you accept a risk, you don’t have to do anything further. If you try to plan anything for this risk then it becomes a mitigation.

B. Treatment Description

Having selected the strategy, this field is where you enter the details of how this strategy will be implemented.

C. Treatment Resources

People, equipment, budget, etc required for this strategy.

D. Risk Owner

The risk owner is the person responsible for ensuring that the risk strategy is put in place, and is also responsible for checking that the risk is dealt with according to the plan, if the risk occurs. This person may not be the same person who actually treats the risk. For example, the IT Manager may be the risk owner for the risk “Some laptop computers may be offsite and not upgraded”, but it will not be the IT Manger who actually recalls and checks each laptop, that is a task for a technician.

E. Deadline

Enter the date when the strategy has to be finalised (e.g. of the strategy is to buy insurance, then this will be the date that the insurance has to be purchased.

and just answer these questions

CSR Analysis of your project

Examine your project and then answer the following three sets of questions. You will probably need your supervisor to assist you.

The principles:

Principle of institutional legitimacy

Would the technology I develop be welcomed by society?

Principle of public responsibility

Is the benefit greater than the risk?

Principle of managerial discretion

Is my work and behaviour ethical and socially responsible?

The processes:

Environmental assessment

Have I asked the right questions?

Stakeholder management

Have I asked the right questions of the right people?

Issues management

Have I been thorough in thinking this through and prepared as well as I can?

The outcomes:

Social Impacts

Will the software/services I provide work to benefit the company and society?

Social programs

Does the software/services take into account all relevant legislation and compliance requirements?

Social policies

Can I take my knowledge into the community to enhance the reputation of my company and support the community in which my company operates?

Black or White is a one-player puzzle game played on a 5×5 grid with 25 identical pieces. Each piece is a disk, white on one face, black on the other—thus the name. One piece is placed in each grid square. Initially pieces are placed randomly as to whether the white or black side is up. The player may pick any piece to flip, thus reversing its color. BUT—when any piece is flipped, then every piece in the same row and same column, regardless of current color, must also be flipped. The object is to make a series of flips such that the pieces are either all-white or all-black. Your task is to write a program that can generate a random Black or White puzzle, and then find a solution, or demonstrate that no solution exists from that starting configuration.

If a solution exists, give the user the option of seeing just a list of the moves that must be made, or a more comprehensive version showing the state of the board after each flip. Allow output to a text file, since the number of flips necessary may be large.

Programming notes:

• You may use C++
• Note that there are 25 pieces, and each may be in 2 states independently. Thus there are 225 = 33,554,432 possible states, of which 2 are goal states. Data representation will be important and a compact representation may make the difference between a program that works and one that runs out of memory. You may want to consider a bitstring representation for storage, since each possible board configuration maps directly to a 25-bit integer.
• Note that any position has a dual, consisting of the same position with all pieces reversed. If a series of steps from this position would lead to an all-black state, then a corresponding series from the dual would lead to an all-white state. This makes the code more complex but cuts data storage in half. But be careful that you keep track of which goal state you’re headed towards….
• Algorithm choices: Since moves are reversible, any forward search will have to track which positions have already been examined, to avoid cycles. There will not be a monotonic metric allowing you to assess progress; it may be necessary to temporarily increase the number of disks of the “wrong” color to reach a solution. You will probably want to use retrograde analysis: If this is a winning position (monochrome), what must the position have been just before this? Each of those 25 positions can be stored and marked as 1 step from the goal, with what the winning move is. Now, what position would have led to each of those positions? Those positions should be marked as winning in 2 moves, and for each, what the correct move is. (The branching factor is 25, so the number of positions expands quickly, and remember to omit any position that’s already in the database.) This continues until all possible positions have been marked and stored in the database.
• Interacting with the user then consists of presenting a random board, getting input as to which disk the player wants to turn, and showing the updated board. The player should always have an option for the program to show the steps necessary to reach a solution from the then-current position, if it is possible to do so.
• You may want to write 2 programs: One that generates the database of moves, and the game-playing program that uses the database to interact with the player.

Prepare a short (1 Page) report explaining your program and the algorithm you chose, and how well it worked. How well would your solution scale up to a larger board?

Due date: 09/09/19 at 3:00 am.

Purpose

This assignment is all about formatting with CSS. You will create an external stylesheet that contains CSS style rules. These style rules will format your pages and turn text navigation links into an attractive navigation bar.

Assignment Instructions

In this Assignment, you will create an external Cascading Style Sheet (CSS). You will create a History page for a restaurant website. Since the restaurant is family-owned, the History page may include some background information about the family. This page may also tell a story about how the restaurant was started and/or how the recipes came to be part of the menu. You should include at least 50 words on this page.

Assignment Requirements

1. Create a History page from the website template.
   • Open template.html in Notepad to edit.
   • Type the restaurant name and the text “History” in the title tag.
   • Add a level 1 (h1) heading inside the header of the page. Include logical heading text for the History page.
   • Between <nav> and </nav> tags, add navigation links to your navigation code for the History and Menu pages:
     • <ul>
     • <li><a href=”history.html”>History</a></li>
     • <li><a href=”menu.html”>Menu</a></li>
     • </ul>
   • Save the page as history.html.
   • Close history.html

1. Create a Menu page from the website template.
   • Open template.html in Notepad to edit.
   • Type the restaurant name and the text “Menu” in the title tag.
   • Add a level 1 (h1) heading inside the header of the page. Include logical heading text for the Menu page.
   • Between <nav> and </nav> tags, add navigation links to your navigation code for the History and Menu pages:
     • <ul>
     • <li><a href=”history.html”>History</a></li>
     • <li><a href=”menu.html”>Menu</a></li>
     • </ul>
       
   • Save the page as menu.html
   • Close menu.html

1. Create an external Cascading Style Sheet (CSS) document named styles.css. This code will apply to the Web page elements, adding specific styling and design to the page content.
   • Open a new blank document in Notepad
   • Format the element coded into your HTML pages using CSS. The selector identifies the element that will be formatted, such as body, header, main.
   • Notice there is an ID named #container. This is standard practice for creating an invisible “box” around the entire page content. This helps develop fluid pages for mobile devices and gives a parent element to hold all page elements. It could be named anything, but container is standard.
   • Type the code below into the page, exactly as shown:
     • @charset “utf-8”;
     • body {
     • background-color: #9b30ff;
     • font-family: Arial, Tahoma, sans-serif;
     • color: #000000;
     • }
     • h1 {
     • color: #ffffff;
     • }
     • header {
     • background-color: #000000;
     • color: #ffffff;
     • text-align: center;
     • padding: 5px;
     • width: 80%;
     • margin-left: 10%;
     • }
     • #container {
     • width: 100%;
     • }
   • Save.
   • The next section of CSS formats the main content area and the footer. The footer must include the clear: both; style rule so it is placed below all other content on the page.
   • Type the code below into the page, after the last } bracket:
     • main {
     • width: 80%;
     • background-color: #ffffff;
     • float: left;
     • padding: 5px;
     • margin-left: 10%;
     • }
     • footer {
     • clear: both;
     • background-color: #000000;
     • color: #ffffff;
     • text-align: center;
     • margin-left: 10%;
     • padding: 5px;
     • font-size: 12pt;
     • width: 80%;
     • }
   • Save as styles.css. Don’t forget to select All Files from the drop menu when you save.

1. Link your external CSS document to your Web pages.
   • Open history.html in Notepad to edit
   • Type the link tag exactly as shown between </title> and </head>
     • <link rel=”stylesheet” type=”text/css” href=”styles.css”>
   • Save and close.
   • Open menu.html in Notepad to edit.
   • Type the link tag exactly as shown between </title> and </head>
     • <link rel=”stylesheet” type=”text/css” href=”styles.css”>
   • Save and close.

1. Edit CSS to apply formatting to navigation links within a Web page.
   • Type the following CSS code into styles.css. This code will format your navigation links, rendering the list and links into a decorative and functional navigation bar.
     • nav {
     • color: #000000;
     • padding: 5px;
     • width: 80%;
     • margin-left: 10%;
     • font-weight: bold;
     • }
     • nav ul {
     • list-style: none;
     • }
     • nav ul li {
     • float: left;
     • padding: 5px;
     • }
     • nav ul li a:link, nav ul li a:visited {
     • display: block;
     • width: 150px;
     • margin-right: 4px;
     • color: #000000;
     • padding: 2px 4px 2px 4px;
     • background-color: #ffffff;
     • text-decoration: none;
     • }
     • nav ul li a:hover {
     • color: #ffffff;
     • background-color: #9b30ff;
     • }
   • Save and close.

1. Upload history.html, menu.html, and styles.css to the server.