analyzing and visualizing data

 Select any example visualization or infographic and imagine the contextual factors have changed:

  1. If the selected project was a static work, what ideas do you have for potentially making it usefully interactive? How might you approach the design if it had to work on both mobile/tablet and desktop?
  2. If the selected project was an interactive work, what ideas do you have for potentially deploying the same project as a static work? What compromises might you have to make in terms of the interactive features that wouldn’t now be viable?
  3. What about the various annotations that could be used? Thoroughly explain all of the annotations, color, composition, and other various components to the visualization.
  4. What other data considerations should be considered and why? 
  5. Update the graphic using updated data, in the tool of your choice (that we’ve used in the course), explain the differences.

 Be sure to show the graphic (before and after updates) and then answer the questions fully above.  This assignment should take into consideration all the course concepts in the book.  Be very thorough in your response.  The paper should be at least three pages in length and contain at least two-peer reviewed sources. 

In the Resources section of Blackboard

      

INTRODUCTION: In the Resources section of Blackboard, there are links for installing Visual Basic 2010 Express Edition, and for downloading the data files you need for this course. Do those two things first before starting on this lab assignment. (Note: you can also use Visual Basic 2010 from Visual Studio 2010 for these assignments, although the interface might be slightly different.)

ASSIGNMENT:

1) Exercise 9, steps b and c, on page 298-299 of the lab textbook, “Clearly Visual Basic”, at the end of Chapter 16. You will use the experience you have gained so far in this class to create an application. Create the application as instructed, and make the following changes:

a. Enlarge your form if necessary. In the bottom center area of the form, add a label with the Text property, Designed by, followed by your name.

b. Add a button between the Calculate and Exit buttons, with the text “Clear”, and code it to clear the two input text boxes and the output labels.

c. Put five comment lines at the top of the code page, listing:
‘Project Name: Water Bill Project
‘Class: CINS 113-nn [section number]
‘Programmer: [your name]
‘Date: [date last modified]
‘Purpose: [1- or 2-line description of program]

d. Put brief comments in all sub procedures, explaining what that section does: the button click procedure, the sub procedure for making the calculations, the sub procedure for displaying the results, as well as the Clear button and the Exit button sub procedures.

e. Declare the rate of .00205 dollars per gallon as a constant.

f. The variables for Current reading, Previous reading and Gallons used should be integers.

g. Your message box for invalid input should include these things:

i. The message should include the numbers the user entered, for example: “ERROR: Current reading (2000) cannot be less than Previous reading (3000).”

ii. The title bar text should say “Invalid Input”.

iii. The message box button should say “OK”.

iv. The message box icon should be the Error icon.

h. The output for the total charge should be displayed in currency format.

i. Run the program, entering 8450 as the Current reading, and 6225 as the Previous reading. Click Calculate, then take a screen shot of the form, paste it at the end of this document, and press ENTER twice.

j. Clear the text boxes, and run the program again, entering 8450 as the Current reading, and 8995 as the Previous reading. Before you click Calculate, take a screen shot of the form, paste it at the end of the document and press ENTER twice.

k. Then click Calculate. A message box should pop up with an invalid input error message. Take a screen shot of the message box and paste it at the end of this document.

l. Go to Code View for your form, copy all the code (using Edit / Select All and Edit / Copy, or CTRL-A and CTRL-C), and paste it at the end of this document (using Edit / Paste or CTRL-V).

m. You do not have to do step 9a, listing output, input and processing items and a pseudocode algorithm.

2) At the top of this page, replace the line after “Student’s name” with your name.

3) Click the Office Button, Prepare, and Properties, and type your name as the Author, and CINS 113 as the Subject. Close the Document Properties area by clicking the X at the right end of the yellow bar.

4) Save this Word document. Close the document.

5) In Blackboard, go to Session #8 in Class Sessions when it is made available, and click on the View/Complete Assignment link.

6) Attach this file (CINS 113 VB Midterm Project.doc) and click Submit.

HINTS:

1) To restrict a text box to accepting only certain characters, see page 190, Coding the KeyPress event procedure

2) To exit, see Chapter 4

3) Suggestion: pass the gallons used and total charge variables to the sub procedures by reference

NOTES:

1) Any time you make changes to your Visual Basic program, you should use File / Save All to save all files associated with your program.

2) In Blackboard, you can check to see if your file was submitted correctly. Go to My Grades, and in the column for this Lab, there should be a white exclamation mark on a green background. Click on the exclamation mark, and open up the submission page. Right-click on the link for your file, and see if it opens correctly. If not, contact your instructor immediately and ask for your attempt to be cleared.

CHECKLIST FOR SUBMITTING THE ASSIGNMENT:

· You have entered your name at the top of this document after “Student’s name”

· In the Properties area, you have entered your name as the Author, and CINS 113 as the Subject

· You have attached this file, CINS 113 VB Midterm Project.doc, using the Blackboard View/Complete Assignment link

· You are ready to click Submit

· Check your file submission using the instructions in the Note section above

In this excise, you code an application that calculates a water bill. 
The clerk at the water department will enter the current meter reading and the previous meter reading in two text boxes. 
The application shuold calculate and display the number of gallons of water used and the total charge for the water. 
The charge for water is 2.05 per 1000 gallons, or .00205 per gallon. 
Use two independent Sub procedures: one to make the calculations and the other to display the results. 
Call both Sub procedures from the Calculate button's Click event procedure. 
Make the calculations only when the current meter reading is greater than or equal to the previous meter reading; 
otherwise, display an appropriate message in a message box.
Step B:
Create a visbual basic windows application. Use the following names for the solution and project, respectively: 
Water Bill Solution and Water Bill Project. Save the application in the ClearlyVB2010/Chap16 folder. 
Change the name of the form file on your disk to frmmain.vb. If necessary, change the form's name to frmMain.
Step C: Create the interface shown in Figure 16-24 and then code the application. Be sure to code each text box's KeyPress and TextChanged Event procedures.
Save the solution and then start and test the application. Close the Code Editor window and then close the solution.

Exp22_Excel_Ch01_CumulativeAssessment

 Exp22_Excel_Ch01_CumulativeAssessment

  

Project Description:

You manage a company that provides corporate training workshops. Your two types of clients are business people and college professors. You want to complete a spreadsheet that calculates gross revenue for upcoming training workshops. Finally, you will improve the appearance of the worksheet by applying font, alignment, and number formats.

     

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

 

Your organization provides a   discount to educators. However, the worksheet contains wording that needs to   be changed to Education.
 

  Use Find and Replace to find Teacher and replace it with Education.

 

The worksheet contains spelling   errors that need to be corrected.
 

  Check the spelling of the worksheet and correct the errors.

 

You canceled the Charting Basics   workshop because only one person registered for it.
 

  Delete the row containing the Charting   Basics workshop.

 

The Excel Analytics &   Forecasting training course filled, and you opened another course.
 

  Insert a new row between the Big Data   Foundations and Data Mining   rows. Copy row 5 and paste it on the empty row. Change the dates to June 7, 2024 in the range C7:D7. Enter 11 in cell G7 and 10 in cell H7.

 

 

Assigning a code to each   workshop provides a reference number. You will use 06 to indicate the sixth   month (June) and 001 for the first workshop.
 

  Type 06-001 in cell A5. Use AutoFill to   complete the range A6:A10.

 

Instead of displaying dates such   as 6/3/24, you want to display dates as 6/3/2024.
 

  Format the dates in the range C5:D10 with Short Date format (or *3/14/2012   from the Type list).
 

Note, Mac users, select 3/14/2012   as the format.

 

The worksheet contains columns   for the start and end dates. It would be helpful to insert a column to   display the number of days for each workshop.
 

  Insert a column to the right of the End Date column. Type # of Days in cell E4.

 

 

Row 3 contains # of Attendees and Gross Revenue main headings. Centering   these headings over their respective subheadings will help clarify the   details.
 

  Merge and center the cells H3 and I3. Merge and center the range J3:L3.
 

 

Applying a cell style will   improve the appearance of the headings on row 4. In addition, wrapping and   centering the text in the heading cells will further improve the appearance   of the worksheet.
 

  For the range A4:L4, apply the Good cell style, wrap text, and center   horizontally.

 

 

You are ready to calculate the number of days for the workshops.
 

  In cell E5, enter a formula to calculate the number of days for the first   workshop. Add 1 to the results to include the total number of days, including the start   and end dates. The results may display in date format. Copy the formula to   the range E6:E10.

 

 

The number of days results show   dates rather than values. Applying the Number format will solve this issue.
 

  Apply Number format with zero decimal places and center the results   horizontally in the range E5:E10.

 

 

The gross revenue is calculated   by type of customer. Column J is designed to display the gross revenue for   corporate customers.
 

  In cell J5, enter a formula to calculate the gross corporate revenue for the   first workshop by multiplying the cost per attendee by the number of   corporate attendees. Copy the formula to the range J6:J10.

 

Column K is designed to display   the gross revenue for education customers.
 

  In cell K5, enter a formula to calculate the gross education revenue by   subtracting the education discount rate from 1, multiplying the result by the cost per attendee   and multiplying by the number of education attendees. Copy the formula to the   range K6:K10.

 

 

Now that you calculated the   gross revenue for corporate and education customers, you can calculate the   total gross revenue for each workshop.
 

  In cell L5, enter a formula to calculate the total gross revenue by adding   the Corporate Gross Revenue and the Education Gross Revenue. Copy the formula   to the range L6:L10.

 

 

The discount rates look better when displayed with percent symbols   and centered because the rates are all two digits.
 

  Format the range G5:G10 as Percent Style and center the data horizontally.

 

 

The monetary values in the Cost   per Attendee, Corporate, Education, and Gross Revenue columns would look   better with dollar signs and commas.
 

  Format the ranges F5:F10, J5:L10 with Accounting Number Format with zero   decimal places.

 

 

Change the width of columns G,   H, and I to 9. Change the width of columns J, K, and L to 11.

 

 

To further improve how the   number of attendees values display below their headings, you can change the   alignment and indent the data.
 

  Right-align data in the range H5:I10 and increase the indent two times.

 

Borders around the # of   Attendees and Gross Revenue sections would help distinguish data and improve   readability.
 

  Apply Outside Borders to the range H4:I10. Apply Outside Borders to the range   J4:L10.

 

 

You want to prepare the   worksheet so that your manager can print it. Because the worksheet data   consumes several columns but only a few rows, it would look better in   landscape orientation.
 

  Select Landscape orientation.

 

 

A larger top margin but smaller left and right margins will help   balance the worksheet data on a printout. Centering the data between the left   and right margins further balances workshop revenue data on the page.
 

  Set a 1.5-inch top margin, 0.5-inch left and right margins, and center the   worksheet horizontally on the page.

 

 

Even with the smaller left and   right margins, the data does not fit on one page. Therefore, you should   reduce the scaling so that it fits.
 

  Change the scaling to 90%.
 

 

Insert a footer with the text Exploring   Series on the   left side, the sheet name code in the center, and the file name code on the   right side of the Sheet1 worksheet.

 

The worksheet is named Sheet1,   which is not meaningful. You want to add a meaningful sheet name so that it   will display in the footer. In addition, the Sheet2 worksheet is empty and   should be deleted.
 

  Rename Sheet1 as June and then delete Sheet2.

 

Save and close Exp22_Excel_Ch01_CumulativeAssessment_Training.xlsx.   Exit Excel. Submit the file as directed.

Discuss common forms of attack on Microsoft systems using the Internet

 

Instructions

Assignment Instructions

Week 1 Assignment:

In order to complete assignment #1 you will need to answer the below questions. Please complete the questions in a Word document and then upload the assignment for grading. When assigning a name to your document please use the following format (last name_Assignment #1). Use examples from the readings, lecture notes and outside research to support your answers. The assignment must be a minimum of 1-full page in length with a minimum of 2 – outside sources. Please be sure to follow APA guidelines for citing and referencing source. Assignments are due by 11:59 pm Eastern time on Sunday.

Instructions

1. Discuss common forms of attack on Microsoft systems using the Internet, and/or your job as reference for full credit
2. Read the week 1 article on installation and deployment of Windows Server 2012 and list 5 concerns that could result in vulnerabilities during installation.

Article Link

3. Discuss three basic network components and how they are used today.

Submission Instructions: The report must be at least 300 words.

wk 12

Should corporations be more concerned about the data and physical security of their customers, especially when it pertains to the use of IoT and Smart Devices?

CS4310: Computer Networks

CS4310: Computer Networks
Project #2
 

1. Overview
In this project, we are going to build a component of a Command and Control (C2C) server that is used to allow agents in a multi-agent system to become aware of each other. In particular, the C2C server should be able to maintain a list of active agents and respond to various actions as issued by the agents. For example, the agents could be a group of UAVs and the C2C server could be a satellite. The agents would need to communicate through the satellite if they are out-of-range of each other. The C2C
server will run on a particular port (supplied by a command line argument) and should be able to respond to TCP connections from agents. Agents send various actions to the
server to update the information maintained. The agent code is supplied in this assignment and is written in C. An agent can issue one of those actions:
1- #JOIN
When the C2C server receives a join request, it will add this agent to its current list of active agents and responds with “$OK”. An agent can only join once before it leaves. If an agent tries to join while it is already an active agent, the C2C
server should respond with an error message “$ALREADY MEMBER”
2- #LEAVE
When the C2C server receives a leave request, it deletes the corresponding agent from its list of active agents and responds with “$OK”. An agent cannot leave if it has not already joined and the server responds with an error message “$NOT MEMEBER”
3- #LIST
When the C2C server receives a list request, it responds with the list of all active agents (agents that have joined, but not already left). The C2C server can only respond to list actions from active agents (otherwise ignored and no response is
given). The list contains the IP address and duration in seconds (how many seconds since an agent joined) for each agent. Each entry should be in the form of . You may assume that each agent has a unique IP. Requests generated from the same IP address are treated as a single agent.
4- #LOG
When the C2C server receives a log request, it responds with the log file (log.txt) to the agent. Similar to list, only active agents can issue log requests. You can assume that the log requests itself should be logged into the log file before its gets sent to the agent. Note that the log file could be quite large, so make sure not to try to load it into a buffer all at once.
The agent takes three arguments in its command line: the C2C server IP, server port and the action string. It sends the action string and writes the response, if any, to the screen. The agent code is listed under resources on TRACS.
The agent would connect to the server on its listening port and waits for a response to its actions before it exits. All actions start with a ‘#’ and all responses start with ‘$’
followed by the data/message.
The C2C server should be able to listen for actions on the port it is running on and once a request is received, the server responds with the information/confirmation based on its current state (e.g., active list of agents, when they joined and the agent requesting the information) and records its interactions in the log file. Notice that the C2C server will
never exit; it continues listening and servicing requests.
2. Log File
The C2C needs to maintain a log file the records any information about any given connection along with a time stamp (up to millisecond granularity) and the response
sent (if any). You can assume the file is called log.txt. For example:
“TIME”: Received a “#JOIN” action from agent “147.26.143.22”
“TIME”: Responded to agent “147.26.143.22” with “$OK”
“TIME”: Received a “#LIST” action from agent “147.26.12.11”
“TIME”: No response is supplied to agent “147.26.12.11” (agent not active)
3. Where to start
First, you need to get familiar with Internet programming API. This will be based on the material discussed in class.
Given the agent application provided, start working on the server part. To test your C2C server, you need to generate multiple actions from different agents by running them
from different machines. You can run a number of agents from different terminals, but all of them will have the same IP address and thus would be treated as the same agent.
You need to handle different cases such as a “#LEAVE” without joining, a “#LIST” from an inactive agent, among many others.
4. Submission
 

• You need to turn in a short design document stating the overall design decisions you made and the data structures used.
• Please provide a single command line to test your code and make sure to provide a working example of the command line.
• Please provide the output log file for 3 agents (using different terminals from different servers) that perform the following actions in that order:
1- Agent 1 joins
2- Agent 2 joins
3- Agent 3 joins
4- Agent 1 issues list
5- Agent 1 leaves
6- Agent 1 issues list
7- Agent 2 leaves
8- Agent 2 leaves
9- Agent 3 issues list
10-  Agent 3 issues log
• Please submit only one zip file that contains all of the above by email to [email protected] with the subject: “CS4310: Project #2”
5. Notes
In a real-world setting, we will need to add a layer of authentication in which the C2C server can verify that it is really communicating with an agent (as opposed to an
attacker) and vice versa. Also, communication should be encrypted between them.
Finally, the server should be a multithreaded one, so it can respond to various agents in parallel (for example using pthreads).