AGR-TEAC61-09 · Lesson 3 · 36 clock hours · lab
Portfolio Compilation, Data Documentation, and Digital Presentation
Objective. Students will assemble a complete capstone portfolio using a structured digital format, create a data display of simulated student-progress data using spreadsheet software, and produce a slide deck summarizing their project for the oral defense.
⚠ 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 the Capstone Portfolio Matters
Your capstone portfolio is the professional record of everything you have learned and practiced in this program. It demonstrates to future employers, licensing reviewers, and school administrators that you can plan instruction, support student behavior, keep accurate records, and reflect on your own growth. The State Paraprofessional Certificate process and school district hiring committees regularly ask for documented evidence of skills—this portfolio gives you exactly that. Treat every document in it as a professional artifact, not just a class assignment.
Organizing Your Folder Structure
A clear, labeled folder structure allows anyone reviewing your portfolio to find documents quickly. Use the program's digital portfolio checklist as your guide. Your main folder should be titled with your last name, first name, and the program year (for example: Smith_Jane_2025_Capstone). Inside, create clearly named subfolders or sections:
- Proposal – your original capstone project proposal
- Co-Planning Forms – all four completed co-planning forms, numbered in order
- Activity Reflections – four reflections, one for each implemented activity
- Safety Scenario Responses – your written responses to the safety scenarios assigned earlier in the course
- Behavior Support Record – the completed behavior support documentation form
- Professional Self-Assessment – your two-page written self-assessment
After organizing all files, generate or type a table of contents listing each document, its location in the folder, and the date it was completed. Export the table of contents as a PDF or print a hard copy. Your instructor will verify completeness in a brief one-on-one conference. All documents must be present before you may proceed to the oral defense.
Accuracy and confidentiality note: Even though your capstone uses fictional student data, practice the same habits you will use on the job. Never include real student names, identifying information, or photos in any professional document without proper authorization. This habit protects real students and keeps you compliant with federal student-privacy law.
Working with Student-Progress Data
Data literacy is a core paraprofessional skill and is tested in the mathematics section of the ParaPro Assessment. In this lab you will work with a spreadsheet template pre-loaded with six weeks of simulated formative-assessment scores for four fictional students.
Calculating percent correct: For each student in each week, divide the number of correct responses by the total number of items and multiply by 100. For example, if a student answered 17 out of 20 items correctly, the calculation is (17 ÷ 20) × 100 = 85%.
Class average formula: Use a built-in spreadsheet function (such as =AVERAGE()) to calculate the class average percent correct for each week across all four students. Do not calculate averages by hand when a formula is available—hand calculations introduce rounding errors.
Creating a line graph: Select your completed percent-correct data for all four students across all six weeks. Insert a line graph. Label the horizontal axis "Week" and the vertical axis "Percent Correct (%)". Give the graph a clear title such as "Student Progress Over Six Weeks." Include a legend identifying each student by a fictional label (Student A, Student B, etc.). Make sure gridlines are visible so trends are easy to read.
Writing an interpretation paragraph: After building the graph, write three to five sentences explaining what the data show. Address these points: Which students are showing growth? Which are flat or declining? What does this suggest for your next instructional steps? This paragraph mirrors the kind of analysis you will do every day as a paraprofessional when you share progress data with the supervising teacher.
Building an Accessible Slide Deck
Your seven-to-ten slide presentation must communicate your project clearly to an audience that includes your instructor, peers, and possibly an outside reviewer. Follow these non-negotiable accessibility standards:
- Minimum 24-point font on all slides, including captions and footnotes
- Sufficient color contrast – dark text on a light background or light text on a dark background; avoid red-green combinations, which are difficult for color-blind viewers
- No more than six bullet points per slide – use visuals and your spoken words to carry additional detail
Your slides must cover these topics in order:
1. Project overview and student needs
2. Instructional strategies used and rationale
3. One highlighted activity with evidence of effectiveness
4. Behavior support strategy
5. Data display and interpretation (embed your line graph here)
6. Professional-growth goals
Before submitting to your instructor, trade decks with a classmate and complete the peer-review accessibility checklist together. A second set of eyes almost always catches a font that is too small or a color combination that is hard to read.
Safety and Professional Conduct During Lab
This is a digital lab, so physical hazards are minimal. However, observe these practices:
- Save your work to both a USB drive and cloud storage every 20–30 minutes to prevent data loss.
- Lock your screen whenever you step away from your workstation to protect any sensitive documents.
- If you print documents, retrieve them promptly from shared printers to maintain document security.
- Sit with proper posture and take a brief break every hour to prevent eye strain and repetitive-stress discomfort during extended computer work.
Connecting to Your Credentials
The spreadsheet and data-interpretation skills practiced here directly support the mathematics section of the ParaPro Assessment, which includes basic computation, data reading, and applying math in an instructional context. The portfolio organization process reflects the kind of professional documentation expected for the State Paraprofessional Certificate. Strong communication under the oral defense mirrors expectations set by school districts hiring certified paraprofessionals. Use the ParaPro Assessment Official Study Companion (ETS) to review any mathematics concepts you find uncertain before the defense date.
Key terms8
Capstone portfolioA structured collection of documents produced throughout the program that serves as professional evidence of the student's skills, planning, and reflection.
Table of contentsA document that lists each item in the portfolio, its location in the folder structure, and its completion date, allowing reviewers to locate materials quickly.
Percent correctA score expressed as a percentage, calculated by dividing the number of correct responses by the total number of items and multiplying by 100.
Class averageThe mean score for all students in a group for a given assessment period, calculated by summing individual scores and dividing by the number of students, or by using the AVERAGE function in a spreadsheet.
Line graphA chart that uses points connected by lines to show how one or more values change over time; used here to display each student's weekly progress.
Data interpretationThe process of examining assessment results to identify trends, draw conclusions, and recommend next instructional steps.
Accessibility standardsDesign requirements for presentations that ensure content can be read and understood by all viewers, including those with visual impairments; examples include minimum font size and adequate color contrast.
Oral defenseA formal presentation in which a student explains and justifies the contents of their capstone project to an instructor or review panel and responds to questions.
Worked examples4
1. Student B answered 14 out of 20 items correctly on the Week 1 formative assessment. What is Student B's percent correct for Week 1?
- Write the formula: Percent correct = (correct answers ÷ total items) × 100
- Substitute the values: (14 ÷ 20) × 100
- Divide first: 14 ÷ 20 = 0.70
- Multiply by 100: 0.70 × 100 = 70
Answer: Student B's percent correct for Week 1 is 70%.
2. Four students scored 70%, 85%, 60%, and 75% on the Week 3 assessment. What is the class average percent correct for Week 3?
- Write the formula: Class average = sum of all scores ÷ number of students
- Add the scores: 70 + 85 + 60 + 75 = 290
- Divide by the number of students: 290 ÷ 4 = 72.5
Answer: The class average percent correct for Week 3 is 72.5%.
3. Student A's weekly percent-correct scores over six weeks are: 60, 65, 70, 68, 75, 80. In a spreadsheet, these values are in cells B2 through B7. Write the formula to calculate Student A's six-week average, and then calculate it by hand to verify.
- Spreadsheet formula: =AVERAGE(B2:B7)
- To verify by hand, add all six scores: 60 + 65 + 70 + 68 + 75 + 80 = 418
- Divide by 6 (the number of weeks): 418 ÷ 6 = 69.67 (rounded to two decimal places)
Answer: The spreadsheet formula is =AVERAGE(B2:B7). Student A's six-week average percent correct is approximately 69.67%.
4. A student's rubric scores are: formula accuracy 4/5, graph readability 3/5, and interpretation paragraph 4/5. Did the student pass the spreadsheet rubric (pass = 12 out of 15)?
- Add the three scores: 4 + 3 + 4 = 11
- Compare to the pass threshold: 11 < 12
- Determine result: the student did not reach 12 out of 15
Answer: The student scored 11/15, which is below the 12/15 pass threshold (80%). The student must revise before the defense.
The math in this lesson2
Learners compute percent correct (14 of 20) per student and class averages for the data portfolio.
7.RP.3S-ID.2
In class: Using the program's digital portfolio checklist, students organize all capstone documents into a clearly labeled folder structure (proposal, four co-planning forms, four activity reflections, safety scenario responses, behavior support record, and a two-page professional self-assessment) and export or print a table of contents; the instructor verifies completeness against the checklist in a brief one-on-one conference. · Students receive a spreadsheet template pre-loaded with six weeks of simulated formative-assessment data for their four fictional students. They calculate each student's percent correct by week, enter a simple formula for the class average, create a line graph showing each student's progress over time, and write a three-to-five sentence interpretation paragraph explaining what the data suggest for next instructional steps—mirroring the data-literacy skills tested in the ParaPro Assessment mathematics section. · Students build a seven-to-ten slide presentation covering: project overview and student needs; instructional strategies used and rationale; one highlighted activity with evidence of effectiveness; behavior support strategy; data display and interpretation; and professional-growth goals. Slides must meet basic accessibility standards (minimum 24-point font, sufficient color contrast, no more than six bullet points per slide); a classmate peer-reviews using the accessibility checklist before instructor review.
Materials: Program digital portfolio checklist, laptop or desktop with word processor, spreadsheet software (e.g., Google Sheets or Microsoft Excel), presentation software (e.g., Google Slides or Microsoft PowerPoint), USB drive or cloud-storage access, printer, accessibility checklist (instructor-prepared), ParaPro Assessment Official Study Companion (ETS)
Check: Portfolio checklist conference: all required documents present = pass; any missing document must be submitted before the defense date. Spreadsheet and data display scored on a 15-point rubric: formula accuracy (5 pts), graph readability and correct labels (5 pts), interpretation paragraph accuracy (5 pts). Pass = 12/15 (80%). Slide deck reviewed on 10-point rubric: content coverage (4 pts), clarity and accuracy (3 pts), accessibility (3 pts). Pass = 8/10 (80%). Any section below 80% is revised before the defense.
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.