BTAC 100 Integration Project
BTAC 100 - FINAL INTEGRATION PROJECT – Due August 18 by 9 pm
Project components:
· PowerPoint presentation
· Word lette
· 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 compute
technology ethical issue and to present your findings to the district managers.
You are to choose one of the following compute
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 e
ors, misspelled words, and grammatical e
ors. 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
Hunte
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
Dalle
Rainier Valley
5439
South
8164 Lacey Lane
Tacoma
WA
98402
4237539
Allyson
Zenne
SODO
5853
East
871 A
ey 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
. 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 cu
ent date in formal business style as shown. Change the date of the event to a date two weeks after the cu
ent 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 a
ows 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 a
ow 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
ecommendations 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