BTAC 100 Integration Project BTAC 100 - FINAL INTEGRATION PROJECT – Due August 18 by 9 pm Project components: · PowerPoint presentation · Word letter · Word MLA citations · Excel spreadsheet · Access...

PowerPoint presentationWord letterWord MLA citationsExcel spreadsheetAccess database


BTAC 100 Integration Project BTAC 100 - FINAL INTEGRATION PROJECT – Due August 18 by 9 pm Project components: · PowerPoint presentation · Word letter · Word MLA citations · Excel spreadsheet · Access database You are employed by a high tech corporation called the Green River Corporation. At this company, there has been discussion and concern about ethical issues revolving around technology, software, and computers. The CEO of the company has assigned you to research and investigate a computer/technology ethical issue and to present your findings to the district managers. You are to choose one of the following computer/technology ethical issues that the CEO is interested in having you present to the district managers: · Blogging · Copyright laws regarding the Internet · Software issues (copying software and software piracy including the understanding of freeware, shareware, and other classifications of software) · Internet issues such as fraud, privacy, safety issues, or etiquette · Privacy issues regarding SnapChat, Instagram, Twitter, Facebook, etc. (social networking sites) · Spam · Cookies · Viruses and worms · Spyware · Hacking · Phishing · LinkedIn—What is it? · Using employer technology for personal use: taking laptops home; using work computers, software, copiers, printers, faxes, etc. · Wireless security issues · Identity theft and the Internet · Wikis · Cloud computing After choosing one of the above topics, you will then find factual information on that topic. You will use the Web to research the topic. The CEO would like you to provide the information to the managers by presenting a PowerPoint presentation with your findings. You will be creating this presentation. Also, she wants each manager to receive an informational letter summarizing the information that you are going to be talking about and the date of the presentation. This will require you to create a company database that will be used to distribute the letter. In addition, you will create a worksheet and chart that will be integrated into the informational letter. The informational letter, the database, the worksheet/chart, a Works Cited page, and the PowerPoint presentation will be completed and turned in by Wednesday, August 18, at 9 pm. to the drop boxes in Canvas for each of the above files. No late assignments will be accepted. Make sure to proofread all sections of this project, as points will be lost for typographical errors, misspelled words, and grammatical errors. There will be a grading sheet available to you so that you may see how many points are possible for each section of this project. Ethical Issue Research and Use of Research/MLA Works Cited Page You are responsible for a specific ethical issue and will choose one of the ethical issues listed on page 1 of this handout. You will use the WWW to find information and facts concerning your issue. While researching for information, you are responsible for taking notes or printing selections of information that you will need and use when you create your PowerPoint presentation and your summary paragraph for the informational letter. You are required to use at least three different sites in preparing your presentation. Cite your sources appropriately within your presentation using MLA style. In submitting your project, you will include an MLA-style Works Cited page. I recommend you review your textbook—Word—for Works Cited formatting, and use the same formatting presented in the Word chapter. See the information in the textbook to set up the title. You will type your own entries in the format shown and follow the instructions on formatting paragraphs with a hanging indent. If you need additional information about the MLA style, check the following resources: Citing Sources using MLA citation style or Google the topic: MLA You will list all the sites from which you actually used information in preparing your presentation. You are required to have a minimum of three different sites. Make sure to include the URL of the websites in your Works Cited page. (Wikipages are not considered a valid site.) Include your Works Cited page in the drop box with the required components that you will turn in. Include your name and your specific ethical issue as a footer on the Works Cited page (e.g.: Lori Fishburn, Internet Fraud). Name this Word document Works Cited by Your First and Last Name. Database (Access) Requirements The following table lists the district managers who need an informational letter. You will create a database table, report, and query with the following fields and data. Employee Number First Name Last Name District Phone Ext Region Address City State Zip 5194223 Stanley Thomason Rainier Valley 5435 South 115 Rainier Valley Way Auburn WA 98042 2578854 Katrina Jacobson Industrial City 7353 East 256 Sunset Drive Wenatchee WA 98660 5489793 Hunter Rogers North Central 1412 Central 12th Middle Ave. Black Diamond WA 98038 7943587 Meagann Johnston Snohomish Valley 3528 West 1123 West St. Des Moines WA 98148 6783542 Jake Williams Industrial City 9587 East 1251 Park Dr. Puyallup WA 98371 5824861 Vickie Daller Rainier Valley 5439 South 8164 Lacey Lane Tacoma WA 98402 4237539 Allyson Zenner SODO 5853 East 871 Abbey Road Spokane WA 98851 5787362 Kannedy Miles Capital Hill 5846 Central 1192 Park Ave. Des Moines WA 98354 Review the Access projects in your text to set up this database. The name of the database is Washington State Managers by Your First and Last Name. The name of the table you create is District Managers by Your First and Last Name. The following lists criteria for each specific field. If no criterion is listed, then use the default settings. · Employee Number has numeric data type and is the primary key · Last Name has a field size of twenty-five, text data type · First Name has a field size of eighteen, text data type · Phone Ext (field size 4) and Zip (field size 5) have a text data type · State has a field size of two · Add descriptions to each field · Best Fit all field widths Note: The field names as listed above (Employee Number, First Name, etc.) and some data in the records (365 First St.) will be listed on one line when created as an Access table. Also, the records in the final table in Access will not appear in the same order as listed above. Upon accurately creating the database and the above table, you will complete the following: 1. Create a report using all the fields except Address, State, and Zip · Name the report District Managers Report by Your First and Last Name 2. Perform a single query with the following criteria: a. Include the fields Last Name, First Name, Region, City, and Phone Ext b. Query only for those whose region is East; do not show the region in the results c. Sort by Last Name d. Save the query as East Region Query by Your First and Last Name 3. Create a form using all the fields · Name the report Employee Information Form by Your First and Last Name Worksheet (Excel) Requirements Create the following Excel worksheet and chart, following the directions in the worksheet below: Figure 1: Excel component directions and content Informational Letter (Word) Requirements This informational letter will include a summary of the information that you are presenting in the PowerPoint presentation. Each manager of the company will receive this informational letter. Create the letter shown on the following page with the guidelines on this page and the information in the text boxes on the letter itself. Before beginning to keyboard the letter in Word, select the No Spacing button in the Styles group on the Home tab. Create an appropriate letterhead for your company. The letterhead needs to include an object plus the text as shown. See your textbook for information on inserting pictures. Insert the current date in formal business style as shown. Change the date of the event to a date two weeks after the current date. Type the text as shown in the following letter. When typing paragraphs, they should wordwrap. Your text may look different due to margin or font size. You may choose the margins and font size for the letter. Also, do not type the text boxes and arrows shown on the form letter—the text boxes are only additional information for you to read. Make sure that the entire letter will fit on one page. Also, try to make sure the letter looks balanced on the page, i.e. the top and bottom margins should look fairly equal and the left and right margins should look fairly equal. You will use the Copy command and the Paste Command in the Clipboard group on the Home tab to create a linked copy of the chart named Managers’ Total Concerns in your letter. You will need your Excel file and your Word file open. The steps to copy and paste are listed below: 1. With the worksheet open in Excel, select the chart. On the Home tab, in the Clipboard group, select the Copy command. 2. Return to the letter in your Word document, and make sure your insertion point is at the point where you want the chart to be inserted. 3. On the Home tab, in the Clipboard group, select the down arrow at the bottom of the Paste button. Select the Use Destination Theme and Link Data option. 4. The chart should be inserted into your document. Format the chart to be horizontally centered as shown below. Make sure all chart data is visible. (Hint: size chart using the sizing handles.) If all of the data in the legend does not display, select the legend, on the Home tab, in the Font group, decrease the font size until all of the data in the legend appears. Save this letter as Informational Letter by Your First and Last Name. When completed, you should carefully proof the letter. Points will be lost for typos. Figure 2: Word component directions and content PowerPoint Requirements The PowerPoint presentation is a summary of your research on your ethical issue. You will create the presentation based on the information you have found on the Web. Summarize the main points of your research articles/information, along with your opinion/recommendations about the topic. Do not just copy and paste information from the Web—you should paraphrase or summarize the information gathered into your own words. The presentation must have a minimum of 10 slides (but no more than 15 slides), including a title slide and a closing slide. The PowerPoint presentation should contain the following elements: · Title slide