Custom Spreadsheets

  • Home
  • Custom Spreadsheets

About this service

Smarter Spreadsheets works with a variety of school personnel from principals to teachers to administrative assistants to find ways to save time and energy. By working together, we can create projects that meet your diverse needs. Look at some examples from other clients or reach out to design something specific for your school.

Pricing for spreadsheet creation is $80/hr. Time per project varies based on scope and condition of data sets. Estimates for common projects are given. Estimates for custom projects are provided after a free consultation meeting.


Administrative Team Projects

Smarter Spreadsheets has helped admin teams with time-saving and user-friendly solutions to data management. Look through these examples to see if one meets your needs or contact us for a custom spreadsheet.

Student contact collection made easy

Student Information Systems are not always user-friendly and require multiple steps to gather a variety of pieces of information on separate screens. Spreadsheet functions can pull student data about schedules and contact information to reach out to teachers and parents easier. By typing in a student name, you can easily copy teacher/parent emails, Zoom links or anything else to expedite communications.

  • Customizable
  • Saves hours of looking up contact information over a school year
  • Estimated project time: 4-5 hours

Attendance/out of classroom checker

Setting up a form-based sign-out system can help you identify trends of students avoiding class or identify students for bathroom graffiti or vandalism. Attendance trends can also be identified using scheduled data downloads from your SIS to keep an eye on student absences/tardies.

  • Useful for problem-solving meetings
  • Creates logs for behavior issues that arise during out of classroom time
  • Estimated project time: 3-4 hours

Teacher Projects

Collecting data from students is a great first step. But how can teachers use data to better help their students and incorporate student choice? Spreadsheets can help. Look to see if these services might save you time or help your students. If not, contact us for a custom solution.

Grouping Data

Looking for a way to group students based on student choice or assessment data? Spreadsheet functions can save you time and make it easier to share those selections with others.

  • Increase student engagement by matching choice to activity
  • Easy-to-share document merges available
  • Estimated project time: 1-4 hours depending on the scope of the project

Assessment Data

Assessment data from other services or your own collection can be sorted, ranked, and organized in a variety of ways to better match instruction to student needs. You can also evaluate the effectiveness of interventions and track their implementation.

  • Enable teachers to meet students at their level
  • Useful for program review or interventions
  • Estimated project time: 1-5 hours depending on the scope of the project

Support Personnel Projects

Student data is collected by lots of different staff members. Many of those staff members have not had specific training in organizing data to make their jobs easier to improve communication. Smarter Spreadsheets can help your staff, regardless of their role. Look at some of these options or contact us to discuss how we might help.

Student Information Systems

Student Information Systems might collect data used for state mandated reporting, but it is not always organized in a way that makes it easy to collate and share. Spreadsheet functions can quickly group and count students based on flexible criteria for reporting purposes.

  • Quick data collection for health, fitness or assessment data for state reporting.
  • Easy to use and customizable
  • Estimated project time: 3-5 hours

Mail/document merges for personalized reports

Collecting data is useful, but sharing that data is often just as important. Using Google Sheet Extensions, information that has been organized can be shared in individualized reports via email or through PDF creation.

  • Great tool for parent communication
  • Useful to share teacher materials for testing or special schedules
  • Estimated project time: 2-4 hours depending on scope of the project