|
Spreadsheet planning Sheet2 web
SPREADSHEET PROJECT PLANNING SHEET
Purpose of the spreadsheet: (What information are you keeping track of?) ______________________________________________________________________________
What filename will you give this spreadsheet when you save it? _______________________
REQUIREMENTS:
- Topic must be appropriate for a spreadsheet application
- Must have at least 3 different formula types used appropriately
- Formatting must be appropriate for the spreadsheet and must use at least 4 different format types properly
- Spreadsheet must be easy to read and understand (totals appear in logical places, neat and organized with a title).
- Must have a Graph of meaningful data- follow these guidelines:
- Must have an appropriate title
- Graph's axes must have appropriate labels
- Graph must not lie or misrepresent data
- Appropriate graph type chosen--Example: only use a pie chart to show "parts of a whole"
Plan your spreadsheet by filling out the sheet below & answering the questions on the back.
Answer these questions:
- What will be the title of your spreadsheet?
- What types of formulas will you use and where will the formulas go-(tell me the cells and what type of formula or show me on the sheet sketch)?
(SUM, AVERAGE, MIN, MAX, COUNT, IF, +, -, *, /)
Cells ______________ Formula type____________________________
Cells ______________ Formula type____________________________
Cells_______________ Formula types___________________________
- How will you make your formulas stand out?
- How will you format your spreadsheet to make it look nice and be easy to read? What formatting changes will you make and why? Describe below. You may also make notes in the spreadsheet sketch.
- Column Width
- Row Height
- Bold, Italic or Underline
- Color
- Alignment
- Formatting Decimal Places (no more than 2 places)
- Formatting Numbers
- Other
5. What are three questions you can ask about the information on your spreadsheet?
6. Which information would you graph?
7. What type of graph would you use? Column/Bar Chart Pie Line
8. What will be the title of your graph (what will it be about)?
Formatting Notes:
- Identify formulas to make those cells look different than the other cells.
- No more than 2 decimal places on numbers.
- Use proper alignment (right for numbers, center for headings, left for regular information)
- Make data different look than formulas
- Make column headers and rows stand out either using bold, underline, italics or color
Chart Notes:
Chart must be appropriate for data. Remember, different chart types serve different purposes:
- Pie charts show the relationship of parts to the whole. For example, we used a pie chart in class to show the relative amounts budgeted for "goodies" such as cookies, truffles, mousses, eclairs, pies and cakes.
- Line charts are often used to plot data over time intervals. We might use a line chart to show the monthly (Jan - June) $$ amount of sales in a video store.
- Bar charts generally place less emphasis on time and more on comparisons.
Guidelines for Formatting Worksheets
http://www.eiu.edu/~ofcourse/
- Line up decimals points by formatting columns of values to the same decimal place ("General" format will NOT do this.)
- Display commas in values where appropriate. Usually values greater than 1,000 should be displayed with commas.
- Display labels over the values in columns--make sure labels clearly identify the values in the columns.
- Enter values as labels only if they are to be displayed as labels and not used for calculations. For example, social security numbers, phone numbers.
- Use double underscores under totals. Use single underscores under subtotals.
- Adjust column widths so that columns look equal distance (or other appropriate distance) apart.
- Adjust column widths so entire cell contents (labels and values) are displayed.
Rules You Must Adhere To for your Chart/Graph
- Always title your graphs
- Always indicate units
- Always label your graphs' axes
- Never use a graph to lie or misrepresent data
- Never use a pie chart except to show "parts of a whole"
- Never use 3D just to be "cool", as it often obscures the data.
|
|
