Sunday, February 10, 2008

Class 15: Working on Worksheet, Attendance Sheet and Grade Sheet

I hope you all had a good weekend. By now you should have already finished the following objects:
  • Certificate * 2 / Hall pass *2 (no matter what you choose to work with , the total products for this object will be two).
  • Business card/Student name tag
  • Calendar for March
  • Brochure/Newsletter
On Friday, Anita had you devide into groups and explored different aspects of working on the Brochure/Newsletter object. I think that was a very good strategy and should have helped you to know more about the requirements for this object.

Today we will first talk about worksheet, and then we will have you work on the attendance sheet and grade sheet. You should have brought your handouts about creating attendance sheet and grade sheet, which I gave you on last Wednesday.
Useful links:
When you are creating crossword puzzles, some computers (usually are Macs) or programs don't allow you to copy the puzzle and then paste it to a Word document. In this situation, you can choose "File"-->"Print"-->"PDF", and then your webpage puzzle will be converted into a PDF file.

Grade book and Attendance Sheet
Your final object for these two sheets will be in the same XLS file as the following:
* An attendance sheet for 8 students calculating the number of absences for a 5 day period.

* A grade sheet for the same 8 students calculating their grade average for five assignments.

* Both of the sheets need to alphabetized (use the "sort" function in the menu to do this) by the last name. The workbook sheet tabs must be labeled.

On Wednesday, we are going to work on :

  • Working on:
    • Excel Pictography
    • Seating chart
Please bring your Pictography handout on Wednesday.

No comments: