Excel Shortcuts: Boost Productivity with Keyboard Commands
Managing Rows and Columns
- Ctrl + +: Insert a new row or column.
- Ctrl + -: Delete the selected row or column.
- Ctrl + Space: Select the entire column.
- Shift + Space: Select the entire row.
- Ctrl + 9: Hide the selected row.
- Ctrl + 0: Hide the selected column.
- Ctrl + Shift + 9: Unhide hidden rows.
- Ctrl + Shift + 0: Unhide hidden columns.
Cell Formatting
- Ctrl + 1: Open the Format Cells dialog.
- Ctrl + B: Apply or remove bold formatting.
- Ctrl + I: Apply or remove italic formatting.
- Ctrl + U: Apply or remove underline.
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 MoreFile 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 MorePython 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
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:
- Transform an instance of problem A into an instance of problem B.
- Transform the solution for B back into a solution for A.
- Prove correctness: If the solution for B is correct, the solution for A must also be correct.
- Compute total running time.