Create spreadsheets using basic spreadsheet functions
Order ID:89JHGSJE83839 Style:APA/MLA/Harvard/Chicago Pages:5-10 Instructions:
Create spreadsheets using basic spreadsheet functions
Outcomes addressed in this activity: Unit Outcomes:
Navigate Microsoft Excel to produce and format a worksheet.
Course Outcome:
IT133-4: Create spreadsheets using basic spreadsheet functions.
Scenario: You have decided that it might be a good idea to create a personal household budget. You want to be able to save money to purchase a house after you graduate. You decide to create a personal
budget. You may either gather your pay stubs and the bills you pay each month or create fictional expenses to complete this assignment.
Project Details
Open Microsoft Excel 2013. You will begin with a new worksheet.
Create and format row 1 to show the months for the year (Jan-Dec). Begin adding months in cell B1.
Create and format row 3 to show monthly income for each month (Jan-Dec),
For the income amount you can use the same amount for each month.
Label the row values as currency, 2 decimal places, and a dollar sign.
Create and format a row for 8 separate expenses and do not format to currency.
For the 8 expenses create a year’s history by month. Use different values for each month.
For example, for electric, you would pick a number between $125 and $142 for January (or use your actual data), a different number between $125 and $142 for February, and so on.
Select an appropriate style for your budget and apply it to your worksheet.
See the example below for an idea of how to set up and format your Excel Worksheet.
Directions for Submitting Your Assignment
Complete your Spreadsheet in Microsoft Excel and save as Unit_7_Lastname.xslx and submit it to the Assignment Dropbox for Unit 7.
Create spreadsheets using basic spreadsheet functions
RUBRIC
Excellent Quality
95-100%
Introduction 45-41 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Literature Support
91-84 points
The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.
Methodology
58-53 points
Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score
50-85%
40-38 points
More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.
83-76 points
Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.
52-49 points
Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality
0-45%
37-1 points
The background and/or significance are missing. No search history information is provided.
75-1 points
Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.
48-1 points
There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow Analyze the Water Footprint Results