Tuesday, January 26, 2016

Tech Tip of The Week- January 26



Tech Tip of the Week!

Because of the licensing agreement that Agora has with Microsoft, you are now eligible to participate in Microsoft's Software Assurance Home Use Program (HUP). This program enables you to get a licensed copy of most Microsoft Office desktop PC applications to install and use on your personal home computer for a one-time, low cost of $9.95.  This offer is compatible with both Windows (versions 10, 8, 8.1 & 7) and Mac OS X version 10.10 (Yosemite) or later.  Because this offer is for your personal computer, you cannot submit the $9.95 as an expense.

Under the Home Use Program, as a user of the qualifying applications (i.e., Microsoft Office) for your job, you may acquire a licensed copy of the corresponding Home Use Program software (e.g. Microsoft Office) to install and use on a personal computer. You may continue using HUP software while you are under our employment.

To access the Microsoft Home Use Program Web site: 

1.       Go to http://hup.microsoft.com/
2.        Select the country to which you want your order to be shipped to and choose the language for viewing the order Web site.
3.       Enter your corporate e-mail address (@agora.org) and insert the following program code: 4A1F32D182
a.       Note: This program code is assigned to our organization for our sole use in accessing this site. You may not share this number with anyone outside our organization.
4.       Place your order online, and it will be shipped to the location you have chosen. Please note that a fulfillment fee will be charged to cover packaging, shipping, and handling costs.

Tuesday, January 19, 2016

Tech Tip of the Week - January 19


Tech Tip of the Week!

Over the past few weeks, several staff members have requested directions on freezing single and multiple Rows and Columns of data while working in Agora’s provided Spreadsheet Tools.  

1.       When working in Microsoft Excel, do the following:
o    On the View tab, click the arrow below Freeze Panes and then one of the following:
      • To lock row one only, click Freeze Top Row.
      • To lock column one only, click Freeze First Column.
      • To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll, click Freeze Panes.  Please note, you can lock more than one row and column at the same time by selecting the block below and to the right of the area that you wish to freeze. 
      • You will notice gray lines appear to show what area will be frozen.
  1. When working in Google Sheets: do the following:
    • In the menu bar, click view, then Freeze and do one of the following:
      • To lock column one only, click 1 Column.
      • To lock column one and two, click 2 Columns.
      • To lock row one only, click 1 row.
      • To lock row one and two, click 2 rows.
      • To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll, click Freeze Up to Current Row AND then Freeze Up to Current Column. 
      • As mentioned with the Excel directions above, you can lock more than one row and column at the same time by selecting the block below and to the right of the area you wish to freeze. 
      • You will notice gray lines appear to show what area will be frozen. 

Should you have any questions or need any help doing this, feel free to reach out to Rick Tkach or the Staff Helpdesk

Tuesday, January 12, 2016

Tech Tip of the Week - January 12



Tech Tip of the Week!

Here at Agora, we work with several students and families that speak English as a second language.  In many cases, students do not speak any English in their homes because their parents/learning coaches aren’t bilingual.  So, how effective are we in communicating with our learning coaches and students? 

To help us be more effective communicators with our non-English speaking families, consider using the Translate tool that is built into Google Docs.  We can translate permission slips, homework, newsletters, onboarding papers, and all general communications.  

To translate any document, simply type your material into a new Google Doc, then, go to ‘Tools’ and click ‘Translate document…’.  A new box will pop up and will give you several language options to choose from.  When you pick your language, click on the blue translate button, and a new translated document will appear in a new tab.   



To translate an email, you can type your message in Google Docs, translate it to the language that you need, then copy-n-paste into your email response; OR if you are in Gmail and receive an email in a foreign language, you can use the “Translate message” to see the sender’s message in English, then repeat the above process to reply.  

While the translated text may not be 100% accurate, it should translate it enough to communicate your overall message.    

Don’t forget to bookmark the Ed Tech Site for additional Tips and Resources! 
All Google Training recordings through January 8 have been posted on the bottom left of the site!