• Practice
  • About 15 min
  • 5 practice questions

Using application software for science: documents, spreadsheets and presentations

Use a word processor to write text and equations, enter data carefully in a spreadsheet with correct formulas and graphs, make a presentation, and tell a web browser from a search engine.

If something looks wrong, please tell us.

By the end of this lesson you can

  • List the steps to create a document with an equation in a word processor.
  • Enter data in a spreadsheet following the right precautions.
  • Write a simple spreadsheet formula and draw a graph from data.
  • Describe how a presentation, a PDF reader and a search engine help in science.

Science is not only doing experiments; it is also recording, calculating, graphing and sharing results. Application software makes each of these jobs quicker and neater. The Balbharati book uses the Microsoft Office programs as examples; other programs that do the same jobs work in a similar way.

Word processor: writing reports and equations

  1. Open the word processor from its icon on the desktop.
  2. Choose New, then Blank document, from the File tab.
  3. Type the material and use the Home tab to set language, font size, bold and so on.
  4. To type an equation, choose Equation from the Insert tab, pick a suitable form and type it with mathematical symbols.

Spreadsheet: data, formulas and graphs

A spreadsheet is a grid of cells arranged in rows (numbered) and columns (lettered). A cell is named by its column and row, such as B2. Precautions when entering data:

  • Keep data in tabular form, with different kinds of data in different cells, entered neatly and in one flow.
  • Avoid unnecessary spaces and special characters.
  • When you drag to fill a series, use the smart tag to choose how the cells should be filled.
  • A formula must begin with the = sign, and no space should be typed inside a formula.

To draw a graph: type the data, select it, choose the required kind of graph from the Insert tab, and then study the graph to analyse the information.

Worked example 1: speed with a formula

Question: In a made-up experiment, a toy car's distance (in m) is in cell B2 and its time (in s) is in C2. B2 holds 120 and C2 holds 20. Write a formula for speed in D2 and find the value.

Working: Speed = distance ÷ time. Start with =, use cell names and no spaces: =B2/C2. The spreadsheet calculates 120 ÷ 20 = 6, so D2 shows 6 (m/s). If the data in B2 or C2 is changed, D2 updates by itself, which is a big advantage over working by hand.

Worked example 2: an average and a common mistake

Question: Five made-up readings of the time of swing of a pendulum, 12, 15, 11, 14 and 13 (in tenths of a second), are in cells B2 to B6. A student types 'AVERAGE(B2:B6)' in B7 and sees the text itself instead of an answer. Correct it and find the average.

Working: The formula did not start with =, so the spreadsheet treated it as text. The correct entry is =AVERAGE(B2:B6). Sum = 12 + 15 + 11 + 14 + 13 = 65; average = 65 ÷ 5 = 13. B7 now shows 13.

From readings to a graph in a spreadsheet

  1. Enter data One quantity per column, with headings.
  2. Check entries No extra spaces or symbols.
  3. Add formulas Start each with = and use cell names.
  4. Select and insert graph Choose a suitable graph type.
  5. Analyse Read trends and patterns from the graph.

Presentations, PDF files and the internet

  • Presentation software (such as PowerPoint): gather your material and pictures, start a blank slide, type and insert pictures, use the Design tab to style slides and the Animation tab to animate them, then run a slide show. Useful for presenting the work of scientists with pictures and videos.
  • PDF (Portable Document Format) files keep their layout on any device. A PDF reader (such as Acrobat Reader) is used to view and print them.
  • A web browser is the program that opens web pages. A search engine is a service, opened in the browser, that finds the pages you need from the huge amount of information on the internet. Type a few exact key words for better results.

Every spreadsheet formula starts with = and has no spaces, for example =B2/C2. Select the data first, then insert the graph.

Key takeaways: word processors write reports and equations; spreadsheets store data, calculate with formulas and draw graphs; presentation software shares results visually; PDF readers view fixed-layout documents; browsers and search engines bring the information of the internet to you.

Check your understanding

  1. 1. A student types B2*C2 in a cell, without anything before it. What goes wrong?

    1. The cell turns red
    2. The spreadsheet treats it as text because a formula must start with the = sign
    3. The computer shuts down
    4. The answer is shown twice
    Show answer

    Answer: B. A formula must begin with =. Without it the entry is treated as ordinary text, so =B2*C2 is the correct form.

  2. 2. Cell B3 holds 150 (distance in m) and C3 holds 25 (time in s). What does =B3/C3 show?

    1. 3750
    2. 125
    3. 175
    4. 6
    Show answer

    Answer: D. The formula divides distance by time: 150 ÷ 25 = 6, giving a speed of 6 m/s.

  3. 3. Which software is most suitable for drawing a graph of experiment readings?

    1. Spreadsheet
    2. PDF reader
    3. Web browser
    4. Operating system
    Show answer

    Answer: A. A spreadsheet stores numbers in cells and can draw a graph from selected data using the Insert tab.

  4. 4. Which is NOT a good precaution while entering data in a spreadsheet?

    1. Keeping data in tabular form
    2. Putting different types of data in different cells
    3. Adding extra spaces and special characters between values
    4. Typing = before a formula
    Show answer

    Answer: C. Unnecessary spaces and special characters cause errors and should be avoided. The other three are correct precautions.

  5. 5. What is the main job of a search engine?

    1. To print documents
    2. To find the information we want from the information available on the internet
    3. To store data when the power is off
    4. To control the ALU
    Show answer

    Answer: B. A search engine looks through the internet and lists pages matching the key words typed. Printing, storing and controlling are done by other parts.

Privacy · Terms · Refunds · Delivery