🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Agriculture, Environment & Public Service › Teacher Aide / Paraprofessional › Universal Core: Safety, Math, Communication & Career for Paraprofessionals › Lesson 5
AGR-TEAC61-01 · Lesson 5 · 22 clock hours · demo

Digital Tools for Paraprofessionals

Objective. Students will use a learning management system, word-processing software, a spreadsheet application, and a professional email platform to create, format, and submit documents that meet school-district professional standards.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a licensed 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 Paraprofessionals

Modern schools run on digital infrastructure. As a paraprofessional, you will use a learning management system (LMS), word-processing software, spreadsheets, and professional email every day. Employers expect you to handle these tools confidently and safely. Mistakes — such as sending a file with a student's full name in the title — can violate student privacy law. Accuracy and professionalism in every document you create reflect directly on the school and on you.

Learning Management Systems

A learning management system (LMS) is the digital hub where teachers post assignments, share resources, and collect student work. Google Classroom is one of the most common LMS platforms in US K–12 schools; Canvas and Schoology are also widely used. As a paraprofessional, you will log in with your district-issued account, navigate to the correct class or course, locate assignments, download supporting files, and upload completed documents.

Key habits when using an LMS:

Word-Processing for Professional Documents

Districts require consistent, readable documents. A behavior-observation log is a written record of what a student did and said during a specific time period. It is a factual, objective account — not an opinion. You must write in complete sentences, use a standard font (commonly 12-point Times New Roman or Arial), and follow the heading format your district requires (date, student identifier, observer name, setting).

Critical safety and privacy rule: Never include a student's full name or any other personally identifiable information (PII) in a file name. Use a student ID number or a neutral label such as "Student A" in the file name itself. This protects students under the Family Educational Rights and Privacy Act (FERPA), the federal law governing student records.

When peer-reviewing a classmate's log, use the provided checklist to evaluate heading completeness, font consistency, objective language, and proper file naming. Offer specific, respectful feedback.

Spreadsheets for Tracking Student Data

Spreadsheets — whether Microsoft Excel or Google Sheets — allow you to organize and analyze student data quickly. In a reading-fluency tracking sheet, each row typically represents a student and each column represents a week or a data point.

Building a basic tracking spreadsheet:

1. Enter column headers in row 1: Student ID, Week 1, Week 2, Week 3, Week 4, Average.

2. Enter each fictional student's weekly scores in the appropriate cells.

3. In the Average column, enter a formula to calculate the mean of the four weekly scores.

4. Use conditional formatting to automatically highlight cells or rows that fall below the established benchmark score, making it easy to identify students who may need additional support.

Formulas start with an equals sign. The AVERAGE function adds a range of values and divides by the count automatically.

Conditional formatting applies a color or style to a cell when its value meets a rule you set — for example, turning the cell red when a score is below 60 words per minute. This is a visual flag, not a final judgment; data always require professional interpretation.

Professional Email Standards

Email in a school setting is a professional record. Every message you send from a district account may be reviewed by administrators. Follow these standards:

Data Privacy and Digital Safety

Every digital tool you use in a school is governed by district policy and federal law. The key rules are:

These are not optional courtesies — violations can result in disciplinary action or legal consequences for the school.

Connecting to Your Credentials

The ParaPro Assessment and many state paraprofessional certificates expect candidates to demonstrate basic technology literacy and knowledge of instructional support practices. The digital habits you build in this lesson directly support those credentials and make you a more effective member of the educational team.

Key terms8

Learning Management System (LMS)A digital platform (such as Google Classroom or Canvas) that schools use to post assignments, share resources, and collect student work.
Behavior-Observation LogA written, factual record of a student's behavior during a specific time and setting, used by paraprofessionals to support teachers and document student needs.
Personally Identifiable Information (PII)Any data that can be used to identify a specific student, such as full name, date of birth, or student ID number; protected under FERPA.
FERPAThe Family Educational Rights and Privacy Act, the federal law that protects the privacy of student education records and restricts who may access them.
AVERAGE FunctionA spreadsheet formula written as =AVERAGE(cell range) that adds all values in the specified range and divides by the number of values to produce the mean.
Conditional FormattingA spreadsheet feature that automatically applies a color or visual style to a cell when its value meets a rule you define, such as highlighting scores below a benchmark.
BenchmarkA predetermined performance standard used to evaluate whether a student's score or progress meets the expected level for their grade or instructional goal.
AnnotationA digital comment or note added to a document to provide feedback or highlight information without altering the original text.

Worked examples3

1. Five fictional students each have four weekly reading-fluency scores. Calculate the average score for Student 1, whose scores are: Week 1 = 58, Week 2 = 64, Week 3 = 70, Week 4 = 68.
  1. Step 1: Add all four weekly scores together: 58 + 64 + 70 + 68 = 260.
  2. Step 2: Count the number of weeks: 4.
  3. Step 3: Divide the total by the number of weeks: 260 ÷ 4 = 65.
  4. Step 4: In the spreadsheet, this calculation is entered as =AVERAGE(B2:E2) if the four scores are in cells B2 through E2; the result displayed will be 65.
Answer: Student 1's average reading-fluency score is 65 words per minute.
2. The class benchmark for reading fluency is 70 words per minute. Using the five students' averages below, identify which students should be flagged by conditional formatting. Averages: Student 1 = 65, Student 2 = 72, Student 3 = 68, Student 4 = 75, Student 5 = 60.
  1. Step 1: State the rule: flag any average that is less than 70.
  2. Step 2: Compare each average to 70. Student 1: 65 < 70 → flag. Student 2: 72 ≥ 70 → no flag. Student 3: 68 < 70 → flag. Student 4: 75 ≥ 70 → no flag. Student 5: 60 < 70 → flag.
  3. Step 3: In Google Sheets or Excel, set a conditional formatting rule on the Average column: 'Format cells where value is less than 70' and choose a highlight color such as red.
Answer: Students 1, 3, and 5 fall below the benchmark and will be highlighted by conditional formatting.
3. You need to email the completed fluency spreadsheet to your instructor. Write the key components of a professional email: subject line, greeting, one-sentence body, closing.
  1. Step 1 — Subject line: Be specific and include your name and the document title, for example: 'Reading Fluency Data Spreadsheet — Jane Doe — Para 101'.
  2. Step 2 — Greeting: Use the instructor's title and last name, for example: 'Dear Ms. Rivera,'.
  3. Step 3 — Body: State your purpose clearly in one or two sentences, for example: 'Please find attached the completed reading-fluency tracking spreadsheet for the class activity. The file uses fictional student IDs and includes conditional formatting for scores below the benchmark.'
  4. Step 4 — Closing: Sign off professionally, for example: 'Thank you, Jane Doe, Paraprofessional Certificate Student'.
  5. Step 5 — Attachment check: Confirm the correct file is attached before clicking Send.
Answer: A professional email includes a specific subject line, a formal greeting, a clear one-to-two sentence body stating the purpose, a professional closing with your name and role, and the correct file attached.

The math in this lesson1

Learners average four weekly fluency scores with =AVERAGE and verify the result by hand.
S-ID.2
Brush up in the math halls at newSchoolWorks.com:
In class: Navigate a learning management system (Google Classroom or the institution's LMS) to locate an assignment, download an attached student worksheet, annotate it with digital comments as a paraprofessional would, and re-upload the completed document — instructor demonstrates each step before students replicate it independently. · Use word-processing software to format a professional behavior-observation log entry (template provided) following district document standards: correct heading, consistent font, complete sentences, no personal student identifying information in the file name; peer-review a classmate's log using a provided checklist. · Build a simple class-data spreadsheet tracking five fictional students' weekly reading-fluency scores across four weeks, enter a formula to calculate each student's average, use conditional formatting to flag scores below a benchmark, and email the file as an attachment to the instructor with a professionally worded message.
Materials: Computers or tablets with internet access, Google Workspace or Microsoft 365 (word processor, spreadsheet, email, LMS), instructor-prepared behavior-observation log template, peer-review checklist, fictional student data set.
Check: All three digital tasks submitted and graded with a rubric; each task must score at least 80% (meeting all formatting and accuracy criteria) to pass — students who miss any element must correct and resubmit within one class session.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

Instructional Support / Professional Practices
1. When uploading a completed behavior-observation log to the LMS, which file-naming practice best protects student privacy?
Mathematics / Data Literacy
2. A paraprofessional wants to calculate the average of four weekly fluency scores (80, 74, 90, 76) for one student in a spreadsheet. Which formula is correct?
Mathematics / Data Literacy
3. What is the purpose of conditional formatting in a student data spreadsheet?
Professional Ethics / Legal Compliance
4. Which federal law primarily governs the privacy of student education records, including digital files maintained by paraprofessionals?
Instructional Support / Professional Practices
5. A paraprofessional finishes annotating a digital student worksheet and is about to re-upload it to the LMS. What should she verify first?
Communication / Professional Practices
6. Which component is essential in a professional email sent from a school district account?
Mathematics / Data Literacy
7. Student 3's weekly reading-fluency scores are 66, 70, 74, and 70. What is this student's four-week average?
Professional Ethics / Legal Compliance
8. A paraprofessional accidentally saves a file containing student reading scores to her personal cloud storage account instead of the district system. What is the correct immediate action?
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.