Hi everyone, great class today! Here’s the promised recap of today’s topics:
- The “what to look for when purchasing a computer” lecture is available via the “Lectures” page above.
- We didn’t cover the entire “Software Concepts” lecture, but we did talk a little about the different classifications of software (Commercial, Shareware, Freeware and Open Source). We demoed Open Office which is a freely available alternative to Microsoft Office. There’s a more complete listing of Open Source tools in a blog posting below.
We also spent some time this afternoon exploring some of the freely available tools that Google provides. Everyone in the class already signed up for a free Google account as part of this exercise – anyone else can sign up for their own account at google.com. I would recommend that you use Mozilla Firefox as your web browser when interacting with Google’s online tools – they work MUCH better here than if you were to use Microsoft Internet Explorer.
Once you have an account you can sign into your Google E-mail at by clicking on the Gmail tab at the top of the screen on any of Google’s pages. From here you can also access your Google Documents via the “Documents” tab (if “Documents” doesn’t appar you can usually find it by clicking on the “More” button). We explored a few different ways in which you can use Google Documents:
- You an create a new text document (similiar to a Word document) by clicking on the “New” button and then selecting “Document”. You can also upload Word documents from your desktop into Google Documents by using the “Upload” button.
- Documents in Google have most of the features that you have come to expect from a standard word processing program, but with a collaborative twist thrown in for good measure. You can “Share” any documents with other Google Document users by clicking on the “Share” button and then on “Share with others.” A form will appear and you can type in the e-mail addresses of anyone in the world with whom you would like to collaborate. They will be sent a message and will be able to subsequently view and make changes to your document. You can access the revision history for a document via the “Tools” menu when a document is open – this log will show when the document was changed, who authorized the change and the content that was added or subtracted during that revision.
- You can also create presentations a la Power Point via the “New” button on the first page of the Google Documents site. Remember that you can always get back to the first page by clicking on the Google Documents logo at the top left side of the screen.
- You can “embed” a presentation into your blog by opening it up and selecting the “Publish” button at the top right side of the screen. Click “Publish Document” to make the presentation public, and then copy the HTML code in the text box using the “Edit” -> “Copy” command. Open up a post or page in your blog and switch to HTML mode (as opposed to “visual” mode). Then paste in the code and voila – instant web-based presentation!
- We also played around with the Spreadsheet tool which is available via the “New” button on the main page. Spreadsheets work a lot like Excel Worksheets and Google has implemented a pretty extensive formula system to support custom calculations. You can “Share” spreadsheets just like documents (see above) and collaborate with others, but the coolest feature of the spreadsheet by far is it’s ability to create a “form” that you can use to collect responses. Here’s a step by step guide on how to get started:
- Create a new spreadsheet in Google Documents
- Use the cells in row 1 to type out the questions (i.e. “First Name”, “Last Name”, “Phone Number”)
- Click on the “Forms” tab
- Click on “Create a Form”
- Fill in any instructions that you would like to send along with the form and then click on “Preview and Send”
- You can either type in the e-mail addresses of the people who you want to send the form to, or you can copy the “Embed” code and paste it into a blog posting or page.
And here are the answers to a few random questions thatn came up:
- You can save the contents of a Youtube video using the “downloader9″ tool. It’s available at http://www.downloader9.com/.
- The website that I touted as the “swiss army knife” of the Internet, Zamzar, is available at http://www.zamzar.com .