Analyzing-And-Visualzing-Data.

/in /by

Initial Post

Kirk (2016) tells us that all requirements and restrictions of a project must be identified.  Select 1 key factor below and discuss why Kirk (2016) states it will impact your critical thinking and shape your ambitions:

  • People: stakeholders, audience.
  • Constraints: pressures, rules.
  • Consumption: frequency, setting.
  • Deliverables: quantity, format.
  • Resources: skills, technology

Reference: Kirk, Andy. Data Visualisation: A Handbook for Data Driven Design (p. 50). SAGE Publications

first student post

 

I chose “Resources: skills, technology” to discuss why Kirk states it will impact my critical thinking and shape my ambition.
Skills, you must take inventory of the available capabilities on the team. You may take inventory of yourself, on the personal capabilities that you possess. Not only offer what skills you have and what skills you don’t, but also which of these skills are you good at. What skills go you have available as a team and what weaknesses exist. Working as a team some skills can be compensated for or enhanced. By recognizing the available talent in the group, you should choose and place wisely to optimize available resources. The availability and optimal utilization (critical thinking) of skills can shape ambition.

Technology tools are plentiful for data visualization and becoming more and more holistic. Meaning there are some packages that will do almost everything, as a complete suite. In previous times, varying tools were used to accomplish different tasks. Different tasks entailed the many stages of prepping the data, developing the data, and visually presenting the data. Now technological tools accomplish almost every task. However, cleaning the data is sometimes a manual task and may require writing custom code in languages such Python and R. (The R Project for Statistical Computing, 2018)

Skills must be learned, enhanced, and adapted to ever changing technology. Skills must have the underlying principles that are developed as critical thinking when stepping though a process and knowing the correct and efficient direction. Having clear knowledge of data analysis principles allows ambition to grow, knowing you can accomplish the task. Possessing the skills (principle fundamentals and critical thinking), and technology allow you to “embrace the constraints” and “heighten your creative senses and lead to successful, innovative solutions”. (Kirk, 2016)

second student post

 

  • People: Stakeholders, audience  One of the most important parts of your stakeholder mapping is to identify the impact a stakeholder can have on the success of your project. Keep it simple. High or low is often enough. The impact that a stakeholder can have is a combination of two things; Their formal authority and also their ability to influence others. At the top of the tree of influence are Apex Stakeholders. They can influence other stakeholders without being easily influenced themselves. Make it your priority to find these people and bring them over to your point of view. Once you do, you will be able to use their influence as a lever to amplify your own.  Stakeholders are a major part of the project. Everything in a project should go the way they want and if not, it would be difficult for the people who worked on the project. These stakeholders can be really helpful in helping secure your future. The ideas and the works that have been found under the supervision of the stakeholders, benefits people and help them in a lot of ways.  Theories, concepts and models of audiences, stakeholders or publics, public relations and communication are important because they help us understand and explain our public relations campaigns and the situations these campaigns address. They determine how we plan and conduct public relations. Thus the different theories we hold will lead to different ways of planning and practicing public relations.

and   Assignment 2

 

Complete the “Police Killings” Exercise located at the following link:

http://book.visualisingdata.com/chapter/chapter-4

Working With Data

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

computer science

/in /by

Copyright Cengage Learning. Powered by Cognero. Page 1

Quiz 1: Name:____________________________________

1. For each user, Windows 10 can reserve a special area called a(n) ____ where each user can keep his or her own files. a. password b. Microsoft account c. log in d. locked 2. Which of the following is a set of instructions written for a computer? a. program b. Microsoft account c. log it d. password 3. A(n) ____ is an action you take with your fingertip directly on the screen, such as tapping or swiping. a. pointer b. log in c. gesture d. sign in 4. The Windows 10 desktop has controls, also known as its ____, that allow you to interact with the Windows 10 operating system. a. gestures b. tiles c. apps d. user interface 5. The Start menu includes variously-sized shaded rectangles, called ____ . a. icons b. tiles c. apps d. gestures 6. Each tile represents a(n) ____. a. app b. gesture c. icon d. gadget 7. At the bottom of the Windows 10 desktop is a bar called the ____, with buttons representing commonly used programs and tools. a. startup bar b. apps bar c. live bar d. taskbar 8. In Windows 10, a feature called ____ updates content in some Windows 10 apps. a. Windows updater b. live updates c. live tile d. live app 9. Windows apps are also known as ____ apps. a. universal b. static c. live d. traditional 10. ____ apps are fully-featured programs that may be available at an online store or on disk. a. Universal b. Static c. Desktop d. Single-user 11. Microsoft _____ is the new Microsoft web browser that lets you display and interact with webpages. a. WordPress b. Edge c. Webzilla d. Cortana 12. A pointing device controls the movement of the ____. a. status bar b. cursor c. taskbar d. mouse pointer

 

 

Copyright Cengage Learning. Powered by Cognero. Page 2

13. Clicking and double-clicking are two of the five _____. a. desktop actions b. pointing device actions c. pointing device apps d. operating system actions 14. The area below the title bar is called the ____ and it contains tabs, commands, and the Address bar. a. document window b. Ribbon c. taskbar d. Application bar 15. The area at the top of the window, which displays the name of the window, is called the ____. a. title bar b. App bar c. taskbar d. options bar 16. ____ are groupings of buttons and other controls you use to interact with an object or a program. a. Pointers b. Tabs c. Apps d. Files 17. Buttons act as ____, which instruct Windows to perform tasks. a. select statements b. pointers c. commands d. gestures 18. The ____ shows the name and location of the item you have open. a. taskbar b. address bar c. title bar d. status bar 19. You can ____ a desktop icon, such as the Recycle Bin, by left-clicking it with the mouse pointer and dragging it. a. move b. delete c. duplicate d. organize 20. ____ also work well on tablets and phones. a. Windows apps b. Desktop apps c. Charms d. Operating apps 21. Some smaller desktop apps, called Windows ____, such as Paint, come already installed in Windows 10. a. utilities b. operating apps c. accessories d. default apps 22. The Windows ___ is an app that lets you find all kinds of apps for use on Windows personal computers, tablets, and phones. a. Deal b. Try c. Swap d. Store 23. When you start an app, its _____, a frame displaying the app’s tools, opens. a. dialog box b. icon c. window d. rectangle 24. Buttons are often organized on a ____ into tabs, and then into groups. a. Ribbon b. panel c. palette d. status bar

 

 

Copyright Cengage Learning. Powered by Cognero. Page 3

25. Most buttons open menus and some open ____. a. submenus b. dialog boxes c. panels d. apps 26. In the Paint program, the white drawing area is called the ____. a. paper b. artboard c. workspace d. canvas 27. You can use the Windows 10 ____ app to learn more about help options. a. Support b. Technical Help c. Getting Started d. Info 28. When shutting down the computer, after clicking Start buton, you then click ____ for a list of shut down options. a. Power b. Options c. Exit Windows d. Controls 29. Which option for ending a Windows 10 session completely turns off the computer? a. Shut down b. Exit c. Log off d. End 30. Which button on the desktop do you click to examine your existing folder and file structure? a. Internet Explorer b. File Explorer c. Windows Explorer d. Desktop Explorer 31. A ____ is a three- or four-letter sequence, preceded by a period, that identifies the file type. a. filename b. file extension c. file suffix d. file property 32. In the Save As dialog box, below the Address bar, the ____ contains command buttons that you can click to perform actions. a. navigation bar b. taskbar c. File list d. toolbar 33. __________ is a Windows 10 program that creates files in RTF format. a. Explorer b. FileMaker c. WordPad d. Paint 34. What is the typical drive letter for the hard drive? a. A: b. B: c. C: d. D: 35. A USB Flash drive is a(n) ____ disk. a. floppy b. hard drive c. internal d. removable 36. When you view the File list on the C: drive, you will see the ____ folder. a. Users b. People c. Creators d. Files 37. The Documents folder is in the ____ folder. a. Users b. My Files c. My Computer d. People

 

 

Copyright Cengage Learning. Powered by Cognero. Page 4

38. The set of appearance choices for files and folders is known as the ____. a. Hierarchy b. View c. Design d. Order 39. Windows 10 offers eight different ____ for viewing your files and folders. a. styles b. designs c. themes d. layouts 40. The Sort by button allows you to sort your files using several ____. a. criteria b. lists c. languages d. prompts 41. While looking at your list of files and folders, you can also preview them without ____ them. a. deleting b. copying c. opening d. closing 42. Which tab in Windows do you use to open a file? a. New b. File c. Open d. Edit 43. Making changes to a document is also known as ____. a. processing b. editing c. fixing d. changing 44. When you save an existing file, the ____ dialog box does not open. a. New b. Exit c. Save As d. Save 45. If you open a file and make changes to it and then save the changes, that file has been ____. a. edited b. duplicated c. formatted d. saved as another file 46. A copy or replacement of a file is known as a(n) ____. a. extra b. double c. dupe d. backup 47. When you copy a file, a duplicate remains on the ____. a. clipboard b. flash drive c. hard drive d. desktop 48. In File Explorer, the New Folder button is in the New group on the ____ tab on the Ribbon. a. Edit b. Home c. File d. New 49. When you cut and paste a file, you are actually ____ it. a. deleting b. storing c. moving d. copying 50. To rename a file in File Explorer, click the Rename button in the ____ group. a. File b. Naming c. Filter d. Organize

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

For Kenzym04

/in /by

1. List the seven OSI layers in the indicated sequence where layer 7 is closest to the end user.

Layer 7:

Layer 6:

Layer 5:

Layer 4:

Layer 3:

Layer 2:

Layer 1:

2. Compare the total number of links in an 11 node network for:

a) Mesh Topology

b) Star Topology (counting the hub as one of the nodes)

c) Ring Topology

d) Bus Topology

3. Which OSI layer, by number or name, is most applicable to the following? (Note: All layers are represented at least once)

__________ a) Addressing messages between two processes

__________ b) Bits:

__________ c) Congestion control:

__________ d) Determine where a frame starts and ends

__________ e) Frames

__________ f) Internet browsers

__________ g) Establishing, maintaining, and terminating a Session:

__________ h) Translation between different coding systems

__________ i) Route Determination

__________ j) Interface to transmission media

4. Use the OSI Model Learning Object to determine which OSI layer, by number or name, is most applicable to the following protocols.

(Note: All layers are represented at least once)

___________a) CDR – Common Data Representation

___________b) IPSec – Internet Protocol Security Protocol

__________ c) WEP – Wired Equivalent Privacy

_________ d) PAP – Password Authentication Protocol

__________ e) SMTP – Simple Mail Transfer Protocol

__________ f) TLS –Transport Layer Security

__________ g) SSH – Secure Shell

__________ h) X.21:a – a specification for serial communications over synchronous lines

1

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Write A Proposal For A Visual Basic Project

/in /by

Application Design Documentation

Your assignment is to create initial design documentation for a proposed final application project. Your final project for this class will require building a complete application of your choosing and design in Visual Studio. The application may be written in either Visual Basic, Visual C#, or a combination of both languages.

 

Your final project must be a Windows application that involves at least five (5) of the programming techniques used in this class. You must use the .Net Framework classes and create derived classes from them (counts as one technique). The other four (4) techniques are up to you.

For example, you could use forms, data validation, structures, and animation. While you have not yet covered all of the techniques, you now have a good idea of the kind of skills you will gain in the course. Providing this proposal now allows you to work on the project while you are completing the course.

 

This assignment creates the proposal and design document for your final project in this class. Submit the document in a Word-readable format (.docx, .doc, .rtf, .txt). The following tasks should be outlines in your design document.

 

State the application you wish to create for your final project. Justify why you feel this application will effectively demonstrate your programming skill. List and describe the five (5) techniques you will demonstrate through creating the application. This means writing the name of the technique, stating and discussing why you believe it is important, and describing how you will implement the technique.

NOTE: Think about what you can do and how much time it will take. How can you create an interesting application quickly and easily? Think seriously about what coding tasks were easy or interesting for you versus what tasks you disliked. Your goal is to design a practical project that you can complete during this course.

 

DO NOT PROPOSE OR SUBMIT A PROJECT FROM THE TEXTBOOK!

Please submit your design document to your instructor for grading.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

Assignment-ACCESS DataBase

/in /by

I already have the solution Manual to this attached (I need this translated in Access Database with different screenshots. Final Solution should include an Access DB file and all quetions answered in Word (in own words)with screenshots)

San Juan Sailboat Charters (SJSBC) is an agency that leases (charters) sailboats. SJSBC does not own the boats. Instead, SJSBC leases boats on behalf of boat owners who want to earn income from their boats when they are not using the boats themselves, and SJSBC charges the owners a fee for this service. SJSBC specializes in boats that
can be used for multiday or weekly charters. The smallest sailboat available is 28 feet in length, and the largest is 51 feet in length.

Each sailboat is fully equipped at the time it is leased. Most of the equipment is provided at the time of the charter. The majority of the equipment is provided by the owners, but some is provided by SJSBC. Some of the owner-provided equipment is attached to the boat, such as radios, compasses, depth indicators and other instrumentation, stoves, and refrigerators. Other owner-provided equipment is not physically attached to the boat, such as sails, lines, anchors, dinghies, life preservers, and equipment in the cabin (dishes, silverware, cooking utensils, bedding, and so on). SJSBC provides consumable supplies such as charts, navigation books, tide and current tables, soap, dish towels, toilet paper, and similar items. The consumable supplies are treated as equipment by SJSBC for tracking and accounting purposes. Keeping track of equipment is an important part of SJSBC’s responsibilities. Much of the
equipment is expensive, and those items not physically attached to the boat can be easily damaged, lost or stolen. SJSBC holds the customers responsible for all of the boat’s equipment during the period of their charter.
SJSBC likes to keep accurate records of its customers and charters, and customers are required to keep a log during each charter. Some itineraries and weather conditions are more dangerous than others, and the data from these logs provides information about the customer experience. This information is useful for marketing purposes, as well as
for evaluating a customer’s ability to handle a particular boat and itinerary. Sailboats need maintenance (two definitions of boat are: (1) “break out another thousand” and (2) “a hole in the water into which one pours money”). SJSBC is required by its contracts with the boat owners to keep accurate records of all maintenance activities and costs.

A. Create a sample list of owners and boats. Your list will be similar in structure to that in Figure 1-30, but it will concern owners and boats rather than owners and pets. Your list should include, at the minimum, owner name, phone, and billing address, as well as boat name, make, model, and length.

B. Describe modification problems that are likely to occur if SJSBC attempts to maintain the list in a spreadsheet.

C. Split the list into tables such that each has only one theme. Create appropriate ID columns. Use a linking column to represent the relationship between a boat and an owner. Demonstrate that the modification problems you identified in part B have been eliminated.

D. Create a sample list of owners, boats, and charters. Your list will be similar to that in Figure 1-31. Your list should include the data items from part A as well as the charter date, charter customer and the amount charged for each charter.

E. Illustrate modification problems that are likely to occur if SJSBC attempts to maintain the list from part D in a spreadsheet.

F. Split the list from part D into tables such that each has only one theme. Create appropriate ID columns. Use linking columns to represent relationships. Demonstrate that the modification problems you identified in part E have been eliminated.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

I Need Help With My Final Project For My “CIS 10 – Computer Literacy”

/in /by

SIMnet 2016: Word, Excel, and Access Integrated Project 2

1 | P a g e Last Modified: 9/27/17

Office 2016 Integrated Applications – Project 2 Creating a Company Report In this project, you will create a company report for the Top’t Corn popcorn company using resources an Access

database and two Excel files. First, you will format the Word document, applying a theme, applying styles and text

formatting, formatting a table, and applying list formats. You will enter document information and add a cover page.

Next, you will add a header and add page numbers to the report using Word’s built-in building blocks. Next, you will

import data from Excel into an Access database and then create two queries based on that imported data. You will

export the query results to a new Excel workbook where you will add formulas and create a table and a chart. Finally,

you will copy and paste the chart and table data from Excel into your Word document.

Skills needed to complete this project:

Word Skills

• Change the theme and color theme

• Apply heading styles

• Apply character formatting

• Create numbered and bulleted lists

• Display text in columns

• Add a row to a table

• Enter data in a table

• Apply a table Quick style

• Change document information

• Insert a cover page

• Add a header

• Add page numbers

• Paste data from Excel

• Change font color

• Paste a chart from Excel

Access Skills

• Add records to a table by importing from Excel

• Rename a field

• Create a simple select query to combine fields from multiple tables

• Add text criteria to a query

• Add date criteria to a query

• Apply multiple criteria to a query

• Add numeric criteria to a query

• Specify a sort order in a query

• Export data from a query to Excel

Excel Skills

• Enter text and numbers in cells

• Create a formula using multiplication

• Use an absolute reference in a formula

• Copy a formula

• Format data as a table

• Sort data in a table

• Use the AVERAGE function in a formula

• Use the SUM function in a formula

• Apply a number format

• Modify the font size

• AutoFit columns

• Create a PivotTable using a Recommended PivotTable

• Create a pie chart

• Hide the chart title

• Apply a chart style

• Display chart data labels

IMPORTANT: Download the resource file needed for this project from the Resources link. Be sure to extract the file after downloading the resources zipped folder. Please visit SIMnet Instant Help for step-by-step instructions.

1. Open the start file OF2016-Integrated-Project2. If the document opens in Protected View, click the

Enable Editing button in the Message Bar at the top of the document so you can modify it.

2. The file will be renamed automatically to include your name. Change the project file name if directed to do

so by your instructor, and save it.

Step 1

Download start file

 

 

SIMnet 2016: Word, Excel, and Access Integrated Project 2

2 | P a g e Last Modified: 9/27/17

3. Apply and theme and change theme colors.

a. Apply the Slice theme to the document.

b. Change the color theme to the Orange Red theme.

c. Change the font theme to the Calibri theme.

4. Format text in the document.

a. Apply the Heading 1 style to the Overview and Goals headings on the first page of the document.

b. Apply the Heading 2 style to the Brick and Mortar Stores and the Food Truck Locations headings on page 2

of the document.

c. Scroll to the Our Top’t 4 Sellers section and bold the following words at the beginning of each line:

Original Blend, Old Bay, Sea Salt and Caramel, and Truffle.

d. Convert the four items in the Our Top’t 4 Sellers section into a numbered list using the 1), 2), 3) format.

e. Scroll to the Future Flavors section and bold the following words at the beginning of each line: Choco

Mocha, Raspberry Delight, Key Lime, and Spicy Buffalo.

f. Convert the four items in the Future Flavors section into a bulleted list using the four diamond format.

g. Select the text below the Brick and Mortar Stores heading (from Montgomery Mall to M&T Bank Stadium)

and change the text so it appears in two columns.

h. Select the text below the Food Truck Locations heading (from Farragut Square to National Mall West) and

change the text so it appears in two columns.

5. Work with a table in the document.

a. Navigate to the table in the Pricing section.

b. Add a row to the end of the table.

c. Type Gift Packaging in the first cell of the new row.

d. Type $2 in the second cell of the new row.

e. Change the Table Quick Style options to only show Quick Styles with a header row. Apply a Grid Table

4 – Accent 1 Quick Style to the table. It is in the Grid Styles section of the gallery.

6. Add document information and insert a cover page.

a. Display the Info page in Backstage view and add The Top’t Corn Report as the title of

the document.

b. Add Top’t Corn Company as the company.

c. Add Poppy Cunningham as the author.

d. Return to the document and place the cursor at the beginning of the Overview heading.

e. Insert a cover page using the Austin option.

f. Delete the abstract control at the top of the page (the text control beginning with Draw you reader in…).

g. Click the Document Subtitle control and type Gourmet Popcorn with Capitol

Toppings

 

 

 

SIMnet 2016: Word, Excel, and Access Integrated Project 2

3 | P a g e Last Modified: 9/27/17

7. Add a header and page numbers to the document.

a. Place the cursor at the beginning of the Overview heading.

b. Add a header using the Sideline option.

c. Add page numbers to the bottom of the document using the Accent Bar 3 option.

d. Verify that the header and footer text does not appear on the cover page.

e. Close the Header and Footer view when you are done.

8. Open the Top’t Corn Sales Database Access file from the location where you saved the data files

for this project. (Downloaded from the Resources link.)

a. Import records from the Excel file Nov4Sales (located with the data files for this project) and append a

copy of the records to the OnlineSales table. (Hint: After the import, there should be 133 records in

the OnlineSales table.)

b. In the OnlineSales table, rename the ID field: OnlineSaleID

9. Create a query to display sales of Old Bay flavored popcorn from buyers in Maryland and then export the

query results to an Excel file.

a. Include the following fields in this order: OnlineSaleID, Date, Quantity, and State fields from the

OnlineSales table and the ItemName field from the Items table.

b. Add criteria to the query to limit the results to records where the Item Name is Old Bay, the State is

MD, and the Date is greater than or equal to November 1, 2016. Run the query to check your work.

(Hint: There should be 8 records in the query results.)

c. Return to Query Design view and hide the ItemName and State fields in the query results.

d. Run the query again to check your work.

e. Save the query as OldBayMDQry and then close the query.

f. Export the results of the OldBayMDQry to a new Excel file named: OldBayMDSales Do not export

the data with formatting and layout. Save the file with the other resources for this project.

10. Create a query to display sales of truffle flavored popcorn with a quantity greater than six from the

OnlineSales table.

a. Include the following fields in this order: State and Quantity from the OnlineSales table and

ItemName field from the Items table.

b. Add criteria to the query to limit the results to records where the Item Name is Truffle and the

Quantity is greater than 4.

c. Specify the sort order in the query, so the results are sorted alphabetically by state. Run the query to

check your work. (Hint: There should be 17 records in the query results.)

d. Save the query as HighQuantityTruffleQry and close it.

 

 

 

SIMnet 2016: Word, Excel, and Access Integrated Project 2

4 | P a g e Last Modified: 9/27/17

e. Export the results of the HighQuantityTruffleQry to a new Excel file named:

HighQuantityTruffleSales . Do not export the data with formatting and layout. Save

the file with the other resources for this project.

f. Close any open database objects and then close the database and exit Access.

11. Open the OldBayMdSales Excel file you just created and create a table to copy into Word.

a. In cell D1, type: Total Sale

b. In cell A11, type: Price per Box

c. In cell B11, type: $9.00

d. In cell D2, enter a formula to calculate the total sale. Multiple the quantity sold (cell C2) by the price per

box (cell B11). You are going to copy this formula to cells D3:D9, so use relative and absolute references

as appropriate.

e. Copy the formula in cell D2 to cells D3:D9.

f. Format the data in cells A1:D9 as a table using any style.

g. Sort the table data by quantity so the largest value is at the top.

h. In cell A12, type: Average Quantity

i. Enter a formula in cell B12 to calculate the average of cells C2:C9.

j. In cell A13, type: Total Sales

k. Enter a formula in cell B13 to calculate the sum of cells D2:D9.

l. Apply the Currency number format to cell B13.

m. Select cells A1:D9 and change the font size to 14.

n. Autofit all columns so the data are completely visible.

o. Save Excel file.

p. Copy cells A1:D13. Do not close the Excel file.

12. Return to the Word document and use the Paste Special command to paste data.

a. Place the cursor in the blank line under the first paragraph in the Maryland Sales of Old Bay Flavor section.

b. Paste the copied Excel data using Keep Source Formatting option into the document.

c. Return to Excel and close the OldBayMdSales file.

13. Open the HighQuantityTruffleSales Excel file you created in step 10. e. and create a chart from the data.

a. Create a PivotTable from the data. Use the first (only) recommended PivotTable – Sum of Quantity

by State.

b. Create a 2-D pie chart from the PivotTable data.

c. Hide the chart title.

d. Apply the chart Quick Style Style 4.

e. Display chart data labels using the inside end option.

 

 

 

SIMnet 2016: Word, Excel, and Access Integrated Project 2

5 | P a g e Last Modified: 9/27/17

 

f. Save the file.

g. Copy the chart. Do not close the Excel file.

14. Return to the Word document and paste the chart.

a. Place the cursor in the blank line under the first paragraph in the Sales by State for Truffle section.

b. Paste the chart you copied from Excel into the document. Use the Keep Source Formatting &

Embed Workbook paste option.

IMPORTANT: If you receive an error message similar to “Word cannot obtain the data for the {00020830-

0000-C000-000000000046} link.”, make sure that you have extracted the HighQuantityTruffleSales Excel

workbook from the resources zip folder and open the workbook from the extracted folder, save your Word file,

and then try again.

c. Save and close the document.

d. Return to Excel and close the HighQuantityTruffleSales file.

15. Upload and save your project file.

16. Submit project for grading. Step 2 Upload & Save

Step 3

Grade my Project

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

2-1 Scenario Activity: Gathering Information

/in /by

Based on your selected scenario from Hands-On Database, complete the “To Do” activities described at the end of Chapters 2 and 3 of the textbook. Your response should be submitted as a Word document.

For additional details, please refer to the Scenario Rubric document in the Assignment Guidelines and Rubrics section of the course.

 

I have attached the information you will need to complete the assignment. I completed my scenario on wildwood apartments. You would only need to complete that section. I have attached the PDF if you would like to read about wildwood apartments.

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

4 2-3 Pages Assignment

/in /by

Chapter 11 of your textbook, Managing and Using Information Systems: A Strategic Approach, provides an overview of knowledge management and business intelligence as they relate to organizational decision making. Read Case Study 11-2, “Business Intelligence at CKE Restaurants,” on pages 348–349 in the textbook and answer all three questions regarding CKE Restaurants’ (Hardee’s Restaurant parent company) decision to promote and distribute the Monster Thickburger based on insights derived from their business intelligence system:

  • How does the business intelligence system (BIS) at CKE add value to the business?
  • What are some tips for developing and using the BIS described in this case?
  • Was the introduction of the Monster Thickburger a good idea or an example of information leading to a wrong decision?
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

SQLAlchemy- Climate Analysis And Exploration

/in /by

To begin, use Python and SQLAlchemy to do basic climate analysis and data exploration of your climate database. All of the following analysis should be completed using SQLAlchemy ORM queries, Pandas, and Matplotlib.

  • Use the provided starter notebook and hawaii.sqlite files to complete your climate analysis and data exploration.
  • Choose a start date and end date for your trip. Make sure that your vacation range is approximately 3-15 days total.
  • Use SQLAlchemy create_engine to connect to your sqlite database.
  • Use SQLAlchemy automap_base() to reflect your tables into classes and save a reference to those classes called Station and Measurement.

Precipitation Analysis

  • Design a query to retrieve the last 12 months of precipitation data.
  • Select only the date and prcp values.
  • Load the query results into a Pandas DataFrame and set the index to the date column.
  • Sort the DataFrame values by date.
  • Plot the results using the DataFrame plot method.
  • Use Pandas to print the summary statistics for the precipitation data.

Station Analysis

  • Design a query to calculate the total number of stations.
  • Design a query to find the most active stations.
    • List the stations and observation counts in descending order.
    • Which station has the highest number of observations?
    • Hint: You will need to use a function such as func.min, func.max, func.avg, and func.count in your queries.
  • Design a query to retrieve the last 12 months of temperature observation data (TOBS).
    • Filter by the station with the highest number of observations.
    • Plot the results as a histogram with bins=12.
 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!

IFT 201 HW3

/in /by
[IFT 201] Computer and Network Systems: Organization and Administration

Lab 3: Character Encoding

Score: 60pts

Introduction

As discussed, every kinds of data in a computer must be represented by a sequence of 1s and 0s (binary system). The manner in which these electronic data are converted to a form meaningful to humans depend on the coding system used by the computer.

So the myriad data forms have to be represented using only 1s and 0s; including text, numbers, sounds, colors, still pictures, moving pictures, etc.

· How are characters represented?

A character “mapping” assigns a number to each character, and then this assigned number is encoded in binary. For example, a very simple mapping scheme might assign 1 to A, 2 to B, etc. A computer would then store B as 10, the binary representation of 2.

· Which mapping to use?

It took a long time for the computer industry to stop using many different mappings:

· IBM mainframes used EBCDIC,

· Control Data Corporation (CDC) supercomputers used their own system

· Digital Equipment Corporation (DEC) and other smaller companies used ASCII.

The breakthrough coincided with the introduction of PC in 1981, which used ASCII even though it was an IBM.

ASCII has grown ever since to become practically one of the only two character mappings used today (the other being Unicode).

Background

Read the ASCII character set and text representation from any of the following sources:

· Hand-outs, section 2.6

· Online resources

Download and extract the provided programs:

· ASCII Converter v3.1: ASCIIv3_1.zip

· Text to Binary converter: btt_0.3.zip

· If you don’t have a Windows system, you’ll need to use virtual box with a Windows VM

The ASCII converter can convert plain text to hex and back using the standard ASCII character set. For example, type E0 in the “Hexadecimal” area and click on “Convert”, you’ll see à in the “Plain Text” area.

image1.png

The Text to Binary converter program makes it easy to type in some text and have the computer translate all of it to binary using the ASCII character mapping. The (binary) output is a string of binary numbers separated by spaces, each representing an ASCII value. The screenshot below provides an example.

Note that inside the computer’s memory, there are no spaces between the seven-bit chunks that represent each character.

Most computers today store one ASCII character in a byte, which is 8 bits, not 7. The ASCII character set was extended to include 128 extra characters, many of them for PC graphics.

image2.png

Activities

For these activities, you can use any or a combination of the two programs.

1. Convert decimal 100 to hex: ________________

Type the hex representation into the bottom area of the ASCII Converter program

Write down what you see: ______________

2. Do the same for 68

68 = ________ hex

ASCII __________

3. What relation do the above two numbers have?

4. Do as in 1) for

a) 101 and 69

b) 102 and 70

Write down the codes and the characters you see

5. What conclusion can you draw about how upper- and lowercase characters in ASCII are represented, based on your experiments?

6. If you were writing a function to capitalize text for a word-processing program, what simple transformation would you make to the character codes to capitalize a letter?

7. What does ASCII code 241 look like? What language uses this character?

Provide a screenshot

8. We’ll now see how the computer stores your ASU username.

Write down its binary conversion. Also provide a screenshot

Provide its decimal representation.

9. Provide the decimal representation for each of the following characters: ç, é, $, £

Be sure to provide the screenshot of your initial step

Deliverables

Editing

Prepare your deliverable using this lab document as followed:

1. Answer all the questions in the “Activities” section, illustrating your work with screenshot whenever applicable.

Submission

1. Save your file as lab3_<YOUR USERNAME>.docx. Replace <YOUR USERNAME> with your ASURITE username. If you’re not using MS Word (for example, if you’re using Mac), please submit a PDF document.

2. Be sure to include your full name on every page. You can insert it in the header, on above the “IFT 201” banner.

3. Upload your file to Blackboard.

Page 2

 
Do you need a similar assignment done for you from scratch? Order now!
Use Discount Code "Newclient" for a 15% Discount!