computer class homework
PracticalExercise
Don't use plagiarized sources. Get Your Custom Essay on
computer
Just from $13/Page
Power Point (20 Spring B)
Design and create a short presentation about an historical event that
has influenced or affected you or the world.
Create a short presentation (minimum of 7 slides) about this event. You
may choose any information that can support your presentation. Be sure to
give some background information.
Be sure to use the 7×7 Rule.
Maximum of 7 lines per slide
Maximum of 7 words per line
A paragraph that has been separated into 7 lines with 7 words is not
following the 7×7 rule.
Save your presentation as PE_PP_yourname
You MUST include the following in the presentation:
Use texts that tells about your chosen event
Include a Works Cited Slide
Pick an appropriate Design Theme
Use Word Art for your Title on the Title page
Use images that are appropriate to the presentation
Apply effects to the images
o Add frames, effects,
Use shapes to enhance your presentation
o Include a shape on the Title slide
Use an image/picture as a background for 1 slide in the presentation
Use a texture as a background for 1 slide in the presentation
Apply a transition (use the same transition throughout the
presentation)
Apply an animation in at least 3 slides
Include a footer on all slides except the Title Slide
o Include your Name and Student ID number in the footer
Change the Document Properties
o Include
Name
Subject
Tags (use more than 3 keywords separated by commas)
Author
BE CREATIVE AND HAVE FUN with the presentation.
PRACTICALEXERCISE EXCEL Module 1
Exercise 1
Projected College Cash Flow Analysis Worksheet
Problem: Attending College is an expensive proposition and your resources are limited.
To plan for your four-year college career, you have decided to organize your anticipated
resources and expenses in a worksheet. The data required to prepare your worksheet is shown in
Table.
1. Using the numbers in above Table 1–9, create the worksheet shown in columns A
through F in next Figure.
2. Format the worksheet title as Calibri 24-point bold purple.
3. Merge and center the worksheet title in cell A1 across columns A through F.
4. Format the worksheet subtitles in cells A2 and A11 as Calibri 16-point bold red.
5. Format the ranges A3:F3 and A12:F12 with the Heading 2 cell style and center the text in the
cells.
6. Format the ranges A4:F9 and A13:F19 with the 20% – Accent 2 cell style,
7. Format the ranges A10:F10 and A20:F20 with the Total cell style.
8. Change the name of the sheet tab to College Cash Flow Analysis.
9. Save the workbook using the file name, Case2 College Resources and Expenses.
10. Select the range (A2:A9), press and hold control key and select the range (C2:C9). Release control
key.
11. Insert an Exploded pie in 3-D chart to show the contribution of each category of resources for the
sophomore year.
12. Select the range (A12:A19), press and hold control key and select the range (C12:C19). Release
control key.
13. Add the Pie chart title as shown in Figure.
14. Save the workbook as EX-PE1-Ex1-YourName. Change it to landscape orientation.
15. Submit the assignment to as indicated for your instructor.
Exercise 2
Enter the data given below into a worksheet.
A B C D E
1 Stationery Supplies Ltd
2
3 Date Sales Person Item Receipt No Amount
4 21-Nov Carl Toys 1238 1,782.10
5 26-Nov Carl Stationery 1255 4,853.55
6 26-Nov Carl Toys 1395 51.35
7 Carl’s Total
8 21-Nov John Cards 1141 91.15
9 24-Nov John Books 1982 442.60
10 21-Nov John Toys 1885 561.50
11 26-Nov John Toys 1875 62.75
12 John’s Total
13 22-Nov Judy Books 1032 234.50
14 26-Nov Judy Sports goods 1920 472.60
15 Judy’s Total
16 25-Nov Mary Toys 1774 364.15
17 Mary’s Total
18 22-Nov Susan Electronics 1160 52.95
19 23-Nov Susan Cards 1075 81.60
20 23-Nov Susan Others 1745 132.95
21 24-Nov Susan Sports goods 1662 2,580.10
22 Susan’s Total
23
24 Grand Total
(i). Calculate the totals for each salesperson and get the grand total.:
(ii). Format the worksheet as follows:
Make all the Totals bold, two decimal places, comma, center the title across columns A-E and
make it size 16, bold and Italic.
(iii). Put a double border round the whole table and a single line border inside the table.
(iv). Add a Pie 3D Chart with the Total Sales of each Sales Person
(v). Save the worksheet as EX-PE1-Ex2-YourName
Final Project
READ THIS ENTIRE DOCUMENT BEFORE YOU BEGIN
Your Final Project will consist to select a topic and develop a research paper, a power
point and a spreadsheet about the topic selected. The three parts need to be
connected.
It is a mostly free topic. You may choose whatever you would like to talk about, keep it
fun. The exceptions are as follows:
• No PROJECTS about
o Sex
o Drugs
o Religion
o Politics
o Family
o Family Pets
o No previously done projects from previous and/or present courses.
o No projects about the country which you are from.
o No projects where you have to list things like the 7 wonders or the world.
o No projects about Technology (Keep them fun and light)
Keep the assignment fun and light. Something of interest, a hobby,
favorite place, favorite past time, etc.
Be specific on a topic.
Rules for the Final Project
1. Research Paper: Should be between two and four pages not included the Work
Cited. The MLA documentation style must be used. (40 points)
2. PowerPoint, you must: (60 Points)
o Find photographs
o Your Presentation should not be your entire research assignment.
o USE THE 7X7 RULE
7 lines per slide (maximum)
7 words per line (maximum)
o Use key words and/or phrases to make your point
o DO NOT crowd the slides with too much text or pictures
o Use the NOTES Pages underneath each slide to include some
information you are going to talk about if/when presenting in front of an
audience.
o The purpose of the presentation is to give details, information or teach
about a subject.
o Be sure that your slides contain both text and pictures
o There should not be any slides with pictures only
o Be sure to submit a PowerPoint Presentation and not a Slide Show. (Be
careful on how you save it!)
o DO NOT make the slides change automatically
o The Presentation MUST have a minimum of 10 slides.
Slide 1: Title
Slides 2 – 9: Presentation
Slide 10: Works Cited, Links and resources
o Create a video that need to be related to the topic (10 points)
o Be sure to add your picture somewhere in the PowerPoint Presentation
