Posted by Kristin D. Russell, Secretary of Technology and State Chief Information Officer, Governor’s Office of Information Technology, State of Colorado

Editor's note: Colorado has enticed all sorts of pioneers since its Wild West beginnings. We’re excited to highlight a handful of these trailblazers - the intrepid entrepreneurs, aspiring micro-brewers and ambitious thought leaders - who have helped create the adventurous and innovative culture the Centennial State is known for. Today, we hear from Kristin D. Russell, Secretary of Technology and State Chief Information Officer for the State of Colorado’s Office of Information Technology.

The Colorado Governor’s Office of Information Technology (OIT) is leading an effort to transform government through the use of shared information technology services. As we shift from “business as usual” processes and tools towards innovative solutions that enable the efficient, effective, and elegant delivery of services, we look more and more to cloud-based services and solutions. In fact, we have published a “Cloud First” strategy for Colorado.

The move to Google Apps for Government in Colorado allowed us to replace our 15 siloed and disparate email systems, and the 50 servers supporting them, into a single, cloud-based solution. Now, not only do our more than 26,000 employees have a common email, calendar and collaboration system, they have the ability to work together on Google Docs, allowing teams to work together and share information across departments. This accessibility has also helped to enable a BYOD (bring your own device) program that lets employees work the way they want to work – even when they’re not sitting at their desks.

We are also taking advantage of Google Sites. Since Google Sites doesn’t require extensive web development skills, state agencies are now empowered to create helpful resources, both internally and externally, for a number of programs. TobaccoFreeCO.org, for example, was built on Google Sites and provides information on the effects of second-hand smoke and resources on quitting smoking. When unprecedented flooding devasted many areas of Colorado in recent months, we built a Google Map to help organize recovery efforts and then set up the ColoradoUnited.com website to provide the latest updates and provide an interactive way to assist flood victims as they rebuild.

Colorado Gov. John Hickenlooper often talks about the “three E’s” – making government more efficient, effective, and elegant. In Colorado we in the Governor’s Office of Information Technology are in the business of using innovative technology to accomplish just that.

Posted by Dorothy Burt, professional development leader at Pt England School

Editors note: Today’s guest blogger is Dorothy Burt, a professional development leader at Pt England School in Auckland, New Zealand. Dorothy has been a Google Certified Teacher since 2008.

Here at Pt England School in Auckland, New Zealand our motto is “Strive to succeed.” But in our low socioeconomic area – an impoverished suburb surrounded by affluence – there’s an unspoken belief that success can be associated with your ability to get out of this part of town. 90% of our 600 students are of Maori or Pasifika descent, who are often found in the lowest achieving cohort. Raising student achievement levels for this demographic is a government priority – and a continued focus for the principal, management team, teachers and parent community at Pt England school. Recognizing our students’ natural flair for technology and expressing themselves through digital platforms, we began a journey to get our students excited about learning and improve their achievement levels through collaborative e-learning. We haven’t looked back since.

We migrated to Google Apps for Education in 2008. After training our teaching staff, we quickly began to see the advantages of working collaboratively. Our migration coincided with several neighbouring schools joining together to form the Manaiakalani Cluster – a group that works toward raising student achievement in literacy. Using Google Apps and other tools, we sought to create confident and informed digital citizens. While we quickly noticed increased student engagement, teachers felt that there was still a missing piece. Enter the Teacher Dashboard, an add-on from the Google Apps Marketplace that allowed teachers to get a bird’s-eye view of classroom activity across Docs, Sites, Gmail, Blogger and Picasa. Using Google Sites, the Manaiakalani Cluster manages the student learning environment internally, making the feedback exchange quick and easy.

The research from test scores collated in 2011 showed significant progress in literacy. Surveys, video observations and interviews with students now demonstrate a group of young learners who are highly engaged in learning.

They have a renewed sense of pride because their test scores improved, and – more importantly to them – people all around the world were reading their blog posts and complementing their success. The teachers also feel a renewed sense of engagement with their classrooms since they can centrally track and monitor student progress via the Teacher Dashboard.

Using Google tools has provided our students with equal access to learning opportunities and opened the door for them to be excited about the learning process and share their progress with the world. As a result, these students know that they don’t need to leave their town to be successful; the world now comes to them and shows them that they are.

Posted by Jeremy Milo, Google Apps Product Marketing Manager

We’ve all been frustrated by technology that gets slower, less reliable and less useful over time. Google Apps is different – it actually gets better automatically week after week without patches or updates to manage. People can absorb this stream of innovation without being distracted from their workflow, so this month we’re taking a look back to highlight the most interesting ways that Google Apps has grown up over time. Last week, we started with Gmail and Google Calendar.

Today we’ll break down how Google Docs and Sites support better teamwork, mobile productivity, ease of use and trustworthiness – four areas where Google Apps excels. We’re holding a webinar next Thursday to explore these developments (details below), so join us if you’re interested in learning more. We hope you’ll find a few capabilities here that you didn’t know about before, or haven’t tried in some time.

Designed for Teams
Google Docs and Sites were built from the ground up to make teamwork seamless. Being able to simultaneously edit documents, spreadsheets and presentations without the hassles of attachments is just the start.

• Great documents come from great discussions, so in addition to collaborative editing, Google Docs also enables conversations right alongside your content. Comments can be directed to specific co-editors, who can then respond in the document’s discussion panel or over email.
  
• Sometimes you want to collaborate freely with others in a spreadsheet, but other situations call for a bit more control. Data validation lets you enforce cell input restrictions. You can also protect sheets – making them view-only – or hide sheets entirely within a collaborative workbook.
  
• Forms in Google Docs also offer a structured way of collecting information in a spreadsheet from others. Questions can be multiple choice or open-ended, and your surveys can include branching logic to display different questions to a respondent depending on how they respond to earlier questions.
  
• When a document, spreadsheet or presentation isn’t able to truly capture an idea, try a collaborative drawing. The same real-time co-editing found in those other formats is part of the drawing editor, too.
  
• Across documents, spreadsheets, presentations and drawings, revision history lets you see any edit made by any collaborator since the file was created, which comes in handy when you need to revert changes or view a previous version.
  
• Google Sites can really bring a collection of information together neatly – including embedded documents, spreadsheets and presentations – into a collaborative team, project or public website. Anyone with edit access can contribute and share, no programming skills required.
  
• In today’s world of distributed contributors, working across language barriers can be critical. With automatic document translation, site translation, and even a translation spreadsheet function all powered by Google Translate, being productive in multiple languages has never been easier.
  
• If you can’t measure it, you can’t manage it, so we added built-in analytics within Google Docs and Google Sites, which provides content owners with aggregate stats and metrics about who’s accessing their files and sites.
  
• Beyond collaborative documents, spreadsheets, presentations and drawings, you can upload and share any type of file with Google Docs, including pictures, videos, and special file formats like CAD drawings. Simply upload to Google Docs and decide who should have access. You can even set permissions to a mailing list, which automatically adjusts access as individuals are added to and removed from the group.
  
• Shared collections is a great way to efficiently manage sharing access across a group of files. Instead of sharing file-by-file, you can share a whole folder of information all at once.
  
• And if you’re looking to bring more efficient collaboration to Microsoft Word, Excel and PowerPoint without upgrading to Office 2010, give Google Cloud Connect for Microsoft Office a try.

Productive Anywhere
Mobile access to email, contacts and calendar information is pretty common now, but access to documents, spreadsheets, presentations and team sites across all major smartphone platforms is unique to Google Apps.

• Unlike software and files that live on one specific computer, you can access and work with information in Google Docs and Google Sites from any computer without hassles like software licenses and VPN connections.
  
• Beyond simple mobile document viewing, you can edit documents and spreadsheets from Android and iOS devices. This can be a faster way to make a simple change than firing up your laptop.
  
• The Google Docs mobile app for Android allows you to browse, search, open and share your Google Docs files from your phone or tablet. This app even lets you convert mobile phone pictures into editable documents.
  
• Google Sites are also optimized for smaller screens through automatic mobile rendering. When you’re viewing a site on a small screen, we can automatically display a version of the site that’s easier to use on your phone or tablet.

Simple & Affordable
Google Docs and Sites bring together the best of two worlds: the power of the web and the richness of traditional software applications, all at a dramatically lower cost than buying, installing and managing client software.

• Google documents and spreadsheets have quietly rolled out many basic word processing and spreadsheet capabilities that people use on a daily basis. If it’s been a while since your last encounter with Google Docs, try out headers and footers, pagination, customizable charts, range sorting, data filtering, conditional formatting, in-cell dropdown and validation, a solver tool and pivot tables, just to name a few.
  
• Magic autofill completes spreadsheet lists based on a theme, not just a simple autofill pattern. For example, if you start with Brazil, France, and Tanzania, magic autofill will suggests names of other countries. Hold the Control key while autofilling (Option key on a Mac) to trigger magic autofill.
  
• Spreadsheets can also help you automatically pull statistics, facts and figures from the internet with the GoogleLookup function. For example, =GoogleLookup("Paraguay"; "internet users") returns the latest statistic, along with a source citation.
  
• In documents, you can tap the web for dictionary definitions. Definitions for new words are available in real-time, unlike static dictionaries in traditional software.
  
• Google Docs also supports browser drag and drop actions that you may have learned in traditional desktop software. You can drag pictures from your desktop to embed images in documents, and drag files from your computer to upload files into Google Docs. Many types of files can be converted in high fidelity so you can continue editing as a team, and optical character recognition (OCR) turns images of text and PDFs into editable files as well.
  
• Templates are also a fast way to get started on a new project. Google Docs offers thousands of document, spreadsheet and presentation templates, and Google Sites also includes many starter site templates to help team projects get going.
  
• Getting familiar with our keyboard shortcuts can really speed up simple tasks. Next time, try out our keyboard shortcuts for documents, spreadsheets, presentations and sites.

Pure & Proven Cloud
As with Gmail, the collaboration tools in Google Apps for Business are backed by a service uptime guarantee and transparent system performance information. And compared to sharing information using old tools like thumb drives, Google Apps can help businesses keep their data a whole lot safer, too.

• Our 99.9% uptime SLA guarantees reliable access to Google Apps, and our commitment doesn’t have any exceptions for planned maintenance. This is because our systems are designed to handle updates without interrupting service for customers.
  
• Our publicly available status dashboard offers transparency about the health of our systems, and 24x7 phone and online support is there when you need it.
  
• Google goes to extensive lengths to protect the customer information in our data centers, including extensive personnel background checks, security-focused processes, advanced technology, and around-the-clock physical protection.
  
• Google Docs and Sites have completed a SAS 70 Type II audit, and have achieved the U.S. Federal goverment’s FISMA certification.
  
• With default https connections, your information is encrypted as it travels from your web browser to our servers. This helps protect your data by making it unreadable to others sharing your network.
  
• Google Apps accounts can be further secured with 2-step verification, which requires users to sign in with something they know (their password) and something they have (their mobile phone). With verification codes available via SMS, even basic mobile phones can serve as powerful authentication devices.

As with Gmail and Google Calendar, Google Docs and Sites have been on a fast innovation path (85 improvements last year alone!) that you just can’t get from typical software upgrades every three to five years. So if you missed any of these new features over the years, give them a go – you’re bound to find a few that’ll help you work more efficiently. And if you’d like to hear more about many of these updates, join us for a free webinar next Thursday.

A look back as we move ahead: Google Docs and Google Sites
Thursday, August 4th, 2011
9:00 a.m. PDT / 12:00 p.m. EDT
Register here

Now you can go to Manage Site under More Actions and choose Color and Fonts in the left-hand navigation to choose fonts for the entire site in one go. The web fonts feature lets you select different sections of the site such as the entire page or just the title to selectively choose your styling. Additionally, we've given you control over font sizes for many of these sections.

Take a look at a site that uses multiple web fonts:

We’re looking forward to seeing the sites you create with these beautiful new fonts.

Posted by Robert Dionne, Software Engineer

• The open source import/export project on Google Code that lets you export entire sites as static HTML, maintaining the structure and page hierarchy.
• SharePoint Move for Google Apps, a product developed by LTech for migrating data and content from Microsoft SharePoint to Google Sites.

As a Google Apps Authorized Reseller and enterprise deployment partner, most of Cloud Sherpas' work focuses on helping clients migrate legacy enterprise messaging environments – Lotus Notes, Microsoft Exchange, Novell GroupWise, and others – to Google Apps. These migrations can take a long time depending upon the number of users, amount of data to be migrated and complexity of the legacy systems.

When Neal Miller, a Partner at TechCFO, came to one of our Google Apps demos, he had a more pressing problem to address: how to help the firm's partners located across the country more easily share their expertise as CFOs to benefit all of their clients. This problem was concerning to them since the company's prime asset is the partners' financial knowledge – unlocking its potential would pay dividends to TechCFO. TechCFO's solution at the time was to upload documents to the public folders in their hosted Exchange server – but it was really difficult to search for information. The partners needed something that was simpler to search, simpler to access and provided better performance. Google Sites provided us with the tool to address their needs. Additionally, we developed the Google Sites Bulk File Uploader to help manage the migration of 100's of documents into a unique nested Google Site format.

Google Sites has proven to be a tool that TechCFO can use for multiple purposes. Since the firm needs to share information and collaborate on financial strategy and planning with its clients, we also created Sites they could easily use with people outside their firewall. Each client Site provides a secure "workspace" that is only shared with that client since they may post financial models or legal documents to it. We also built TechCFO a company intranet to share HR information, announcements of new team members and other company news.

Working with TechCFO opened my eyes to another way that companies interested in Google Apps can get started – through Google's collaboration apps. Using Google Sites, TechCFO saved thousands of dollars over other collaboration options – and the firm will save even more when it moves over other applications such as Gmail and Google Calendar. Google Apps has opened up a mountain of possibilities – though sometimes you need the help of a Sherpa to get you to the top.

Michael Cohn, CEO of Cloud Sherpas

Cloud Sherpas (www.CloudSherpas.com) is a cloud computing systems integrator and application developer. As a leading Google Enterprise partner, Cloud Sherpas helps organizations leverage Google Apps and Google App Engine to dramatically reduce IT expenses. The company delivers deployment, change management, support and development services to commercial, enterprise and educational institutions seeking to adopt cloud computing. Cloud Sherpas is a Google Apps Authorized Reseller and enterprise deployment partner. The company also supports cloud computing solutions from EMC/Decho, TriCipher and other best-in-breed vendors.