How To: Make flash cards using Microsoft Word and Excel

I’ve been trying to figure out how to do this for a while and now that I finally figured it I thought I’d document it 🙂 Hope someone finds this useful! Also a great way to print out cards for board games on both sides This may seem like a very tedious process but it’s nice when you are printing 100-200 cards. Also P.S. my printer messed up a couple of times and I had to re-print some of the words by deleting the messed up prints. Sorting/aligning words and definitions and printing again.

I got a bit of help from the links below
Sources:
Changing layout of word document: https://www.youtube.com/watch?v=NI0MG05OojQ
Using Mailing merge document: https://smallbusiness.chron.com/merge-excel-data-word-documents-54185.html
Center text vertically: https://www.howtogeek.com/240521/how-to-center-text-vertically-on-the-page-in-microsoft-word/

1) Preparing the excel spreadsheet

  • Open a new spreadsheet and on sheet 1 place two columns with headers “front” and “back”
  • Now fill in the corresponding information for front on column 1 and back on column 1

2) Preparing the word document

  • File> New blank document
  • Layout>Page Setup>bottom right corner
  • Margins Tab
    • Change margins to 0.5″
    • change to landscape
  • Paper Tab
    • width: 5″
    • height 3″
  • Layout Tab
    • Change Page Vertical alignment to Center
  • Click OK

3) Import/Auto-fill with Excel words

Mailings Tab> star mail merge > Step by step mail merge wizard
step 1 Select Document –>
Letters
step 2 Select Starting document –> use current document
step 3 Select recipients –> use and existing list and browse for excel sheet (with header in sheet one with one column)
step 4 Write your letter –> click on…more items and select column header and press insert
step 4b –> Now format the text size( ~100) and set align horizontally
step 5 Preview your letters –> Nothing really to change, click next
step 6 complete merge –> Click on “Edit Individual Letters” Merge records, select ALL
* Now fix any of the cards where the text is overflowing into the next card. Highlight and change text size to something smaller.

4) Print front of cards

  • Now you should be able to print these cards in the order they appear in the excel column
  • Note: Also there seems to be a error in the last card with it not being centered. Print a blank card at the end of the list.

5) Back Side

  • Repeat with Column 2 inserting “back” instead of “Front”
  • Generate another set of pages with the back text on all the cards. Font size should be about 30 depending on the index card size and amount of text.
  • Make a note of how your printer is printing relative to how you load the index cards into the paper feed
  • Load the cards in order of how you previously printed the words or the definitions won’t match up
  • Repeat this guide to create a set of cards with the definitions based on the excel sheet.

How to: Get Matlab to recognize visual studio c++ 2017 compilers

First of all, be sure to install c++ compilers 2017 from visual studio, they aren’t automatically selected during the install

If Visual Studio Compilers C++ 2017 aren’t detected you need to add an entry to the registry.

Edit Registry
Matlab Source
Edit Registry

As an admin, edit registry entry:

HKLM\SOFTWARE\WOW6432Node\Microsoft\VisualStudio\SxS\VS7

Add a new “string value” called “15.0” and add a path to the following folder containing visual studio

C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\

Start matlab and check that the compiler is found

mex -setup -v

How To: Fix a voicemail that goes directly to scam/ads/robocaller messages *86

I got a call form an unrecognized number, so I let it go to voicemail. I later tried to delete the message but the voicemail kept calling the scammer/robocall/ads phone number as opposed to accessing my voicemail. I kept getting a answering machine with a prompt to “connect with local singles”. As much as I am interested in connecting with local singles, I am more interested in deleting this message and access my voicemail.

Read more

Random: Useful Tasker Android Application Profiles and Tasks

Tasker is an awesome app for android devices… if you know how to use it… otherwise it’s a nightmare!! Here is a list of Tasker settings and profiles I find most useful.

Enable Auto-Rotate Display on Certain Apps

  • Create new profile, select application then choose your desired app.
  • Create a New task and tap the “+” icon. Select “Display” then set “Display Autorotate” to ON.

 

How To: Quickly Restart Spotify or any other App! (Mac Services and Shortcuts)

Every once in a while Spotify glitches out and it won’t play any song and I need to restart it which involved right clicking on the icon and force quitting/quitting. I figured there had to be an easier way. Lo and behold I found macOS services and shortcuts! Kinda tricky to use and a bit glitchy (see below as to why my shortcut wouldn’t work)

Read more

How To: Fix kernel panic-not syncing: VFS: unable to mount root fs on unknown block(0,0)

I ran into this issue while booting up my server. Luckily it was easy to fix after doing a bit of research 🙂

Problem: kernel panic-not syncing: VFS: unable to mount root fs on unknown block(0,0)

Solution: remove old linux kernels, your /boot drive is out of space

  • boot to grub and click on “Advanced options”
  • Select a previous kernel (should boot fine)
  • login and enter command
    • $ df
  • See if your /boot directory is 100% used
  • Remove old linux kernels
    • $ sudo apt-get autoremove

Sources: