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

21038 athens street ashburn va

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:

Math Specialist
Isabella K.
Math Guru
Finance Professor
Chartered Accountant
Assignment Helper
Writer Writer Name Offer Chat
Math Specialist

ONLINE

Math Specialist

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$49 Chat With Writer
Isabella K.

ONLINE

Isabella K.

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

$25 Chat With Writer
Math Guru

ONLINE

Math Guru

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$25 Chat With Writer
Finance Professor

ONLINE

Finance Professor

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.

$19 Chat With Writer
Chartered Accountant

ONLINE

Chartered Accountant

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.

$17 Chat With Writer
Assignment Helper

ONLINE

Assignment Helper

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

$39 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

How is fear shown in year of wonders - 11a queen street balcolyn - Polish national folk costume - 10 1 3 as an improper fraction - Julie bowen eating disorder - Occupied america a history of chicanos 7th edition pdf - Lab report photosynthetic pigments paper chromatography - The lion king can you feel the love tonight - 6103 Week 6 Discussion - Physical, Emotional, and Spiritual Well-Being - 3 letter blend words - Occupational therapy enablement foundations - Racq service centre gold coast - Dance classes brisbane southside - Acc pre assessment - Invacare oxygen concentrator troubleshooting - Briefing paper format cim - Nursing an ethical (Due 24 hours) - Individual assignment - Rsh hong kong limited - Isa in computer architecture - SOCW 6111 - Legislation that has occurred as a result of Nurse advocacy - Kilkenny county council jobs - Hacs air conditioning darwin - Anjolie perfume - How to calculate usual body weight - Compare and contrast vision and mission statements - Diversity Issues in Criminal Justice_Week 6 - Urgent 1 - Current Events Article (4 paragraphs total) - Lloyds bank summer internship - Terms of reference template - Beatrice in a view from the bridge - Relevant costing questions and answers - Dark side of leadership- Summary - Roman numerals rules pdf - Solar Energy for Residential Homes - Contemporary nursing practice - Entrepreneur self assessment profile - Bronfenbrenner defined human development as - PM WK 3. - Hyphenated synonym for commotion tumult confusion - Betrayal in the city - Stage 1 living things - 1101 sequence detector state diagram - Jason benjamin twin falls - Phasor to rectangular calculator - Dogs are better than cats essay - Minority student clubs segregation or integration gabriela moro - Types of leadership cafs - Square root in jupyter notebook - Least common multiple of 12 18 - Presentation handout template word - Igcse biology syllabus 2015 - Gas discharge tube symbol - Disney snow globe maker tesco - Wee sleekit cowrin tim rous beastie - Scaling report 2013 vce - Causes and Treatment of ADHD - Dawson toys ltd produces a toy called - Analyze the strategies used to negotiate new managed care contracts - Deli3 - Hacksaw ridge introduction - Psa powerpoint examples - Bi project plan examples - Http www houstonzoo org gorilla habitat cam - Hec paris international students - Please discuss the following prompt: - A luxury cell phone maker has a high fixed cost - Osha 30 hour test answers - Lone pine cafe balance sheet - To the power of 10 - How to balance polyatomic ions - A godly woman is to be praised - Positive Impacts of Emotional Support Animals - Sears holdings swot analysis 2018 - Seussical the musical mayor - What is diversity indices - Tic tac toe android source code download - Journalize the four entries required to close the accounts - Kubler ross change curve harvard reference - TLMT318 Week 2 Quiz 1 SCORE 100 PERCENT - Into the wild chapter 4 summary - Male health interview - Socrates moral principles - Social work treatment interlocking theoretical approaches 5th edition - Chartered banker mba cost - She's come undone wally lamb sparknotes - Electrical contractors licence vic - Frequency response of rc and rl circuits - Who owns haco industries - Half wave full wave rectifier experiment - Power-Flow Problem - Week -1 discussion Global econ - Types of strategic fit - ECON 2200 MOD 2 DB - Consumer autonomy in business ethics - Because it speaks deceit and i am honest - Hr chally assessment questions - The artichoke version of the self