Develop startups in the portland and oregon area

Assignment Help Database Management System
Reference no: EM132234771

Question: Google Sheets Assignment

Your Week 5 assignment focuses on interpreting and displaying the existing data you created last week. You will be working with pivot tables, charts, graphs, and notes. You are an angel investor looking to help develop startups in the Portland, Oregon area.

You have obtained contact information for maker spaces, incubators, and small business accelerators around Oregon and want to focus your data to find what kind of organizations exist in Oregon and where the highest concentration of organizations are located.

1) Upload this file into your Google Drive: Oregon Startup Organizations

2) Select-all your data and create a pivot table. Rename your pivot table tab to "List by Type"

3) Create a new row in your pivot table with "Type" as your identifier.

4) Uncheck the "show totals" option in your new row

5) Create a new value with "Type" as your identifier, and use COUNTA as your function.

6) Look at your counted data and insert a note with the type of organization (makerspace, accelerator, incubator) that has the highest number of data rows.

7) Insert a pie chart next to your pivot table that graphically displays the breakdown of organizations by type.

8) Return to your original spreadsheet, select all again, and create a second pivot chart. Rename the tab for this pivot chart "List by Area"

9) Create a new row with "Service Area" as your identifier and deselect the "show totals" option.

10) Create a new value with "Service Area" as your identifier and use the COUNTA function to tally the organizations by area. Create a new Column with "Type" as the identifier. This will break down the data even further into types of organizations ordered by service area.

11) Insert a note about the area or areas where you could target the most incubators.

12) On the main spreadsheet, use conditional formatting to highlight any organization type that's labeled "incubator" in Column G with light green.

13) Use conditional formatting in Column F to highlight any cell that has the word "Metro" in it with light blue.

14) Share your workbook and set to "anyone with a address can EDIT". Copy and paste the link into your W5 assignment dropbox.

Information related to above question is enclosed below:

Attachment:- OregonStartupOrganizations13.rar

Reference no: EM132234771

Object-oriented client database assignment

Imagine that a customer has come to your team and has requested a simple application that will allow the customer to store client names, addresses, and telephone numbers. Th

Each member in the club is assigned a number

Expand the database design you created in Question #1 so that it will also support the following situation: Ray wants to start a DVD rental program at his stores. He refers to

Raci diagram for project resources

Write a 5-page plan (be sure to include a short description of the project used) that includes a list of project stakeholders, a RACI diagram for project resources, and a co

Create an er diagram for each of the descriptions

Create an ER diagram for each of the following descriptions: (a) Each company operates four departments, and each department belongs to one company. (b) Each department in p

Design tables import data from access and excel

The main portion of the resort is the hotel. The hotel wants to store information about hotel guests, reservations, and rooms. You will design tables, import data from Acces

Create a struct data structure for each file contained

Write a password protected console-based application, which enables you to create user accounts and specify the name of the file or directory to be shared with other users.

Executing well-planned strategy-manage technology solution

You have a company, specializing in managing technology solutions. you have ben just hired by big firm to execute a well-planned strategy.

List and explain the defined business rules

The Relational Data Model (RDM) which corresponds to the ERD in the format shown below. The RDMMUSTidentify all primary keys, alternate keys and foreign key constraints. Raw


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd