Week 5 Assignment: Microsoft Excel – Collecting & Organizing Data

Submit Assignment

• Due Sunday by 11:59pm
• Points 100
• Submitting a file upload

Introduction

Now that you have made a proposal, we need to collect evidence! This week you will be researching and collecting data that shows why you believe it is important to pursue your proposal. Make sure to collect as much as information as possible so you can create meaningful charts next week. This week’s work will be the basis for next week’s assignment.

Learn

Textbook Reading

Below you will find the textbook reading for the week. Remember to complete your reading by Wednesday to be prepared for the week!

• Microsoft Excel

Microsoft Office 2016 at work for dummies (Links to an external site.)

• Understanding Excel interface – Chapter 7
• Entering and editing data – Chapter 7
• Autofill – Chapter 7
• Cell management – Chapter 7
• Sheet management – Chapter 7
• Cell References – Chapter 8
• Basic Formulas – Chapter 8
• Insert Functions – Chapter 8
• Tables – Chapter 10

Office 2016 All-In-One for Dummies (Links to an external site.)

Apply

Required Resources

The following resources will be used to complete your assignment:

• Microsoft Excel

This week you will complete the first draft of your Excel spreadsheet. Follow the steps listed below to complete the first part of your data collection.

1. Create a new Excel file and call it “YourName_COMP150_W5_Assignment”.
2. Add two new sheets and name them as “Read Me” and “Main Data”.
3. The “Read Me” sheet is the place where you will add your name and date. You will also explain the purpose of the document and the type of information you are providing. See the example below.
   
4. Based on your research topic, you need to provide a large set of data that can be used for analysis during this week and next. Your data set must be at least 10 rows and 3 columns and no more than 50 rows or 10 columns. You can make this up or do research to find a data set. The data set must have numbers to help with the calculations in the next steps, so it is recommended to review the entire assignment before you create the data set. 
5. The table with the dataset must have a header that is merged and center.
6. The data must be visible so make sure the columns and rows have enough spacing
7. You are expected to have all of the following calculations
   1. A formula using a relative reference
   2. A formula using an absolute reference
   3. Use at least three different functions
8. Ensure the different types of data have the right formatting. Here are some guidelines
   1. Dates should have “date” formatting
   2. Any currency should have two decimals
   3. Any text should be set up as “text” or “general”
9. Feel free to be creative by adding images or another formatting, and complete the file. Make sure the file is named “YourName_COMP150_W5_Assignment” and submit the file.

Grading

This activity will be graded based on the Week 5 Assignment rubric.

Course Outcomes (CO): 4

Due Date: By 11:59 p.m. MT on Sunday

Rubric

Week 5 Assignment RubricWeek 5 Assignment RubricCriteriaRatingsPtsThis criterion is linked to a Learning Outcome“Read Me” and “Main Data” sheets were created10.0 ptsProficient Sheets were added and renamed correctly5.0 ptsAverage Sheets were added but not renamed0.0 its topic is not relevant to the assignment10.0 pts
This criterion is linked to a Learning OutcomeRead Me sheet is populated with name, date, and explanation10.0 ptsProficient Read Me Sheet was all information required and formatted as requested5.0 ptsAverage Read Me sheet has certain information and level or organization0.0 ptsNo Effort10.0 pts
This criterion is linked to a Learning OutcomeData provided meets the 10 rows X 3 columns request and no more than 50 rows X 10 columns10.0 ptsProficient Data provided meets the minimum requirements5.0 ptsAverage Data was provided but it is not meeting the minimum requirements0.0 ptsNo Effort10.0 pts
This criterion is linked to a Learning OutcomeTable has a merged header and centered10.0 ptsProficient Table has a header that is merged and centered5.0 ptsAverage Table has a header but it is not merged and centered0.0 ptsNo Effort10.0 pts
This criterion is linked to a Learning OutcomeAll data should be visible without any errors10.0 ptsProficient Data does not display any errors or symbols such as #######5.0 ptsAverage Some data is showing errors and symbols such as #####0.0 ptsNo Effort10.0 pts
This criterion is linked to a Learning OutcomeThere is at least 1 relative reference formula5.0 ptsProficient At least one relative reference was created0.0 ptsNo Effort5.0 pts
This criterion is linked to a Learning OutcomeThere is at least 1 absolute reference formula5.0 ptsProficient At least one absolute reference was created0.0 ptsNo Effort5.0 pts
This criterion is linked to a Learning OutcomeImplements at least three different functions20.0 ptsProficient There are at least three different functions correctly implemented10.0 ptsAverage There are at least 2 functions working correctly0.0 ptsNo Effort20.0 pts
This criterion is linked to a Learning OutcomeFormatting is correctly applied to dates, text, and currency10.0 ptsProficient Formatting is correctly applied to all types of data.5.0 ptsAverage Formatting is not correctly applied to certain types of data.0.0 ptsNo Effort10.0 pts
This criterion is linked to a Learning OutcomeDocument is organized with a title and headers as needed5.0 ptsProficient Document has all required titles and headers, has correct grammar and spelling, and it is well organized2.5 ptsAverage Document has some of the required titles and headers or has some incorrect grammar and spelling, and it is not well organized0.0 ptsNo Effort5.0 pts
This criterion is linked to a Learning OutcomeDocument is named as “YourName_COMP150_W5_Assignment”5.0 ptsProficient The document was renamed including the student’s name, course, and week0.0 ptsNo Effort5.0 pts
Total Points: 100.0PreviousNext
Number Formatting – Chapter 1 of Book III Excel 2016

‘Beena Shaji’_COMP 150_W5_Assignment

Author-Beena Shaji

Date-10-03-2020

Purpose-To research how effective is the medication Verzenio in the treatment of Breast Cancer.

Content- 

Verzenio is a prescription medicine used to treat a type of breast cancer. It is a medicine you can take if:

• You have a type of breast cancer called HR+/HER2– (hormone receptor-positive/human epidermal growth factor receptor 2–negative) and cancer has spread to other parts of the body (metastasized)
• Verzenio is given along with an aromatase inhibitor as initial endocrine-based therapy for the treatment of postmenopausal women, along with fulvestrant in women whose disease has progressed after hormonal therapy, or by itself in adults whose disease has progressed after hormone therapy and prior chemotherapy

It is not known if Verzenio is safe and effective in children.

Cancer Treatment Data- 

Verzenio is an effective medication in treating breast cancer and helping people with metastatic breast cancer that’s HR-positive and HER2-negative to live longer.

Clinical trials of Verzenio looked at the progression-free survival rate. This is the amount of time that a person goes without their condition getting any worse. On average, people who took both Verzenio and fulvestrant went 16.4 months without progression. In comparison, people who took a placebo (treatment with no active drug) along with fulvestrant had a progression-free survival rate of 9.3 months.

treatment of breast Cancer

Length:   Minimum of 700 words

Briefly respond to all the following questions. Make sure to explain and backup your responses with facts and examples. This assignment should be in APA format and have to include at least two references.

System architecture is the descriptive representation of the system’s component functions and the communication flows between those components.

My definition immediately raises some important questions.

• What are “components”?

• Which functions are relevant?

• What is a communication flow?

Part a) 

1)      Discuss the difficulties in measuring the intelligence of machines.

Required: 200+ words

2)       Explore the AI-related products and services of Nuance Inc. (nuance.com). Explore the Dragon voice recognition product. 

Required: 200+ words

Part b) 

1)      Discuss the process that generates the power of AI and discuss the differences between machine learning and deep learning.

Required: 150+ words

Checklist:

Part ‘A’ and Part ‘B’ answers should to be attached as two separate documents. 

Both part ‘A’ and ‘B’ must adhere to APA formatting guidelines

At least two references for each part

Plagiarism report for both.

Final Project (Interactive Solutions)

Project Description:

Currently, the world is going through a crazy epidemic (COVID-19). I hope all is well and are being safe. There are numerous data available online about COVID-19, such as COVID new cases per state, fatalities per country. As a data scientist, you are in charge of building an interactive chart that depicts numerous angles (at least three).  

Activities:

1. Data Acquisition, Examination, and Transformation.

a. Collect the dataset you are planning to use within your project.

b. Data Examination 

i. Examine the dataset to determine how you want to create an interactivity design and briefly explain your Solution.

c. If needed, perform Data Transformation

i. Perform data transformation techniques such as data cleansing, conversion, creation, and consolidation on the dataset.

ii. Record the transformation activities you performed on your dataset.

2. Data Exploration

a. Decide how you want to present the data.  

b. Decide the tool you would like to create the interactive Solution. The tool could be a developer’s tool or non-developer’s tool.

c. If you are not familiar with the tool, complete a tutorial. The reference below includes links to different types of interactive tools and tutorials.

3. Interactive Solution

a. Design and develop an interactive solution.

b. Explain the challenge you encounter.

c. Explain how to avoid such occurrence when and if you decide to go live/production.

4. Proposed Dynamic Solution

a. Explain how you would modify your solutions that allow the data to change (dynamic) with a database continually. 

Deliverables:

Word file with writing about the following:

· Data Acquisition, Examination, and Transformation [10 points]

· Data Exploration [10 points]

· Interactive Solution [40 points]

· Proposed Dynamic Solution [10 points]

· Screenshots of the different angles of the interactive Solution [4 points]

· APA formatting required. [5 points]

· At least five pages including cover page and reference list [1 point]

Submit a draft copy by 23 November 2020 at 11:59 PM and the final version on or before 30 November 2020. Draft copy submission is available in the week 13 folder while the final submission will be open during week 14

· Draft submission should include at least the Data Acquisition, Examination, and Transformation section [5 points]

· All other sections [75 points]

Resources:

1. https://thenextweb.com/dd/2015/04/21/the-14-best-data-visualization-tools/

2. https://www.d3-graph-gallery.com/index.html

Set up your project with the given starting code. The files should compile and run, but either no tests will be run, or tests will run but be failing. 2. For this project, start by uncommenting the first TEST_CASE in the assg10-tests.cpp file. These are the unit tests to test the functionality of your PriorityQueue enqueue() function, the class and overridden member function you are to implement. 3. Add the PriorityQueue class to the Queue.hpp header file. The class should inherit from LQueue and override the enqueue() method as described in more detail below. 4. Add a stub for your enqueue() member function to the assg07-stackfun.cpp implementation file. You could start by doing nothing, or by copying the code of the enqueue() function from the LQueue class. 5. Your code should compile and run now. Make sure after adding the class and your stub method your code compiles and runs. However, your unit tests will be failing initially. 6. Incrementally implement the functionality of your enqueue() member function. You should try to add no more than 2 or 3 lines of code, and then make sure your program still compiles and runs. Start by adding code to get the first failing test to pass. Then once that test passes, move on to the next failing tests until you have all tests passing. If you write something that causes a previously passing test to fail, you should stop and figure out why, and either fix it so that the original test still passes, or remove what you did and try a new approach. 7. Once you have the enqueue() member function implemented and all unit tests passing, you should then move on to the other functions in the order suggested. Some functions use previous ones in this assignment, so do them in the order given for you in the tasks below.

Complete Business Impact Analysis Questionnaire. See attachment below. 

1.  250 words

Discuss the pros and cons of using a blog to present content on behalf of a company. Discuss the type of content for which a blog may be most appropriate.  Use at least one source to support your discussion.  Reference your source in APA.

2.  250 words

CASE 6-3 Dropbox Cloud-Based File Sharing and Synchronization (15 pts)

Most users today manage their content on a variety of devices. Dropbox is a cloud-based storage facility for photos, documents, and other digital content. Dropbox provides a convenient folder, as shown in Figure 6-7 of you Jamsa (2013) textbook. In one page, discuss the benefits of having web-based access to a cloud storage area.

The paper must adhere to APA guidelines including Title and Reference pages.  There should be at least one source listed on the reference page.  Each reference cited in the text must appear in the reference list, and each entry in the reference list must be cited in text. APA requirements for this class include:

• A title page
• 12-point Time New Roman font
• Your paper should be typed and double-spaced with 1″ margins on all sides
• The first sentence of each paragraph should be indented one tab space
• All papers should contain the page number, flush right, in the header of every page. Use the automatic page-numbering function of your word-processing program to insert page numbers in the top right corner; do not type page numbers manually.
• APA 7th edition in-text citations
• Reference page

The Title and Reference pages do not count towards the page count requirement. This paper should be written in third-person. The third-person point of view belongs to the person (or people) being talked about. The third-person pronouns include he, him, his, himself, she, her, hers, herself, it, its, itself, they, them, their, theirs, and themselves (Not I, we, us, our).

For this assignment you will research the performance specifications of commonly used disks as well as the impact of configurations such as RAID etc on those performance characteristics.   You will also research the common storage performance needs of server operating systems and applications and see how this compares to the performance characteristics you found for common systems. Be sure to detail how you the information you gathered would impact your decisions on implementing a disk.   Highlight in your response how you think these items can be resolved and what needs to be kept in consideration when designing a virtualized system. Your submission needs to be in one of the following formats .doc, .docx, .pdf or .odf

For this assignment, you are asked to reflect on how the technical, team and development process impacts your career interests and goals.  The paper should be double-spaced and between 4-5 pages (assuming a 12-point font), with the following sections: 

Note: Please follow the points and explain according to that( in the view point of programmer the essay should be related to technologies, programming language)

1. Introduction

Where you introduce yourself and what your career goal and interests are.  Try to be specific but naming compainies is not needed. 

—Computer science major who has interest more in developing software and familiar languages like c++programming, python, learing new framework,. 

—Goal is to develop apps like which make people life easier and time saving.

2. Technical Concepts

1. This is where you can talk about what technologies you interest you in further working with, that you need to learn more about, etc. as you look ahead to your career.  It does not have to be specific languages (though it can be), but it can also be frameworks, tools, platforms, etc.

—-Technologies : learing azure , what improvement and learning is necessary framework django

3. Teamwork

1. This is where you talk about how working in teams in terms of communication, project management, etc.

— how is communication and leadership skills

4. Software Development Concepts

This is where you talk about the activities and concepts you related to software development such as the overall process model (e.g. Iterative, Agile) or specific activities like Design or Testing.

— design process model example- waterfall model, iterative model– process to develop to app

5. Conclusion

1. Use this section to tie your reflection in the above areas together.

n Conclude overall and how excited and developing skills are helpful for future

Why do we need to understand data visualisations? There is more and more data around us, and data are increasingly used in decision-making, journalism, and to make sense of the world. One of the main ways that people get access to data is through visualisations, but lots of people feel like they don’t have the skills and knowledge to make sense of visualisations. This can mean that some people feel left out of conversations about data.” – http://seeingdata.org/developing-visualisation-literacy/

Please conduct the following activity located at the following address:

http://seeingdata.org/developing-visualisation-literacy/rate-these-visualisations/

Tell us what you think of the visualisations that we used in our focus group research. Instructions below!

What to do

1. Look at the visualisations by clicking on the images below. You can choose to open the visualisation in a NEW tab or window (we recommend this) or view it in a pop-up window if you prefer to stay on this page. Some are interactive (i) and some are static (s).
2. Place the images on the grid. When you’ve looked at one, go to the grid and position the image according to whether you liked or didn’t like and learned or didn’t learn something from the visualisation (‘learning something’ could also mean confirming something you already knew). Only place the visualisations that you have looked at onto the grid. Click SUBMIT.
3. Compare your views with others. You can compare your responses to the visualisations with those of others, by clicking COMPARE.

Choose three of your favorite visualisations. Post a 3 – 5 sentence summary of why you chose the visualisations. What caught your attention? Were they effective in presenting the provided data? If possible, explain how you would you do to improve the visualization?