Time Management

Objective

In this lesson you will:

Review academic goals and reflect on your current time management in school and personal life.
Learn to use simple and conditional formulas using Google Spreadsheets.
Properly format graphs using Google Spreadsheets.
Learn how to integrate the use of Google Drive with Excel for backup and sharing.

Anticipatory Set

On September 18, 2007, Randy Pausch, a Carnegie Mellon professor and alumnus delivered a one-of-a-kind last lecture that made the world stop and pay attention. He had been diagnosed with terminal pancreatic cancer and rather than ride out his time left in self pity, he spent his time preparing his family to move on and giving inspirational lectures. If you need to be inspired about achieving childhood dreams watch:

Randy Pausch Last Lecture

Watch the Kobe Bryant video to understand his commitment to improvement through detail oriented reflection. What are you passionate about? What gives you positive energy? What are you good at? How can you use Kobe's words to help drive you to improve?

What better voice to listen to about time management than someone who used every precious moment he had left to share invaluable insight and wisdom. Watch the short excerpt from the full 1 hour+ lecture he gave on time management. Ask yourself:

Why is time management important?
What advice can I apply to my school success?
What advice can I apply to my personal development?

Time Management Excerpt

Randy Pausch-Time Management.mp4

The Full Time Management Lecture

Randy Pausch Lecture_ Time Management

Lesson

Investigate Your Own Time Management Using Excel as your "microscope"

Open the Time Management spreadsheet shared via GoogleClassroom.

Part 1. Believe in yourself and set goals:

On the sheet labeled Part 1, list your courses in cells A4-A12. You can add cells by using the smart copy/ paste handle for the last row and drag it to make extra rows.
In cells B4-B11 put the highest grade you think you can earn in the class if you work hard. This suggests that you would never miss an assignment, go to extra help or seek out an NHS tutor after school, thoroughly study for all test and quizzes, and even review/ practice subject matter when the teacher doesn't give homework.
Select the cell below your last grade. If your last grade is in B11, select B12.

Time Mgt Pt1.mp4

Use the auto-sum icon on your toolbar and select Average . . . this will give you the basis for a formula computing an average of an array of numbers =Average()

Now all you have to do is put the range of cells you want to average, in the parentheses, separated by a colon . . . your formula will now look something like this =Average(B4:B8).
Use Format > Number > 0 to change number
In the "A" Cell to the left of the formula, put the Text "AVG". Bold the "A" and "B" Avg Cells and change the font color.
Keep all data in column B centered and make sure there are borders around all cells in your chart.

Part 2/ Naviance Goal

Create a Naviance Goal and hold yourself accountable. see the directives for this on the Naviance Goal page.

Part 3. Record the events of a typical week:

Enter Data

- Complete Part 2 of the time_mgt attachment. Use the codes on the table on the right side of the sheet to fill in your typical school week in the table cells B7 through H54.
- You may add or make up your own codes and names for activities not on the chart or delete ones that do not apply in column "J".
- Do not put more than one code in a cell-- estimate or round off items that are not full half hours.

Use your copy and paste "fill handle" to be efficient and save time!

Part 4/ Data Formulas

A. Use Conditional Formulas to Add up Your Data

Find out the total number of hours per week you spend on each activity:

In L7 put the following formula

=countif($B$7:$H$54,J7)/2

Smart copy and paste the formula from L7 to cells L8-L24 (or however many categories you have beyond K22).

Note that the formulas are basically saying, "count up the number of times a certain 'code letter' you used appeared in the range of cells B7 through H54 in your chart and divide by 2." Dividing by 2 is done so you will end up with a reference of how many total hours you spend doing the activity.

B. Find out the percentage of our average week that you spend doing each activity.

First format column M so it will show %. To do this select all of column "L" (click on the letter "L" at the top of the column) and then select Format, Number, Percent (with 2 decimal places).
In cell M7 put the following formula =L7/168
"Smart" copy and paste this formula from M8 through the rest of your L column codes. This formula is the number of hours you do an activity divided by the number of hours in a week. This will give you the percentage of time for each activity over the course of a week.
In the next available cell under your categories in column J, put the text "Total" and make it bold and red. Merge that cell and the adjoining "K" cell and right justify the text.
At the bottom of your "L" column totals and "M" column percents, use the auto-sum feature to add the totals of each column. If you have done this correctly, your column "L" 's formula will produce a result of 168 and "M" will read 100%. Make these bold and red also.

Keep data in both charts the default black and size 12 (or red as requested) font the and make sure there are borders around all cells in your chart.

Part 5. Create a visual graphic of your results.

Select cells K7-L22 (or however many categories you have beyond K22).
On the toolbar, select Insert and select a pie graph.
Move the pie graph to a separate sheet by selecting the Dropdown in the upper right corner, select Move to own sheet.
Rename the sheet tab at the bottom of the page "Time Chart" by right clicking on it and renaming with the new text.
Give the pie graph the title "My Time Management" and keep the font black. Spelling and capitalization count!
The labels will probably be too small and a larger font will make them more "readable." Click on the right corner dropdown and select Advanced edit. Change Title Size to 30, the Make slice percent labels between font size 12-15.
The legend should remain in black font.
Choose your own colors for each pie piece. Click on a piece, and use the paint bucket icon to change each color. Be sure there is strong contrast between the pie slice color and the data point so it is easy to read.
Reflect on the information in Part 1, 2, and 3:

Time Management Reflection

Submission

Your instructor will visit your spreadsheet from Google Drive. Turn In on the Google Classroom assignment post.

Closure

Public speaking assignment - After reflecting on your LinkIt results and your weekly activity breakdown, what is one aspect that you are proud of and what is one aspect that you feel that you can improve upon? What steps will you take to go about doing this?
Check theses PDFs for some useful Time Management strategies:
- Time Management Strategies for College (Courtesy of the University of Georgia)
- Time Management Worksheet (Courtesy of K-State University)
- Time Management Tips (Courtesy of Springfield TCC)
For studying, check these strategies out.

NJ Standards

- CAEP.9.2.12.C.1 - [Standard] - Review career goals and determine steps necessary for attainment.
- CAEP.9.2.12.C.2 - [Standard] - Modify Personalized Student Learning Plans to support declared career goals.
- MA- A function can be described in various ways, such as by a graph (e.g., the trace of a seismograph); by a verbal rule, as in, “I’ll give you a state, you give me the capital city;” by an algebraic expression like f(x) = a + bx; or by a recursive rule. The graph of a function is often a useful way of visualizing the relationship of the function models, and manipulating a mathematical expression for a function can throw light on the function’s properties.
- TECH.8.1.12.A.4 - [Cumulative Progress Indicator] - Construct a spreadsheet workbook with multiple worksheets, rename tabs to reflect the data on the worksheet, and use mathematical or logical functions, charts and data from all worksheets to convey the results.

Report abuse