Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| القانون | الصيغة | قيمة 1 | قيمة 2 | قيمة 3 | الناتج | الوحدة |
|---|---|---|---|---|---|---|
| السرعة المتوسطة | v = d ÷ t | 150 | 30 | 5 | m/s | |
| التحويل من km/h إلى m/s | v(m/s) = v(km/h) ÷ 3.6 | 72 | 20 | m/s | ||
| العجلة | a = (v − u) ÷ t | 20 | 0 | 5 | 4 | m/s² |
| القوة (نيوتن الثاني) | F = m × a | 10 | 3 | 30 | N | |
| الوزن | W = m × g | 60 | 9.8 | 588 | N | |
| الكثافة | ρ = m ÷ V | 540 | 200 | 2.7 | g/cm³ | |
| الضغط | P = F ÷ A | 600 | 0.02 | 30000 | Pa | |
| ضغط السائل | P = ρ × g × h | 1000 | 9.8 | 2 | 19600 | Pa |
Example from the “حاسبات” tab (Arabic), with the numbers and formulas that are in the file.
What is inside
- قوانين الفيزياء: Physics laws: 18 rules, each with its name, formula, symbols with SI units, a solved example and a note, from average speed to frequency and period.
- أساسيات الكيمياء: Chemistry basics: states of matter and their changes, the parts of the atom and the rules for atomic number and mass number, a valency table of 20 ions with the criss-cross method, 12 common substances with their formulas, 8 balanced equations, and acids, bases and the pH scale.
- أساسيات الأحياء: Biology basics: 8 cell parts with their functions and whether they are in plant or animal cells, 8 body systems with their organs and functions, and the equations for photosynthesis and cellular respiration.
- بحث عن قاعدة: Rule lookup: choose a physics law, an ion or a body system from the list and its formula, details and example appear straight away.
- حاسبات: Calculators: 22 calculators for speed, acceleration, force, weight, density, pressure, work, power, energy, Ohm's law, waves, pH and number of moles. Each has a ready example. Change its numbers and the result appears with its unit.
- اختبار ذاتي: Self-test: 32 questions in physics, chemistry and biology, some numeric and some chosen from a list. A ✔ or ✘ appears with your score at the top. The answer key is in hidden columns.
- المتابعة: Review tracker: the topic, review date and your score. The sheet works out the next review date from the score and highlights topics that are due, with a chart of your scores.
- الملخص: Summary: the number of items in each section, your quiz result for each branch and your average tracker score, with three charts.
The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.
What makes it different
The sheet does more than state the law. Each rule has its symbols with units, a solved example with numbers and a calculator where you try your own. You learn how to substitute values and check the unit, which is where most exam mistakes happen. Alongside the reference there is a quiz that marks itself and a schedule that sets your review date from your score.
How to use it
- Open "قوانين الفيزياء" (Physics laws), "أساسيات الكيمياء" (Chemistry basics) and "أساسيات الأحياء" (Biology basics) to review each rule with its formula, symbols, units and solved example.
- In "بحث عن قاعدة" (Rule lookup) choose a law from the list, an ion in the valency table or a body system, and its details appear straight away.
- Try "حاسبات" (Calculators): each law has white cells for your numbers and a grey cell with the result and its unit, with a ready example whose numbers you can change.
- Test yourself in "اختبار ذاتي" (Self-test), 32 questions. Type your answer or pick it from the list, and a ✔ or ✘ appears with your score at the top of the sheet.
- Record in "المتابعة" (Review tracker) the topic you reviewed, the date and your score, and the sheet sets your next review date.
- Open "الملخص" (Summary) to see the number of rules in each section, your result in each branch and your tracker scores.
Before you start:
- This is a general summary and not an official syllabus for any particular grade, so check your school textbook. Symbols and formulas can be written slightly differently between books and schools.
- The examples take the acceleration due to gravity g as 9.8 m/s². Some books use 10 m/s² for simplicity, and the quiz states the value to use in the question itself.
- The solved examples use SI units unless stated otherwise: metre, kilogram, second, newton, joule, watt, pascal, volt and ohm.
- The pH values for everyday examples are approximate and vary with concentration and type.
- The calculators hold 22 laws, the quiz holds 32 questions and the review tracker holds 20 topics. The reference tables are fixed and read-only: 18 physics laws, 20 ions in the valency table, 12 common substances, 8 balanced equations, 8 cell parts and 8 body systems.
- In the quiz, a numeric answer is accepted within a small tolerance, and for text answers letter case in English does not matter. Write formulas with plain digits (H2O).
Free cheat sheet for this field
Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
Does this sheet match my grade's syllabus?
It is a general summary and not an official syllabus for any particular grade, so check your school textbook. The wording of a rule, its symbols or the value of g (9.8 or 10) can differ between books, so follow what your teacher asks for.
How do I use the calculators?
In "حاسبات" (Calculators) type your numbers in the white cells using consistent units (metre, kilogram, second). The grey cell shows the result with its unit. The ready example in each row shows what the input looks like, and every result has been checked by hand.
How do I enter my answer in the quiz?
Type numbers without a unit. Write chemical formulas with plain digits (H2O); letter case in English does not matter. For multiple-choice questions, pick from the drop-down list so your answer matches the key.
Are the pH values for everyday examples exact?
They are approximate and vary with concentration and the type of substance. They are there to show roughly where a substance sits on the scale. Calculating pH from the hydrogen-ion concentration is exact, using pH = -log10[H+].
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
All the templates in this group: Free study summaries: rules, formulas and self-tests
More free templates for: Study summaries
More free templates
- Periodic table in Excel (Arabic names): lookup, molar mass calculator and quiz
- Arabic grammar summary sheet: rules, i'rab and a self-test with examples
- English grammar rules sheet in Excel: tenses and structures with examples
- Algebra rules summary sheet: laws, identities and solving equations with examples
- Solid geometry formulas sheet: areas and volumes with examples and a calculator
- English vocabulary and expressions sheet in Excel: words by topic and spaced review
- Complete nursery management sheet
- Private school management sheet
- Complete clinic management sheet
- Medical lab management sheet
- Pharmacy management sheet: sales, purchases, shortages and suppliers
- Small hospital management sheet: departments, beds, admissions and revenue
- Metal and turning workshop job sheet in Excel: job orders, materials and labor
- Glass and aluminium workshop sheet in Excel: orders by square metre, cutting and waste





