dave seah: better living through new media Filter Navigation Temporary Redirect Page Personal Articles Productivity Articles Compact Calendar The Printable CEO Series The Printable CEO Series Back to Home Page Admin:Login

Compact Calendar 2009

POSTED 09/19/2008 UNDER Tools

Compact Calendar 2009

The power of the human voice is such that when someone called me up to ask me about the 2009 version of the Compact Calendar, I was so moved that I actually got off my butt to make it. Easier said than done; I said it would take about 15 minutes + about an hour to post. Four hours later, I'm finally done with tweaking, testing, download testing, virus scanning, packaging, and updating. It takes a bit of work to make sure these archives are clean...hopefully I didn't miss anything. I almost posted a version that was off by one day...close call!

What Is It?

The Compact Calendar is my impromptu planning calendar, designed to be printed on paper from Excel. Print a bunch of these sheets out; it's great for bringing to a meeting and sketching out a schedule on-the-fly. I keep a supply on hand when I'm actively out in the field. Unlike other calendars, it represents the months as a solid "bar of time", which makes it easier to visualize how much time you really have. Plus, it just looks neat.

You can read more about the use and design of the Compact Calendar on the Compact Calendar Page.

What's New

I finally have a version that will update the entire calendar when you change the year field at the top of the spreadsheet, based on the work of Todd Foster. So now, it's super easy to make new versions of the calendar yourself for any arbitrary year. Just remember to update the Holiday Table.

"Jenny" and Jim Service both submitted techniques for handling the automatic month labeling on the left side, and I've incorporated it.

There have been several other modifications submitted to me over the year, and I've tried to pick the ones that are simple to maintain (e.g. they don't require additional Excel modules, or tricky hidden extra columns). Thanks everyone for your submissions!

Check It Out

You can download the 2009 version at the regular Compact Calendar Page. I have only updated the US version; the international versions are handled by independent bloggers and are not under my control at all. I just link to them!

You'll need Office 1997 or later to open the Excel Templates. Personally I have been using Office 2007, so there may be some issues with earlier versions of Office that I don't know about. Please leave a comment if you come across anything. For users of non-Office productivity suites, good luck!

Academic Year Compact Calendar

POSTED 08/29/2008 UNDER Tools

Here's a quickie:

Professor (and reader) Jim Mitchell adapted a version of the Compact Calendar for the U.S. academic school year, with a few tweaks of his own!

You can download his version of the academic compact calendar from Jim's blog, Architectural Education.

Thanks Jim!

PowerPoint Resume Layout Tips

POSTED 07/24/2008 UNDER DesignMaking Stuff

Powerpoint Resume

I know I said I was going on hiatus, but I just I got a nice email from a reader today complimenting me on the layout of the blog...thanks Janet! She also asked a question about my old online resume PDF:

In particular your resume's design caught my attention. How did you create a one-page PDF resume that's so organized and detailed? Would you be able to suggest resources or pages on how to design a PDF resume from scratch?

The short answer is that I use Adobe InDesign and Adobe Acrobat, which are pricey professional page layout and document management software packages.

The longer answer is that I spent some time thinking about how I wanted people to perceive my resume and how people actually read them:

  • After scanning a few hundred resumes, you start to get snow blindness from all that white. This is where graphic designers have a seeming advantage: A HAH! We can use this opportunity to uniquely express our graphical talents and creative expression! While that does work when you know you're competing against a sea of white paper, it doesn't work so well when everyone else is doing the same thing. The takeaway is a resume should be easy to read, with style in a supporting role.

  • When resumes are being screened by someone who is unable to evaluate the strengths of a candidate themselves, the resume is being scanned for relevant experience and skills that match the job criteria they've been handed. It's important that these requirements are easy for them to find so your resume makes the cut.

  • When resumes are being handled directly by the people that you'll be working with, they'll be scanning for signs of rare competence or interesting combinations of skills. They aren't hiring for just skills, though: they're hiring for a team fit. While you still need to address the basic requirements of the job, interjecting that curveball skill might just catch the attention of the person assembling the list of "awesome people we'd like to work with".

Most of the time, my resume isn't being processed by an HR or employee review process, but is provided as a formality, so I don't really follow the standard format. What is important, though, is that people get a sense of what skills and experience I have. The issue I have with the standard resume look is that they often have long page-width sentences (hard to read) and are filled with sentences that sound like Single-handedly managed team productivity of 50 associates through just-in-time distributed beverage ordering coordination and delivery processes. I am yawning "BS" before I even get to the word "handedly", so I cater to my own whims by using shorter descriptions in my lists of credentials. My reasoning goes something like this:

  • I put all the experience "color commentary" in the "framing statement" at the top of the page, where it is placed so it is the first thing read on the page, after my name and categorical title. It should be short and to the point, serving as a kind of establishing shot, to use film lingo, for the rest of the resume.
  • All the following lists of education, experience, skills, and so on then (ideally) support the framing statement. If they don't, then you are sending a mixed message about what it is you do. You may do a LOT MORE in real life, but a company is generally looking you to FIT into a particular kind of box. You might change the actual categories from what I have here to suit the type of business and industry, and if necessary add the necessary years of experience quantifiers.
  • While I like to say that people should find out how to stand out rather than just fit in, the resume is one of those cases where you might want to make it easy for potential employers to IMAGINE you as a plug-and-play part in their company. That is what you are trying to sell here: possibility of a good fit, which makes it a no-brainer of a deal to get a phone call.
  • When you get to the interview, your personality can then sell the other connections you can foresee. The AREAS OF INTEREST part of my resume provides potential jumping-off points for conversation.

Anyway, this is just what I do for my simple resume. I'm generally targeting the case where my resume is being considered by the creative professional for informational purposes, not competing with others as I've described above. So your mileage may vary considerably!

So, You Don't Have InDesign

In answering Janet's email, I thought about the common problem I face when telling people that I use expensive production graphics software to do my work. The implication is that THEY SHOULD TOO, though it's impractical most of the time due to the need for training and people like to use what they have available. Most of the time this is Microsoft Word or Excel. While I like Word for straight writing and basic formatting of source text, I hate its page layout tools. They are very finicky, and often times one little layout issue will cascade into an unrecoverable mess. Excel just lacks the fundamental typographic control tools, though it is surprisingly flexible.

I avoid using Microsoft FrontPage on general principle, which is that it is the source of ugly web pages that I have had to clean up. Call me small minded, but I don't even want to know what it does because of past ills visited upon me by its twisted autogenerated HTML progeny.

That leaves Microsoft PowerPoint. I occasionally have received photo assets that had been copied and pasted into a Word document or PowerPoint presentation, and this creates a production headache because the original file is down-sampled or destroyed in the process. However, I've also seen several reader-provided PowerPoint and Excel versions of my templates, and these look fine. I then idly wondered if I could use PowerPoint to recreate the layout without looking too ugly, so I gave it a try. I think it actually works. The advantage of PowerPoint over Word is that you can freely place text blocks and format them as you would in Word. You can place graphic imagery. You can also specify in PowerPoint's options to produce output aligned to the resolution of your printer, not the screen. And since PowerPoint is part of the most basic Microsoft Office suite, you probably already have it...so let's rock!

Shown below is PowerPoint 2007 duplicating my resume layout, with the "view grid" and "view rulers" options turned on to make the screenshot look more impressive:

PowerPoint Resume

PowerPoint allows you to set the page size of your presentation, so I set it to US Letter. Then I just drew a bunch of text boxes and aligned them in such a way that the white spaces worked together. The grid isn't particularly tight or well-constructed (in other words, it looks a little sloppy) but the overall look is fairly clean. The unit whitespace I used is the height of a line in the body text, because I didn't feel like fiddling with line heights for every paragraph. I adjusted the spaces between the headers to be greater than the blank line that separates paragraphs, and just adjusted other parts of the composition so they tended to line up cleanly where it seemed that should happen.

If I was being more anal, I would have shrunk the space between paragraphs by about 25-30% and tightened everything up proportionally...this would have improved the "scattered" look of the "education" and "experience" areas. However, this effort would have required a lot of paragraph twiddling and hey, I would have used InDesign or Illustrator for this if I were doing it for real. If you are so inclined to this kind of adjustment, though, you would select the paragraph and then right-click to choose "Format Paragraph" to play with the "space after" parameters and linespacing.

There are a couple of tricks that I had to apply to the topmost header that says DAVID SEAH.

  • First, I tweaked the left margin from 0 inches to a small value to make the left edge of the D in "DAVID SEAH" line up with the type before it. If you align by the text box margins, the D does not optically line up with the left margin of the text below it ("new media designer"). In a real page layout program I would have just nudged it over, but I could not place the text box accurately enough with the mouse due to the way the program "auto-snaps" objects into alignment. Adjusting the internal margin was easier than figuring out how to turn that feature off, which I suspect is not possible.

  • I opened the text box formatting options to adjust the character spacing (the default value was way too wide) by -2pt. This didn't fix the regrettable amount of space between the D and A letters (a common problem with electronic type on PCs) but it does seem more put together.

I use Acrobat Professional to create my PDF files, but I imagine there are other providers of inexpensive PDF encoders. I'm not familiar with any of them. Readers, any suggestions? [UPDATE: Several suggestions have been posted in the comments, so check them out!]

Download Example Resume Files

If you'd like to play with your own version of this resume, just download the zip file which contains the PowerPoint 2007 source. I've also enclosed a version that should work with PowerPoint 2005 versions and earlier, though I'm not sure if it works. A sample PDF is also included for your reference. Please note that this is not my actual resume, though it is using elements from it.

» Download PPTResumeSample.zip (170K)
» Requires Microsoft PowerPoint

Note: If you are looking for Calibri, the font that I'm using here, it's part of Office 2007. You can download and install the Microsoft Office 2007 Compatibility Pack to get them; check this article for some tips on other options.

NOTE: There have been some really great reader comments for this article; you should definitely check them out! :-)

On Hiatus

POSTED 07/22/2008 UNDER Personal

Although at this moment I am filled with excitement at again redefining and reframing myself, I have a big project I need to close out, and I'm going to have to refrain from blogging for at least a month. This is a good time to haul out my Pickle Jar, which I think is in the laundry room collecting coins that I find in the washing machine. The Pickle Jar is used for holding ideas that I don't want to lose, a sort of promise to myself to come back to the idea later.

Before I disappear, here's some updates on various initiatives:

  • I'm still working on that interactive museum project, and we're at the point where development should be hitting "full steam ahead" mode. I'm falling a bit behind on the technology side of things (I'm learning how to program 3D graphics systems) because I'm becoming familiar with the underlying development system. I'm also looking for programmers experienced with XNA on Windows, particularly on the model/shader development/animation side of things, to help out on a module-by-module basis.

  • One of the people I met at Starbucks teaches piano lessons, so I signed up for one to see if that will help with the Gospel Music experiment I started a while ago.

  • I've gotten several submissions for the freelance referral building, but I have not yet processed any of this. If there's anything I post about, it will be this.

  • I have Printable CEO-related updates that I'd like to make, but I don't know when I'll be able to get to them. This also includes several user submissions that I haven't had the time to virus-check, zip, and upload. The challenge with user submitted updates is that I end up having to provide the technical support for the uploads; links to blog posts are much easier to deal with.

Although the writing and blogging are activities that fill me with energy, they take a lot of time and I have to shift that to my paying work for a good chunk of time. At least afterwards, I'll have a whole new body of expertise to write about.

Personal Insights from Social Media

POSTED 07/21/2008 UNDER PodcampSocial Media

Laugh it up, Podcampers

Yesterday was the final day of PodCamp Boston 3, and I had a really great time. I wasn't sure if I would fit into a social media event, but apparently what I've been trying to do for the past two years IS social media. It all started with insights from my first SXSW, and more recently I've been going through this progression of insights over the past month that have led up to this insight:

  1. For the past year or two, I've been trying to figure out my "angle" so I can accurately describe what I do. I've played with ideas like storytelling by design (which I've noted interestingly that some other designers online have since adopted) and investigative design to describe my design approach. The major insight I've had, up to now, was that I should put my skills (programming, interactive, design) second, and my nature first. Figuring out what my nature is has been what's on my mind.

  2. Following up on that insight, I'd noted in Groundhogs, The Future, and Tanabata Too that my "armor" or "persona" was in opposition to some mysterious bird-like core that wanted to "just be". In other words, I was denying myself my nature, and this reminded me very much of how recognizing such conflict can help inspire great character performances in film. Perhaps I am in my third act.

  3. I've recently realized that I would rather be writing than anything else. At PodCamp, I dipped my toe in the water by labeling my name tag "designer / writer" instead of the usual "personal productivity enthusiast" or "investigative designer". I was pretty pleased with myself until the all-seeing Chris Brogan happened to catch it as he was sweeping by, and commented, "designer first, Dave?" before vanishing in a puff of rhetoric. Realizing I was lacking guts, I went back to the registration table and put writer before designer.

So what is social media? You can read the definition on Wikipedia, but I would flip it around and say that it's reaching people and making a genuine personal connection steeped in shared passion. It's not about technology. It's not about increasing the size of your network. It's not about monetizing the eyeballs that advertisers are desperate to reach. For me, it is about making a real one-on-one connection, to create enthusiastic conversation. What social media does, from an action-oriented methodology perspective, is create the context where such conversations can take place. That's the way I'm thinking about it, anyway.

One of my favorite presentations at Podcamp Boston 3 was C.C. Chapman's Building Your Brand Through Passion & Community, because C.C. is a living example of the kind of transparency I applaud. I didn't keep good notes, other than the link to the awesome Where The Hell Is Matt dancing around the world video, but I remember feeling that for the first time, I had some external confirmation that it was OK to equate brand and personal identity. I do not need to compartmentalize my interests for the convenience of marketing myself as a package to different special interest groups. However, I do need to be cognizant of the need to make those aspects of myself easily approached; that also means that they need to be clearly presented. That isn't the case at all right now on this website, and the scattered nature of my topical writing isn't helping either. On top of that, there are several threads that I haven't reported on in a while: the gospel music project and the freelance network wiki are foremost on my mind at the moment. I'm feeling bad about this because continuity is important when you're trying to do anything of lasting coolness; you can see the tie-in to productivity here.

I met a ton of cool people, and feel plugged into the possibility of having found another community that's close to my heart. And this time, it's right here in the Boston area. Awesome.

Page 1 of 257 pages  1 2 3 >  Last »
Thank you for printing this article! Please note that all material on this website is copyrighted by either David Seah or individual comment contributors. To request permission for republication and distribution, please contact David Seah (http://davidseah.com/contact).