As students are working their way through college and preparing for the future, they will use skills learned in Computer Concepts and Applications for this final project.The students will be doing some research and creating an Excel Spreadsheet of Proposed College Expenses, a Resume and Cover letter for a possible job, and a PowerPoint Presentation relating to their field of study.
I. Resume and Cover Letter Instructions
Word 2016 - Creating a Resume Using a Template or table and a Cover Letter with a Table and bulleted list
Using what you have learned while working with Word, You will create a resume and cover letter for a potential job.
Assume you are graduating this semester and need to find a job immediately after graduation. Check your local newspaper or online employment source to find an advertisement for a job relating to your major or a job for which you believe you are qualified. Tailor your cover letter and your resume to fit the job description. Use the Copy and paste commands on the Office Clipboard to copy your name and address information from one document to the other.
At a minimum, the resume should:
1. Use a resume template or table to set up your resume
2. Contain a name, complete address, and telephone number of job seeker.
3. Contain an objective, education work experience sections, and any other pertinent sections. (you may enhance your job qualifications if necessary)
4. Fill a page.
5. Contain no spelling or grammar errors.
At a minimum, the cover letter should:
6. Contain an attractive letterhead including ClipArt.(Letterhead creation can be found in Word Module 1 Word Page 14-Word Page 16 of the text)
7. Add a hyperlink to your email address in the Letterhead.
8. Include all elements of a business letter (date line, inside address, salutation, body, complimentary close, a signature block, and an Enclosure line).
9. Place the date line, complimentary close, and signature on the 3.5" mark (set with tabs).
10. Include a table and a numbered or bulleted list.
11. Contain no spelling or grammar errors.
You do not need to submit the want ad because the pertinent information should be in the letter.
***Don't forget to add a footer to your documents and set the document properties with your name, assignment name and class section.
Make the cover letter and resume as professional as you can. You may supplement your information to make the assignment more complete.
II. Bachelor Degree Expense and Resource Projection
Attending college with limited resources can be a trying experience. One way to alleviate some ofthe financial stress is to plan ahead. Research how much it costs for Room & Board and Tuition & Books for a year at either Pierpont or Fairmont State. **Hint: You can look at the Costs in the Financial Aid links on your MyCampus page. Develop a worksheet following the general layout in Table 3-16that shows the projected expenses and resources for four years of college. Based on your research use the numbers you found and enter them under Freshman. Use the formulas listed in
Table 3-17 and the concepts and techniques presented you learned in Excel to create the worksheet.
Table 3-16 Bachelor Degree Expense and Resources Projection (If you are a 2 year student, you may include only the 2 years in your calculations)
|
Expenses
|
Freshman
|
Sophomore
|
Junior
|
Senior
|
Total
|
|
Room & Board
|
$ ????
|
 Formula A
|
|
|
-
|
|
Tuition & Books
|
$ ????
|
 Formula A
|
|
|
-
|
|
Clothes
|
$ 785.00
|
Formula A
|
|
|
-
|
|
Entertainment
|
$ 1520.00
|
 Formula A
|
|
|
-
|
|
Miscellaneous
|
$936.00
|
Formula A
|
|
|
-
|
|
Total Expenses
|
-
|
-
|
-
|
-
|
-
|
|
Resources
|
Freshman
|
Sophomore
|
Junior
|
Senior
|
Total
|
|
Savings
|
 Formula B
|
|
|
|
-
|
|
Parents
|
 Formula B
|
|
|
|
-
|
|
Job
|
 Formula B
|
|
|
|
-
|
|
Loans
|
Formula B
|
|
|
|
-
|
|
Scholarships
|
 Formula B
|
|
|
|
-
|
|
Total Resources
|
-
|
-
|
-
|
-
|
-
|
|
Assumptions
|
|
Savings
|
10.00%
|
|
Parents
|
12.00%
|
|
Job
|
11.00%
|
|
Loans
|
35.00%
|
|
Scholarships
|
32.00%
|
|
Annual Rate Increase
|
8.25%
|
Table 3-17 Bachelor Degree Expense and Resource Projection Formulas
Formula A = Prior Year's Expense * (1 + Annual Rate Increase)**Be sure to use Absolute Reference for the Annual Rate Increase in your
formula so the What-If Analysis will work correctly.
Formula B = Total Expenses for Year * Corresponding Assumption
After creating the worksheet:
(a)perform what-if analysis to determine the effect on the resources by increasing the Annual Rate Increase to 9.95%. Enter the answer below the worksheet;
(b)with the original assumptions, goal seek to determine what the Annual Rate Increase would be for the total expenses to be $100,000 and enter that rate below the worksheet;
(c ) below the worksheet, insert a hyperlink to the page where your got your information on the costs for your college.
***Don't forget to add a footer to your documents and set the document properties with your name, assignment name and class section.
III. Presentation Based on Major Field of Study
You will create a PowerPoint presentation dealing with a topic related to your major field of study. (If you do not have a major selected, choose a topic of study that interests you.
Design it as if you are giving a class presentation to familiarize your fellow students with your topic.
• Select an appropriate design template.
• Create an interesting title slide, using your name as the subtitle. Animate the title text appropriately by opening the Custom Animation dialog box.
• Include at least eight slides.
• Include at least one object from the "Stars and Banners" category of AutoShapes, adding text within that shape. For instance, you could insert a banner, increase its size, and write your title in it.
• Include clip art or other graphic images on at least three slides.
• Include at least one slide transition
• Animate at least one graphic.
• Include some sounds.
• Include a hyperlink to a site with information that pertains to your topic. (Make sure it works)
• Create a table with information about your topic. You might create a table of supplies needed and their costs.
• Add notes to some of the slides. (in space under slide where it says "Click to Add Notes")
• Spell check your presentation, and then check for any style problems.
• Include your footer on the slides.
• ***Don't forget to set the document properties with your name, assignment name and class section.
• Save your presentation using the filename MyPresentationyourname.
• Attach your presentation and any extra files (extra pictures or downloaded sounds that you added) and submit them.
IV. Submit your assignment files as specified by your instructor.