I will be using Excel

example:

- ProblemiOpportunity \& Goal Identify a problem to volve or an opportunity to take advantage of using MS Excel or MS Access Describe the significance of the problem (basically describe the problem) Describe the goal (s) of the project (basically describe how Excel or Aecess would solve the problem) - Using MS Excel OR MS Access show your work to solve the problem identified - Requirements (if you solect Excel, only the requirements for Excol andiy and if you select Access, only the Access requirements anoly). MS Excel: - At least 2 worksheets - Functions (at least 2 different functions) - Conditional formatting - Graphs (at leas 2 graphs) MS Access: - At least 2 tables - Relationships between tables - Primary keys - 1 Qucry - i Report Deliverables: - Powerpoint document Problem description, significance, and conclusion For Excel: - Function used (which cell (9)) For Access: - Irimary key for each table - Relationships between the ables - Solution file Foe Excel: MS Excel file For Access: MS Access file When submining your work: - make sure you name your document as folows: NAME_MIS2000_Powerpoint \& NAME_MIS2000_Excel or NAME_MIS2000_Access Example of a project I am tring to manage my monthly expenses and seperate the school expenses from ocher axpenses. Goal of the project would be would be to keep treck of expenses and compare them. The sprendsheet would have 2 workheets (achool expenses worksheet, other expenses worksheet). I would hawe SUM (for totals and subtotals), DAtE. 8 COUNTIF (to oount based on expense criteria). I would use conditicnal foemalling to show when f am over budgot by displaying color fed for the amouit over the budget. I would ahow 2 graphs, one for the axpenses for school and one tor the expenses non school