Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Starting a content tracking spreadsheet

From: Web Site Strategy and Planning

Video: Starting a content tracking spreadsheet

I would like to use a Spreadsheet for tracking content on my website. The easiest way for everyone to consistently access the same version of that Spreadsheet is to use Google Documents. This is a free service at Google, which offers Spreadsheets, Word processing documents, and much more. Google Documents, or Google Docs, allows you to share a Spreadsheet between you, your client, all of your subcontractors and anyone else who might be interested. This way, you won't have to worry about who has the most recent copy of your Spreadsheet.

Starting a content tracking spreadsheet

I would like to use a Spreadsheet for tracking content on my website. The easiest way for everyone to consistently access the same version of that Spreadsheet is to use Google Documents. This is a free service at Google, which offers Spreadsheets, Word processing documents, and much more. Google Documents, or Google Docs, allows you to share a Spreadsheet between you, your client, all of your subcontractors and anyone else who might be interested. This way, you won't have to worry about who has the most recent copy of your Spreadsheet.

Furthermore, everyone can access it and update it quickly and easily. From the Google homepage, if you look under the link for more, go down to choose the Documents option. And this will put you on the Documents homepage. You'll need to sign in to access Google Docs. If you don't have a Google account, you can create one by clicking on to Get started button down at the bottom of your screen. Otherwise, Sign in. You have a Google account if you have Gmail, Google Analytics, or some other Google service that you use.

All right, so we're looking at the screen here for Google Docs. What we are going to do now is create a new Spreadsheet. We are going to do that by going over here to the left, and saying Create new>Spreadsheet. This should look fairly familiar to you if you've worked with programs such as Microsoft Excel, and it works very much the same sort of way. What we are going to do is we are going to create several columns in our Site Map.

First of all, we're going to put in a number to identify each item from our Site Map. In our second column, we're going to put in the name of that navigation item. In the third column, we are going to put in the person who is responsible for this piece of content, in other words, it's the person who's going to write the content, edit the content or otherwise create the content. Then we are going to put in a column describing where the content is coming from. Is it coming from an existing page on the current website? Is it coming from a brochure, or is somebody writing it completely from scratch? And we are also going to put in a date for when the content is due.

Now that we've created those headers for our Spreadsheet, we will start to type in the items from our Site Map. Item number one is the Home page. The people responsible for the content on the home page will be Hansel and Petal. It's going to come from a number of different places. There will be Most recent blog entry, there will be a recent photo, and some brief description text packed with keywords for the search engines.

The due date for delivery, we have already figured out, will be about six weeks from now. Now we will type in the second item for our navigation. Navigation item number two will be Your Special Event. Your Special Event has some sub- navigation associated with it. There is Weddings, Corporate Functions, and other events. Each of those items also has sub-navigation.

I am going to show you how to put in each of those without filling out the full spreadsheet, so that you can see how to put in each navigation item. Weddings is going to be item number 2.1. In other words, it's the first item under the second navigation item. Weddings has two items underneath of it, one is For Brides, and one is For Wedding Planners. So our first one, For Brides, will have the number 2.1.1. It's the first item under the first item, under the second navigation item.

And For Wedding Planners, the number is 2.1.2. Okay. Now we are going to Corporate Functions. The number for Corporate Functions is 2.2, because this is under the second main navigation item and it's the second sub-navigation item. We will continue in this way for the other items under Your Special Event.

As you might expect, commitment to the environment would be our third navigation item, while restaurant service is our fourth navigation item, and things will continue in that way. Finally, we will want to make sure we save this spreadsheet. The Save button is located in the upper right-hand corner. If I click Save, it will ask me what I'd like to save the Spreadsheet as. This will be our content plan for hansel and petal, and I'll say OK. Finally, I'll want to share this spreadsheet with Kirk Hansel and Petal Jones so that they know what's going on while they're working on the website.

In order to share this document, I'm going to go to the Share button up here, in the upper right-hand corner, and click it. It will ask me if I want to Invite people to share the document. I'm going to choose that, and I can type in an e-mail address. I can also type in a message. This is the content plan I mentioned on the phone earlier today.

And I will Send that. Now I can access this document as can Hansel at hanselandpetal.com. I am going to Save and Close. I am going to go ahead and finish typing in my Site Map now off-line. You go ahead and finish typing in your Site Map for your client in your Google Document. Google documents is a great way to share documents with your client and your subcontractors without worrying about version control. This is a great way to track all the content in your website, who is providing it, and the date that content is due.

Show transcript

This video is part of

Image for Web Site Strategy  and Planning
Web Site Strategy and Planning

24 video lessons · 28469 viewers

Jen Kramer
Author

 

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Web Site Strategy and Planning.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.