Exp19_Excel_Ch11_ML2_Game_Studio

  Exp19_Excel_Ch11_ML2_Game_Studio

  

Project Description:

Innovations Game Studio has locations in Portland, Seattle, and Salt Lake City. Each location has game-development teams to produce video games for various consoles. You will use text functions to format the list and copy records of programmers in one location. In addition, you will insert database functions to calculate summary statistics and create a lookup area to look up an employee’s ID to retrieve that person’s name, job title, and salary.

     

Start   Excel. Download and open the file named Exp19_Excel_Ch11_ML2_GameStudio.xlsx. Grader has automatically added   your last name to the beginning of the filename.

 

You want to combine the first,   middle, and last names into one cell for each person.
 

  Display the Salary Data worksheet. In cell E2, insert the TEXTJOIN function   to join the range
  B2:D2, using a space delimiter and ignoring blank cells. Copy the function to   the range E3:E49.

 

Column F contains job titles and   departments. You want to separate the data into two columns.
 

  Select the range F2:F49 and convert text to columns using the comma delimiter   to separate
  the department names from the job titles. Click OK when prompted with There’s already data
here. Do you want to replace it?

2 Discussions and 3 Case Studies

Discussion 4.1 (Cyber)

Due: Initial Post due Wednesday, Replies due Sunday

Provide the requirements of the Sarbanes-Oxley Act.  Do you think this Act is good or bad?  Explain your answer and uses sources to support your points. 

Discussion 4.1 (Hacking)

Due: Initial Post due Wednesday, Replies due Sunday

What are some things you should consider when using Python as a Hacking tool?  Why?  What things should you avoid?  Why? 

Case Study ( Cyber Crime)

Due: Sunday, End of Module by 11:55 p.m. EST

  • Individual Paper:
    • In chapter 8 you should have read about the Federal Information Security Management Act (FISMA).  Assume that this Act hasn’t been enacted yet and you are the one that is in charge of either getting this Act passed or in charge of making sure this act doesn’t get passed (You are pro FISMA or against FISMA).  In a 4 to 5 page paper describe FISMA, list the pros and cons, and make a decision on your support or non-support for the act.  Make sure you follow APA format and cite all of your sources.
  • Team Presentation:
    • Build a PowerPoint presentation on what you just discussed in your paper about FISMA.  Your presentation should contain 10 to 20 slides including the title and reference slides.  When you present your project remember that you are trying to convince people to either approve or disapprove FISMA.

Writing Requirements: 

  • Team PowerPoint presentation 10-20 slides
  • 4-5 page paper in APA format, for citations and refereneces

Intro to Python Completion 

Due: Sunday, End of Module by 11:55 p.m. EST

Midterm Requirements

  • Individual Paper:
    • We will be completing the Intro to Python Primer. Your goal will be to write a 3 to 4-page paper where you discuss the use of Python in the field of Data Analytics.         

Writing Requirements: 

  • 4-5 page paper in APA format, for citations and references

Paper (Individual) Python Used in Hacking

  • Individual Paper:
    • Write a 3 to 4-page paper where you discuss the uses of Python in hacking. This will require you to find an article on the use of Python in Hacking and explain how the article covers the use of Python in the hacking process.       

Writing Requirements: 

  • 4-5 page paper in APA format, for citations and references

Types of Memory

Question 1

Application of Amdahl’s Law:

Answer the following two questions and show your work:

  1. What is the overall speedup if you make 15% of a program 85 times faster?
  2. What is the overall speedup if you make 85% of a program 15 times faster 

Question 2

Consider a dynamic RAM that must be given a refresh cycle 64 times per ms. Each refresh operation requires 150 ns; a memory cycle requires 250 ns. 

What percentage of the memory’s total operating time must be given to refreshes? Explain your answer and show your calculations.

Question 3

List and briefly define three newer nonvolatile solid-state memory technologies.

Question 4

What is the difference between DRAM and SRAM in terms of application? What is the difference between DRAM and SRAM in terms of characteristics such as speed, size, and cost? 

Item Inventory Inheritance C++

 

1 The Problem

This assignment deals with a program places items into separate inventories.

In this assignment, you will make use of inheritance–e.g., virtual functions. You will need to complete the Armour and Consumable classes.

1.1 Input

The program reads data from one file, items-0x.txt. Each line in this file represents one item. The first item on every line denotes the Item type–the remainder of the line varies by item type.

 Tool Pickaxe Diamond 100 1 Fortune 5
 Potion Speed-II-Potion Spd*2 1
 Food Tomato Hunger-10 2
 Tool Axe Stone 10 2 Unbreaking 2
 Armour Boots Diamond 100 10 Protection 3 lightning

Each Item type is denoted by a keyword:

  • Tool indicates a Tool object.
  • Armour and Armor indicate an Armour object.
  • Food, Potion, and Disposable indicate a Consumable object.

After the leading keywords, each line has a distinct structure:

  1. The remainder of a Tool line contains–in order–a name, material, durability, speed, enchantment, and enchantment level. Tool Items are not stackable.
  2. The remainder of a Armour line contains–in order–a name, material, durability, defense, enchantment, enchantment level, and element. Armour Items are not stackable.
  3. The remainder of a Consumable line contains–in order–a name, effect, and # uses. Consumable Items are stackable.

1.2 Output

If the program is run with the first provided input file, items-01.txt, the following output should be generated:

Processing Log:
(S) Speed-II-Potion
(S) Tomato
(S) PotatoCamera
(S) PotatoCamera
(S) Boots
(S) Boots

Player Storage Summary:
-Used 50% of 10 slots
 Nme: Speed-II-Potion
 Eft: Spd*2
 Use: 1
 Qty: 1

 Nme: Tomato
 Eft: Hunger-10
 Use: 2
 Qty: 1

 Nme: PotatoCamera
 Eft: ImageQuality-97%
 Use: 5
 Qty: 2

 Nme: Boots
 Dur: 100
 Def: 10
 Mtl: Diamond
 Mdr: Protection (Lvl 3)
 Emt: lightning

 Nme: Boots
 Dur: 100
 Def: 10
 Mtl: Diamond
 Mdr: FeatherFalling (Lvl 4)
 Emt: lightning

Note how there is no Tool output. The Tool class is not present in this assignment. The Tool class will be part of a future assignment.

Your output–including labels and spacing–must match the expected output. The easiest way to see generate the expected output is to run the sample executable solution I have provided.

Hint – each line of output in your display functions should probably start with two leading spaces.

To run this program with items-01.txt as input type:

./storage items-01.txt

(On a Windows system, you would omit the “./”. If you are running from Code::Blocks or a similar development environment, you may need to review how to supply command-line parameters to a running program.)

1.3 Your Tasks

The key abstractions employed in this program are Item, ItemStack, Inventory Armour, and Consumable.

Your overall task is to complete the Armour and Consumable ADTs.

  1. As an initial step, you will need to complete the Armour and Consumable Default Constructors:
    1. Set the stackable attribute–i.e., stackable.
      Hint Remember initializer lists?
    2. Set the name attribute–i.e., Item::name. The attribute, name, is a protected data member of Item.
  2. Implement Armour::clone and Consumable::clone.
  3. Implement Armour::read and Consumable::read.
  4. Implement Armour::display and Consumable::display.

You are expected to generate additional input files to test your code. Test your code throughly before submitting your solution.

1.3.1 Expected Initial Error Messages

If you run make without adding the missing read, clone, and display methods, you will see something simliar to

/usr/bin/ld.gold: the vtable symbol may be undefined because the class is missing its key function
Armour.cpp:14: error: undefined reference to 'vtable for Armour'
/usr/bin/ld.gold: the vtable symbol may be undefined because the class is missing its key function
Consumable.cpp:4: error: undefined reference to 'vtable for Consumable'
/usr/bin/ld.gold: the vtable symbol may be undefined because the class is missing its key function
Consumable.cpp:12: error: undefined reference to 'vtable for Consumable'
/usr/bin/ld.gold: the vtable symbol may be undefined because the class is missing its key function
collect2: error: ld returned 1 exit status
make: *** [storage] Error 1

While these errors may be intimidating, they are simply telling you to implement the necessary virtual functions for Armour and Consumable.

1.3.2 Testing Your Code

I have provided you a set of unit tests. In addition to your normal checks (e.g., running the completed program and performing head-to-head testing) run the unit tests with

make tests
./testNewClasses

You should see:

PASSED -> testDefaultArmourConstructor
PASSED -> testArmourCopyConstructor
PASSED -> testArmourClone
PASSED -> testArmourDisplay
PASSED -> testArmourRead
PASSED -> testDefaultConsumableConstructor
PASSED -> testConsumableCopyConstructor
PASSED -> testConsumableClone
PASSED -> testConsumableDisplay
PASSED -> testConsumableRead

2 Grading

In the grade report that you receive, you will see tests numbered 000 through 008.

  1. Test 000 evaluates your implementation of Armour::Armour()
  2. Test 001 evaluates your implementation of Armour::clone()
  3. Test 002 evaluates your implementation of Armour::display
  4. Test 003 evaluates your implementation of Armour::read
  5. Test 004 evaluates your implementation of Consumable::Consumable()
  6. Test 005 evaluates your implementation of Consumable::clone()
  7. Test 006 evaluates your implementation of Consumable::display
  8. Test 007 evaluates your implementation of Consumable::read
  9. Test 008 (System Test) evaluates all both classes–i.e., your solution as a whole–including output and output formatting.

Do not procrastinate.

3 Files

See Attachment 

4 Submitting

Files to Submit:

  • Armour.cpp–i.e., your version of the Armour ADT.
  • Consumable.cpp–i.e., your version of the Consumable ADT.

Portfolio Assignment

  

Portfolio Assignment 

Question One 

“Welcome onboard,” Oswald Cobblepot says. He’s the Chief Executive Officer of Digicom, a leader in international digital communications and you are the new associate counsel. 

This is your first day in the new spot.

Cobblepot doesn’t sit in your office, even though there is a chair. He clearly wants to tell you something. He leans in… “Listen, about a year ago, I started a blog on our external website. I call it Digital Bites! Get it? Digital Bites!” You smile…politely. It doesn’t help that he smells rather fishy. 

He continues, “You see, on this site, I would publish about once a week, and the topics would usually be tied to something going on at the company. We have been fairly careful to limit our topics to the same things that are in our press releases. You know, we just wrapped up that whole multi-year SEC investigation, so we wanted to be careful about what we are saying out there. In fact, we have always moderated the comments, just so we could control the message on the site further. In other words, if someone tried to say something bad, we would either delete that comment or we would never let it be posted on the blog. That’s where the problem has come in.”

“You see, last month we got sued in a class action about the deleted comments. Basically, the complaint says that we have been hiding information from our shareholders because we have been deleting truthful comments from the blog – or just not posting them. I have heard of spolcreation or something like that, but I don’t know what we should be doing to prevent it, or what we should say when the other side accuses us of this stuff. I mean, they are looking for these comments which never really appeared on the web. Who keeps those?” 

“Give me some advice about the steps we should be considering, but, I have a call in a few minutes, so just give me the high points.”

Then Cobbelpot says, “Oh yeah – I forgot to tell you about this.” You inwardly sigh and wait for Cobblepot to drop the other shoe.

“I was also asked if I have a e-mail retention system in place. I don’t want to do this because if I do then it will cost me hundreds of thousand dollars. I’m not Mr. Moneybags like that playboy, Bruce Wayne. How do you shysters do this sort of analysis? When is an email retention system justified and in what situations?”

You gently push back, tell him you need time to collect your thoughts and you promise him a memo. Cobblepot nods then waddles out. You turn to your computer and start a new document. What do you say? 

Question Two: 

You have just finished your memo for Cobblepot. It’s almost lunchtime, so you pull out your peanut butter and jelly sandwich, but as you look up, Edward Nigma is in your doorway. 

You’ve heard things about him and his penchant for riddles. He’s also your Chief of Security. “Do you have a minute to read this email?” You think, no, but say yes. “Oh, let me just show you.” 

Next thing you know, your sandwich has been tossed aside, and he’s at your computer, digging through your inbox. He clicks on a message from him. It opens to show a short message and an attachment, a video. “The video is surveillance footage from the garage, level G3 to be specific. It’s footage from last night, just watch this.” 

He clicks a button, and the video comes alive showing two shadowy figures breaking in to two cars. They reach inside and take something from each car and then take off running. “I don’t know who these people are, but I think they are the same people who assaulted Pamela Isley last week in the same parking garage. Even though she works with us in Security, Pamela’s filed a formal complaint  and is just being plain mouthy about how we have ‘mishandled’ her situation. She says she is putting us on notice. What does that mean? I think she’ll sue, but me and the other guys in Security thinks she’s nuts because she’s always about the environment so we’re not doing anything. Anyway, it just isn’t our fault. And we’ve told her that plenty of times.” 

Seeing the look on your face, Nigma laughs and says “Don’t worry. Most of us keep those conversations on our personal phones and pagers. So don’t worry about it. The company doesn’t have to do anything because the phones and pagers belong to us, not to the company. That’s how we worked around it. Hey! What’s black and white and red all over?”

You decide ignore the riddle (besides, you already know the answer to the riddle: it’s a newspaper) as you open your mouth to start to give advice as to how to handle this situation. What do you say?

Question Three: 

Shortly after Mr. Nigma leaves your office, Harvey Dent walks in. Dent is the senior associate general in charge of overseeing all litigation for the company. You also notice that he keeps flipping a coin up in the air constantly and wonder if that helps keep him balanced and relaxed. 

You ask him to sit, but he refuses. Instead he closes the door and begins… “I need to update you on a new case we have against Kord Industries. It’s basically a breach of contract action, but we are in federal court because of diversity jurisdiction.” 

“So basically,” Dent continues. “I need some advice on how to approach this matter with the judge. My initial pre-trial conference is in 25 days. I don’t practice much in federal court. The guy on the other side has already called me with questions about metadata preservation, whether I have an 30(b)(6) representative, blahblah, but I haven’t gotten him on the phone yet. I have already spent a lot of time with our vendor people and they seemed to know what metadata is even though I don’t – is that a new Microsoft application anyway? They seem to know what they are doing and I trust them plus if they make a mistake I can blame it on them. Right? If a vendor screws up, loses data, or whatever then the company isn’t held accountable. Right???” 

Then Dent stands up. “Besides I don’t know computers or metadata preservation so I won’t be held accountable. Heh-heh-heh. Heads or tails. I win. It’s a win-win situation! Hey, want to do happy hour with me and get two-faced?” 

You start to shake your head at Dent then you think better of it as you’re getting a sense that he may not be as balanced as he seems. Instead, you ask for a rain check on happy hour and promise to send him a memo that will help him organize his case (and more importantly – not get him in trouble with the judge). What is it you will say? 

Question Four: 

Oswald pops back in your office. “Oh no” you mutter under your breath.

Oswald cackles, “Enjoying your day?” Before you can respond, Oswald follows up with “Hey, I have two questions. Can you prepare a memo for me answering them? I’ve got to make my lunch appointment with Selina Kyle – she says she has a new business proposal for me. Man, she’s sly as a cat but when she has a good idea she usually has a good idea!” Then he hands you his handwritten notes before waddling off. 

1. Can destruction of records under a records retention policy before those records can be reasonably anticipated to be relevant to a particular future litigation constitute spoliation? If so, under what circumstances? 

2. Should a very short retention period for e-mail necessarily give rise to a presumption of spoliation? Why or why not? What steps can a party with such a short retention period take to defend its policy? 

Question Five

It’s nearly 6 pm and you’re anxious to get out. It’s time to catch up on the latest episodes on the Game of Thrones show. Curiously, you feel like that show is a reflection of your life in the law practice. 

This is not what you expected when you took that LSAT seminar in your last year of college. Plus, you’re not too sure about this city especially with the rumors of a large Bat that comes out at night. Then what about this character called the Joker; is this guy for real? This city just oozes weirdness. You miss Central City.

Then Dent walks in your office waving an article about Metropolis. 

You wonder if it’s about the flying guy that is apparently from another world. Now that’s the life! Flying; bulletproof; heat-vision; x-ray vision, can run faster than a speeding bullet, super-strength. And doesn’t he have some kind of a relationship with an Amazon goddess? 

No. The article is about how there is a court ruling from Metropolis has breathed new life in the social media debate. You quickly scan the article which talks about how attorneys collecting relevant social media evidence must be prepared to properly authenticate it. 

In this article, the criminal defendant argued on appeal that the government had properly failed to authenticate certain Facebook posts attributed to him because the government failed to produce any witness identifying the Facebook chat logs on the stand. He argued nothing in the contents of the message was uniquely known to the defendant and the defendant was not the only individual with access to the Facebook account issue. 

In addition, the court rejected government’s argument that Facebook posts were business records that may be “self-authenticated” by way of a certificate from a records custodian under Rule 902(11) of the Federal Rules of Evidence. Much of it can be, you suspect, attributed to the court’s inherent mistrust of social media evidence with all the “fake news” accusations flying around. 

Dent looks at you for your thoughts because he’s actually leading a case whose evidence rests on offering social media evidence for its evidentiary matter. He wants to know whether (1) authenticating social media is the same as traditional paper evidence under Federal Rule of Evidence 901; and (2) what are the various instances where social media will enjoy a strong likelihood of being deemed authenticated; and also (3) how should one consider preserving social media in the future? 

Exception Handling in Java

Please respond below with a minimum of 200 words and site your references.

 In addition to what we have learned from the course materials, there are  other ways to categorize exceptions in Java such as checked and  unchecked exceptions. Please conduct online research on these two  categories, share what you find. Of these two kinds of exceptions  (checked and unchecked), which method do you prefer? Which method is  easier? 

Design a simple mobile

 Instructions Part 1: Pseudocode and Flowchart You’ll create both pseudocode and a flowchart to design a mobile app. The app will write the device’s latitude and longitude to a file each time the device’s location changes. Use the techniques discussed in Section 3.3 and Chapter 10 of your textbook to write the latitude and longitude to the file as a record.
to create the flowchart. Write your pseudocode in a plain-text editor such as Notepad or TextEdit, and save as a text file (*.txt). Also, save a screenshot of your flowchart as a JPEG file (*.jpg). 

Temperature Converter

  

Temperature Converter
Objective
To practice using JavaScript expressions, control
structures, and operators
Instructions
For this lab you will need to create a javascript script which will prompt a user
to enter a temperature in either Fahrenheit or Celsius. Your script will then
need to determine which type of temperature was entered and then convert the
temperature to the other units and display that converted temperature for the
user.
When the user is prompted to enter a temperature with a prompt() statement
the user should be told to enter the units following the temperature as either F
or C (for example 98.6F). Your program will then need to determine which was
entered. If the user neglects to specify a unit, an error can be displayed in
place of the converted temperature.
To perform the conversion from Celsius to Fahrenheit: Multiply the Celsius temperature time 1.8 and add 32
(F = C * 1.8 + 32)
To perform the conversion from Fahrenheit to Celsius: Subtract 32 from the Fahrenheit temperature and then Multiply times .55
(C = (F – 32) * .55)

Artificial Intelligence Discussion

What is Machine Learning and what are the advantages and disadvantages involved with it?Please review how to create a podcast for your discussion boards because it is required! Use Audacity by clicking the links embedded below:

Audacity is a free, open-source, cross-platform software for recording and editing sounds. It is available for both Windows, Mac, GNU/Linux, and other operating systems.

Initial Discussion: 300 words

Responses 4 : Each 300 Word