BUS-ENTR56-01 · Lesson 5 · 22 clock hours · lab
Digital Tools for Small-Business Owners
Objective. Students will create, format, save, and share a set of standard small-business documents using word processing, spreadsheet, presentation, and cloud-storage applications, demonstrating file organization and basic cybersecurity habits.
⚠ Pending professional review
This lesson, its worked examples and its practice questions has not yet been verified by a credentialed professional in the field or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.
VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.
Why Digital Tools Matter for Small-Business Owners
Running a small business today requires more than a good idea. Owners use digital tools every day to write professional documents, track money, pitch to investors, and store files safely. Mastering a core set of applications saves time, reduces errors, and signals professionalism to customers, lenders, and partners. This lesson covers the four categories you will practice in the skills circuit: word processing, spreadsheets, presentation software, and cloud storage — plus the cybersecurity habits that protect everything you create.
Word Processing: Writing Professional Documents
A word processor (such as Google Docs or Microsoft Word) lets you create, edit, and format text documents. For small-business owners, the most common documents include business letters, invoices, contracts, and policies.
Standard block-letter format is the professional standard for business correspondence. Every line begins at the left margin. The document includes, in order: your return address, the date, the recipient's address, a salutation, body paragraphs, a complimentary close, and your signature. Consistent fonts (typically 11–12 pt serif or sans-serif), one-inch margins, and single spacing within paragraphs are expected.
Always save a working copy with a clear file name (for example, `BusinessLetter_ClientName_2025-06.docx`) so you can find it later. Use Save As to keep original templates untouched.
Spreadsheets: Tracking Numbers
A spreadsheet (such as Google Sheets or Microsoft Excel) organizes data in rows and columns called cells. Each cell has an address — column letter plus row number (for example, B3).
Two formulas every small-business owner should know:
- SUM adds a range of cells: `=SUM(B2:B7)` adds all values from B2 through B7.
- AVERAGE calculates the mean of a range: `=AVERAGE(B2:B7)` divides the total by the count of values.
Charts turn numbers into visuals. A bar chart (also called a column chart) is ideal for comparing monthly sales figures because each bar represents one time period, making trends easy to see. Select your data range, insert a chart, and choose the bar/column chart type.
Label all columns clearly, include units (dollars, units sold), and save the file with a descriptive name.
Presentation Software: Pitching Your Business
A pitch deck is a short slide presentation that tells the story of your business. A standard five-slide deck for early-stage entrepreneurs includes:
1. Title slide — business name, your name, date
2. Problem statement — the specific pain point your customer faces
3. Solution — how your product or service solves that problem
4. Financial snapshot — key numbers such as startup cost, projected revenue, or break-even point
5. Call to action — what you are asking for (investment, partnership, a first sale)
Design principles: use a readable font size (24 pt or larger for body text), limit text to key points, and use images or simple charts to support your words. Avoid clutter. Your slides support your spoken words — they are not a script.
Cloud Storage: Organizing and Sharing Files Safely
Cloud storage (such as Google Drive or Microsoft OneDrive) keeps your files accessible from any device and allows controlled sharing with partners or clients.
File organization best practices:
- Create a top-level folder for your business.
- Use subfolders by category (Finance, Marketing, Legal, Operations).
- Name files consistently so anyone on your team can locate them.
Sharing permissions control who can view, comment on, or edit a file. Always use the most restrictive permission that still meets the need: share a read-only link for documents others only need to read; grant edit access only when collaboration is required. Never share a public link to documents that contain financial data, passwords, or personal customer information.
Cybersecurity: Protecting Your Business
Small businesses are frequent targets of cyberattacks because they often have less security than large companies. The following habits are essential — not optional.
Strong passwords combine uppercase and lowercase letters, numbers, and symbols and are at least 12 characters long. Never reuse a password across multiple accounts. A passphrase approach (stringing several unrelated words with numbers and symbols) is both strong and memorable.
Two-factor authentication (2FA) requires a second verification step — such as a code sent to your phone — after you enter your password. Even if a criminal steals your password, 2FA blocks access. Enable 2FA on every business account that supports it.
Phishing emails try to trick you into clicking a malicious link or revealing credentials. Red flags include:
- An urgent or threatening subject line
- A sender address that does not match the organization it claims to be from
- Links that display one URL but point to another (hover to check)
- Requests for passwords, banking details, or Social Security numbers
- Spelling or grammar errors in a message claiming to be from a major company
If you are unsure whether an email is legitimate, contact the sender through a known, trusted channel — do not reply to the suspicious email.
Acceptable-use policies (AUPs) are short written rules that tell employees how business devices and accounts may and may not be used. Even a one- or two-person business benefits from a written AUP because it sets clear expectations and provides documentation if a dispute arises.
For additional guidance, the CISA Small Business Cybersecurity Corner (cisa.gov) offers free, publicly available resources written specifically for small-business owners.
Saving Your Work and Backing Up
Save files frequently while working. Cloud storage provides automatic backup for files stored online, but also keep a local or external-drive copy of critical documents. Follow the 3-2-1 rule as a general best practice: three copies of important data, on two different media types, with one copy stored off-site (or in the cloud).
Key terms9
Block-letter formatA standard business letter style in which all lines — address, date, salutation, body, and closing — begin at the left margin with no indentation.
SUM formulaA spreadsheet function written as =SUM(range) that adds all numeric values in a specified range of cells.
AVERAGE formulaA spreadsheet function written as =AVERAGE(range) that calculates the arithmetic mean of all numeric values in a specified range.
Pitch deckA short slide presentation, typically five to ten slides, used to communicate a business concept, opportunity, and financial highlights to an audience such as investors or partners.
Sharing permissionsSettings in cloud-storage platforms that control whether another user can view, comment on, or edit a file or folder.
Two-factor authentication (2FA)A login security method that requires a second form of verification — such as a one-time code sent to a phone — in addition to a password.
PhishingA cyberattack in which a criminal sends a deceptive email or message designed to trick the recipient into revealing credentials, clicking a malicious link, or transferring money.
Acceptable-use policy (AUP)A written document that defines the rules for how employees may use a business's computers, internet connection, and digital accounts.
Cloud storageAn internet-based service that stores digital files on remote servers, making them accessible from any authorized device and providing off-site backup.
Worked examples4
1. A small business records monthly sales for six months: January $4,200 | February $3,800 | March $5,100 | April $4,750 | May $6,000 | June $5,500. Enter these values in cells B2 through B7. Write the correct SUM formula to find total sales for the six months.
- Click on cell B8 (the cell below the last data entry).
- Type the formula: =SUM(B2:B7) and press Enter.
- The formula adds all six values: 4200 + 3800 + 5100 + 4750 + 6000 + 5500.
Answer: =SUM(B2:B7) returns $29,350 as the six-month total.
2. Using the same monthly sales data from the previous example, write the AVERAGE formula to find the mean monthly sales, then calculate the result by hand to verify.
- Click on cell B9.
- Type the formula: =AVERAGE(B2:B7) and press Enter.
- To verify by hand: add the six values to get the total — 4200 + 3800 + 5100 + 4750 + 6000 + 5500 = 29,350.
- Divide the total by the count of values: 29,350 ÷ 6 = 4,891.67 (rounded to the nearest cent).
Answer: =AVERAGE(B2:B7) returns approximately $4,891.67 per month.
3. A business owner wants to know what percentage of total six-month sales came from the best single month (June, $5,500). How do you calculate this percentage?
- Identify the part (June sales): $5,500.
- Identify the whole (total six-month sales): $29,350.
- Apply the percentage formula: (Part ÷ Whole) × 100.
- Calculate: (5,500 ÷ 29,350) × 100 = 18.74% (rounded to two decimal places).
Answer: June represented approximately 18.74% of total six-month sales.
4. A startup owner is building a financial snapshot slide. Startup costs total $8,000. Projected monthly revenue is $2,500 and monthly expenses are $1,800. How many months until the business breaks even (recoups startup costs from net monthly profit)?
- Calculate net monthly profit: monthly revenue minus monthly expenses = $2,500 − $1,800 = $700.
- Divide total startup costs by net monthly profit to find break-even period: $8,000 ÷ $700 = 11.43 months.
- Round up to the nearest whole month because you need a full month's profit to cover the remaining balance: 12 months.
Answer: The business is projected to break even in approximately 12 months.
The math in this lesson1
Learners total six months of sales with a SUM formula and check the $29,350 result.
7.NS.3
In class: Complete a hands-on skills circuit covering four digital tools in sequence: (1) word processor — format and save a one-page business letter using standard block-letter format; (2) spreadsheet — enter data, apply SUM and AVERAGE formulas, and create a bar chart of monthly sales; (3) presentation software — build a five-slide pitch deck with a title slide, problem statement, solution, financial snapshot, and call to action; (4) cloud storage — organize the three documents into labeled folders, set sharing permissions, and share a folder link with the instructor. · Evaluate three free or low-cost small-business software tools (such as a point-of-sale system, a bookkeeping app, or a scheduling tool) using a provided comparison matrix that rates cost, features, ease of use, and data-security practices; present a two-minute verbal recommendation to a small group. · Practice basic cybersecurity hygiene: create a strong password using a provided framework, enable two-factor authentication on a training account, recognize phishing email red flags in five sample emails, and draft a one-paragraph acceptable-use policy for a hypothetical business with two employees.
Materials: Computers or tablets with internet access, Google Workspace or Microsoft 365 (word processor, spreadsheet, presentation, cloud storage), software comparison matrix worksheet, phishing sample emails (instructor-created), password-creation framework handout, cybersecurity awareness resource (e.g., CISA Small Business Cybersecurity Corner, publicly available)
Check: Instructor inspects all four completed digital documents against a formatting and functionality checklist (80% or higher required); software comparison matrix and cybersecurity exercises are evaluated pass/fail with all safety-critical cybersecurity items (phishing identification) requiring 100% accuracy.
Practice check8
Answer each question, then check it. Nothing is recorded; this is your own practice.
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.