Excel Shortcuts: Boost Productivity with Keyboard Commands

Managing Rows and Columns

  1. Ctrl + +: Insert a new row or column.
  2. Ctrl + -: Delete the selected row or column.
  3. Ctrl + Space: Select the entire column.
  4. Shift + Space: Select the entire row.
  5. Ctrl + 9: Hide the selected row.
  6. Ctrl + 0: Hide the selected column.
  7. Ctrl + Shift + 9: Unhide hidden rows.
  8. Ctrl + Shift + 0: Unhide hidden columns.

Cell Formatting

  1. Ctrl + 1: Open the Format Cells dialog.
  2. Ctrl + B: Apply or remove bold formatting.
  3. Ctrl + I: Apply or remove italic formatting.
  4. Ctrl + U: Apply or remove underline.
Read More

Image Matching with SIFT and RANSAC: A Practical Example

Image Matching with SIFT and RANSAC

This document demonstrates image matching using SIFT (Scale-Invariant Feature Transform) and RANSAC (RANdom SAmple Consensus) algorithms. The code snippets below illustrate the process.

Import Libraries

import cv2
import os
import matplotlib.pyplot as plt
import numpy as np

Define Query Images

query_images = [
    'query//hw7_poster_1.jpg',
    'query/hw7_poster_2.jpg',
    'query/hw7_poster_3.jpg'
]

Function to Show Combined Images

def show_combined(image_1, image_2)
Read More

Computer and Internet Terminology

Definitions and Explanations

Hacker: A person with technical expertise who experiments with computer systems to determine how to develop additional features. Hackers are occasionally requested by system administrators to try and “break into” systems via a network to test security. The term hacker is sometimes incorrectly used interchangeably with cracker. A hacker is called a “white hat” and a cracker a “black hat.”

Help Desk Technician: Helps end-users with their computer problems in person, by e-

Read More

File Handling in C: Functions, Structures, and File Splitting

File Handling in C: A Practical Explanation

File Operations

Data type: FILE *

fopen: This function opens or creates a file physically.

fich = fopen("filename", "mode");

Opening modes: "r" (read), "w" (write), "a" (append), "+" (update)

  • fclose(tab);
  • character = getc(tab);
  • fgets(string, length or size, fich);
  • putc(character, cards);
  • fputs(string, cards);
  • EOF: End Of File
  • rewind(tab)

Structures and Records

Creating variables of type STRUCTURE OR RECORD:

struct reg_alumno alumno1;

Access fields using dot notation.

Read More

Python Fundamentals: Installation, Operators, Loops, and Data Types

Python Fundamentals

Installing Python

To install Python, download it from python.org, run the installer, and ensure you check “Add Python to PATH.” Verify the installation by typing python --version in the command prompt or terminal.

Getting Started with Python

To work with Python, choose an IDE or text editor (like IDLE, PyCharm, or Visual Studio Code), write your code in a .py file, and run it using the command python filename.py in the terminal. Basic concepts include variables, data types, control

Read More

Algorithms: Analysis, Design, and Optimization Techniques

Reduction

When encountering a new problem A, instead of creating a new algorithm, you may transform it into another problem B that already has a known solution (useful when A resembles B, allowing you to leverage an existing solver). Here’s how it works:

  1. Transform an instance of problem A into an instance of problem B.
  2. Transform the solution for B back into a solution for A.
  3. Prove correctness: If the solution for B is correct, the solution for A must also be correct.
  4. Compute total running time.

Asymptotic

Read More