Cold Hollow Career Center

We will be using Microsoft Excel for this workshop (although the content is applicable to other Spreadsheet software).

Task #1:  Chocolate Distribution Data

Using the M&Ms provided (don't eat the data yet) separate the colors and create a spreadsheet similar to this:

We will use this data to:

     1) find the sum and average

     2) make a pie chart, and resize it to fit on the page

     3) sort the data alphabetically and/or numerically

Task #2:  List My Students Birthdays

Login to your PowerSchool Gradebook (or Admin) and export a list of students.

     Gradebook - Reports - Roster - Export (csv)

     Admin - select students - Import/Export - Export "Lastfirst" and "DOB"

Import the CSV file into Excel

Adjust the columns & rows, font size, borders

Make a header row for columns

Resources:

http://www.viking.stark.k12.oh.us/~technology/excel/index.html

If Statement Spelling Test