Quick exercise to establish how to enter data into the ...



Excel for P6 and 7 with a focus on learning skills for ‘Enterprise’ type activities.

Load MS Excel to look at.- Identify grid, columns, rows, cells, formula bar.

Now load the ready-made file - ‘Compilation Excel Exercise’

Open ‘Our school Shared Area’ > Pupil’s Write > P7 >

Copy the file ‘Compilation excel Exercise P67 to your ‘My Work’ folder

Now open this file from your ‘My Work’ Folder

Activity 1 Use temperature data from cities round the world

Quick exercise to establish how to enter data into the spreadsheet

• Edit data

• Highlight data and make a bar chart

• Format the chart – learn how to add titles for chart, x and y axes. Change colour of bars in a data series. Change colour of the plot area.

• Copy / paste into another document – ie MS Word

• Move / resize graphics in DTP programme. Save

Activity 2 Open the sheet ‘Fish shop’ Use this file to learn about :-

• Adding another row for eg ‘Mrs Waddell’s Seafood Surprise’

• Changing width of columns

• Calculating totals vertically and horizontally, using ‘Autosum’

• Formatting cells to show ‘£’s’ Go to Format > Cells > Currency Change to ‘£ Pounds’ and two decimal places

Activity 3 Using formulas

Use the same file as above (‘Fish shop’ ) to learn about

• Entering a ‘times’ or multiplication calculation

• Learn the fast way of copying formulae

Activity 4

Open the sheet ‘Balance Sheet’

• Revise formatting rows

• Entering formulas for ‘times’, or ‘Multiplying’

• Explore changing the contents of cells - the ‘what if’ scenario.

Activity 5

Open the sheet ‘Calc & Currency’

• Entering formulae for + -, * and /

• Change colour of background etc

• Enter formulae for converting currency . Use Scotsman cut out for Exchange rates.

Activity 6

Open the sheet ‘Birthday Cards’. Enter the formulae which will calculate the ‘best value’ of the boxes of cards.

Activity 7

Go back to Fish shop data and make charts to show Mr Waddells weekly sales

Learn how to find ‘Average’ and ‘Maximum’

Activity 8 Evacuation

Use the paper copy and finish entering the data on evacuees.

Use the method you learned above to find totals.

Answer the questions on the paper sheet.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download