Bis 220 Week 3 Learning Team Efficiency and Collaboration Proposal

In: Other Topics

Submitted By uoptutors3
Words 253
Pages 2
BIS 220 Week 3 Learning Team Efficiency and Collaboration Proposal
To Buy This material Click below link http://www.uoptutors.com/BIS-220/BIS-220-Week-3-Learning-Team-Efficiency-and-Collaboration-Proposal Resources: Ch. 1 & 2 of Excel® in Microsoft® Office 2010.

Scenario: Imagine you are an employee of Party Plates, a company that manufactures decorative paper plates and napkins for special events. Your team has been assigned a new project. The president of your company has tasked you with improving the efficiency of the current information systems used in the sales department, because the current systems are somewhat antiquated. Your organization is currently using Microsoft® Excel® to track all personnel data, but would like to migrate to a relational database like Microsoft® Access®. You have also been tasked with identifying potential collaborative software that may improve internal communications and help streamline some of the work processes for the sales department.

Prepare a 1200- to 1500 word proposal addressing the potential implementation of new information systems in your organization.
Note: The Cover Page and Reference Page does not count towards the word count.

Explain the usefulness of converting data currently held in Microsoft® Excel®spreadsheets into a relational database using Microsoft® Access®.
Describe the benefits of using Microsoft® Access® in the work environment.
Include suggestions for the future use of collaborative software and how it can help the sales department improve communications and streamline work processes
Format your proposal consistent with APA guidelines.
For more Assignments visit:…...

Similar Documents

Bis220 Efficiency and Collaboration Proposal

...Efficiency and Collaboration Proposal Team B BIS/220 September 18, 2012 Instructor Title of Paper The main purpose of this proposal is to show how changing Party Plates current information system is beneficial. The sales department should consider a relational database such as Microsoft Access versus their current database, Microsoft Excel. Team B will explain the usefulness of converting data currently held in Microsoft Excel into a relational database using Microsoft Access. Team B will also introduce types of collaborative software; how this software can improve communications and streamline work processes. Microsoft Excel Microsoft Excel is the most used spreadsheet program (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). In Excel, a worksheet is a single spreadsheet that typically contains descriptive labels, numeric values, formulas, functions, and graphical representations of data (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). A workbook is a collection of one or more related worksheets contained within a single file; by default, new workbooks contain three worksheets (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). Storing multiple worksheets within one workbook helps organize related data together in one file and enables you to perform calculations among the worksheets within the workbook (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). Business typically uses Microsoft Excel to store simple information. ......

Words: 691 - Pages: 3

Efficiency and Collaboration Proposal

...Efficiency and Collaboration Proposal BIS/220 Microsoft Access has become more user friendly over the past few years; it has more tools and is very simple for a person to learn, even if they have never used the program before. The system has easier add, subtracting, and also is easier to change data that has previously been entered. Access gives the ability for more than one user to update tables at the same time, and gives the option to create more than one report from the same data. Access stores data in tables that look like worksheets, but are designed for complex querying in relation to data stores in other tables and locations. Access also allows you to use structured query language, to quickly retrieve just certain rows and columns of data that you may want for a report, even if that particular data is part of another table. By converting our data that we currently have in Microsoft Excel to Microsoft Access it will give us the opportunity to track different areas of our business in more ways than one. It will also allow us to effectively maintain our reports to ensure better production and customer satisfaction. Using Microsoft Access as the database for our company is beneficial for so many reasons. For instance, with an access database file, several users can work in the same file at the same time, multiple users, from different computers; can work on an Access database simultaneously. One person could add records to the Customer table while another could......

Words: 527 - Pages: 3

Efficiency and Collaboration Proposal

...Efficiency and Collaboration Proposal BIS/220 April 16, 2013 Ramin Tabrizi Efficiency and Collaboration Proposal The main purpose of this proposal is to show how changing Party Plates current information system is beneficial. The sales department should consider a relational database such as Microsoft Access versus their current database, Microsoft Excel. Team C will explain the effectiveness of converting data currently held in Microsoft Excel into an interactive database using Microsoft Access. Team C will also introduce types of collaborative software; how this software can improve communications and streamline work processes. It is time for something new, something invigorating and inspirational for this business’ organization. Party Plate’s current system is Microsoft Excel. The system is excellent for managing and maintaining data entry information as well as other electronically processed information. Microsoft Excel has allowed our business to control the inventory and regulate the calculations that are constantly occurring during a daily routine. Excel’s spreadsheet program has allowed this company to create and breakdown prices into rows and sections wherever needed for evaluating values and rates for our customers’ orders and suppliers’ productions. Excel allows us to distinguish between the two as well as the many other values that may be involved in the transaction. Errors are easily corrected that may be found after evaluation is nearly complete. The......

Words: 754 - Pages: 4

Week 3 Bis 220

...Efficiency and Collaboration Proposal James M. McCarver, Jill Brogan, Judy Vilayphone, Lashunda Wallace, Laura Silberman, Mem Sanders BIS 220 May 13, 2013 Lars Vesterberg Efficiency and Collaboration Proposal The purpose of this proposal is to show you the potential implementation of new information systems at Party Plates. We are excited to introduce all the new changes taking place. The sales department is currently using Microsoft Excel but after looking around for something that would suit our needs better we found Microsoft Access. As technology and our business grow we are always looking for ways to improve. We will tell you how switching over to Access will benefit the company. We will also include suggestions for future use of collaborative software and how it can help the sales department improve communications. Stated below are the changes being made. Microsoft Access is a program that is used to store large data. Microsoft Access is very beneficial in the work environment, because of the different features that it offers, and it is easy to learn. The program is user friendly which incorporates other features offered through Microsoft Office. Without sacrificing performance, large amounts of data can be stored into the database. It is very easy to store available information into the database. If your office environment is large , Access may be programmed to retrieve information from the enterprise software. This short document will......

Words: 807 - Pages: 4

Efficiency and Collaboration Proposal

...Efficiency and Collaboration Proposal BIS/220 April 16, 2013 Efficiency and Collaboration Proposal Team “D” would like to propose a convenient and efficient system that will allow the company to function more proficient. The purpose of this proposal is to introduce a relational database system that will improve the company’s productivity by updating our current information system. Team D will demonstrate this by explaining the usefulness of converting data currently in Microsoft Excel spreadsheets into a rational database using Microsoft Access. Describe the benefits of using Microsoft Access in our organization and will include suggestions for the future use of collaborative software, showing how it can improve the communication of the sales department while also streamlining the work process. Usefulness Depending on whom you speak with you will get a different response when asked, which software is better Microsoft Excel or Access. They are both very powerful and unique software used by tremendous amount of individual’s worldwide. Just know that both are used to make our day at work or even at home easier by recording and organizing important data. However, how they store, organize, or display that data is completely different from each other making it one of the major differences between the two. For example, excel offers what is known as the what-if analysis, which can forecast the outcome of the worksheet. Although they may seem completely different......

Words: 684 - Pages: 3

Bis 220 Week 3 Efficiency and Collaboration Proposal

...Efficiency and Collaboration Proposal | | BIS220 September 4, 2012 As our company, Party Plates, continues to grow and expand, we must consider other viable options to improve our information systems. Our sales department’s database has basically outgrown Excel and we need to commit to switching over to Access. In the long run, we will save time by having the program filter our queries, by tracking personnel data and storing pertinent information for the sales department. In order for us to achieve greater success, we need to explore the technologies that are available to us that will enable us to improve internal communications and develop ways to streamline certain actions in the sales department. It was originally a good idea for Party Plates to use Microsoft Excel for data storage; however, the massive amount of data the company currently produces necessitates a relational data structure like Microsoft Access. Access allows users to divide information into logical fragments, and place each piece in a separate table. This structure will make it easier to manage data, avoid trouble with data redundancy, and improve employee efficiency. Party Plates can also use Access to create data entry forms that will expedite the data entry process and reduce the risk of employees entering data in the wrong table (Microsoft, 2012). The ways Access will benefit and improve sales improve communications and streamline work is by being able to bring up a specific search of a......

Words: 521 - Pages: 3

Efficiency and Collaboration Proposal

...Information Systems Proposal BIS/220 July 7, 2014 Contents Types of Information System (IS)……………………………………..3 Benefits & Drawbacks…………………………………………………4 Image of Our Record Store…………………………………………….5 References……………………………………………………………..6 Types of Information Systems (IS) 1. Functional Area Information System * Supports the activities within individual areas of the business/ System to process time keeping. 2. Transactional Processing System * Processes transaction information /Point of Sale terminals for checking out customers. 3. Office Automation System * Keeps track of daily work actions/ Utilizing Excel to create spreadsheets of inventory. 4. Management Information System * Creates reports with summaries of daily transactions/Daily or weekly tracking of revenue and most popular items......

Words: 387 - Pages: 2

Efficiency and Collaboration Proposal

...Efficiency and Collaboration Proposal Maliaka M. McClendon, Tameeka Kelly, Tokisha Payne, Jude McDonald BIS/220 September 22, 2014 Darrell Oakland Efficiency and Collaboration Proposal When it comes to running a business, efficiency is important to both the business and the customers. But what makes the business efficient? The most important programs to run in a business are the database systems as well as the collaboration tools. If you are using a program from Microsoft, Access is the best one to use in the business because of its ability to process information using a relational database system. However, the collaboration tool that a business uses is equally important. This tool whether it is an inter- or intra-net type system is critical when working with other team members or employees to process work efficiently and effectively for the business and its customers. While currently at Party Plates we utilize Microsoft Excel, there is good reason to incorporate Microsoft Access as well. On many occasions, you will want and possibly need to take advantage of the benefits that both programs have to offer. For example, you created a spreadsheet in Excel in which you can calculate and analyze the data, and it has become unmanageable due to size and complexity, and now that data needs to be accessed by many more users than you. One example would be to, import or link your worksheet into Access and use it as a database as an option to working with it in......

Words: 701 - Pages: 3

Efficiency & Collaboration Proposal

...Efficiency and Collaboration Proposal Learning Team D BIS/220 October 20, 2014 Mr. Keith Hopkins Efficiency and Collaboration Proposal Party Plates A Business Proposal to Improve the Efficiency of our Current Information System used by our Sales Department Our sales department for Party Plates is currently using Microsoft® Excel to keep track of all personnel data. This proposal will provide an explanation as to why we believe Microsoft® Access would be more beneficial to use and other possible software uses. Microsoft® Access provides built-in tools that assists in organizing data that Microsoft® Excel does not. Currently, our personnel data is kept on an Excel spreadsheet. Converting this information to Access will allow Party Plates to share this database within our entire company, so that everyone will have access to it. The best thing that Access can do to impact the use of our personnel data information is that one of the tools allows us to create relationships (Office 2014). Doing so will allow us to efficiently combine data from our database to create forms and reports. With our increasing sales, our sales department will not be able to affectively track our personnel. Therefore, using Microsoft® Access will allow multiple fields instead of worksheets. It will also allow us to have multiple users to use one data source, so that a number of departments can view the data (Office 2014). Social media has taken over everywhere. Individuals use social......

Words: 612 - Pages: 3

Bis 220 (Information Systems Proposal) Complete Class

...BIS 220 (Information Systems Proposal) Complete Class IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download http://hwnerd.com/BIS-220-Information-Systems-Proposal-Complete-Course-1395.htm?categoryId=-1 If You Face Any Problem E- Mail Us At Contact.Hwnerd@Gmail.Com Week 1 Individual Information Technology Acts Paper Select two of the following acts to research: Do Not Call Implementation Act, 2003 Controlling the Assault of Non-solicited Pornography and Marketing (CAN-SPAM) Act, 2003 Federal Information Security Management Act (FISMA), 2002 Uniting and Strengthening America by Providing Appropriate Tools Required to Intercept and Obstruct Terrorism Act (US Patriot Act), 2001, renewed 2006 Children’s Internet Protection Act, 2000 Financial Services Modernization Act, 1999 Children’s Online Privacy Protection Act (COPPA), 1998 No Electronic Theft (NET) Act, 1997 Health Insurance Portability and Accountability Act (HIPAA), 1996 Telephone Consumer Protection Act (TCPA), 1991 Video Privacy Protection Act, 1988 Computer Fraud and Abuse Act, 1986 Electronic Communications Privacy Act, 1986 The Cable Communications Policy Act, 1984 Electronic Funds Transfer Act, 1978 Family Educational Rights and Privacy Act, 1974 Fair Credit Reporting Act, 1970 Prepare a 350- to 1,050-word paper that answers the following question: What were the advances in information technology that resulted in new ethical issues necessitating......

Words: 887 - Pages: 4

Bis 220 (Information Systems Proposal) Complete Class

...BIS 220 (Information Systems Proposal) Complete Class IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download http://hwnerd.com/BIS-220-Information-Systems-Proposal-Complete-Course-1395.htm?categoryId=-1 If You Face Any Problem E- Mail Us At Contact.Hwnerd@Gmail.Com Week 1 Individual Information Technology Acts Paper Select two of the following acts to research: Do Not Call Implementation Act, 2003 Controlling the Assault of Non-solicited Pornography and Marketing (CAN-SPAM) Act, 2003 Federal Information Security Management Act (FISMA), 2002 Uniting and Strengthening America by Providing Appropriate Tools Required to Intercept and Obstruct Terrorism Act (US Patriot Act), 2001, renewed 2006 Children’s Internet Protection Act, 2000 Financial Services Modernization Act, 1999 Children’s Online Privacy Protection Act (COPPA), 1998 No Electronic Theft (NET) Act, 1997 Health Insurance Portability and Accountability Act (HIPAA), 1996 Telephone Consumer Protection Act (TCPA), 1991 Video Privacy Protection Act, 1988 Computer Fraud and Abuse Act, 1986 Electronic Communications Privacy Act, 1986 The Cable Communications Policy Act, 1984 Electronic Funds Transfer Act, 1978 Family Educational Rights and Privacy Act, 1974 Fair Credit Reporting Act, 1970 Prepare a 350- to 1,050-word paper that answers the following question: What were the advances in information technology that resulted in new ethical issues necessitating......

Words: 887 - Pages: 4

Bis 220 (Information Systems Proposal) Complete Class

...BIS 220 (Information Systems Proposal) Complete Class IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download http://hwnerd.com/BIS-220-Information-Systems-Proposal-Complete-Course-1395.htm?categoryId=-1 If You Face Any Problem E- Mail Us At Contact.Hwnerd@Gmail.Com Week 1 Individual Information Technology Acts Paper Select two of the following acts to research: Do Not Call Implementation Act, 2003 Controlling the Assault of Non-solicited Pornography and Marketing (CAN-SPAM) Act, 2003 Federal Information Security Management Act (FISMA), 2002 Uniting and Strengthening America by Providing Appropriate Tools Required to Intercept and Obstruct Terrorism Act (US Patriot Act), 2001, renewed 2006 Children’s Internet Protection Act, 2000 Financial Services Modernization Act, 1999 Children’s Online Privacy Protection Act (COPPA), 1998 No Electronic Theft (NET) Act, 1997 Health Insurance Portability and Accountability Act (HIPAA), 1996 Telephone Consumer Protection Act (TCPA), 1991 Video Privacy Protection Act, 1988 Computer Fraud and Abuse Act, 1986 Electronic Communications Privacy Act, 1986 The Cable Communications Policy Act, 1984 Electronic Funds Transfer Act, 1978 Family Educational Rights and Privacy Act, 1974 Fair Credit Reporting Act, 1970 Prepare a 350- to 1,050-word paper that answers the following question: What were the advances in information technology that resulted in new ethical issues necessitating......

Words: 887 - Pages: 4

Bis 220 (Information Systems Proposal) Complete Class

...BIS 220 (Information Systems Proposal) Complete Class IF You Want To Purchase A+ Work Then Click The Link Below , Instant Download http://hwnerd.com/BIS-220-Information-Systems-Proposal-Complete-Course-1395.htm?categoryId=-1 If You Face Any Problem E- Mail Us At Contact.Hwnerd@Gmail.Com Week 1 Individual Information Technology Acts Paper Select two of the following acts to research: Do Not Call Implementation Act, 2003 Controlling the Assault of Non-solicited Pornography and Marketing (CAN-SPAM) Act, 2003 Federal Information Security Management Act (FISMA), 2002 Uniting and Strengthening America by Providing Appropriate Tools Required to Intercept and Obstruct Terrorism Act (US Patriot Act), 2001, renewed 2006 Children’s Internet Protection Act, 2000 Financial Services Modernization Act, 1999 Children’s Online Privacy Protection Act (COPPA), 1998 No Electronic Theft (NET) Act, 1997 Health Insurance Portability and Accountability Act (HIPAA), 1996 Telephone Consumer Protection Act (TCPA), 1991 Video Privacy Protection Act, 1988 Computer Fraud and Abuse Act, 1986 Electronic Communications Privacy Act, 1986 The Cable Communications Policy Act, 1984 Electronic Funds Transfer Act, 1978 Family Educational Rights and Privacy Act, 1974 Fair Credit Reporting Act, 1970 Prepare a 350- to 1,050-word paper that answers the following question: What were the advances in information technology that resulted in new ethical issues necessitating......

Words: 887 - Pages: 4

Bis 220 Learning Consultant / Tutorialrank.Com

...BIS 220 Entire Courses (UOP Course) For more course tutorials visit www.tutorialrank.com BIS 220 Week 1 Individual Assignment Information Technology Acts Paper (UOP Course) BIS 220 Week 1 DQ 1 (UOP Course) BIS 220 Week 1 DQ 2 (UOP Course) BIS 220 Week 2 LT Reflection Summary (UOP Course) BIS 220 Week 2 Individual Assignment Information Systems Proposal (UOP Course) BIS 220 Week 2 DQ 1 (UOP Course) BIS 220 Week 2 DQ 2 (UOP Course) BIS 220 Week 3 Individual Assignment Types of Electronic Commerce Activity (UOP Course) BIS 220 Week 3 LT Reflection Summary BIS 220 Week 3 Team Assignment Efficiency and Collaboration Proposal (UOP Course) BIS 220 Week 3 DQ 1 (UOP Course) BIS 220 Week 3 DQ 2 (UOP Course) BIS 220 Week 4 Team Assignment Wireless Technologies Proposal (UOP Course) BIS 220 Week 4 DQ 1 (UOP Course) BIS 220 Week 4 DQ 2 (UOP Course) BIS 220 Week 5 LT Reflection Summary (UOP Course) BIS 220 Week 5 Individual Assignment Social Media and Networking Presentation (UOP Course ____________________________________________________ BIS 220 Week 1 Individual Assignment Information Technology Acts Paper (UOP Course) For more course tutorials visit www.tutorialrank.com Select two of the following acts to research: Do Not Call Implementation Act, 2003 Controlling the Assault of Non-solicited Pornography and Marketing (CAN-SPAM) Act, 2003 Federal Information Security Management Act (FISMA), 2002 Uniting and Strengthening America by Providing......

Words: 936 - Pages: 4

Learning Team Collaboration Bis/220 Week 2

...Information system plays a vital role in a working environment and allows organizations to work more efficiently by increasing productivity. Information systems are essential, which helps organizations collect, store, and process data to communicate information throughout the organization. Information system is the structure in any business by knowing how to use the system will enhance my skills. My learning has increased because I know by learning the components of information systems I will always continue to apply in my personal life and in any business environment to display my skills. With new technologies arising makes a threat on security, and privacy concerns. They are many ethical issues related to information technology for example, such as the increasing collection of personal data by private and governmental agencies. In addition, this makes new systems vulnerable, and the security can be breached by hackers. Information technology can be applicable in my workplace by better securing customer’s information. In addition, providing security controls by going the extra mile to safeguard customer’s information will secure controls and help build customers confidence. My knowledge has increased because I understand security, and I know I have to take steps to protect my computer by incorporating the software to safeguard information from hackers. By using word processing tools to communicate business objectives within the business environment using word processing......

Words: 321 - Pages: 2