21st Century Teacher's Markbook

Google Sheets Add-on for collecting, organising, and analysing learners' scores safely and efficiently.

100% Safe & Secure No Personal Data Collected Completely Free

Installation & Setup Guide

System Requirements

  • Compatible Browsers: Google Chrome, Microsoft Edge.
  • Version: Ensure your browser is updated to the latest version.
  • Add-ons: Ensure extension/add-on usage is enabled in browser settings.
  • Network: A stable internet connection is required during installation.

Admin Configuration

  1. Log in to your environment (Google Sheets, LMS, or School Management System).
  2. Navigate to the Add-ons/Extensions section and confirm 21st Century Teacher's Markbook is enabled.
  3. Go to your Markbook Dashboard.
  4. for Mobile or Desktop users, + tab on the sheet can be used to add a new sheet to record for a particular learner.
  5. The Subjects you entered in the sheet 1(A7:A15) will be updated to Other sheets. .This reduces stress of entering subjects to individual sheets.
  6. Click the optional (reset ) button to reset your sheet if you have messed up your sheet .
  7. ClickRun Score Button to view results summary on sheet2 sheet3 and sheet4 .
  8. Click the "Next term" button to start a fresh for next term and your brought forward (B/F) for the learner will be updated. Please ensure that you export your data before clicking “Next term” .
  9. For Desktop users only, Click the menu bar at the right of your sheet to insert a new sheet and run your scores .

Step-by-Step Installation

1

Open a Google Sheet.

2

Go to Extensions > Add-ons > Get add-ons.

3

Search for "21st Century Teacher's Markbook".

4

Click Install and grant the necessary permissions.

Post-Installation Quick Tips

  • Manual Grading: Input grades directly into the designated data matrices.
  • Automated Dashboard: Check performance matrices, class averages, and diagnostic analytics instantly.
  • Troubleshooting: If the add-on fails to load, verify device storage limits and clear your browser cache.

Video Tutorials

Watch our step-by-step guides to master the deployment of your digital markbook system.

Markbook Training Tutorial - Part 1

Learn the foundational layout, setup, and initialization of classes within your Google Sheet.

Watch Video

Advanced Features & Analytics - Part 2

Deep dive into student score summaries, position tracking, and automated reporting systems.

Watch Video

Frequently Asked Questions

How do I add a new student to the Markbook?

Go to your Markbook Dashboard, select cell B2 on the active sheet, and input the student's name details.

How do I update a student's grade?

Simply change or enter the new data point into the score matrix. The system computations and overall grades will update dynamically . Then, click the analyse score button to view the results summary on sheet2 , sheet3 and sheet4.

Can I export student data to a CSV file?

Yes. Access the Markbook Dashboard interface, select the "3 dot on the right" choose share/export CSV formatting standard, and trigger the localized file download.

How do I view a student's performance report?

Navigate to the specific student profile sheets to view individual metrics, position ranks, and percentage curves. For system-wide diagnostics, view the initial dashboard sheet for macro-level subject metric analytics.

Technical Support & Issue Reporting

Encountered an anomaly? Submit this automated diagnostics log layout directly via email link extraction.

Developer Architecture Context

Ogunleye T.M. Profile Dashboard Reference

Ogunleye T.M.

Teacher, Mathematician, Task Automation Engineer, & Education Test/Measurement Specialist

The 21st Century Teacher's Markbook Workbook Architecture is custom-engineered to handle complex psychometric and educational tracking matrices without adding computational overhead for standard users.

Support Desk Channel

Email Correspondence: oandttech@gmail.com

Availability Framework: 24 / 7 Operations Matrix System Support