Manual - Chapter 7

Click on the list below to jump to that topic

PRINTING TIMETABLE
PRINTING BATCH OF STUDENTS
PRINT LECTURER LIST
INSERTING THE HEADER AND FOOTER
PRINTING EXAMPLES

[return to content menu]

Once you have completed your timetable, you are ready for printing it in Microsoft Excel. Before you can do so, you have to export your timetable structure into an text file enabling to be imported into Microsoft Excel.

 

.TDat ----export---> Microsoft Excel ----print---> Output

Printing timetable

Step 1 : Click on the File tab.
Step 2 : Select Export.
Step 3 : Select Timetable to text file (for excel import).

Figure 7.1

Step 4 : Choose what format to export

Figure 7.2

Time Slot Format
Basic Default Time Slot - a default timetable will be generated.
Continuous Time - thetime slot will be continuous or the user can choose the time gap.

Export Format
Individual Timetable - printout timetable one by one (which user can choose which group to print).
Master Timetable - print a master timetable that have attribute selected by user.

Time Slot Position
Top - time slot will be position on the top of the timetable.
Left - timeslot will be position on the left of the timetable.

Grouping
By Day - printing format is by day.
By Room - printing format is by room.
By Lecture - printing format is by lecture.

Field to Include
Tick the preferred field to be included in the timetable. The field will appear in the timetable printed

Step 5 : Click OK.

Step 6 : Choose a location to save the export file to be print.

Figure 7.3

Step 7 : Open Timetabler plus.xls

Figure 7.4

Step 8 : Select Format Timetable.

Step 9 : Open the file that we already save (refer to step 6 for the location).

Step 10 : Excel format timetable is generated.Done.

Printing a Batch of Student

To print timetable for batch of student, first you have to group the students in batch groups first.

Step 1: Click Course List in Data tab.

Figure 7.5

Step 2: Click on .

Figure 7.6

Step 3: Click icon to add new group.

Step 4: Rename the new group with students' batch name.

Figure 7.7

Step 5: There are 2 ways to define the section in the respective groups.

1st  way: drag sections with same section name into respective groups.

Figure 7.8

2nd way: Double click on any sections and change the group column to the respective group names.

Figure 7.9

Step 6: After finish dragging all the sections, follow Step 1,2 and 3 in the topic Printing Timetable.

Step 7: Set the printing format as below.

Figure 7.10

Done. Your raw output in Excel will be as below.

Figure 7.11

You can then edit the timetable according to your preference. Below is an example.

Figure 7.12

Print Lecturer List

Figure 7.13

Step 4: Choose a location to save the export file to be print.

Figure 7.14

Step 5 : Open Timetabler plus.xls.

Figure 7.15

Step 6 : Select Format Timetable.
Step 7 : Open the file that we already save (refer to step 4 for the location).
Step 8 : Excel format timetable is generated.

Done

Inserting the Header and Footer

Step 1 : Open Timetabler plus.xls.

Step 2 : Select Insert Header or Insert Footer or both.

Figure 7.16

Step 3 : Click the tab in blue color named Header.

Step 4 : Click icon. Choose your logo either in JPEG or GIF format. You can also change the text on the top box.

Figure 7.17

Step 5: Now you have your header.

Figure 7.18

Step 6: Click the tab in red color named Footer.

Step 7: You can add text and table using excel borders function.

Figure 7.19

Printing Examples

Here are some examples of printing format that you can refer.

Example 1 : Basic timetables

Figure 7.20

Example 2 : Rooms timetable

Figure 7.21

Example 3 : Lecturers timetable

Figure 7.22

Example 4 : Master timetable (everything in 1 single page)

Figure 7.23

Example 5: Example timetable where the timeframe is vertical on the left (can be apply with any timetable format).

Figure 7.23

Basic is the structure as we can see in Timetabler Plus, i.e. the timetable is arranged by day and room with the break down in time slot.

Figure 7.24

Continuous Time  is the same as the first, i.e. organize by day and room, but the time slot is not in the breakdown of slot. Instead, it shows continuous time from the start to the end of class.

Figure 7.25

[back to top]

[return to content menu]