Gantt Chart

I found a site for basic procedures in creating a Gantt chart

Click here for simple steps in creating a Gantt chart

Wait a minute, what is a MARKBOOK?

What does a markbook do? What is it for? Who uses it? Who makes it? How does it work?

In Mariel's dictionary this is a markbook;

...A Markbook is a software tool that is used for managing systematic rosters purposed for school and employment participants. 

The possible participants could be teachers, students, employers and employees, and more others for different industries.

Still not sure what it is?...

...Well so am I :[

But here are some more information that i feel that i think that i know it's right and reliable :D

• it uses macros
• it would be very useful if it can be shared with other colleagues and/or participants
• it may be configured to suit applications and software
• some uses multiple applications (?)
• it may be upgraded

Further research is needed  

eMarkbook and Level Markbook

Examples of Teachers Markbooks

The eMarkbook and Level Markbook manages both individual classes or multiple classes of a common subject. 

eMarkbook

Latest version: 6.14
Released: 23 November 2004

Current features in latest version:
  • Minimal knowledge of MS Excel needed
  • Unlimited students in any number of classes
  • Up to 66 assessments per markbook
  • Apply individual weightings to each assessment
  • Automatic calculation of percentage scores
  • Automatic calculation of summary statistics
  • Automatic grading using your preset grade cutoffs
  • Rank students as whole or by class
  • View grade distribution of whole group
  • Up to ten grade cutoff points
  • Print whole group or individual classes
  • Print raw scores, percentages or both
  • Estimate marks for absent students
  • Easy sort and delete options
  • Scale assessments to required levels/statistics *
  • Scale final results to desired statistics *
  • Multilinear mapping of mark distributions *
  • Print blank registers/mark sheets for any class
  • Print individual student summaries at any time *
  • Easy email of results to students *
  • User worksheet for your own use
  • Import / upgrade from older eMarkbooks
  • Import student data from other applications
  • Export data and results to other applications *
    * New or improved feature!

Level Markbook

Latest version: 2.40
Released: 7 August 2003

Current features in latest version:
  • Minimal knowledge of MS Access needed
  • Unlimited students per markbook
  • Unlimited tasks per markbook
  • Option to break tasks into subtasks
  • Automatic calculation of levels and grades
  • Print whole class or individual results
  • Print blank registers/mark sheets for class
  • Print individual student summaries at any time
  • One-click email of assessment results to students
  • Import standard tasks and outcomes for all courses
  • Import student data from other applications
  • Export student results to other applications

                 

For more information, click here.

Macros

Macros offer a powerful and flexible way to extend the features of certain applications such as MS Excel. They allow the automation of formatting, charting and other often-used spreadsheet tasks. More advanced macros can display custom forms (with command buttons, text boxes, drop-down lists, etc.) and interact with other applications; these macros typically involve the writing and editing of Visual Basic for Applications (VBA) program code.

Creating a simple macro...

If you frequently need to format individual cells in a particular way (for example, currency style in red Arial bold 12-point font), a simple recorded macro will do the trick. Use the following steps to create it:

1. Select Tools, Macro, Record New Macro to display the Record Macro dialog box.
2. In the Record Macro dialog box, type a descriptive Macro name (such as "RedCurrency"). By default, the macro will be stored and available only in the current workbook; if appropriate, open the Store macro in drop-down list and select either New Workbook (to store and use the macro only in a new empty workbook) or Personal Macro Workbook (to make the macro available in allworkbooks). If desired, edit the text in Description. When done, click the OK button to begin recording.
3. The word "Recording" will appear on the status bar at the bottom of the Excel window to remind you that all keystrokes and mouse actions are now being recorded. Depending on how your system is configured, a Stop Recording toolbar may also appear in the window. If you make a mistake, simply correct it as you normally would and continue; both the mistake and its correction will become part of the macro, and may be edited out later if desired.
4. Perform the actions necessary to complete the task. For this example, the actions are:
1. Select Format, Cells to display the Format Cells dialog box, click the Number tab, select Currency in the Category list, and click the OK button; as an alternative, you may simply click the $ button on the Formatting toolbar.
2. Select Format, Cells to display the Format Cells dialog box, click the Font tab and then:
1. open the Color drop-down list and select the desired color;
2. select Arial from the Font list;
3. select Bold from the Font style list;
4. select 12 from the Size list; and
5. click the OK button.
5. If the Stop Recording toolbar is visible, click its Stop Recording button; if the toolbar is not visible, select Tools, Macro, Stop Recording.

 For more information and advanced processes about macros click here.