+ Reply to Thread
Results 1 to 6 of 6

Help with timetable

  1. #1
    Registered User
    Join Date
    04-02-2013
    Location
    United Kingdom
    MS-Off Ver
    Mac 2010
    Posts
    3

    Question Help with timetable

    Hello everybody,

    I'm not brilliant with Excel so please excuse poor explanation of what I want. I am a teacher and teach different classes over a week. I have downloaded a workbook for lesson planning. On the first sheet, every row is a day and I have entered my timetable, so it's like a table of five rows (Mon-Fri) and six columns (lessons 1-6), repeated to show enough weeks for the term.

    In the workbook are separate pages for each class. So, for example, there is a page for my Year 11 class - this is a similar 'calendar sheet' and I can copy all of my Y11 cells from the first page into this grid and paste them into the right cells on the Lessons page. On the Y11 Lessons page, I can type in what I'm going to teach for each lesson and hyperlink to documents etc. This will show up on the first sheet.

    I then have a timetable for the term on the first page, showing what I am teaching so I can see what I am doing on each day. Then I have a page for each class with all of their lessons mapped out. To do this, I have copied and pasted each cell from the timetable on to the relevant Lessons page but there must be an easy way to do this. I have asked the person who uploaded the workbook and she he has told me that he has done it the same way that I have.

    Can somebody help me with this? Thanks in advance

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Help with timetable

    Can you upload the workbook please Gloria?

    1.Select Reply
    2.Select "Go Advanced" (Bottom right)
    3.Select the paperclip in the menu bar above (attach file)
    follow the wizard instructions to select and upload a file.
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    04-02-2013
    Location
    United Kingdom
    MS-Off Ver
    Mac 2010
    Posts
    3

    Re: Help with timetable

    LESSON PLANNER.xlsx

    I think I've attached the file. I've edited the Summer sheets.

  4. #4
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Help with timetable

    I'll have a look and get back to you

    Before I start can I just clarify that what you need is to automatically populate your term timetable from your class plans?
    Last edited by AndyLitch; 04-02-2013 at 06:11 AM.

  5. #5
    Registered User
    Join Date
    04-02-2013
    Location
    United Kingdom
    MS-Off Ver
    Mac 2010
    Posts
    3

    Re: Help with timetable

    I was working the other way round - completing the timetable first.

  6. #6
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Help with timetable

    OK.. That makes sense.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1