Use Excel to design an electronic program tracker, gradebook, "calculator", or recording instrument  that would be used in your major.  This might be part of theme you started with your communication project and/or continued in your powerpoint.  You should design something that would demonstrate an actual situation - something realistic - something well-thought out..........something based on our discussions in class.

This project will use Excel.

Details will be presented in class, but, at a minimum, the following criteria are expected:

• 10 subjects ( X = 10) - e.g., number of people
  
• 10 variables - variables are items/events, etc. that are measured and recorded - and will contribute to your formulas [totals, etc. are not variables.]
• Demonstrate formatting cells including "number", "alignment", "border", "font", "fill"
  
• Use at least 5 different Formulas; iIn other words, if you use a formula to average scores - you have used "average" no matter how many different ways you write it - you would need four more.  Writing formulas will let you interpret, explain, or clarify your data.  When you get to the point of saying, what other formulas can I use......you should be asking, what do I want to say about this data, what does this say about my program, what does this say about each subject........(IF formulas)
  
• Include descriptors for variables, subjects and results determined from formulas - take out the guesswork - be clear.
  
• A total of 3 charts:  2 charts comparing at least 2 variables using different chart types, and 1 chart comparing 3 different variables (be careful about using more because it will get confusing to the viewer) using a third chart type - charts should have appropriate legend and variables identified - the three charts should present different views of your data and be appropriately used - think about what you are trying to show/say - demonstrate editing of charts.  Should be placed on separate workbook (tab) - change colors and use data values.  Use appropriate charts - not just ones that you seem to like.
  
• Include one summary page - data should be linked to this page.
• Include one chart page - include 3 charts.
• Include at least one "sorted" sheet (rename tab) - details in class (faux data base) - this is the process similar to the demonstration I use with my gradebook - you MUST sort a variable (not the alpha order).
• Include at least two "data" sheets (rename tab) - details in class (faux data base) - this is the process similar to the demonstration I use with my gradebook.
• Use color on a spreadsheet/workbooks for emphasis or attention - but don't overuse and confuse.
• Link to your porfolio page
  

• create at least two data pages
• enter formulas on data pages - formulas that help tell a story or answer questions
  
• create summary, chart and sorting pages
• link data from data sheets to summary page
• copy and paste data from one of your other pages to the sorting page - use sorting page to demonstrate sorting
  
• create charts and place on chart page

• 1 spreadsheet file with multiple tabs (one excel spreadsheet with use of multiple workbook tabs, including one summary, one chart, one sorted and, a minimum of two data)
• 10 subjects and 10 variables
• complete required formatting
  
• 5 different formulas
• 3 charts
• use of color on sheets and charts
• link to porfolio page
  

Due Date:  April 12