Reference no: EM131067030
Projects Microsoft Office Applications Software
I. Microsoft Word
Create a one page document on any topic that interests you and save it with your User ID as the leading characters in the file name. Your document must include the following features:
• Bold text
• Italic text
• Underlined text
• Centered text
• Copied text (copy and paste text)
o Change the font type and font size of the copied text
• A bulleted list (as in this list)
• Any clip art or other graphics image inserted into your document
Submit a printout of your word document with your final exam on the day of the final.
II. Excel
Create a spreadsheet for a payroll application for at least five employees and save it with your User ID as the leading characters in the file name. Include at least one graphic image of your choice using the chart wizard. Your spreadsheet should contain the following data with appropriate row and column labels:
• Federal tax percentage at top of spreadsheet
• State tax percentage at top of spreadsheet
• For each employee (each item will be a column)
o Name
o Hours worked
o Hourly rate of pay
o Gross pay (hours worked * hourly rate of pay)
o Federal Tax Amount (gross pay * federal tax percentage)
o State Tax Amount (gross pay * state tax percentage)
o Net pay (gross pay - federal tax amount - state tax amount)
• Column totals
o Total Gross pay
oTotal Federal tax amount total o Total State tax amount
o Total net pay
• Column averages
o Average Gross pay
o Average Federal tax amount total o Average State tax amount
o Average net pay
• Using the Chart Wizard in Excel create a Chart of the data of your choice with a chart type of your choosing
Submit a printout of your spreadsheet with your final exam on the day of the final.
III. Powerpoint
Create a presentation consisting of at least 5 slides on any topic. Include the following features:
• Varied slide types
• Text
o Centered
o Bulleted list o Bold
• Any clip art or other graphics image
• Sound clip
• Italic text
Sound clips, videos, graphics and clip art can be downloaded from free sources on the web.
• Print out your slide presentation. You may print multiple slides on one page.
Submit the printout of the presentation with your final exam on the day of the final.
IV. Access
Create a database with at least eight records added to keep track of your favorite television shows. Each record should have at least five fields of your choice. Submit the following screen captures of your database design and functioning in a word document:
• Screen capture of Database design from the design view after creating table
• Screen capture of Datasheet view after entering data for at least eight records
• Screen capture of Query design views for each of two queries
• Screen capture of Output from Queries after running each of two queries
• Examples of queries could be:
o Which of my favorite shows are comedies?
o Which of my favorite shows start after 9:00 P.M.?
Submit the word document with your final exam on the day of the final.
|
Fill in the frequency cells using the frequency function
: Calculate the Cumulative Interest column. You MUST use the CUMIPMT function and the "Type" will be 0 (Make the value return a positive number). Calculate the Cumulative Principal column.
|
|
Contrast parkinson disease and huntington disease
: Compare and contrast Parkinson's disease and Huntington's disease. Huntington's disease is caused by a faulty gene on chromosome. The gene, which produces a protein called Huntingtin.
|
|
What are externalities
: What are externalities? Give an example of a positive externality and a negative externality. In each case, explain the difference between the private market outcome and the socially optimal outcome.
|
|
What is the maximum speed at which one can travel
: what is the maximum speed at which one can travel to avoid being involved in the accident?
|
|
Create a spreadsheet for a payroll application
: Create a spreadsheet for a payroll application for at least five employees and save it with your User ID as the leading characters in the file name. Include at least one graphic image of your choice using the chart wizard.
|
|
In what studies could you use convenience sampling
: In what studies could you use convenience sampling? What are some of the strengths of using this method? What are some weaknesses? How can these affect research results?
|
|
Intercultural and co-cultural communication
: Explain how differences in the perception of time and the use of space affect intercultural and co-cultural communication.
|
|
Amphibian trapped down
: Well, while I'm as healthy as can be, the same cannot be said for my poor neighbour, whose throat is so painfully sore that she is convinced (idiomatically, of course) that there's an amphibian trapped down there. With this in mind, what on earth ..
|
|
Long essay- remember to have a thesis
: Write a logical, emotional, and ethical (ethos) appeal for why Gregor's family from the "Metamorphosis" should not or should have let him die.
|