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

Glow in the dark widget penn foster

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

LESSON 6 Computer Applications 2016 Graded Project

Graded Project

Computer Applications

© PENN FOSTER, INC. 2016 PAGE 1COMPUTER APPLICATIONS Graded Project

INTRODUCTION 2

INSTRUCTIONS 2

SCORING GUIDELINES 10

SUBMITTING YOUR PROJECT 13

INTRODUCTION

CONTENTS

© PENN FOSTER, INC. 2016 PAGE 2COMPUTER APPLICATIONS Graded Project

COMPUTER APPLICATIONS

INTRODUCTION

This project uses the skills you’ve acquired for Word, Excel, and PowerPoint to prepare for a sales meeting. You’ll assume the role of Director of Sales. For this project, you’ll complete a memo, a spreadsheet with sales figures and a chart, and a presentation that integrates spreadsheet data.

INSTRUCTIONS

MEMO

1. Start Word and create a new blank document.

2. Create a memo for the sales meeting as shown in Figure 1, using the following formats:

a. The company name should be in Arial 20-point, bold, purple font.

b. The memo headings and text should be in Times New Roman, 12-point font, with left-aligned tab stops set to 1 inch.

c. Replace Your Name Here with your name.

d. The body text should be in Times New Roman, 12-point font, with bold text where indicated.

Figure 1

3. Save the document as Meeting Memo.

© PENN FOSTER, INC. 2016 PAGE 3COMPUTER APPLICATIONS Graded Project

3. Save the worksheet as Summer Sales.

4. Create a column chart based on cells A4 through D7 that looks similar to Figure 3.

a. Select the 2-D Column Stacked Column style.

b. After the chart is created, add data labels as shown in the figure.

c. Edit the chart title as shown in the figure.

SPREADSHEET AND CHART

1. Start Excel and create a new blank workbook.

2. Enter data as shown in Figure 2, using the following formats:

a. The company name should be in Arial, 20-point, bold, purple font.

b. The Summer sales title should be in 16-point font.

c. The company name and Summer sales titles should be merged and centered.

d. Column headings should be bold, and month headings right-aligned.

e. The sales figures should be in Currency cell style with no decimal places.

f. Formulas that use functions should be used for calculated totals.

g. Cells B8 through E8 should be formatted in the Total cell style.

Figure 2

© PENN FOSTER, INC. 2016 PAGE 4COMPUTER APPLICATIONS Graded Project

5. Save the modified workbook. Your final spreadsheet should look similar to Figure 4.

Figure 3

Figure 4

© PENN FOSTER, INC. 2016 PAGE 5COMPUTER APPLICATIONS Graded Project

PRESENTATION

1. Start PowerPoint and create a new blank presentation.

2. Change the theme of the presentation to Crop or another appropriate style if you don’t have Crop.

3. Verify that slide 1 uses Title Slide layout and then enter text so that your slide looks similar to Figure 5.

Figure 5

Figure 6

4. Add a new slide 2 with a Blank layout, insert a table, and then add the sales data from the Summer Sales workbook. Size the table so that slide 2 looks similar to Figure 6.

© PENN FOSTER, INC. 2016 PAGE 6COMPUTER APPLICATIONS Graded Project

5. Add a new slide 3 with a Blank layout and then insert a Stacked Column chart. Add the Summer sales data, format the title, and add the data labels to each column. Size the chart so that slide 3 looks similar to Figure 7.

Figure 7

Figure 8

6. Add a new slide 4 with a Picture with Caption layout and add content so that the slide looks similar to Figure 8. Insert the Glow in the Dark Widget.jpg, a data file for this graded project.

© PENN FOSTER, INC. 2016 PAGE 7COMPUTER APPLICATIONS Graded Project

7. Add three more Picture with Caption layout slides to introduce the Lime Doodad, Buttercup Gizmo, and Black Widget products. Their corresponding image files are data files for this graded project. Your slides should look similar to Figures 9, 10, and 11.

Figure 9

Figure 10

© PENN FOSTER, INC. 2016 PAGE 8COMPUTER APPLICATIONS Graded Project

8. Add a new slide with a Title and Content layout and add text so that the slide looks similar to Figure 12.

Figure 11

Figure 12

© PENN FOSTER, INC. 2016 PAGE 9COMPUTER APPLICATIONS Graded Project

10. Apply the Page Curl transition to all the slides.

11. Apply the Grow & Turn animation to each of the bullet items on slide 8.

12. Save the presentation as Fall Meeting, and then play the slide show from the beginning to check your presentation.

Figure 13

9. Add a new slide with a Title Only layout. Insert text and a clip art picture that thanks employees for their hard work (use “thank you” as the search text when searching for the image). Size and position the picture to look similar to Figure 13.

© PENN FOSTER, INC. 2016 PAGE 10COMPUTER APPLICATIONS Graded Project

SCORING GUIDELINES

RUBRIC

SKILL/ GRADING CRITERIA

EXEMPLARY (4)

PROFICIENT (3)

FAIR (2)

POOR (1)

NOT EVIDENT

(0)

Create a memo

A memo with all appropriate formatting, including tab stops, and accurate text, has been created.

A memo with most of the correct content and format- ting has been created.

A memo with most of the correct con- tent and some of the correct formatting has been created.

A memo with little or no for- matting and inaccurate content has been created.

No attempt has been made to cre- ate a memo.

Create a spread- sheet

All cell data is correctly for- matted and the calculations use formulas with functions.

Cell data is cor- rectly formatted and some cal- culations use formulas with functions.

Some cell data is correctly formatted and some calcu- lations use formulas with functions.

Some cell data is present with little or no formatting or use of formulas for calculation.

No attempt to create a spreadsheet has been made.

Create a chart

A column chart based on the correct data, the specified style, and the correct labels has been created.

A column chart based on the correct data, the specified style, but with- out the correct labels has been created.

A column chart based on the correct data, with an unspecified style, and the correct labels has been created.

A chart has been cre- ated without the correct data, speci- fied style, or labels.

No attempt to create a chart has been made.

Create a presentation

A presentation in the specified theme with 9 slides in the correct lay- outs has been created.

A presentation in the specified theme with most of the slides in the correct lay- outs has been created.

A presentation in the spec- ified theme with some of the slides in the correct layouts has been created.

A presen- tation with fewer than 9 slides in varying layouts has been created.

No attempt has been made to create a presentation or fewer than 9 slides without some required content have been created.

(Continued)

© PENN FOSTER, INC. 2016 PAGE 11COMPUTER APPLICATIONS Graded Project

Insert Excel data as a linked object into

slide 2

The specified cell data has been pasted as a linked Excel Worksheet object into slide 2 and appropri- ately sized.

The specified cell data has been pasted as an Excel Worksheet object without linking.

The specified cell data has been copied and pasted as a PowerPoint table or embedded.

An attempt has been made to paste some cell data into the presentation.

No attempt has been made to add Excel spreadsheet data to the presentation.

Paste an Excel

chart into slide 3

The specified Excel chart has been pasted into slide 3 and appropriately sized and positioned.

The specified Excel chart has been pasted into slide 3 but not sized or positioned.

The specified Excel chart has been rec- reated in the presentation by using the Insert Chart command.

The chart has been inserted as an Excel Worksheet Object and displays the entire worksheet.

No attempt has been made to add a chart to the presentation.

Insert data file images

Images have been inserted as specified.

Most of the specified images have been inserted.

Some of the specified images have been inserted.

Few of the specified images have been inserted on any slide.

No attempt has been made to add specified images to the presentation.

Insert a clip art

image into slide 9

An appropri- ate clip art image has been inserted on slide 9 and appropriately sized and positioned.

An appropriate clip art image has been inserted on slide 9 but may not be sized or positioned appropriately.

N/A N/A No attempt has been made to add an appropriate clip art image.

Apply a transition

The Page Curl transition has been applied to all slides.

The Page Curl transition has been applied to two or more slides.

The Page Curl transition has been applied to one slide only.

The wrong transition has been applied.

No attempt has been made to apply a transi- tion to any of the slides.

Apply animations

The Grow & Turn ani- mation has been applied to each bullet item separately.

The Grow & Turn anima- tion has been applied to all the bullet items together.

A different animation has been applied to each bullet item separately.

A different animation has been applied to all the bullet items together.

No attempt has been made to apply an animation.

© PENN FOSTER, INC. 2016 PAGE 12COMPUTER APPLICATIONS Graded Project

SUBMISSION CHECKLIST

Before submitting your project, make sure you’ve correctly completed the following:

q Enter text in Word.

q Set tab stops.

q Apply formatting to text in Word.

q Enter and format data in Excel.

q Merge and center cells in Excel.

q Change the decimals displayed by numbers in Excel.

q Create a 2-D Column chart in the Stacked Column style.

q Modify the data labels of the chart.

q Change the layout of the specified slides.

q Apply a theme to the presentation.

q Add nine slides of different layouts to the presentation.

q Insert and format a table in a slide.

q Create and format a chart in a slide.

q Insert existing picture files into slides.

q Insert a clip art image from the Internet into a slide.

q Apply a transition to all slides.

q Apply an animation to bullet points separately.

q View a slide show from the beginning.

© PENN FOSTER, INC. 2016 PAGE 13COMPUTER APPLICATIONS Graded Project

SUBMITTING YOUR PROJECT

Each project is individually graded and therefore could take approximately 5–7 business days to grade. You will submit three files for this project:

1. Meeting Memo.docx

2. Summer Sales.xlsx

3. Fall Meeting.ppt

Make sure the following information is in the heading of each file:

O Your name

O Your email address

O Your student number

O Course name and number

O Project number (58480700)

Follow this procedure to submit your assignment online:

1. Go to http://www.pennfoster.edu and log in to your student portal.

2. On your student portal, click on Exam.

3. In the box provided, enter the examination number. The number for this exam is 58480700.

4. Click Submit.

5. On the next screen, enter your email address. (Note: This information is required for online submission.)

6. If you wish to tell your instructor anything specific regarding this assignment, enter it in the Comments.

7. Attach your file or files as follows:

a. Click on the first Browse box.

b. Locate the file you wish to attach.

c. Double-click on the file.

d. To attach the additional files, click on the next Browse box and repeat steps b and c. Repeat until all files are uploaded.

8. Click Submit.

Be sure to keep a backup copy of any files you submit to the school!

http://www.pennfoster.edu

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:

Homework Master
Instant Assignments
Essay Writing Help
Coursework Assignment Help
Quality Homework Helper
Write My Coursework
Writer Writer Name Offer Chat
Homework Master

ONLINE

Homework Master

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$34 Chat With Writer
Instant Assignments

ONLINE

Instant Assignments

Give me a chance, i will do this with my best efforts

$28 Chat With Writer
Essay Writing Help

ONLINE

Essay Writing Help

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$48 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment Help

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$38 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$24 Chat With Writer
Write My Coursework

ONLINE

Write My Coursework

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

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

Is light reflected or refracted mastering physics - I Need PGCE Assignment Help Service in UK! - Week 8 Response to feedback - M4 hole size in mm - Gordon roddick net worth - Code review practice comes under which domain of bsimm - A b 4 expansion - Does rap stand for rhythm and poetry - Why was the controlled substance act created - 8 steps of ethical decision making - Business valuation report format in word - Jamba juice net worth - 8 2 2 project 3 multimedia presentation submission - Annotated Bibliography - Which poet wrote the most poems about tanabata - What is a value scale in art - Https apps deadiversion usdoj gov webforms - Math homework - Writing - Difference between manual accounting system and computerized accounting system - Sample excel sheet with employee data - What is a strong entity - The color of water - Example of a 4 mat review paper - Determine the size of square bearing plates - Eye level camera angle - Epic hero chart for beowulf - Aptly named sleep aid crossword clue - Overhead ground wire lightning protection - Cyber risk management and emerging cyber security attacks - The earnings dividends and stock price of shelby - Utilitarianism and Deontology Assignment - Www youtube com watch v litxw91uaue - 1769 l19er bb1b user manual - Persuasive speech on honey bees - Noncallable bonds that mature in years - Examples of unicellular organisms and multicellular organisms - How do kangaroos maintain homeostasis - Follow the guide tag a career like the future essay - Agar jelly diffusion experiment method - Business Intelligence 14 - Total the capacity of each product in that segment capsim - Slumdog millionaire part 3 - C squared equals a squared b squared - The french revolution timeline - System analysis and design - Csu discussion - A 20g ball of clay traveling east at 2.0 - Middle passage robert hayden analysis - D2 2 - How to use ardex feather finish - Bosch v perpetual trustee co ltd - How to staff a 24 7 operation - Quotes from to kill a mockingbird chapter 1 - Article Review- Corporate Finance - Four causes of the great depression - Dsm 5 bipolar 2 disorder criteria - Fin 571 interpreting financial results - Unit 4 legal and ethical responsibilities worksheet answers - Week 3 discussion form: peer review for scientific and mathematical analytic inquiry draft - "A" WORK PLAGIARISM FREE - Tri quad penta hexa hepta octa - Body shop start up cost - Population health and epidemiology - Caged bird and free bird - What does the concept of free cash flow represent - Rectification of errors meaning - How to calculate freezing point depression - Two main branches of statistics - Important court cases apush - Fish cheeks by amy tan answer key - Baw baw snow cam - Financial Statements - Competitive position - Direct and partial variation - Jay z 8 miles and runnin lyrics - Match the hominin group to the description of their morphology at ~40,000 to 25,000 ybp. - Milestone 3 - The cancer journals audre lorde sparknotes - Amanda Smith - Vertical bullet list smartart graphic - Uv light meter app - Why is random assignment important - New holland br740a specs - Loser geek whatever chords - Giggles and grins new iberia - Apics cscp learning system - Classify the following coordinate systems as either right-handed or not right-handed. - Winning grants step by step pdf - Short essay - What does parq stand for in pe - Financial statement analysis involves all of the following except - Hi amp buss 80 amp - Renold conveyor chain catalogue - Final Business Project Report - Katy perry brighter than the moon - 2 coments each one 150 words (CITATION AND REFERENCE) - Chase production strategy formula - Bernard l madoff investment securities llc company - Discussion 3 Japan