Financial Accounting
Annual Report Project
Annual Report Project: Each student will be responsible for conducting a research project of a company based on the material we have covered in this course. You may choose any company that is publicly traded on an American Stock Exchange. It is your responsibility to obtain an Annual Report for your desired company. A good place to start would be the library databases, specifically the Edgar database at www.sec.gov. Report requirements will be made available.
The objective of this project is to take the concepts learned in the course and apply them to your company’s annual report. The following is a suggested format to use for this analysis:

I. Executive Summary (2-3 paragraphs describing what the company is in business to do)

II. Background and nature of the company’s business (3-5 paragraphs describing how the company got started and how it got to it’s place now)

III. Discussion of the industry in which the company operates (2-3 paragraphs describing the industry in which the company operates and their key competitors)

IV. Information related to the management and key executives (2-3 paragraphs about the companies CEO/CFO)

V. Financial statement analysis (this should be your focus)*

A. Reproduce the company financial statements – Balance Sheet,
Income Statement, Statement of Cash Flows and the Statement of Stockholders’ Equity. (This means you need to re-type them in either a Word or Excel document, you may not photocopy or cut and paste.

B. Ratio Analysis – using ratios on ‘Ratio Sheet’ (compute each ratio as shown below, then write 2-3 sentences describing what the ratio MEANS for the company. Don’t give me the definition of each ratio, tell me what the ratio means for the company)

Example: Current Ratio = Current Assets/Current Liabilities
4,000,000/2,000,000 = 2

VI. Stock Journal From __________________(the stock journal will be a day by day look at the companies stock ups and downs, simply give the day and close for each business day in the time period listed. Example 1/18/11 $25.67)

VII. Discussion (summary) of 5 footnote disclosure items. (choose 5 notes to the financial statements and briefly describe)

VIII. Summarize the letter by the auditing CPA firm (relevant information such as GAAP guidelines, changes in accounting principles, etc.)

IX. Inventory principles used by the company (what method of inventory valuation does the company use, refer to inventory chapter in book)

X. Discussion of current events related to the company – three articles (choose three articles about the company and summarize each – I will need a copy of the actual article)

XI. Recommendation – would you invest in this company, why or why not?
(1-2 paragraphs on your decision to invest or not)

CAFR Analysis Paper Guidelines
Please prepare an 8-10 page paper, font 12, double spaced. The length of the paper will increase if you have more illustrations (preferred). This project will detail all information you found or did not find in the budget and the CAFR for the County of San Diego. You should also have a cover/title page and a reference page.
It is important that this be your original thoughts and language/writing. Do not copy large sections from a source. If you do include a sentence or two word for word, be sure to put it in quotes. Provide citations for information such as facts and other information.
The paper should include:
• An introduction to include purpose of paper and intro to the county,
• Graphs or charts in the body of the report to compare topics, data, statistics and anything else that you need to present to support your analysis of the data or to help the reader understand your point. Do not just say it is there; give examples of the way it is presented and the implications.
• Analysis that should be on two levels: First, the quality of the reports in terms of meeting GASB 34 or GFOA award requirements including how “user friendly” it is in your opinion (support your opinion) and second, some analysis of the data such as where the money is spent, how healthy the current revenue stream, the reserves, how well inter-period equity issues are addressed, etc..
• Review of the format, the presentation of the CAFR, which should include mention significant differences between your San Diego County CAFR and the one used as an example in class.
• Conclusion of your overall assessment of San Diego CAFR and Budget. Reiterate the main points of your findings and analysis; what is needed, what was presented very well and anything you think they could improve.
• Reference page: make sure to reference your sources in correct APA style. Please note that Wikipedia is not a valid reference source; you can use it as a source of more authoritative references.
There are rubrics and checklists at the end of this document to help you make sure you’ve included everything to get the maximum grade. You must turn in on date due or lose points for the assignment.

Steps to follow:
We are going to be analyzing the CAFR for the County of San Diego.
Part 1 – Budget analysis
1. In your paper, provide answers to the following questions using visual as well as text. Provide the discussion and analysis as if you were presenting a report to Council:
a. What major concerns are addressed in the budget document?
b. What is the total County budget? Breakout the budget for the enterprise funds versus the general fund.
c. What sources of revenue are received by the County overall?

2. Look at the General fund budget overall. Compare revenues and expenditures budgeted.
a. Determine which Department consumes the most general government resources (support your selection). For that department, answer these questions:
i. What are the department’s goals and purpose? How do those match with what you would think the citizens expect?
ii. Are there revenues specific to the department?
iii. What are the budgeted expenditures? Provide examples from the budget.
iv. If a 15% decrease is to be made for this department you have chosen where would you cut the budget? Explain why and what you think the overall effect of this decrease would be on the department.
v. Anything else you think is significant about this department’s budget?

Part 2 – CAFR analysis
1. Read the Transmittal Letter, MD&A and notes. For additional reference, look for official reports or financial information such as reports to Council about the CAFR.
2. Provide an analysis of the CAFR using text and graphics as if you were presenting your analysis to someone in order to inform them about CAFRs in general and this city in particular.
3. Include in your analysis the answers to the following questions. Be sure to also conform to the guidelines for the paper overall presented in the first section of these instructions and support your opinions with references or examples.
a. Has the County received an award for the CAFR? If so, you don’t need to spend time analyzing conformity with GASB 34 requirements.
b. What detail is available in the notes to the statements that would be useful to a particular type of reader (citizen, potential commercial operation, etc.).
c. What is the financial situation for this government? Support your comments with examples from the CAFR. Is there sufficient information to determine the financial health of the government?
d. Compare the information provided in the CAFR and the budget for this city including a review of the budget vs. actual statements in the CAFR.
e. What do you think was especially helpful or not in the CAFR overall including the MD&A and statistical sections? Support your responses with examples.
See also checklist, grading rubrics, and writing standards below.

Checklist for Students:
Introduction
• Tell the reader what you will cover and why it is interesting; give the reader context (for instance, say something about the city such as its location, weather, what it’s known for, etc..
Body – Organization
• Well organized; flow in a logical sequence from paragraph to paragraph, from sentence to sentence; the reader isn’t surprised by a sentence that doesn’t seem related to the ones before and after. The best way to check this is read it out loud, preferably to someone else (teenagers are the best; they won’t spare your feelings with their feedback).
• Statements supported with appropriate tables, graphs, charts, or references.
• Transitions are easy to follow.
• Coverage of topic is complete.
• Layout is easy to follow.
Conclusion
• Findings consistent with purpose are summarized.
References
• Sufficient to support the conclusion.
• Appropriately cited.
USE of Visuals
• Use visuals, graphs, tables and charts to make points.
• Easy to read and appropriately place.
Professional appearance
• Word choice and sentence structure are clear.
• Spell check and editing appears to have been done
• Logical sequencing of thoughts and analysis of topics;
• Use of examples and visuals

GRADING RUBRICS:
Criterion Unsatisfactory Satisfactory Exceptional
1. Content
Compare and describe budget or CAFR and discuss the sections of these documents. Did not adequately compare and describe the document by choosing at least 1-2 items shown and discussing. Adequately compared and described the document by choosing at least 1-2 items shown and discussing. In addition to meeting the requirements of satisfactory,
*included a discussion of at least 3-4 items in the report and explained them in detail
* analyzed these items and determined whether it gives enough information
Evaluate the way these documents display information and if the information is clear for any person in the public to understand. Did not evaluate adequately the data presented. Evaluated adequately the data presented. In addition to meeting the requirements of satisfactory,
*discussed other ways of displaying the information or suggested items the public would like to see.
*analyze and suggest some other details you believe would help the presentation
Describe how the budget is presented in each document and look at the details for the General fund, the proprietary funds and one department. Did not describe accurately the budget characteristics shown for the 2 funds and one department. Described with some detail the budget characteristics shown for the 2 funds and one department. In addition to meeting the requirements of satisfactory,
*analyzed the data and explained some of the problems with the information.
*analyze the data and explained some of the most effective information displayed.

Evaluate the notes of the CAFR or the details of the budget.
Answer questions provided. Did not evaluate at least 3 of the written notes or details included in the reports. Evaluated at least 3 of the written notes or details included in the reports. In addition to meeting the requirements of satisfactory,
* analyzed 4+ details or notes and suggested ways to improve the accounting.
*recommend 2 things that could be done to improve the public’s understanding of the budget or CAFR
*+++extra credit- compare some items in the city you chose to another city and their presentation.
USE of GASB pronouncements and other rules/guidelines used in text, handouts,etc. Did not reference the budget, CAFR or GASB that should be used in the reports. Adequately referenced the budget, CAFR and GASB for the details above. In addition to meeting the requirements of satisfactory,
*used another site on internet to explain how they could present better.
* reference at least 1-2 GASBs and give more details about them and how they effect the documents.
Resources Used References 0 sources in paper References 1-2 sources in paper References 3+ or more sources in paper
Visuals – Show calculations and comparisons using graphs, charts, and data tables. Not include any. Include 2-3 and explained in detail what it represents. Includes 4+ and explained in detail what it represents.

2. Writing Standards
Quality and Organization of the Writing
The paper is poorly organized with clumsy transitions from point to point, several spelling and grammatical errors, references not correctly indicated, and introductory and summary paragraphs may not be fully developed or engage the reader. The paper is very well organized:
Includes 1)introductory paragraph that explains the purpose and provides context 2)summary/conclusion paragraph that communicates writer’s perspectives and highlights of paper, 3)very few spelling or grammatical errors
4) reference section correctly cited. Includes 1)introductory paragraph that explains the purpose, provides context and engages the reader, 2)summary/conclusion paragraph that communicates writer’s perspectives and highlights of paper, 3)excellent transition from point to point, 4)no spelling or grammatical errors
5) reference section correctly cited and references are exceptionally relevant.

Writing Standards
Content/Development
• All key elements of the assignment are covered in a substantive way.
• The context and purpose of the writing are clear.
• Content is comprehensive, accurate, and/or persuasive.
• Major points are supported by specific details, examples, and/or analysis.
• Research is adequate and timely for the topic.
• Where appropriate, the paper supports major points with theory relevant to development of the ideas, and uses the vocabulary of the theory correctly.
• There is integration of theory and practice whereby the writer is able to link theories to practical experience.
Sections of paper
• Introduction must be included to express the purpose of the paper; including any theories that the students will prove or disprove.
• Summary or conclusion should include a summarization of the main points proved in the paper or analytical conclusions supported within the paper.
• Body must have all references stated and build the theme to 1 or more conclusions of the writer.
• Reference section must include all sources used for the paper presented by APA standards.
• Visuals should be included in the paper to assist the reader to see the financial facts/data. They can then be analyzed and explained in detail to support the point of the writer.

Organization
• The introduction engages the reader by providing an idea of the focus of the paper or the primary thesis of the writer in a way that makes the reader want to read the paper.
• The structure of the paper is clear and easy to follow.
• The paper’s organization focuses on the central theme or perspective identified by the writer in the first paragraph.
• Ideas flow in a logical sequence.
• Paragraph transitions are present and logical, and maintain the flow of thought throughout the paper.
The conclusion is logical and impactful. It summarizes key points and flows from thoughts and analysis presented in the paper. It is impactful in that it shares the perspectives of the writer, answers or re-enforces the introduction, acts as a crescendo to the writer’s story, and makes it worthwhile for the reader to have read through the paper.

Format
• The paper, including citations and the reference page, follow program guidelines for format; double spaced 12 font.
• The paper contains quotes and/or borrowed ideas from the text or other outside readings pertaining to the course material and properly cites them within the paper’s body in APA format.
• The paper is laid out effectively and utilizes references appropriately.
Proper formatting, as well as headings, the use of italics, and so forth, aid in the readability of the paper and are not overdone.

Grammar, Punctuation and Spelling
• Rules of grammar, usage, and punctuation are followed.
• Spelling is correct.
• Readability/Style
• Sentences are complete, clear, and concise.
• Sentences are well-constructed, with consistently strong, varied structure.
• Sentence transitions are present and maintain the flow of thought.
The style of the writing is engaging and makes the reader want to continue reading to the end.

In the ethical theories of Kant and Aristotle, it is arguably the case that the good person exercises control over the moral worth of her actions.

In Aristotle, the accomplishment of virtue is, broadly, the product of the kind of person one has cultivated oneself to be. In Kant, insofar as one is a rational being, one can determine freely, for oneself, whether one is acting from duty (putting aside the fact that one can never have certainty about the purity of acting from moral duty). In contrast, Mill’s theory appears to place moral value entirely in the resulting happiness produced by the action. A person thus does not have control over her moral goodness. Does Mill’s ethical theory suffer from requiring that a person not be totally in control over the moral value of her actions? Is this a problem for utilitarianism as a theory, compared to Deontology or Virtue Ethics? (In your answer, you should make brief – i.e. 1-2 paragraph apiece at the most – reference to the relevant material from Kant and Aristotle).

In the ethical theories of Kant and Aristotle, it is arguably the case that the good person exercises control over the moral worth of her actions.

In Aristotle, the accomplishment of virtue is, broadly, the product of the kind of person one has cultivated oneself to be. In Kant, insofar as one is a rational being, one can determine freely, for oneself, whether one is acting from duty (putting aside the fact that one can never have certainty about the purity of acting from moral duty). In contrast, Mill’s theory appears to place moral value entirely in the resulting happiness produced by the action. A person thus does not have control over her moral goodness. Does Mill’s ethical theory suffer from requiring that a person not be totally in control over the moral value of her actions? Is this a problem for utilitarianism as a theory, compared to Deontology or Virtue Ethics? (In your answer, you should make brief – i.e. 1-2 paragraph apiece at the most – reference to the relevant material from Kant and Aristotle).

In the ethical theories of Kant and Aristotle, it is arguably the case that the good person exercises control over the moral worth of her actions.

In Aristotle, the accomplishment of virtue is, broadly, the product of the kind of person one has cultivated oneself to be. In Kant, insofar as one is a rational being, one can determine freely, for oneself, whether one is acting from duty (putting aside the fact that one can never have certainty about the purity of acting from moral duty). In contrast, Mill’s theory appears to place moral value entirely in the resulting happiness produced by the action. A person thus does not have control over her moral goodness. Does Mill’s ethical theory suffer from requiring that a person not be totally in control over the moral value of her actions? Is this a problem for utilitarianism as a theory, compared to Deontology or Virtue Ethics? (In your answer, you should make brief – i.e. 1-2 paragraph apiece at the most – reference to the relevant material from Kant and Aristotle).

INNOVATION PROCESS – Use the INNOVATION PROCESS 3 circle Model.
— Revenue and liabilities
-Innovation possibilities and challenges and post launch
Located in Course Information. Note: This will be discussed in class.
(**Use this in the Outline.)
• What area is the innovation taking place?
A. Technology
C. Business
D. Design Innovation
E. Organizational Behavior
F. Human Values
G. Design & Interactivity
• What resources will be needed?
• What type of teams will be needed?

• What communication networks will be used?
• What steps will be taken to apply the idea?
• What monitoring maintenance/management systems will there be?

5. Presentation Materials:
• Create PowerPoint slides – 10 max
• Use pictures, graphics, charts, diagrams, other visuals
• Use videos i.e. YouTube
• Design a prototype
• Use drawings, pictures, etc.
• Provide samples

6. Creativity Project Outline (Team)
• Outline must detail both Creative and Innovative Process.
• Provide brief descriptions for each of the steps followed.
• Cite sources
• Cover Page
• Attach PowerPoint slides

INNOVATION PROCESS – Use the INNOVATION PROCESS 3 circle Model.
— Revenue and liabilities
-Innovation possibilities and challenges and post launch
Located in Course Information. Note: This will be discussed in class.
(**Use this in the Outline.)
• What area is the innovation taking place?
A. Technology
C. Business
D. Design Innovation
E. Organizational Behavior
F. Human Values
G. Design & Interactivity
• What resources will be needed?
• What type of teams will be needed?

• What communication networks will be used?
• What steps will be taken to apply the idea?
• What monitoring maintenance/management systems will there be?

5. Presentation Materials:
• Create PowerPoint slides – 10 max
• Use pictures, graphics, charts, diagrams, other visuals
• Use videos i.e. YouTube
• Design a prototype
• Use drawings, pictures, etc.
• Provide samples

6. Creativity Project Outline (Team)
• Outline must detail both Creative and Innovative Process.
• Provide brief descriptions for each of the steps followed.
• Cite sources
• Cover Page
• Attach PowerPoint slides

INNOVATION PROCESS – Use the INNOVATION PROCESS 3 circle Model.
— Revenue and liabilities
-Innovation possibilities and challenges and post launch
Located in Course Information. Note: This will be discussed in class.
(**Use this in the Outline.)
• What area is the innovation taking place?
A. Technology
C. Business
D. Design Innovation
E. Organizational Behavior
F. Human Values
G. Design & Interactivity
• What resources will be needed?
• What type of teams will be needed?

• What communication networks will be used?
• What steps will be taken to apply the idea?
• What monitoring maintenance/management systems will there be?

5. Presentation Materials:
• Create PowerPoint slides – 10 max
• Use pictures, graphics, charts, diagrams, other visuals
• Use videos i.e. YouTube
• Design a prototype
• Use drawings, pictures, etc.
• Provide samples

6. Creativity Project Outline (Team)
• Outline must detail both Creative and Innovative Process.
• Provide brief descriptions for each of the steps followed.
• Cite sources
• Cover Page
• Attach PowerPoint slides

BPCS9205 Excel Project Fall2015
Part 1 of 2:Creating a personal budget workbook.
As you have seen Excel can be valuable to a wide audience of users. A workbook can be complex, recording data for thousands of financial transactions, or it can simply trace a few monthly expenses. Everyone has to balance a budget, track expenses, or project future income can make use of the financial tools in Excel. In this first part of your project, you’ll use Excel to create a sample budget workbookthat will contain information of your choice.
Use the following steps as a guide to completing your workbook.
Note: Please be sure not to include any personal information of a sensitive nature in any workbooks you create to be submitted to your instructor for this exercise. Later, you can update the workbooks with such information for your personal use.
1. Create a new workbook for the sample financial data. Use the first worksheet as a documentation sheet that includes your names, the date on which you start creating workbook, and a brief description of the workbook’s purpose.
2. In the second worksheet, enter realistic monthly earnings for each month of the year. Use formulas to calculate the total earnings each month, the average monthly earnings, and the total earnings for the entire year.
3. On the same worksheet, enter realistic personal expenses for each month. Divide the expenses into at least three categories, providing subtotals for each category and a grand total of all the monthly expenses. Calculate the average monthly expenses and total expenses for the year.
4. Calculate the monthly net cash flow (the value of total income minus total expenses).
5. Use the cash flow values to track the savings throughout the year. Use a realistic amount for savings at the beginning of the year. Use the monthly net cash flow values to add or subtract from this value. Project the end-of-year balance in the savings account under your proposed budget.
6. Format the worksheet’s contents using appropriate text and number formats. Add colours and line borders to make the content easier to read and interpret. Use cell styles and themes to provide your worksheet with a uniform appearance.
7. Use conditional formatting to automatically highlight negative net cash flow calculated in Step 4.
8. Insert a pie chart that compares the TOTAL ANNUAL expenses for the categories.
9. Insert a column chart that charts all the monthly expenses regardless of the category.
10. Insert a line chart that shows the change in the savings balance throughout the 12 months of the year.
11. Insert new rows at the top of the worksheet and enter titles that describe the worksheet’s contents.
12. Think of a major purchase you might want to make—for example, a car. Determine the amount of the purchase and the current annual interest rate charged by your bank. Provide a reasonable length of time to repay the loan, such as five years for a car loan or 20 to 30 years for a home loan. Use the PMT function to determine how much you would have to spend each month on the payments for your purchase. Add this information to your monthly budget. If the payment exceeds your budget, reduce the estimated price of the item you’re thinking of purchasing until you determine the monthly payment you can afford under the conditions of the loan.
13. Format the worksheets for your printer. Include headers and footers that display the filename of your workbook, the workbook’s author, and the date on which the report is printed. If the report extends across several pages, repeat appropriate print titles on all of the pages and include page numbers and the total number of pages on every printed page. Save and close your workbook. Submit your printed hardcopy workbook on the due date.
Part 2 of 2:Tracking and analyzing data.
Excel can be a useful program for tracking information about many everyday activities, such as
? Organizations you belong to/participate in
? Collections
? Hobbies
? Community work
? Social Events
? Sports records and statistics
? Business ventures

In part 2, you need to select an area that fits your interests and create an application in Excel to track information related to your area of interest.

1. Plan the organization of your workbook—what information related to your area of interest do you want to track; what fields do you need to enter; how will you organize the data; what calculation will you need to perform; how do you want to format the information, and so on.
2. Create a Documentation worksheet that includes your name, the date, and the purpose of your workbook. Format it appropriately.
3. Set up multiple worksheets to record your data on (for example, a budget for each event could be a separate worksheet). Use a worksheet group to enter labels and other nonvariable text, formatting, and formulas in the worksheets.
4. Apply validity checks to improve the accuracy of data entry.
5. Create a summary worksheet that consolidates the information from these worksheets.
6. Create an Excel table to track data. Enter an appropriate table name, column headers, and formulas. Format the table attractively. Add records to the table. Insert a Total row in the table with an appropriate summary calculation (SUM, COUNT, etc.).
7. Add a calculated column to the table with an appropriate function (such as an IF function, and AND, function, and so on).
8. In the worksheet with a range of data, define names for cells and ranges. Convert the existing formulas in the worksheet to use the defined names.
9. Paste a list of defined names as documentation in the Documentation sheet.
10. Check for duplicate values using conditional formatting.
11. Check for data entry errors using the IFERROR function.
12. Sort the data as needed.
13. Use a filter to answer a specific question about the data. Add a comment to explain how the data was filtered and what question it answers.
14. Plan and record an appropriate macro. Assign the macro to a button. Save the workbook in macro enabled format.
15. Prepare the workbook for printing. Include headers and footers that indicate the filename of your workbook, the workbook’s author, and the date on which the workbook is printed.
16. Save the workbook and submit an electronic copy through Blackboard Assignments.

BPCS9205 Excel Project Fall2015
Part 1 of 2:Creating a personal budget workbook.
As you have seen Excel can be valuable to a wide audience of users. A workbook can be complex, recording data for thousands of financial transactions, or it can simply trace a few monthly expenses. Everyone has to balance a budget, track expenses, or project future income can make use of the financial tools in Excel. In this first part of your project, you’ll use Excel to create a sample budget workbookthat will contain information of your choice.
Use the following steps as a guide to completing your workbook.
Note: Please be sure not to include any personal information of a sensitive nature in any workbooks you create to be submitted to your instructor for this exercise. Later, you can update the workbooks with such information for your personal use.
1. Create a new workbook for the sample financial data. Use the first worksheet as a documentation sheet that includes your names, the date on which you start creating workbook, and a brief description of the workbook’s purpose.
2. In the second worksheet, enter realistic monthly earnings for each month of the year. Use formulas to calculate the total earnings each month, the average monthly earnings, and the total earnings for the entire year.
3. On the same worksheet, enter realistic personal expenses for each month. Divide the expenses into at least three categories, providing subtotals for each category and a grand total of all the monthly expenses. Calculate the average monthly expenses and total expenses for the year.
4. Calculate the monthly net cash flow (the value of total income minus total expenses).
5. Use the cash flow values to track the savings throughout the year. Use a realistic amount for savings at the beginning of the year. Use the monthly net cash flow values to add or subtract from this value. Project the end-of-year balance in the savings account under your proposed budget.
6. Format the worksheet’s contents using appropriate text and number formats. Add colours and line borders to make the content easier to read and interpret. Use cell styles and themes to provide your worksheet with a uniform appearance.
7. Use conditional formatting to automatically highlight negative net cash flow calculated in Step 4.
8. Insert a pie chart that compares the TOTAL ANNUAL expenses for the categories.
9. Insert a column chart that charts all the monthly expenses regardless of the category.
10. Insert a line chart that shows the change in the savings balance throughout the 12 months of the year.
11. Insert new rows at the top of the worksheet and enter titles that describe the worksheet’s contents.
12. Think of a major purchase you might want to make—for example, a car. Determine the amount of the purchase and the current annual interest rate charged by your bank. Provide a reasonable length of time to repay the loan, such as five years for a car loan or 20 to 30 years for a home loan. Use the PMT function to determine how much you would have to spend each month on the payments for your purchase. Add this information to your monthly budget. If the payment exceeds your budget, reduce the estimated price of the item you’re thinking of purchasing until you determine the monthly payment you can afford under the conditions of the loan.
13. Format the worksheets for your printer. Include headers and footers that display the filename of your workbook, the workbook’s author, and the date on which the report is printed. If the report extends across several pages, repeat appropriate print titles on all of the pages and include page numbers and the total number of pages on every printed page. Save and close your workbook. Submit your printed hardcopy workbook on the due date.
Part 2 of 2:Tracking and analyzing data.
Excel can be a useful program for tracking information about many everyday activities, such as
? Organizations you belong to/participate in
? Collections
? Hobbies
? Community work
? Social Events
? Sports records and statistics
? Business ventures

In part 2, you need to select an area that fits your interests and create an application in Excel to track information related to your area of interest.

1. Plan the organization of your workbook—what information related to your area of interest do you want to track; what fields do you need to enter; how will you organize the data; what calculation will you need to perform; how do you want to format the information, and so on.
2. Create a Documentation worksheet that includes your name, the date, and the purpose of your workbook. Format it appropriately.
3. Set up multiple worksheets to record your data on (for example, a budget for each event could be a separate worksheet). Use a worksheet group to enter labels and other nonvariable text, formatting, and formulas in the worksheets.
4. Apply validity checks to improve the accuracy of data entry.
5. Create a summary worksheet that consolidates the information from these worksheets.
6. Create an Excel table to track data. Enter an appropriate table name, column headers, and formulas. Format the table attractively. Add records to the table. Insert a Total row in the table with an appropriate summary calculation (SUM, COUNT, etc.).
7. Add a calculated column to the table with an appropriate function (such as an IF function, and AND, function, and so on).
8. In the worksheet with a range of data, define names for cells and ranges. Convert the existing formulas in the worksheet to use the defined names.
9. Paste a list of defined names as documentation in the Documentation sheet.
10. Check for duplicate values using conditional formatting.
11. Check for data entry errors using the IFERROR function.
12. Sort the data as needed.
13. Use a filter to answer a specific question about the data. Add a comment to explain how the data was filtered and what question it answers.
14. Plan and record an appropriate macro. Assign the macro to a button. Save the workbook in macro enabled format.
15. Prepare the workbook for printing. Include headers and footers that indicate the filename of your workbook, the workbook’s author, and the date on which the workbook is printed.
16. Save the workbook and submit an electronic copy through Blackboard Assignments.