Maths Worksheets - Excel

Document Sample
Maths Worksheets - Excel Powered By Docstoc
					                      GCSE Maths


           Active Worksheets

                                                      Use the following sheet to to produce a
                                                               variety of worksheets.

                                                      Each worksheet will randomise the values
  Contents (includes worksheet and answer sheet):     of each question set, so every worksheet
                                                              produced can be different,
                * Percentages 1 and 2               ideal if you want additional practice material.
                  * Fractions 1 and 2
                     * Pythagoras                        To change the values used press F9
                       * Trigonometry
                        * Algebra
                      * Quadratics



produced by A V Ali
he following sheet to to produce a
    variety of worksheets.

worksheet will randomise the values
ch question set, so every worksheet
  produced can be different,
you want additional practice material.

 change the values used press F9
                                             GCSE Mathematics




                  Percentages Worksheet 1

             1) Find 10 % of :                                      3) Find 2.5 % of :


             a) £ 238.00                                            a)   £       377.00
             b) £         17.00                                     b)   £        90.00
             c) £        55.00                                      c)   £       407.00
             d) £        109.00                                     d)   £       382.00
             e) £ 436.00                                            e)   £       185.00




             2) Find 5 % of :                                       4) Find 17.5 % of :


            a)    £ 368.00                                          a)   £       178.00
            b)    £ 332.00                                          b)   £       402.00
            c)    £ 202.00                                          c)   £       182.00
            d)    £ 493.00                                          d)   £       469.00
            e)    £      63.00                                      e)   £       439.00



             5) Calculate the new price and change in price
                  Sale            Original                 Change in
                  discount        Price      New Price Price
             a)            40% £ 44.00
             b)            40% £ 69.00
             c)            35% £ 27.00




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls       created by A V Ali                         11/22/2010
                                             GCSE Mathematics




                 Percentages Worksheet 1
          Answers
            1)                                                  3)


            a)   £     23.80                                        a)   £    9.43
            b)    £      1.70                                   b)       £    2.25
            c)    £     5.50                                        c)   £   10.18
            d)    £    10.90                                    d)       £    9.55
            e)   £     43.60                                        e)   £    4.63


            2)                                                  4)


            a)    £    18.40                                        a)   £   31.15
            b)    £    16.60                                    b)       £   70.35
            c)    £     10.10                                       c)   £   31.85
            d)   £     24.65                                    d)       £   82.08
            e)    £      3.15                                       e)   £   76.83

            5)
            a)   £     26.40     £ 17.60
            b)    £     41.40   £ 27.60
            c)    £     17.55    £    9.45




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls       created by A V Ali                    11/22/2010
                                                   GCSE Mathematics




                             Percentages Worksheet 2



                        1) Calculate the new price and change in price
                             Sale          Original                       Change in
                             discount      Price         New Price Price
                        a)           5% £ 63.00
                        b)          20% £ 125.00
                        c)          50% £ 133.00


                       2) Calculate the old price and change in price
                             Sale          Original                       Change in
                             discount      Price         New Price Price
                        a)          50%                   £ 67.50
                        b)          10%                   £ 110.70
                        c)          10%                   £ 88.20


                       3) Calculate the percentage discount and change in price
                             Sale          Original                       Change in
                             discount      Price         New Price Price
                        a)                 £ 10.00        £     7.50
                        b)                 £ 129.00       £ 90.30
                        c)                 £ 52.00        £ 41.60


                       4) Calculate the new price price and percentage discount
                             Sale          Original                       Change in
                             discount      Price         New Price Price
                        a)                 £ 93.00                        £ 23.25
                        b)                 £ 117.00                       £ 17.55
                        c)                 £ 115.00                       £ 28.75




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls             created by A V Ali               11/22/2010
                                               GCSE Mathematics




                             Percentages Worksheet 2
                 Answers


                        1)                                            2)
                        a) £ 59.85         £   3.15                   a) £ 135.00   £ 67.50
                        b) £ 100.00        £ 25.00                    b) £ 123.00   £ 12.30
                        c) £ 66.50         £ 66.50                    c) £ 98.00    £   9.80



                       3)                                             4)
                        a)        25% £        2.50                   a)      25% £ 69.75
                        b)        30% £ 38.70                         b)      15% £ 99.45
                        c)        20% £ 10.40                         c)      25% £ 86.25




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls         created by A V Ali                            11/22/2010
                                           GCSE Mathematics




                       Fraction Arithmetic Worksheet 1


                       Work out : -
                 1)    Addition                                   2)    Subtraction


                  a)    2     +    3                               a)    7     -      1
                        2          3                                     14           1

                  b)    2     +    1                               b)    4     -      1
                        7          3                                     4            1

                  c)    7     +    7                               c)    12    -      9
                        9          10                                    13           9

                  d)    5     +    1                               d)    8     -      4
                        5          1                                     12           6

                  e)    3     +    5                               e)    2     -      2
                        7          5                                     5            2

                  f)    2     +    1                               f)    3     -      5
                        3          2                                     8            6

                  g)    1     +    1                               g)    2     -      7
                        8          1                                     2            7




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls     created by A V Ali                           11/22/2010
                                                GCSE Mathematics




                       Fraction Arithmetic Worksheet 1
                 Answers
                 1)                                                    2)
                  a)    12   =                                         a)   -7    =       -1
                                     2
                        6                                                   14            2
                  b)    13   =             13                          b)   0     =
                                                                                      0
                        21                 21                               4
                  c)   133   =             43                          c)   -9    =       -1
                                     1
                        90                 90                               117           13
                  d)    10   =                                         d)   0     =
                                     2                                                0
                        5                                                   72
                  e)    50   =             3                           e)   -6    =       -3
                                     1
                        35                 7                                10            5
                  f)    7    =             1                           f)   -22   =       -11
                                     1
                        6                  6                                48            24
                  g)    9    =             1                           g)   0     =
                                     1                                                0
                        8                  8                                14




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls          created by A V Ali                            11/22/2010
                                              GCSE Mathematics




                       Fraction Arithmetic Worksheet 2


                       Work out : -
                 1)    Multiplication                          2)    Division


                  a)     5    x     2                           a)     3       2
                         9          6                                  8        9

                  b)     8    x     7                           b)     5       9
                         8         10                                  5        10

                  c)     2    x     2                           c)     3       1
                         2          2                                  3        1

                  d)     2    x     1                           d)     2       3
                         2          1                                  7        6

                  e)     6    x     1                           e)     3       1
                         8          1                                  7        4

                  f)     1    x     2                           f)     1       2
                         2          9                                  1        2

                  g)     1    x     1                           g)     3       1
                         3          1                                  4        2




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls       created by A V Ali                    11/22/2010
                                                GCSE Mathematics




                       Fraction Arithmetic Worksheet 2
                 Answers
                 1)                                       2)
                  a)    10    =            5              a)     3       x   9    =   27   =       11
                                                                                               1
                        54                 27                    8           2        16           16
                  b)    56    =            7              b)     5       x   10   =   50   =       1
                                                                                               1
                        80                 10                    5           9        45           9
                  c)     4    =                           c)     3       x   1    =   3    =
                                      1                                                        1
                         4                                       3           1        3
                  d)     2    =                           d)     2       x   6    =   12   =       4
                                      1
                         2                                       7           3        21           7
                  e)     6    =            3              e)     3       x   4    =   12   =       5
                                                                                               1
                         8                 4                     7           1        7            7
                  f)     2    =            1              f)         1   x   2    =   2    =
                                                                                               1
                        18                 9                         1       2        2
                  g)     1    =            1              g)     3       x   2    =   6    =       1
                                                                                               1
                         3                 3                     4           1        4            2




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls        created by A V Ali                                      11/22/2010
                                                       GCSE Mathematics




           Pythagoras Worksheet 1



       1) Find the value of length x correct to 1 dp


               a)                          b)          45                     c)   x


                                                 50
                         x        60                               x                    23
                                                                                   37



                                  34



               d)                          e)                                 f)
                                                                                   x
                         x                       39    47
                                  48                                          1
                                                                                   45
                         7
                                                        x




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls                 created by A V Ali                  11/22/2010
                                                       GCSE Mathematics




            Pythagoras Worksheet 1


            Answers
       1)      a)      49.4        b)      67.3   c)   29.0


               d)      48.5        e)      26.2   f)   45.0




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls                 created by A V Ali   11/22/2010
                                                                       GCSE Mathematics




         Trigonometry Worksheet 1



     1) Find the value of length x correct to 1 dp


              a)                           b)        31.0                          c)          x
                                                            55.0                          20.0


                          4.0                                x                                           36.0
              x


                          45.0



     2) Find the value of angle A correct to 1 dp



              a)                           b)                           c)
                                                                                              15.0
                                                    33.0     59.0                                    A
                                  58.0
                                                                                              48.0
                      A                                            A
                          26.0




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls                                 created by A V Ali                     11/22/2010
                                                               GCSE Mathematics




          Trigonometry Worksheet 1
    Answers
     1)
     a)          2.8               b)      54.0           c)    98.9


     2)
     a)         65.9 degrees       b)      34.0 degrees   c)    71.8 degrees




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls                         created by A V Ali   11/22/2010
                                                GCSE Mathematics



                      Algebra Worksheet 1



                 1)   Evaluate the following using x =          4 and y =       10

                 a)        4 x    +        5 y

                 b)        5 x    -        5 y

                 c)        3 x    +        4 y

                 d)       10 x     +       6 y                      Leave answer as a fraction
                                 3 x

                 e)        6 x     -       5 y                      Leave answer as a fraction
                                 5 y

                 2)   Solve the following, give your answers to 1 dp

                 a)        6 x    -        9         =          6

                 b)        5 x    -        6         =         -5

                 c)        8 y    -        2         =         -1

                 d)        7 y    -        10        =         -9

                 e)        8 z    -        2         =         -7

                 3)   Solve the following, give your answers to 1 dp

                 a)        4 x    +        10        =          1 x         +        9

                 b)        5 x    -        5         =          6 x         +        1

                 c)        6 y    +        7         =         10 y         +        7

                 d)        5 y    +         1        =          3 y         +        2

                 e)        3 z    +        8         =          9 z         +        2




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls          created by A V Ali                             11/22/2010
                                                GCSE Mathematics



                    Algebra Worksheet 1
                 Answers

                 1)                                         2)

                 a)      66                                 a)         2.5

                 b)     -30                                 b)         0.2

                 c)      52                                 c)          0.1

                 d)     100 =              1                d)          0.1
                                    8
                         12                3
                                                            e)         -0.6
                 e)     -26 =              13
                         50                25



                 3)

                 a)     -0.3

                 b)     -6.0

                 c)      0.0

                 d)      0.5

                 e)      1.0




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls          created by A V Ali          11/22/2010
                                                                          GCSE Mathematics




                               Quadratics Worksheet 1



                    1)    Expand the following


                     a)    (    1   x      +    3   )    (   4   x    +     7    )          1    3    4   7
                                                                                            4    19 21
                     b)    (    4   x      +    5   )    (   5   x    -     4    )          4    5    5   -4
                                                                                           20    9    #
                     c)    (    1   x      -    2   )    (   5   x    -     7    )          1    -2   5   -7
                                                                                            5    # 14
                     d)    (    1   x      +    1   )    (   4   x    -     5    )          1    1    4   -5
                                                                                            4    -1 -5
                     e)    (    3   x      -    3   )    (   1   x    +     7    )          3    -3   1   7
                                                                                            3    18 #
                     f)    (    4   x      -    8   )    (   6   x    +     1    )          4    -8   6   1
                                                                                           24 # -8
                     g)    (    6   x      +    7   )    (   5   x    -     6    )          6    7    5   -6
                                                                                           30 -1 #
                     h)    (    1   x      -    2   )    (   4   x    -     6    )          1    -2   4   -6
                                                                                            4    # 12



                    2)    Factorise the following


                     a)             1      x2   -   8    x   +   12


                     b)             6      x2   +   12   x   -   18


                     c)             6      x2   +   10   x   +   4

                                         2
                     d)             18 x        -   18   x   -   8


                     e)             6      x2   -   23   x   +   7

                                         2
                     f)             10 x        -   17   x   +   6




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls                                    created by A V Ali                 11/22/2010
                                                                      GCSE Mathematics




                    Quadratics Worksheet 1


                    Answers


                    1)                                                       2)
                     a)             4      x2   +   19   x   +   21          a)    (    1    x   -   6   )   (   1   x   -   2   )   1
                                                                                                                                     1
                                            2
                     b)            20 x         +   9    x   -   20          b)    (    6    x   -   6   )   (   1   x   +   3   )   6
                                                                                                                                     6
                     c)             5      x2   -   17   x   +   14          c)    (    6    x   +   4   )   (   1   x   +   1   )   6
                                                                                                                                     6
                     d)             4      x2   -   1    x   -   5           d)    (    6    x   +   2   )   (   3   x   -   4   )   6
                                                                                                                                     18
                     e)             3      x2   +   18   x   -   21          e)    (    3    x   -   1   )   (   2   x   -   7   )   3
                                                                                                                                     6




b1ba5e18-4698-4b99-aaeb-07fbfe0e12e4.xls                                created by A V Ali                                                11/22/2010

				
DOCUMENT INFO
Description: Maths Worksheets document sample