Class roster spreadsheet

• Computer Applications:  center and merge, bold, size = 16, font style = your choice
• Column widths:  Last Names, First Names, and Class Hour = autofit, Birthdates and Ages = 12, empty column = 4
• Change the height of row 4 (empty row) to 6 (insert a new row above row 4 if there isn't one there already)
• Column headings (row 6):  bold and center (last name, first name, birthdate, age, class hour)
• Males/Females headings:  bold, merge and center above each section, font size = 14, font style = match it to row 1
• Borders:  A1:last row (modify color and style)
• Determine their age using a formula. (already done)
• Sort the females by age descending (Z-A, largest to smallest)
• Sort the males by age ascending (A-Z, smallest to largest)
• Center all birth dates, ages, and class hours
• Left align last names and first names (this should be the default)
• Format ages with 2 decimal places (already done)
• Format count, youngest, oldest and average to 2 decimal places (already done)
• Using a Conditional Formatting, change all the ages older than 15.49 to have a yellow fill color and bold font.
• Landscape spreadsheet

• open the Apps Roster spreadsheet from Shared/Johnson and one other class information
  • choose another class and add those students to your existing list (insert rows below your class names)
  • organize the names into Males/Females
  • calculate ages (fill formula)
  • sort by Class Hour (smallest to largest) then by Last Name (ascending A-Z), then by First Name (ascending A-Z)...one sort
  • include this new class info with count, average, min, max area (do NOT mix them in, use the next columns)
    • see example above

Create the charts

1. Name and class period in the Header

2. Landscape the page

3. Set the spreadsheet to fit to ONE page (page setup)

4. Center it Horizontally and Vertically on the page (page setup)

5. Change Top/Bottom/Left/Right margins to .5"

6. Print the sheet to 4200

7. Copy/Paste the file in your Grading Folder (delete existing files currently in the grading folder)

Put the print out in the red tray

Back

• open the Apps Roster spreadsheet from Shared/Johnson and one other class information
  • choose another class and add those students to your existing list (insert rows below your class names)
  • organize the names into Males/Females
  • calculate ages (fill formula)
  • sort by Class Hour (smallest to largest) then by Last Name (ascending A-Z), then by First Name (ascending A-Z)...one sort
  • include this new class info with count, average, min, max area (do NOT mix them in, use the next columns)
    • see example above

Create the charts