2013 Excel Final Project
Create a spreadsheet from a topic in which you can collect data (data must be collected from a reliable source that can be cited – data cannot be made up or fictitious):
· Movies (earnings per week, theater counts, etc.)
¿ TV (network ratings, awards won, etc.)
Athletics (player statistics, player earnings, team statistics, etc.)
² Music (albums sold, money earned, etc.)
Ø Weather (daily temperatures, rain/snow data, etc.)
J Other ideas?
Your spreadsheet must contain the following:
ü 15 columns and 9 rows of data collected (see me if you have another idea) – these 15 columns and rows do not include formulas.
ü At least 2 appropriate charts to display 2 different components of your data.
o Charts should be properly titled, include data labels when appropriate, chart type is appropriate for the data, size is appropriate, data is visible, etc.
ü Proper Number Format
ü Border lines placed appropriately
ü Fill color used appropriately
ü Accentuated font – no Times New Roman, no Arial, no Calibri – use legible font – different font types should enhance titles, headings, etc.
ü The use of at least 5 of the following formulas or other discussed during the course: SUM, AVERAGE, MIN, MAX, IF, COUNT, simple formulas (adding, subtracting, dividing, multiplying) – formulas must be used appropriately (ex. it is not appropriate to add years together, etc.)
ü Data on 2 lines within one cell
ü Data sorted – your choice how
ü Proper page setup to fit all of your data to 1 page – data spread out across your page
ü Header to include your name (Insert Tab)
ü Spreadsheet centered horizontally and vertically on the page (Page Layout tab, Page Set-up)
ü Source noted
Tips for Creating a Chart in Excel:
v Select the first set of cells that you want displayed, hold down the control key, then select the second set of cells you want displayed in your chart.
v Choose the Insert tab, select they type of chart you want to insert and click on that chart type.
v A chart will appear on your Excel spreadsheet
v You can modify the chart by clicking on Chart Tools, Layout, and choose Chart Title and add an appropriate title for the information displayed in your chart.
v Still in Chart Tools, you can select Data Labels and select having your data displayed in several different ways. Select the style you like best.
v 1 page summary explain your Excel Project
v In Chart Tools, Format, you can change colors, if you would like. Be creative!
Rubric
Points Possible / Points Earned15 columns included / 2
9 rows included / 2
2 charts to display 2 different types of data / 4
Charts are titled / 2
Data labels are included / 2
Proper number format is used / 1
Border lines are used appropriately / 1
Fill color is used appropriately / 1
Font does not include Times New Roman, Arial, or Calibri / 1
At least 5 different types of formulas are used (ex: SUM, AVE, MIN, MAX, If, COUNT, etc.) / 3
Data is on 2 lines within one cell / 1
Data is appropriately sorted / 1
All data and charts fit on one page / 1
Header is used and includes your name / 1
Spreadsheet is centered vertically and horizontally on the page / 1
Source is noted / 1
Total / 25