Home » Uncategorized

Category Archives: Uncategorized

How do I stop Java from auto updating?

For desktops with Windows 7 operating systems, there are times when Java would keep popping-out, asking for an update and then failing to do so.

As suspected this problem was due to the Java control panel requiring Admin Privileges to disable the automatic update.

These instructions apply to Windows 7 (click on the pictures so that you can see the fine print more clearer):

1) In My Computer go to C:\Program Files (x86)\JAVA\jre7\bin\

Java 1

2) Right click the program javacpl.exe

3) Select “Run as Administrator

Java 2

4) Select “Yes” from the User Account Control dialog.  The Java Control Panel will open.

5) Select the Update Tab

6) UNcheck the “Check for Updates Automatically” check box

Java3

 

7) Select Apply, then click on OK.

8) Have a nice day!

 

Thanks for reading it! For further questions, please contact:

ITS Help Desk

(831) 647-6656

helpdesk@miis.edu

Casa Fuente 320

How do I add an image to the top right corner of a webpage?

Note: These instructions apply to the “Basic Content” content type on our Drupal content management system. This article also assumes that you’ve already uploaded your image(s) to the appropriate “Files (hidden)” webpages and optimized the photo to these dimensions: 238 x 180 pixles.

  1. Make sure you are logged on and in the editing interface for the content you wish to edit.
  2. Scroll down to the “Image” menu.
  3. Select the menu, and being typing in the name of your image (Ex. “peter_shaw_thumbnail”)
  4. Select the image.
  5. Optional: Please also set the “Image Alt Text” field, a short description of the image, including relevant keywords.
  6. “Save” your changes. The image will automatically be pulled into the top right corner of your webpage.

What to do if your data is an absolute mess… in Excel

Use the “Text to Columns” function! Let’s say this is your data:

Select the data you want to use…

 Select “Delimited” for the file type. Click “Next”
Select the proper delimiters for your data. For mine, I had Commas and Spaces. Click Next for more formatting options or click Finish.
Yay.The data looks wonderful. *Please note, your data might not be perfect after you are done and you might have to use the “Text to Columns” function several times.

For more information on Data Analysis tools, please visit The Commons Blog.

How to make calculations in Excel

  1. Average, Count, and Sum appear on the bottom of your window when you select 2 or more cells.
    *Note: On a PC, all three show up in a row; on a Mac, you can choose which one to see with the down arrow for the drop-down menu.
  2.  To get the sum of a set of numbers: in a cell type:
    =SUM(whatever cells or range of cells you need)
    and press Enter
  3. To get the mean or average of a set of numbers: in a cell type:
    =AVERAGE(whatever cells or range of cells you need)
    and press Enter
  4. To raise a number to a degree (such as square it, cube it, etc): in a cell type:
    =(the number or the cell you select)^(2)
    and press Enter
  5. To take a square root of a number: in a cell type:
    =SQRT(the number or the cell you select)
    and press Enter
  6. To find the standard deviation of a dataset: in a cell type:
    =STDEV(whatever cells or range of cells you need)
    and press Enter

*Another note: if you need to make calculations on different cells, you can select one at a time using Ctrl click (Command click on Macs).

 

For more information on Data Analysis tools, please visit The Commons Blog.

How to sort and/or filter your data in Excel

If your data is a mess, you can easily sort in is ascending and descending order. You can also Filter it to show you only certain values. These two functions work both with numbers and text.

For more information on Data Analysis tools, please visit The Commons Blog.

How to copy a pattern in Excel

If you want Excel to extend your data into other cells, you can show it a pattern, then click on the T in the right-hand corner of the box and drag it into however many cells you need.
For example:
                                        

 

 

For more information on Data Analysis tools, please visit The Commons Blog.

How do I add a Facebook Like button to a webpage or story page?

There are two steps involved in adding a Facebook Like button to a webpage or story page: first you must add the Facebook Element content type and then you must complete the Open Graph tags.

  1. Click on “Add” in the “Edit Console.”
  2. Select “Facebook Element” from the list of content types.
  3. Enter the URL of the webpage or story page you want to “Like.”
  4. Under “Type,” select “Like Button” from the drop down menu.
  5. Choose the “Layout,” “Button with count inside.”Facebook Element Like Button
  6. “Save.”

Now you will see the Facebook Like button appear on your webpage or story – but it’s only the first step. In order for Facebook to figure out what your webpage or story is all about, you’ll have to add Open Graph Tags. Luckily, adding these tags only takes about 5 minutes of your time.

  1. Here’s the tricky part. You’ll need to enter the Open Graph Tags in different areas depending on whether you’re editing a webpage or a story page. If you’re editing a webpage, click on “Settings” in your “Edit Console.” Scroll down and click on “Meta-tags.” Meta tags for webpages OR If you’re editing a story page, click “Edit” story at the bottom of the page before the share and comment area. Scroll down through the editing interface and click on the “Meta tags” menu.Meta tags for stories
  2. A new menu will open and you’ll see lots of options. The first thing you’ll want to do is ignore the “Meta Description” option, unless you’d like to take the time to set your webpage’s meta description for Google search.
  3. You only need to add the following tags: Open Graph Title, Open Graph Type, Open Graph URL, Open Graph Image, and Open Graph Description.
  4. The “Open Graph Title” is simply the title of your webpage or story.
  5. The “Open Graph Type” will always be “website.”
  6. The “Open Graph URL” will always be the URL of your webpage or story page.
  7. The “Open Graph image” is the URL of the photo in the right hand corner of your webpage or story page.
  8. The “Open Graph Description” is a short intro to the web content. If you’ve written a good opening paragraph to your webpage, or a good teaser to your story, simply copy and paste that to the Open Graph Description field.Facebook Open Graph tags
  9. “Save.”
Sites DOT MIISThe Middlebury Institute site network.