Main

Without data you're just another person with an opinion.

William Edwards Deming

snow flake

Snow Flake - "close-up" on 1/16/2018

 by Del DeVries, on Flickr  Creative Commons License  

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License

Total Count: 585052 | Page Views: 167

Excel

  1. Keyboard Shortcuts Excel Keyboard Shortcuts For PC And MAC
  2. Repeat the last action key = F4 In edit mode, F4 is the toggle key for Absolute reference markers, i.e. $ before column and row
  3. Saving time - https://exceljet.net/blog/29-ways-to-save-time-with-excel-formulas
    1. Display all formulas in a spreadsheet: Ctrl G for Goto ... Special ... checkbox for formulas. Of course, Ctrl Tilde toggles the formula display view. This Special Goto shades the cells with formulas.
    2. Paste Special Values Ctrl -wait- V
    3. Tab to pick function name from autocomplete list
    4. skip the closing parenthesis ) ... just hit Enter

Blackboard grading tool

Online grading is possible in Blackboard with tools from New Box View. Annotation of the following file types is possible:

  • PDF, PPT, PPTX, DOC, and DOCX
  • Image Files: New Box View also supports only point-based annotations on these file formats: AI, BMP, DCM, EPS, GIF, PNG, PS, PSD, SVS, TGA, TIF, and TIFF
  • what about annotation of Excel files??
  • this is new in Jan 2018 ... details at New Box View

Preview of many different file types is possible (including Excel).

Adding notes: I'll assume that this link explains some new capabilities possible in the grading process

Useful tools in Windows

My question for today as a Google search of course: disk folder hierarchy capture to file

The answer is simple, but elegant. Goes back to the DOS based command tree and uses two command line switches in the Command Prompt box. Redirect the output to a text file and I have the answer to my question stored.

A few steps to accomplish this:

  1. Open Windows File Explorer.
    1. Keyboard Shortcut: [Windows Key] + [E]
  2. Navigate to the desired disk folder
  3. Open the Windows Command Prompt by typing "cmd" in the address bar
    1. the Command Prompt opens IN THE FOLDER that was current in Windows File Explorer. Note the drive/folder in the prompt.
    2. of course if that is NOT the correct folder, feel free to use DIR to display folders/files and CD to navigate to the correct folder
    3. skipping details of administrative rights if that is an issue for the folder
  4. Run the tree command by typing after the prompt: tree /a /f > Tree_Output.txt
    1. The result will be a new file, Tree_Output.txt, in the starting disk folder.
    2. The command line switches:
      1. /f Displays file names in each directory (Note: leave this switch off to include only the folder names in the hierarchy)
      2. /a Displays ASCII characters for the hierarchy linking lines (note: leave this switch off for graphic characters, however the resulting output file will not be pure text)
    3. what is the tree command? A tree structure is a hierarchical listing of folders in the path which are connected in branches to show linkage and structure within the tree. Excellent for graphical display of folder structure/hierachy.
  5. Done ... the solution to disk folder hierarchy capture to file
  • Alternative Solution to display all files in all folders without the tree structure graphically displayed.
    • Substitute dir /s > Tree_Output.txt
    • The command line switch: /s Displays files in specified directory and all subdirectories.
    • Sorted file list?? /o List by files in sorted order. adda sort switch as well: N By name (alphabetic) S By size (smallest first) E By extension (alphabetic) D By date/time (oldest first) G Group directories first - Prefix to reverse order

Old tools for File Lists and Directories

Alternatives to X1 for search

Capture files and folders from a folder in Windows File Explorer

NOT the hierarchy, or tree beneath it however

  1. Open Windows File Explorer.
    1. Keyboard Shortcut: [Windows Key] + [E]
  2. Navigate to the desired disk folder
  3. Select all files and folders within by Keyboard Shortcut: [Ctrl] + [A]
  4. For this selection: Copy as path by holding down the Shift key, right-click on the selection highlight area, and choose Copy as path
    1. The result is stored in the clipboard
  5. Paste the text result from the clipboard into Excel. Keyboard Shortcut: [Ctrl] + [V]
  6. Done ... the solution to (a question not asked!) capture file and folder names

New and Changed:

    Part of a backup solution for photos and a move in the direction of making photos available and usable. What are some things to consider?

    Dr. Diego Comin of Dartmouth University

    He has painstakingly studied the evolution of technology diffusion over the past two centuries in countries throughout the world, and has concluded that the differences between rich and poor nations can largely be explained by the speed at which they adopted industrial technologies. But, he says, what’s equally important is the intensity by which they put new technologies to work. This means that even when countries that were slow to adopt new technologies eventually catch up, it’s the intensity of how they use the technology — not simply the access — that can create great economic opportunity.

      ... more ...
    
    • Update to the Cybersecurity Canon for 2017. Huge increase in the number of nominees! Five "winners" added in 2017.
      1. How to Measure Anything in Cybersecurity Risk by Douglas W. Hubbard
      2. The Practice of Network Security Monitoring: Understanding Incident Detection and Response by Richard Bejtlich
      3. The Phoenix Project: A Novel about IT, DevOps, and Helping Your Business Win by Gene Kim
      4. Hacking Exposed 7: Network Security Secrets & Solutions, Seventh Edition by Stuart McClure
      5. Unmasking the Social Engineer: The Human Element of Security by Christopher Hadnagy
      6. Secrets and lies : digital security in a networked world by Bruce Schneier

    See the updated Cybersecurity Canon list on LibraryThing. At the end of 2017, the Cybersecurity Canon is made up of 19 award winners.


    Backlinks

    A ounce of action is worth a ton of theory.

    Friedrich Engels

    Page Views: 167 | << Scribbles - March 2018 | Trail Index | Scribbles - November 2017 >> | HomeLinks