Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

13903 alvarez rd jacksonville fl

26/10/2021 Client: muhammad11 Deadline: 2 Day

Computer Science

Open PowerPoint. Create a new presentation. For the opening slide, type "CS 120 Final Exam Term Year" as the title. Term being Winter/Fall/Spring. Put your name as the subtitle. Use any formatting or style you wish. You are done with slide 1. The content for the next four slides will created in Word, Excel and Access. The specifications for these slides are provided below. Save your presentation as final.pptx.

Slide 2 Microsoft Excel (10 points)

Open Excel. Create a new spreadsheet named final.xlsx. Enter the following data into the worksheet. Enter numbers exactly as you see them. The first row is a heading that should merge across all six columns.

http://www.cs.csubak.edu/~bryant/cs120/Final/tableWeightTax.png

To complete your worksheet, add the following:

1. Enter a formula to compute the tax on each order (Price * 0.07). Format the values as 'Currency'.

2. Use the IF function to find the shipping charge. If the weight is more than 125 pounds the shipping charge is $1.00 per pound (1.00 * pounds). Otherwise it is $0.75 per pound (.75 * pounds).

3. Use either a function or a formula to find the total cost of each order.

4. Display the numbers in the Tax, Shipping, and Total columns with two decimal places.

5. Make the title bold and increase the font size of it.

6. Sort the data by descending 'Order No.'.

Return to your PowerPoint presentation. Insert a new slide. Copy and paste your finished Excel table into the slide. You are done with slide 2.

Slide 3 (10 points)

Return to Excel. In the same Excel workbook, rename Sheet 2 as Exercise 2 and enter the following data on the Exercise 2 sheet.

http://www.cs.csubak.edu/~bryant/cs120/Final/tableFruitPreferences.png Using the above data, make a Bar Chart. Save it on the same sheet as the data. Resize the chart if necessary to make the legends and titles clearly visible. When finished, it should look like the chart below.

http://www.cs.csubak.edu/~bryant/cs120/Final/fruitPreference.png

Return to your PowerPoint presentation. Insert a new 'Title Only' slide. For the slide title, enter your name. Copy and paste your Excel Bar Chart into the slide. You are done with slide #3. Save your worksheet in case you need to create your slide again.

Slide 4 Acess (10 points)

Import these files into your Access Database

Open Access. Create a blank database named final.accdb. Import the tables from above and name them Students, GPA, & Major. The data files you downloaded are comma delimited files (CSV) or tab delimited. The three files represent tables for Students, a table for their major, and a table for their GPA.

Create a query that selects all of the history majors and their GPA.

Now create a report with all of the students in the History department with a GPA greater than or equal to 3.50. You will have the following fields in the given order 'Last', 'First', 'Department', & 'GPA'. Hint: put >= in the GPA Criteria field when in the query design view. Order the table from highest to lowest GPA.

Make the report fit on one page and make it look neat. So shorten up the text boxes put a title, remove the time from the header and reformat the date to mm/dd/yyyy.

Return to your PowerPoint presentation. Insert a new slide. Paste your report on this slide. You are done with slide #4.

Slide 5 (10 points)

Create a form for the 'Students' table using the 'Form Wizard' from the ribbon. Update all of the fields using one form. The form should look like the one below and in that order. TITLE YOUR FORM 'Bakersfield Students Data Update'. Take a screen shot of your form and insert it into slide #5. (See the 'Addendum' below that uses 'Paint' to do the screen capture, Google it, or use your favorite program to capture screen images and edit them. The TA can also help. Also you can take a picture with your phone and attach that.

http://www.cs.csubak.edu/~bryant/cs120/Final/access_form_final.png

Slide 6 (10 points) Using the above form add five entries where the 'City' is equal to 'Bakersfield'. Leave the first field alone it will populate on its own. Use fictional data for the other fields. Remember the zip has to be numbers. Select only the cities that match 'Bakersfield'. Create a report with only the Bakersfield entries. Make the report look nice and copy it to the PowerPoint presentation as slide #6

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Professional Coursework Help
24/7 Assignment Help
Smart Homework Helper
Assignment Solver
Academic Master
Peter O.
Writer Writer Name Offer Chat
Professional Coursework Help

ONLINE

Professional Coursework Help

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$41 Chat With Writer
24/7 Assignment Help

ONLINE

24/7 Assignment Help

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$38 Chat With Writer
Smart Homework Helper

ONLINE

Smart Homework Helper

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$28 Chat With Writer
Assignment Solver

ONLINE

Assignment Solver

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$37 Chat With Writer
Academic Master

ONLINE

Academic Master

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$24 Chat With Writer
Peter O.

ONLINE

Peter O.

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$48 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

HS440 Raquel Lytle - Jb hi fi games return policy - Sun microsystems case study valuation - Monthly fee commonwealth bank - Bartlett believed that the memorizer organizes material into meaningful wholes that he called - What is the purpose of man's existence - Williams nelson and quick principles of management cengage 2016 - Brasov olympic ice rink - Can you use zappos gift card on 6pm - Picasso girl before a mirror meaning - Contribution margin per unit - Theology sir is a fortress meaning - 700 word discussion: Complexity is increasing as new technologies are emerging every day. This complexity impacts human experiences. Organizations are turning to digitally enabled solutions to assist with the emergence of digitalization. - Week 1 case study - Xian janssen pharmaceutical china and the euro - Oedipus text online - Thorn jupiter 3 led - Strategic Management and Strategic Competitiveness - Discovering psychology remembering and forgetting worksheet answers - Vertex42 gantt chart pro password - Wuthering heights chapter 29 summary - Ms groves has trays of paints for students - Contingent assessment methods - Token economy parenting - Thums up taste the thunder - Of the different types of memory, _____ memory has the shortest duration. - Business organizations - Supply Chain management - A birthday present sylvia plath sparknotes - 2008 general maths hsc - The operations section chief - Harvard case studies pdf - The chimney sweeper songs of innocence summary - Dissertation topic proposal - Cherry blossom pink and apple blossom white song - Appreciation - Technology-based leadership - Response to intervention case study - Landis+gyr e350 user manual - Choose the best answer - Webinars - Ethical terms nursing - Shona rapira davies - Alka seltzer surface area experiment - Toyota weaknesses 2018 - Psychological first aid training post test answers - Sample of minutes writing - Biology 1 - 2c rosslyn street glengowrie - Safely share secure data - Notre dame referencing guide - Describe the role of three external services during an emergency - Josephine paterson and loretta zderad - Discussion / read chapter 1 / around 300 words / answer and comment / need within 10 hours - 2.19 5 circle pyramid 2.0 - 7215 hydrus drive harrison tn - Motor vehicle repairers licence wa - Need Response to below discussion-cloud IT - Empirical formula of benzene - William shakespeare webquest answer key - Mighty to save chords - Alberto's pizza philippines franchise cost - Freezing and boiling point graph answers - Near east university mechanical engineering - Implementing change business case ldr - Bradfords builders merchants liskeard - Canadian Business law Case report essay - Warr corporation just paid a dividend - Money and the prices in the long run and open economies - Broadway leisure caravans wrexham - Blade runner origami chicken - Leadership is the ability to ______ employees to voluntarily pursue organizational goals. - Intro to Cybersecurity and Technology - 3 minute persuasive speech examples about bullying - Assignment 2 situation analysis course hero - Comp4920 company case study - Catcher in the rye historical context - One by kathryn otoshi summary - Stop all the clocks poem - Pumicestone passage marine park - Contract Law Case Analysis - Outline for effective speaking - Www.blackboard.com mdc - Life Cycle Assessment - A pyramid has how many faces edges and vertices - What is first class lever - Comprehensive problem 1 period 2 the accounting cycle answers - Water in our world cpalms - Ksa examples for postmaster - An electric space heater draws 15.0 a - Module 07 Case Study - Advance Pharmacology - Hampshire hospital blood test - 200 mercedes ct grandy nc - They say i say 4th edition online - How to make a diet coke and mentos rocket - St lucy's home raised by wolves short story sparknotes - The cutting edge the magic of movie editing worksheet - Best company vision statements 2014 - How to install float valve on power pressure cooker xl