Return to Directory

Wednesday, April 27, 2016

Computer Group Session Tuesday May 3rd, 17th, 24th and 31st, at 10:00AM

Session Plan for Tues: May 31st
We will continue working on "Excel" files this week starting at 10:00AM.

Art's presentation plan last Tuesday should have made you familiar with various features of Excel and how to use them. He did an "Excellent Job" explaining the important things to know.

On May 17th we converted a (CSV) (Comma Separated Value) into an (XLS) file and started editing it. We will continue editing our newly created  "Computer Group List" and finalize it using our new skills.

We will also edit the the "Monthly Budget" file.
Both of the files and two excerps from Excel Tutorials will be included in this week's Email.





Session Plan for Tues: May 24th
We will continue working on an "Excel" files this week starting at 10:00AM.
Art has a plan to make you familiar with various features of Excel and how 
to use them.


The following may be covered as useful.Here is a topic list for next week for the Session.


Cell Data

General Text, Numbers, Currency and Dates

Formatting

Row Heights, Column Widths, Hide and Unhide

Formulas

Addition, Subtraction, Division, and Multiplication
We will spend time on "Copy and Paste".

You need to know that a copy of a formula copies the formula, not the data. We will show you how to copy a formula, and point out how it works. Modifying the formula with dollar signs to make use of constants is also important.
If we are able to make these points, understanding will be easier. 


The "Excel file" from last week may be updated and another "Budget.xls file will be featured for review and possible editing.




Session Plan for Tues: May 17th

We will start working on an "Excel" file this week starting at 10:00AM.
Many of you have never used this powerful software package and may
find it useful for you. 

The "Excel Manual" will be featured for review.




This Session will cover basics.



No Session Plan for Tues: May 10th

Region 12 School Budget Vote. 




Session Plan for Tues: May 3rd

We will continue working on "Pictures" this week starting at 10:00AM.
The useful parts of our "Managing Pictures Manual" will be featured 
as part of the Session on keeping your pictures under control.




Setting Up Folders

When you are organizing your pictures, you will first need to set up a hierarchy of folders similar to that of a file drawer system.  This is very easy in Windows 10.  First you need to open up your "My Pictures" folder.

 You can find this by double-clicking on the "Pictures" folder in Windows Explorer to show the folders under it (i.e., included in it).  These will usually be "My Pictures" and "Public Pictures". 

We will focus on "My Pictures".  This will show all the pictures and/or folders already in this folder.   You can add new folders in the "My Pictures" folder by right-clicking to open up a menu, putting the arrow over “New” in the menu, and left-clicking on “Folder” in the sub-menu that comes up.  A new folder will then appear on the screen with the title "New Folder" highlighted.  Just begin typing the desired title for this folder (no need to put the cursor in the box) and then push the "Enter" key on the keyboard to title this new folder appropriately. 

Continue adding as many folders as needed.  You can double-click on any folder to open it up and then add new folders in that folder, using the same technique.  This is the way to build up a hierarchy of folders.

A good example of folders you can use to organize pictures is shown below:

Holidays
Christmas
2011
2012
Etc.
Easter
Thanksgiving
Birthdays
Hobbies
Husband
Wife
Family
Husband
Wife
Grandchildren
Family #1
2011
2012
Etc.
Family #2
Vacations
Asia Cruise 2012
Celtic Tour 2013
Danube Cruise 2014
Eastern Europe Tour 2005
Hawaii Cruise 2010
Holland 2010
Gulf Cruise 2006
Natural Bridge Visit 2009


Moving or Copying Files

Once you set up a system of folders, you will need to move pictures already in your "My Pictures" folder or in other less useful folders (such as folders labeled only with a date) into folders appropriately titled.  There are several ways to do this, but the safest way is the "right-click" method. 

Find the picture you want to move and right-click on it.  This will bring up a menu that includes, among other things, "Cut" and "Copy".  If you left-click on "Cut", it will move the picture into the Clipboard (a temporary storage device in Windows).  If you left-click on "Copy", it copies the picture into the Clipboard, leaving a copy of the picture behind.  Choose the one that works best for you, but remember that always using "Copy" will clutter your folders. 

Then move the pointer over the folder you want to move the picture to.  Then right-click on that folder.  A menu will come up that includes "Paste", among other things.  Left-click on "Paste", and that will move the picture from the Clipboard into the folder.  You can move or copy a contiguous group of pictures all at the same time by first "selecting" them all before performing the move or copy as described above.  To "select" them, find the first picture in the contiguous group and left-click on it.  Then hold the "Shift" key down and push the "→" key as many times as needed to highlight all the pictures you want to move or copy.  You can go down several rows if needed. You will see the highlighting progress as you push the "→" key.  If you go too far, you can push the "←" key to move back.  Be sure to hold the "Shift" key down until you finish the "Selecting" process.  Then release the "Shift" key and proceed with the copy or move process, using the "right-click" method described above. 

If, at any time, you wish to un-select the pictures, just left-click on any blank space in the folder.  Continue doing this until all your pictures are properly located.  This will probably result in some folders that are no longer needed, since they are not usefully titled.  It is best to delete them to simplify your system of picture folders.  If they contain copies of pictures that are in appropriately titled folders, these picture copies can be deleted along with the unneeded folders.           

Examples:

Vacation Folders:

Asia Cruise 2012 – Bangkok

Celtic Tour 2013 – Scottish Lake Scene

Danube Cruise 2014 – Budapest

Eastern Europe Tour 2005 – Fence (Auschwitz)
 Galloping Horses

Hawaii Cruise 2010 – Honolulu Hotel

Holland 2010 – Alsmeer Flower Auction

Gulf Cruise 2006 – Cruise Ship

Natural Bridge Visit 2009 – Natural Bridge