 |
Time Management: Timetable and Notional Hours |
Activity 11 |
Time Management for students |
| Activity 11b |
Setting up your Timetable |
| |
Please note:
Set up your timetable for the first semester only!
Students for large courses are divided into groups.
Example:
There are 3 groups for the lectures for WTW 114 and 7 groups for practicals. If you select the lectures for group 1, you can select a practical with another group, let's say group 6. To make it easier for you, populate your timetable with all your lectures first and then add the practicals. |
| |
- Open a new worksheet in your Time Management Excel file "yourSurnameTime" and rename it to “Timetable”.
- Download the blank excel timetable from: http://upnet.up.ac.za/tt/plts.xls. Enable editing and copy/paste it into your Excel workbook's "timetable" worksheet.
- Use the timetable book or the timetable on the website: http://upnet.up.ac.za/tt/hatfield_timetable.html to work out a timetable for the study programme you selected.
Enter the code (i.e. CMY 131) of the Core and Elective modules only; leave out the Fundamental modules.
Consult page 5 in the book or the notes on the webpage: http://upnet.up.ac.za/tt/TimeTableNotes_Abbreviations.pdf
to understand the abbreviations.
- Delete rows 15 to 18 of your timetable.
- Change the property of the cells C15 to G15 to ‘number with 0 decimals’.
- In row 15 count how many periods in your timetable are not empty for each weekday by using the count all function: =COUNTA(C5:C14)
- Calculate the total number of hours you will be having lectures/practicals per week in cell H15 – make sure cell 15 has the right properties.
- In cell H16 calculate the self-study hours using the 50 notional hours as calculated under selfstudy hours under at the top of activity 11a.
- If there is time, make your timetable look pretty by colouring the cells for lectures and practicals of the different courses with different colours.
|
| Activity 11c |
Time - Where do all the hours go? |
| Excel Tips |
Make sure your cells have the right format (right-click, select "Format Cells ..." and choose General or Number of Text, or... ... ...)
Examples of formulas you should know:
- To add the numbers in cells A1 to A10 you can either type
- =A1+A2+A3+A4+A5+A6+A7+A8+A9+A10
or
- =SUM(A1:A10)
- =COUNTBLANK(L3:L15)
count how many cells in the column L from cell L3 to L15 are blank
- =COUNTA(B3:B10)
counts how many cells in the column B from cell B3 to B10 are not blank
- =AVERAGE(G3:G13)
calculates the average value of the numbers in cells G3 to G13; blank cells are not taken into account. A zero does not count as a blank cell.
- =COUNTIF(C1:C20,"1")
counts the number of cells that have the value 1
- =COUNTIF(K2:K21,"BioChem")
counts the number of cells that have the word BioChem.
|
References & Resources
- Lee Bob Black. 2014. The Career Value of Microsoft Excel [Infographic].
http://cdn.skilledup.com/wp-content/uploads/2015/01/Value-Of-Learning-Excel-Infographic-secondary2.png
Viewed online on 10 March 2016 at : www.skilledup.com/articles/career-value-microsoft-excel-infographic
- Don Lee 2013. Why you need to learn MS Excel. Viewed online on 10 March 2016 at: http://edonn.com/2013/01/13/why-you-need-to-learn-ms-excel-now/
- Five Minute Lessons. 2014. 10 essential things you should learn about Microsoft Excel. Viewed online on 10 March 2016 at:
fiveminutelessons.com/learn-microsoft-excel/10-essential-things-you-should-learn-about-microsoft-excel#sthash.UoausCmL.dpbs
|
