Spreadsheet

Student will recreate the assigned spreadsheet.

• Recreate the given spreadsheet

  • Enter and format the data into a spreadsheet
    
    Click to view image of the assigned spreadsheet including the data

(This assignment does not call for perfect fidelity to the original.
You will be assessed on data entry, use of formulas/functions, and charting/graphs.)

• • Use working formulas (given) where appropriate (instructed)

  • Include in the spreadsheet file the four graphs

  • Answer all four questions

  • Modify website to include access to the product
    

• Create a Google Form
  (Example: The Report web site URL Click here)

• • From your Google Drive create a simple questionnaire

  • Make the Form accessible from your website
    

• Take the Mid-Term Quiz

Spreadsheet presentation (Lab, mask, squeaky chair, bad mic version)

Optional (older version) Spreadsheet Assignment quick walk-through video

• Microsoft in Education | Teacher resources | Product how-tos | Excel

• Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)

• Learn Pivot Tables in 6 Minutes

• Mail merge video

• • Tennis team spreadsheet workshops (Special thanks to UNCA Tennis for sharing this content!)

    • Day 1

    • Day 2

    • Day 3

    • Day 4

• Excel functions (alphabetical)

• Google Docs size limits (includes spreadsheets)

• Using Excel as a Grade book

• Faux clickers (audience response system on the cheap) demo using Google Docs