Basic shortcuts and Selecting tricks were covered
Management of Windows and Navigating tricks
Accessories that come with every Windows computer were opened and tried. Lorem ipsum website is here
Outlook Shortcuts – p. 3
Pages 1 through 4 in the packet were covered (Phase 1)
If you use Rubrics, you will love this: Rubistar
More basic shortcuts and Internet Shortcuts were covered
Distribution Lists were covered in Outlook
Outlook Tricks, and we made some Signatures in our Outlook.
Voting buttons were covered in Outlook Excel –filling in data quickly with Autofill, Then Custom Lists
Flag Follow-up and Recurring appointments
Paste Special was covered in Excel as well as Sums
Templates, ClipArt, Flickr
Getting a file out of x2 in csv format
Formulas and Functions
The Quick Access toolbar – we set these up for Word, and any other Office program. Quick Access Toolbar (p. 35)
Get templates off Office Online p.26 – 28
Excel shortcuts (p. 6 and 7 in packet)
Summing and formulas in Excel (p. 17–19)
Flag followup in Outlook (p. 10-13)
Recurring appointments (p. 13)
We looked on teacherspayteachers.com for materials to use. (p. 51)
We went over Outlook Rules to organize your inbox (and folder making in outlook)
We made some folders and organized our files. Here is a video on how to make a folder on the desktop or in the Explorer window. The second video is slower and more in depth. Don’t forget to use Shift-Click to highlight a whole bunch of things, or Ctrl-Click if the icons are not next to each other!
We made some folders in Outlook.
We quickly made a presentation, by harvesting files from another PowerPoint presentation.
We made a quick Flow Chart. We made a Hyperlink in PowerPoint.
We tried Refdesk.com
We checked out Thinkfinity.org and BetterLesson.org.
We pick out our Microsoft projects that we will work on. These should be complete for class 12. We started an Excel file for use with Labels (an address list.) We organized our bookmarks in IE9, or Firefox. Then we learned about Social Bookmarking and its advantages. We signed up for Delicious.com (optional). The other major site: Diigo –we just looked at. We discussed how far we have come since the first class. We talked about how much we had covered. We then watched this video about what the next wave of computers will probably look like: Ted video
We checked out: TeachParentsTech.org
Labels Here is a 15 page document with graphics on how to print the labels. I found it here. Here is the single sheet with text instruction.
We worked with Tables.
Check out the tutorials that are free on office.microsoft.com
We made Address labels with Mail Merge (in Word with Excel data file), and/or Access and Excel.
Here are the instructions for Word 2010. Here are the instructions from Microsoft for Word 2007 (They have never worked for me, past page one of the process. That is why I showed you how to do it in Access. Here are the instructions to get the To get Labels out of your addresses.
We will format a PowerPoint file and poked around Slide Masters. (Click the link at left, to get to a video about Slide Masters in 2007.
Backgrounds in PowerPoint–more information here.
Prezi and beginning Access are covered.
We checked out some sites from this main one with free clipart.
We reviewed labels. We played with Wordle.net!! It’s lots of fun making word clouds.
Graphics are covered in different Office programs.
Here is where I found the help on graphics in PowerPoint.
Here is where I found the basic help on graphics in Word. And here where you will find the more extensive document produced by Smith College.
Here is the graphics training course from Microsoft.
Project Management Principles
Project Management Principles that Help that can be very helpful, listed in a Word document (you may want to download before you play the videos, so you have notes to follow). Or you can download the PowerPoint file: Welcome to Class 9. The videos are only 5 minutes each, in length.
Here is the first video to play Project Mgmt 1.
Here is the second video to play Project Mgmt 2.
Here is the third video to play Pert and Gantt_PM 3.
Here is the fourth video to play Making the Project plan in PowerPoint.
If you choose to use Excel to make your plan, you can use Drop-down lists to help you. The steps are below in pdf format, or you can watch one more video!
Example Project, the writing of a Training Manual– some Summary Tasks and SubTasks that you can play with.
Excel Data Validation on using “Data Validation” and drop-down lists in Excel. More help from Microsoft here.
Text Boxes in PowerPoint: Text boxes in PowerPointfrom PowerPoint Help.
Style Sheets The link to the free Microsoft course regarding Style Sheets is here.
Check out some advanced tutorial sites like:
I am the biggest fan of this guy - DataPig! And… Martin Green is also one of my favorite people. Both are amazing at providing free tutorials for Excel and Access users.
Table of Contents For a full description of Table of Contents, see the Microsoft site here. If you want the quick instructions: just click References, Table of Contents, and pick a style. Here is another website with help for TOC.
Finished projects reviewed!
For free Smartboard materials (presentations) click this website. For tips on using the Smartboard, try YouTube from home–they have many videos posted there.
A funny (but useful) thing that I discovered: Teach your parents technology If you use Rubrics, you will love this: Rubistar I also highly recommend Element K tutorial books, if you like to have a book with a step-by-step tutorial. I am the biggest fan of this guy – DataPig! And… Martin Green is also one of my favorite people. Both are amazing at providing free tutorials for Excel and Access users. For more Access practice(lots more) click the link, and follow the roadmap of training. Here is a copy of the PowerPoint for today’s class.
Intro to Macros
Excel Sorting and Filtering There is good help on sorting right inside Excel help. You don’t usually need more than the A-Z button but if you do: One of my favorite websites, I forgot to show in class! How could I forget Mr. Excel? Here he is at this link. There is some great information on Filtering here.
Project Management Principles that Help that can be very helpful, listed in a Word document (you may want to download before you play the videos, so you have notes to follow). Or you can download the PowerPoint file: Welcome to Class 9. The videos are only 5 minutes each, in length.
Here is the first video to play Project Mgmt 1.
Here is the second video to play Project Mgmt 2.
Here is the third video to play Pert and Gantt_PM 3.
Here is the fourth video to play Making the Project plan in PowerPoint.
If you choose to use Excel to make your plan, you can use Drop-down lists to help you. The steps are below in pdf format, or you can watch one more video!
Example Project, the writing of a Training Manual– some Summary Tasks and SubTasks that you can play with.
Excel Data Validation on using “Data Validation” and drop-down lists in Excel.
Text Boxes in PowerPoint: Text boxes in PowerPointfrom PowerPoint Help.
Style Sheets The link to the free Microsoft course regarding Style Sheets is here.
Table of Contents For a full description of Table of Contents, see the Microsoft site here. If you want the quick instructions: just click References, Table of Contents, and pick a style.
Labels Here is a 15 page document with graphics on how to print the labels. I found it here. Here is the single sheet with text instructions For the instructions on how to put your labels into Access from Excel: To get Labels out of your addresses
Here is the link to the How do I find my Cookies Folder? article. For more info on Cookies, see the CyberSafety Resource page that I keep for Billerica Schools. The Wall Street Journal article regarding tracking software is on the bottom of that page. For the malwarebytes.com site click on the name of it. I cleaned up the steps for HOW TO FIND MY COOKIES and The cookies folder in Vista, if you would like to print it to work on at home. It also had a definition of the Low folder.
For working with Publisher, I found a great resource of helpful tips and steps: Publisher help here
Here is where I found the help on graphics in PowerPoint.
Here is where I found the basic help on graphics in Word. And here where you will find the more extensive document produced by Smith College.
Here is the graphics training course from Microsoft.
Here is some help on Tables in Word. Here is some more help on tables from one of my favorite organizations: TechRepublic
We began the sixth class by discussing how far we have come since the first class. We talked about how much we had covered. We then watched this video about what the next wave of computers will probably look like: Ted video Then we started working on Productivity tools like an Excel file that you can use to plan a Field Trip or Vacation. Here is take a trip for Office blank of the Vacation File Here is the finished file: take a trip for Office We then learned how to organize our Bookmarks. The assignment was then to finish organizing bookmarks and to start a Delicious account at home, and have it upload the bookmarks. Everyone received these Youtube links to learn about Delicious at home: Creating a Delicious Account (When she says don’t upload your bookmarks, you can go ahead and upload because we already organized.) Adding Bookmarks to Delicious How to use Tags A review of the Basics of Delicious We also played with a terrific tool for Math teachers, or Elementary teachers who may want to make their own math worksheets, quizzes or tests. It is called Dynamic Paper and it is found here. We broke down the directions for getting the images of number lines or shapes. Using the Dynamic Paper tool.
We made some folders and organized our files. Here is a video on How to make folders” target=”_blank”>how to make a folder on the desktop or in the Explorer window. The second video is slower and more in depth. Don’t forget to use Shift-Click to highlight a whole bunch of things, or Ctrl-Click if the icons are not next to each other! We made some folders in Outlook. We quickly made a presentation, by harvesting files from another PowerPoint presentation. Next we used the ICDL site. Next we watched a movie About Slide Masters Then we experimented with slide masters Next we watched a movie About Outline Then we experimented with outlines We made a quick Flow Chart We tried the different navigation and pointer options We made a Hyperlink in PowerPoint We tried Refdesk.com
We tried making a Shortcut on the Desktop We watched a tutorial about Calendar use in Outlook We practiced with the Calendar and with Meetings, Events, and Appointments Signatures are a great time saver in Outlook–a movie about them. We made some Signatures in our Outlook. Folders in Outlook We played with AutoCorrect then the QuickParts Gallery(To quickly enter text that you usually use over and over.)
Flag Follow-up and Recurring appointments Paste Special was covered in Excel as well as Sums Templates, ClipArt, Flickr Getting a file out of x2 in csv format Excel formatting tricks Formulas Functions The Quick Access toolbar – we set these up for Word, and any other Office program.
More basic shortcuts and Internet Shortcuts were covered Distribution Lists were covered in Outlook Excel –filling in data quickly with Autofill, Then Custom Lists Mail Merge between Excel and Word was covered.
Basic shortcuts and Selecting tricks were covered Management of Windows and Navigating tricks Outlook Tricks, and Voting buttons were covered in Outlook Accessories that come with every Windows computer were opened and tried. Lorem ipsum website is here
What’s New 10 Cool Features to look for Most Innovations are online more soon…
