Blog


Want to Explore Internet History or Look for a Dead Website? The Wayback Machine may be Your Answer.

posted Feb 28, 2017, 6:24 AM by Tech Training

“What goes on the internet stays on the internet.” Well, that’s not always the case. There are plenty of old websites no longer available or have changed so significantly that you may not even recognize them. That’s where the Wayback Machine comes in hand. This tool, designed by the nonprofit Internet Archive, gives you a chance to relive the past or rediscover a long-lost website. 

Looking for a Dead Website? The Wayback Machine may be Your Answer.

Internet Archive Red and Black Wayback Machine Logo


The Wayback Machine currently has 279 billion webpages that have been saved over time. Now, some of them may not be that old—but the differences between a website in 2010 compared to 2017 can be staggering. There are even gems going back as far as 1996, like a 1998 Amazon homepage I found touting Beanie Babies. (Note: My Beanie Baby investments never did return a profit.

Here’s how to get started:

1. Open an internet browser and visit the Wayback Machine

2. You have two options from the homepage: Simply enter an email address or just select the scrolling notable examples underneath the search field.

Wayback Machine Home page with search field and timeline of notable sites scrolling beneath

3. If you choose to look for a specific site, you will be directed to a page where you can select the year to search. There’s also a calendar below displaying the days in which the Internet Archive saved the site. Start by clicking your desired date.

Timeline at top of screen with black bar charts indicating the amount of Internet Archive saves. Calendar beneath.

Here, for example, is CCIS.edu from March 1st, 2001:


4. You may also search through the site’s history by using the navigational timeline at the top of the screen. Just select a period on the timeline or flip through the Archive’s saves by using the date selector 

That’s all there is to it! Just note that there may be some issues loading certain media, or it may take significant time for a site to appear. What do you expect? You’re going back in time! Enjoy!

Tuesday Tech Tip: Dissect Your Writing with Expresso

posted Feb 14, 2017, 9:40 AM by Tech Training   [ updated Feb 28, 2017, 5:24 AM ]

Chances are that you’re required to do some writing here at CC, but it can be hard to find the time for in-depth editing. Why not let a program designed by a computational neuroscientist give you a hand? Expresso, a browser-based program, provides you with metrics and points out potential weaknesses in your writing.  
Please note that there have been reports that this app has had some issues inside of Internet Explorer. Try using Google Chrome or Firefox if you experience any issues.

Dissect Your Writing with ExpressoTable with metrics for editing.

Metrics for Editing
When visiting Expresso-app.org, you are prompted to paste text into the webpage for analysis. Upon entering text and pressing the Analyze Text button, Expresso provides you with metrics for editing. These metrics include: synonyms, weak verbs, filler words, nominalizations… and the list goes on. Look at this analysis of a recent Tuesday Tech Tip blog post. Yikes!

Develop an Eye for Awkward Phrasing
One of my biggest weaknesses in writing is passive voice. Expresso can help point out passive voice or alert you to awkward phrasing in your writing. 

Readability Grade
Another interesting aspect of Expresso is that it grades the readability of your writing. My last blog post, for example, corresponds roughly to an American 6th Grade Level. I like to keep things simple!

Remember: There’s No “Magic Bullet”
As the site mentions “writing metrics employed by Expresso can be powerful but they are not a ‘magic bullet’. They highly correlate with good writing but are not the cause of it, just like umbrellas correlate with rain but, of course, don’t trigger it. Therefore, there is no benefit in optimizing the metrics blindly.” Writing is an art, not a science, but the tips Expresso may help you communicate clearer.  

Flowcharts, Diagrams, Timelines? Get Started with MS Visio!

posted Feb 7, 2017, 7:13 AM by Tech Training

Still using browser-based flowchart tools or drawing applications to create diagrams? If so, you need to switch to Microsoft Visio. The information you want to present is important, and Visio will help you keep it consistent and understandable. Here’s how to get started:

Flowcharts, Diagrams, Timelines? Get Started with Visio!
Visio Icon

Popular Templates
Need to create an organization chart, describe a workflow, or present information about a database? Don’t start from scratch, let Visio do the leg work. After opening Microsoft Visio from your start menu, you will be prompted with potential templates you may want to use. Here are just a few options: 

Organization Chart, Computer Icons connected by lines Active Directory Chart, various office icons connected to each other Timeline of Events, no data Workflow Chart, icons of research, manufacture, data, and sales

Shapes
Don’t spend your valuable time creating shapes. Visio includes pre-made shapes and icons to best represent what you are presenting. 

List of premade icons to represent different workplace tasks


Connector Tool
Use the Connector tool to quickly show relationships between the subjects of your presentation.

Icons of workplace function connected by arrows


Themes & Variants
Use themes and variants to quickly coordinate colors and designs to make your diagram even more professional.

The MS Themes toolbar with color swatches


Collaboration and the Ink Tools
Collaborating with others? Use the Ink and Comment tools to let them know what you think!

Workplace function represented by icons, annotated with red pen and includes a comment bubble.


What are you doing still listening to me? Go give Visio a try!

Already Forgot Your New Year's Resolution? Use These Apps to Stay on Track!

posted Jan 24, 2017, 12:16 PM by Tech Training

Have you already forgotten about your New Year’s Resolution? Stay true to your health, wealth, or productivity with the following free apps. 

C25K Logo

Fitness:
Couch to 5K
If you’ve wanted to try running but never known where to start, Couch to 5K should be the next app you download. The free eight-week program gives users three workouts per week that get you ready for your local Turkey Trot or Fourth of July road race. (Free; iOS and Android)
View the original review from Greatist



Intuit Mint Logo on Black Background

Wealth:
Mint
With over 15 million users, Mint.com is a simple personal financial program that’s web-based. It’s free to signup and only takes a few seconds to add new accounts. Every time you visit their site, your financial data gets updated automatically. It presents this information in a slick easy-to-use web interface, with pretty graphs and all. Use this app to start fulfill your financial goals for 2017! (Free; iOS and Android)
View the original review from InvestorJunkie




MyFitnessApp Logo, silhouette of woman and Underarmor logo.

Food and Nutrition:
MyFitnessPall
MyFitnessPal is the most popular health and fitness app in the world, and it’s easy to see why. The app’s database of more than 6 million foods makes it easy to track your diet, no matter what you eat. Whether you’re trying to lose weight or put on muscle, the app helps determine the best things to eat to meet your goals. (Free with optional in-app purchases; iOS and Android
View the original review from Greatist




Stop, Breathe, and Think Logo, Cross-legged woman meditating.

Mindfulness:
Stop, Breathe, & Think
If you're trying to do more mindful meditation, you may need some help starting out. This app reminds you to meditate during the day and gives you easy suggestions for your first few times. The killer feature is the app asking you to check yourself before you start. It asks you how you're feeling mentally, physically and emotionally before you begin.  It then offers a few meditations customized for your current state of mind. (Free with optional in-app purchases; iOS and Android)
View the original review from LifeHacker


Looking for Something Different?
Got a goal we didn’t cover? Take a look at the top ten habit tracking apps from Daily Tekk

Tech Tip Tuesday: Provide Context to Spreadsheets by Using Range Names

posted Jan 10, 2017, 7:35 AM by Tech Training   [ updated Jan 10, 2017, 7:51 AM ]

If you refer to the same data in an Excel sheet every day, sure, you may know just where to find the information you need. In a large workbook, however, you may lose track of exactly where you placed some crucial data. Start naming cell ranges to easily refer to information you need. 

Stop remembering random letters and numbers: Provide context to spreadsheets by using Range Names

To begin naming cell ranges, follow the steps below:

1. Select the range of cells you would like to name. Remember: a cell range is a block of one or more cells. In this example, I want to be able to quickly refer to my 2017 Feed Expenditure information no matter where I am within the Excel workbook.

Selection of Cell Range under Feed Expenditure, Winter through Fall.

2. Next, click on the Formulas tab in the Excel ribbon. 

3. With the desired range still selected, click the Define Name in the Defined Names portion of the Formulas tab.

Excel Ribbon with Formulas Tab Selected, Define Name Option Highlighted

4. When giving a range a name, you cannot use spaces or any special characters except an underscore. Also, be sure to double check your cell ranges. Press OK to continue. 

New Name window with field for entering name and which cells it will reference

5. A shortcut method for performing this action is to select the desired cell range, place your cursor in the Name Box, and simply type a name. 

Excel Ribbon with Name Box highlighted

6. Now, you can reference theses ranges in formulas and functions across the workbook rather than typing a traditional cell range. 

Highlighted cell with =sum formula that references the Feed Expenditure named range

7. Lastly, if you need to rename any of your ranges, just click the Formula tab again and select Name Manager. 

Name Manager button highlighted in Excel ribbon

Tech Tip Tuesday: #NULL!, #REF!, #DIV/0 – What does it all mean?!

posted Jan 3, 2017, 7:00 AM by Tech Training   [ updated Jan 3, 2017, 7:09 AM ]

Trying to figure out just what Excel is telling you when an error occurs in your spreadsheet? Here are some of the most common Excel errors and how to fix them.

Remember: Excel will display a small green triangle in the upper left corner of the cells containing error values. Clicking on that green triangle will prompt a yellow diamond to appear with options for correcting the error. 

#VALUE Excel Error Message


#VALUE!
#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." There are a number of reasons this might occur, but it’s always good to check if you included spaces, characters, or text in a formula where Excel was expecting a number. 

#####
When you see this error, don’t worry. All it means is that the column isn’t wide enough to display the information you’ve included.

#DIV/0!
Just like in regular ol’ math, you don’t divide by zero. When this message appears, make sure you’re not accidentally dividing by zero or—which is more likely the case—referencing a blank cell. 
 
#REF!
The #REF! error shows when a formula refers to a cell that’s not valid. This happens most often when cells that were referenced by formulas get deleted, or pasted over.

#NULL!
Getting a #NULL! error all depends on your spacing in a formula. For example, maybe you forgot to include a mathematical operator such as the plus sign ( + ) and included a space instead, like =B2 B4+B6; Or maybe you forgot the colon ( : ) for selecting a range and accidentally wrote =SUM(A1 A10). Double check your formulas and functions for extra spaces!

#NUM!
Excel shows this error when a formula or function contains numeric values that aren’t valid. This often happens when you’ve entered a numeric value using a data type or a number format that’s not supported in the argument section of the formula. For example, you can’t enter a value like $1,000 in currency format, because dollar signs are used as absolute reference indicators and commas as argument separators in formulas. To avoid the #NUM! error, enter values as unformatted numbers, like 1000, instead.

Photo courtesy of Where Marketers Go to Grow.

Tech Tip Tuesday: Six Holiday Gifts Under $60

posted Dec 20, 2016, 6:55 AM by Tech Training

Looking to get something for the techie in your life without breaking your budget? Here are some of this season’s notable items:


Amazon Echo Dot - $39.99

Amazon Echo Dot
Amazon’s way of entering your household with Alexa. Tap into cloud services, activate connected home devices, play music, or ask questions like “What’s the score of the Cardinals game?” Alexa’s there to help.

 





Photo Courtesy of BGR.com


Nintendo NES Classic - $59.99

Nintendo NES Classic



This tiny, retro console comes preloaded 30 great games from the NES era. Relive games like Super Mario Brothers, Megaman 2, and Punch Out. The only problem? With so much hype, finding this hot-ticket item on any shelf will be a challenge.






Photo Courtesy of Nintendo.


Tile Mate - $24.98

Tile Mate



Always misplacing your stuff? Less than 5 millimeters wide, this tracking device syncs with your phone to map the last location of your lost valuable, chirps and sings when you’re looking for said item, and gives you directions to it.

Forgot where you put your phone? You can also use Tile to locate your synced mobile device. 


Photo Courtesy of SlashGear.com.



Google Chromecast - $25.00


Google Chromecast




Yes, Smart TVs are here. But the functionality of a set top box device is way better. Whether you’re looking to cut the cable cord or you just want a way to stream your favorite entertainment, Chromecast turns your mobile device into a powerful television remote for some of the best TV shows you can find.







Photo courtesy of Google.

Samsung Gear VR (2015) - $59.99

Samsung Gear VR



Although not the latest virtual reality headset, you can experience new worlds for almost half the price of the VR 2016. Lightweight and cordless, this headset has ushered in the world of VR gaming. The only downside? It only works with some recent Samsung phones






Photo Courtesy of Samsung.


D-Link Day & Night Wi-Fi Camera - $39.99

D-Link Day and Night Camera



Need to do some surveillance around your home? Great for parenting or recording wildlife from your house, this small wireless camera transmits video (and audio) to its D-Link App. What does that mean for you? You can view the video stream from your computer, phone, or any device with web interfacing.  With quick set up and features like infrared vision and motion alerts, this cheap gadget provides security on a budget.




Photo Courtesy of D-Link.

Tech Tip Tuesday: Using Google Docs Offline

posted Dec 6, 2016, 8:19 AM by Tech Training

Picture of laptop at the beach

Although it has become increasingly easier to find WiFi or stay connected to a mobile network, there may be a time when you need to work on a Google Doc, Sheet, Slide, or Drawing and don’t have access to the internet. Let’s say you have a long flight during the holiday season. You board the plane and realize there's no WiFi. There goes an opportunity to get some work done. To avoid this, follow the directions below and get ready to go off the grid!

Just remember to keep sensitive files off of Google Drive and on a Columbia College backed location, such as your personal I:Drive, department drive, etc.

Here’s what you need to do before your trip:

For a Windows Laptop:

    1.Open Google Chrome. 

    2.Make sure you are signed into your Google Account.

    3.Go to drive.google.com/drive/settings.

    4.Look for the “Offline Sync” and click “Turn On”.

Google Drive Settings Window

For an iPad:

    1.Open Google Docs.

    2.If you are using an iPad to work on Docs offline, click the Settings icon at the top left of the screen.

    3.Press the Offline Icon.

Docs Setting Panel for iPad

Other Tips before Going off the Grid:

Before you leave for your trip, make sure you’re signed into Google on Chrome. Another tip to avoid any hiccups is having the documents opened on Chrome before you leave. If you plan on using a mobile device to access your work, check that you have all necessary apps downloaded. 

Safe Travels!

Photo courtesy of PC Magazine.


Tech Tip Tuesday: Printing Excel Spreadsheets

posted Nov 29, 2016, 9:29 AM by Tech Training   [ updated Nov 29, 2016, 9:53 AM ]

Having trouble printing an Excel spreadsheet to one page? Is your printer cutting off valuable information? Luckily, there’s a quick solution. What it comes down to is setting your Page Size and Print Scale:

Setting Page Size

    1. Select Page Layout in the Excel ribbon.
Page Layout Button
    2. Select the Size button.
Page Size Button
    3. Next, choose your desired page size. For this scenario, I’m choosing a Standard Letter Size.
Letter Size Option

Setting Print Scale:

    1. Staying on the Page Layout ribbon, click the Scale to Fit Launcher.
Scale to Fit Launcher
    2. Choose your scaling option from this section of the Page Setup Dialogue window. To make the spreadsheet fit to one page, click Fit To and then press Okay.
Fit To Option

Your Excel spreadsheet should now fit to one page. If you choose, you may also fit the spreadsheet to more pages by simply increasing the amount in the Fit To field.


Photos courtesy of www.CustomGuide.com


Tech Tip Tuesday: 5 Underutilized Keyboard Shortcuts

posted Nov 22, 2016, 8:59 AM by Tech Training   [ updated Nov 22, 2016, 9:22 AM ]

Time is precious. If you’re not using the following Windows keyboard shortcuts, you should definitely start.
Keyboard

 

Tech Tip Tuesday: 5 Underutilized Keyboard Shortcuts

*Note: "WIN" refers to the  The Windows "WIN" Key key and “+” means to press the designated key simultaneously with the following key.

1. CNTRL+L - Find the Address Bar

Once you’re ready to go to a new website, simply press CNTRL+L to automatically return to the address bar rather than using your mouse.

2. WIN+D – Minimize & Open All Windows

Working with sensitive information? Instead of going through each window and selecting the minimize button, pressing WIN+D will quickly hide every program open on your desktop. Ready to view them again? Just press WIN+D a second time.

3. CNTRL+F – Go to Find Bar

With access to a number of different web-browsers, it can become easy to forget where the Find Bar is located. The Find Bar is used to look up specific text within a webpage. Just press CNTRL+F and begin searching.

4. WIN+L – Lock your Computer

Need to get up from your desk quickly while making sure your computer isn’t vulnerable? Press WIN+L and your account will be locked until you’re ready to log on.

5. CNTRL+1-9

If you’re like me, you keep a number of tabs open on your web-browser while surfing the Internet. By pressing CNTRL and any number 1 through 9, the browser will rapidly switch between tabs, making it easier to get the information you need as quickly as possible.

Photo courtesy of www.itjive.com.

1-10 of 90