Computer science

Excel Assignment No. 2: Create a spreadsheet to display the sales for your five main products for the last four weeks.

Element #
1. Place a title for your worksheet (e.g. Last Month’s Sales) at the top of the spreadsheet. Center it over your table using the “Merge and Center” button on the toolbar (near the alignment buttons). See help if necessary. Use a size 16 font for your labels and the default font size for your data. Use any color except black for your labels.
2. Create a spreadsheet that lists products down the left column and Weeks 1 through 4 across the top row. Enter fictitious data for sales for each week by product. Make the product names and the week names bold. Do not bold the data.
3. Use the Sum function to add the totals for each week for all products (at the bottom) and the Sum function to add the totals for each product for all four weeks (right side).
4. In the row beneath the sum function for the product totals, use the Average Function to calculate the average sales per week. You do not need to calculate the average for each product on the right side.
5. Format the data to Currency with decimal points to two places (e.g. $365.43) for all data, totals, and products of the functions. In other words, everything.
6. Set each column width to 12. Set all row heights to 20.
7. In page setup, create a footer that has your name and the date the sheet was created, choose landscape, and center horizontally and vertically.
8. Set the print area to include all the data in the table you have created.
9. Using the chart command, chart the data (be careful not to include the totals or averages in your range) using a bar chart. Choose the option that places the chart in your spreadsheet and not as a separate sheet. Your chart should show all five products together grouped by weeks. This should happen automatically.
10. Follow project “Internet Café” theme. Spell and grammar check your work and save the file with your initials at the beginning of the name (e.g. AN_P2.xlsx).
PowerPoint Assignment No. 3: Create a presentation for your new business to explain to lenders why they should loan you money to expand your business.

Element #
1. Your presentation should consist of five slides, including the title slide, two bullet slides, one graph slide, and one bulleted summary slide.
2. Choose and use a design template for your presentation.
3. Insert clip art on at least four of the slides.
4. Place: 1) a logo, 2) page numbers and 3) a date in the master slide (see PowerPoint help if necessary).
5. Create a graph (bar chart or line chart) on one slide to show increasing sales over the last year. You can use the charting function inherent in PowerPoint or embed the chart created for assignment 2 (Excel) (copy and paste) from Microsoft Excel (Unit C).
6. Create speaker notes on each of the slides using the notes function in PowerPoint.
7. Use at least two colors for your fonts, at least two font styles, and at least two different font sizes.
8. Set the preset timings and create transitions for each slide for the online presentation mode.
9. Omit the background from the graph chart only, and change its background to a solid color (other than white) of your choice.
10. Follow project “Internet Café” theme. Spell and grammar check your work and save the file with your initials at the beginning of the name (e.g. AN_P3.pptx)

Computer science

Students, please view the “Submit a Clickable Rubric Assignment” in the Student Center.
Instructors, training on how to grade is within the Instructor Center.

Assignment 2: COPA and CIPA
Due Week 4 and worth 70 points

The Children’s Online Privacy Protection Act (COPPA) and the Children’s Internet Protection Act (CIPA) are both intended to provide protections for children accessing the Internet. However, they both have had some opposition.

Write a three to five (3-5) page paper in which you:
Describe the main compliancy requirements and the protected information for both COPPA and CIPA.
Analyze how COPPA and CIPA are similar and how they are different, and explain why there is a need for two (2) different acts.
Describe what you believe are the most challenging elements of both COPPA and CIPA to implement in order to be compliant.
Speculate on why COPPA and CIPA define protection for different ages; COPPA defines a child as being under the age of 13 and CIPA defines a minor as being under the age of 17.
Identify the main opposition to COPPA and CIPA based on research and speculate on whether they will be changed in the future based on the opposition.
Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required page length.
The specific course learning outcomes associated with this assignment are:
Explain the concept of privacy and its legal protections.
Describe legal compliance laws addressing public and private institutions.
Use technology and information resources to research legal issues in information security.
Write clearly and concisely about information security legal issues and topics using proper writing mechanics and technical style conventions.

Computer science

Students, please view the “Submit a Clickable Rubric Assignment” in the Student Center.
Instructors, training on how to grade is within the Instructor Center.

Assignment 2: COPA and CIPA
Due Week 4 and worth 70 points

The Children’s Online Privacy Protection Act (COPPA) and the Children’s Internet Protection Act (CIPA) are both intended to provide protections for children accessing the Internet. However, they both have had some opposition.

Write a three to five (3-5) page paper in which you:
Describe the main compliancy requirements and the protected information for both COPPA and CIPA.
Analyze how COPPA and CIPA are similar and how they are different, and explain why there is a need for two (2) different acts.
Describe what you believe are the most challenging elements of both COPPA and CIPA to implement in order to be compliant.
Speculate on why COPPA and CIPA define protection for different ages; COPPA defines a child as being under the age of 13 and CIPA defines a minor as being under the age of 17.
Identify the main opposition to COPPA and CIPA based on research and speculate on whether they will be changed in the future based on the opposition.
Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; references must follow APA or school-specific format. Check with your professor for any additional instructions.
Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required page length.
The specific course learning outcomes associated with this assignment are:
Explain the concept of privacy and its legal protections.
Describe legal compliance laws addressing public and private institutions.
Use technology and information resources to research legal issues in information security.
Write clearly and concisely about information security legal issues and topics using proper writing mechanics and technical style conventions.