Worksheet

Last updated

A worksheet, in the word's original meaning, is a sheet of paper on which one performs work. They come in many forms, most commonly associated with children's school work assignments, tax forms, and accounting or other business environments. Software is increasingly taking over the paper-based worksheet.

Contents

It can be a printed page that a child completes with a writing instrument. No other materials are needed. In education, a worksheet may have questions for students and places to record answers.

In accounting, a worksheet is, or was, a sheet of ruled paper with rows and columns on which an accountant could record information or perform calculations. These are often called columnar pads, and typically green-tinted.

In office software, spreadsheet software presents, on a computer monitor, a user interface that resembles one or more paper accounting worksheets.

Education

In the classroom setting, worksheets usually refer to a loose sheet of paper with questions or exercises for students to complete and record answers. [1] They are used, to some degree, in most subjects, and have widespread use in the math curriculum where there are two major types. The first type of math worksheet contains a collection of similar math problems or exercises. These are intended to help a student become proficient in a particular mathematical skill that was taught to them in class. They are commonly given to students as homework. The second type of math worksheet is intended to introduce new topics, and are often completed in the classroom. They are made up of a progressive set of questions that leads to an understanding of the topic to be learned. [2]

Parents also need worksheets. [3] With evolving curricula, parents may not have the necessary education to guide their students through homework or provide additional support at home. Having a worksheet template easily accessible can help with furthering learning at home.

As an assessment tool, worksheets can be used by teachers to understand students’ previous knowledge and the process of learning; at the same time, they can be used to enable students to monitor the progress of their own learning. [4]

Accounting

In accounting, a worksheet often refers to a loose leaf piece of stationery from a columnar pad, as opposed to one that has been bound into a physical ledger book. From this, the term was extended to designate a single, two-dimensional array of data within a computerized spreadsheet program. Common types of worksheets used in business include financial statements such as profit and loss reports. Analysts, investors, and accountants track a company's financial statements, balance sheets, and other data on worksheets.

In spreadsheet programs like the open source LibreOffice Calc or Microsoft's Excel, a single document is known as a 'workbook' and may have by default three arrays or 'worksheets'. One advantage of such programs is that they can contain formulae so that if one cell value is changed, the entire document is automatically updated, based on those formulae.

Taxes

Many tax forms require complex calculations and table references to calculate a key value, or may require supplemental information that is only relevant in some cases. Rather than incorporating the calculations into the main form, they are often offloaded on a separate worksheet. The worksheet may be incorporated into the filing package, or may only be a tool for the filer to figure out the value, but without requiring the worksheet to be filed.

As an example, in the United States, income tax is withheld from the payments made by employers to employees. If taxes are significantly underwithheld, there is a penalty to the employee at the end of the year, and if they are overwitheld, the employee gets a refund for the overpayment of taxes. There is a basic formula for estimating the taxes that need to be paid, but various tax factors may cause it to be wrong, such as dependents, tax deductions, or income from other sources.

The W-4 form allows the employee to pick an exemption level to reduce the tax factoring (to avoid overpayment), or specify an extra amount above the standard number (to avoid underpayment). The form comes with two worksheets, one to calculate exemptions, and another to calculate the effects of other income (second job, spouse's job). The bottom number in each worksheet is used to fill out two if the lines in the main W4 form. The main form is filed with the employer, and the worksheets are discarded or held by the employee.

Related Research Articles

<span class="mw-page-title-main">Microsoft Excel</span> Spreadsheet editor, part of Microsoft 365

Microsoft Excel is a spreadsheet editor developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft 365 and Microsoft Office suites of software and has been developed since 1985.

<span class="mw-page-title-main">Spreadsheet</span> Computer application for organization, analysis, and storage of data in tabular form

A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. The term spreadsheet may also refer to one such electronic document.

<span class="mw-page-title-main">Lotus Improv</span> Spreadsheet program

Lotus Improv is a discontinued spreadsheet program from Lotus Development released in 1991 for the NeXTSTEP platform and then for Windows 3.1 in 1993. Development was put on hiatus in 1994 after slow sales on the Windows platform, and officially ended in April 1996 after Lotus was purchased by IBM.

<span class="mw-page-title-main">Graphing calculator</span> Electronic calculator capable of plotting graphs

A graphing calculator is a handheld computer that is capable of plotting graphs, solving simultaneous equations, and performing other tasks with variables. Most popular graphing calculators are programmable calculators, allowing the user to create customized programs, typically for scientific, engineering or education applications. They have large screens that display several lines of text and calculations.

<span class="mw-page-title-main">Payroll</span> Record of money paid or due to employees

A payroll is a list of employees of a company who are entitled to receive compensation as well as other work benefits, as well as the amounts that each should obtain. Along with the amounts that each employee should receive for time worked or tasks performed, payroll can also refer to a company's records of payments that were previously made to employees, including salaries and wages, bonuses, and withheld taxes, or the company's department that deals with compensation. A company may handle all aspects of the payroll process in-house or can outsource aspects to a payroll processing company.

TK Solver is a mathematical modeling and problem solving software system based on a declarative, rule-based language, commercialized by Universal Technical Systems, Inc.

A Simplified Employee Pension Individual Retirement Arrangement is a variation of the Individual Retirement Account used in the United States. SEP IRAs are adopted by business owners to provide retirement benefits for themselves and their employees. There are no significant administration costs for a self-employed person with no employees. If the self-employed person does have employees, all employees must receive the same benefits under a SEP plan. Since SEP-IRAs are a type of IRA, funds can be invested the same way as most other IRAs.

<span class="mw-page-title-main">Mathcad</span> Computer system for mathematical calculation

Mathcad is computer software for the verification, validation, documentation and re-use of mathematical calculations in engineering and science, notably mechanical, chemical, electrical, and civil engineering. Released in 1986 on DOS, it introduced live editing (WYSIWYG) of typeset mathematical notation in an interactive notebook, combined with automatic computations. It was originally developed by Mathsoft, and since 2006 has been a product of Parametric Technology Corporation.

Working Tax Credit (WTC) is a state benefit in the United Kingdom made to people who work and receive a low income. It was introduced in April 2003 and is a means-tested benefit. Despite the name, tax credits are not to be confused with tax credits linked to a person's tax bill, because they are used to top-up low wages. Unlike most other benefits, it is paid by HM Revenue and Customs (HMRC).

<span class="mw-page-title-main">Form W-4</span> US Employees Withholding Allowance Certificate IRS form

Form W-4 is an Internal Revenue Service (IRS) tax form completed by an employee in the United States to indicate his or her tax situation to the employer. The W-4 form tells the employer the correct amount of federal tax to withhold from an employee's paycheck.

<span class="mw-page-title-main">Origin (data analysis software)</span> Scientific data analysis software

Origin is a proprietary computer program for interactive scientific graphing and data analysis. It is produced by OriginLab Corporation, and runs on Microsoft Windows. It has inspired several platform-independent open-source clones and alternatives like LabPlot and SciDAVis.

Expense management refers to the systems deployed by a business to process, pay, and audit employee-initiated expenses. These costs include, but are not limited to, expenses incurred for travel and entertainment. Expense management includes the policies and procedures that govern such spending, as well as the technologies and services utilized to process and analyze the data associated with it.

<span class="mw-page-title-main">Numbers (spreadsheet)</span> Spreadsheet application by Apple Inc.

Numbers is a spreadsheet application developed by Apple Inc. as part of the iWork productivity suite alongside Keynote and Pages. Numbers is available for iOS and macOS High Sierra or newer. Numbers 1.0 on Mac OS X was announced on August 7, 2007, making it the newest application in the iWork suite. The iPad version was released on January 27, 2010. The app was later updated to support iPhone and iPod Touch.

<span class="mw-page-title-main">Software calculator</span> Calculator as a computer program

A software calculator is a calculator that has been implemented as a computer program, rather than as a physical hardware device.

<span class="mw-page-title-main">Formula calculator</span> Software calculator that can evaluate expressions

A formula calculator is a software calculator that can perform a calculation in two steps:

  1. Enter the calculation by typing it in from the keyboard.
  2. Press a single button or key to see the final result.

A model audit is the colloquial term for the tasks performed when conducting due diligence on a financial model, in order to eliminate spreadsheet error. Model audits are sometimes referred to as model reviews, primarily to avoid confusion with financial audit. A study in 1998 concluded that even MBA students with over 250 hours of spreadsheet development experience had a 24% chance of introducing spreadsheet error.

Construction cost estimating software is computer software designed for contractors to estimate construction costs for a specific project. A cost estimator will typically use estimating software to estimate their bid price for a project, which will ultimately become part of a resulting construction contract. Some architects, engineers, construction managers, and others may also use cost estimating software to prepare cost estimates for purposes other than bidding such as budgeting and insurance claims.

In the tax law of the United Kingdom, tax credit overpayment occurs when a claimant has received more Working Tax Credit (WTC) or Child Tax Credit (CTC) than HMRC’s final end of year calculations awards them. This can be caused by official or claimant error or neglect, or simply because the provisional payments were based on out of date information. This article is solely about overpayment, not about details of the tax system as a whole.

The Office Open XML file formats are a set of file formats that can be used to represent electronic office documents. There are formats for word processing documents, spreadsheets and presentations as well as specific formats for material such as mathematical formulas, graphics, bibliographies etc.

The functional database model is used to support analytics applications such as financial planning and performance management. The functional database model, or the functional model for short, is different from but complementary to the relational model. The functional model is also distinct from other similarly named concepts, including the DAPLEX functional database model and functional language databases.

References

  1. "Worksheet". Cambridge Dictionaries online. Cambridge University Press. Retrieved 25 September 2014.
  2. Fauvel, John; Maanen, Jan; van Maanen, J.A. (2000). History in Mathematics Education: An ICMI Study. Springer Science & Business Media. p. 216. ISBN   9780792363996 . Retrieved 25 September 2014.
  3. Hegde, Archana V.; Cassidy, Deborah J. (2009). "Kindergarten Teachers' Perspectives on Developmentally Appropriate Practices (DAP): A Study Conducted in Mumbai (India)" (PDF). Journal of Research in Childhood Education. 23 (3): 367–381. doi:10.1080/02568540909594667. S2CID   143999565 . Retrieved 21 November 2018.
  4. Lee, Che-Di (2014). "Worksheet Usage, Reading Achievement, Classes' Lack of Readiness, and Science Achievement: A Cross-Country Comparison" (PDF). International Journal of Education in Mathematics, Science and Technology. 2 (2): 96–106. doi:10.18404/ijemst.38331 (inactive 2024-11-12).{{cite journal}}: CS1 maint: DOI inactive as of November 2024 (link)