Download to read offline
Uploaded byIntan Jameel
Unit 1.3 Introduction to Programming (Part 2)
This document provides an introduction to programming unit 1.3 on process and information layout. It covers creating workbooks using data layout, publishing workbooks as web pages, using basic spreadsheet functions like SUM, MAX, COUNT, formatting cells, creating charts and hyperlinks across multiple worksheets and workbooks, and publishing workbooks as web pages. The objectives are to create workbooks using data layout, publish workbooks as web pages, and describe functions like SUM, MAX, and COUNT.
TechnologyâŠ
More Related Content
Similar to Unit 1.3 Introduction to Programming (Part 2)
Unit 1.3 Introduction to Programming (Part 2)
- 1. Introduction to Programming Unit 1.3 - Process and Information Layout Presentation 2
- 2. Objectives At theend of this presentation, you will be able to: Create workbooks using data information layout Publish workbook as web page
- 3. Data Information LayoutHelps in creating spreadsheets.
- 4. Spreadsheet Basics ScrollButtons Worksheet Tabs Column Row Cell Cell Number Box Active Cell Formula Box
- 5. Single Excel SheetWorkbook is a collection of worksheets .
- 6. Hands-On! Perform thesteps to format the text and change the column width in the worksheet.
- 7. Entering Formula Returnsthe smallest value for the selected values. MIN Returns the largest value for the selected values. MAX Calculates the average of the selected values. AVERAGE Calculates the total of all the selected values. SUM Description Formula Name
- 8. Entering Formula Multipliesall the selected values and returns their product. PRODUCT Counts the number of cells that contains the specified value. COUNT Description Formula Name
- 9. Hands-On! Perform thesteps to perform calculations such as sum and average.
- 10. Activity 1.3.7 Performthe following steps: Step 1: Open the data file Sales.xls . Step 2: Calculate the total number of Music CDs sold by typing the formula =sum(f11,f18,f25) on the cell F34 . Step 3: Copy this formula to other cells to calculate the total number of Movies and Games CDs sold. Step 4: Save the workbook and identify the change in code.
- 11. Formatting the CellsIt is possible to change the way a text or number that appears in a cell by formatting the cell.
- 12. Hands-On! Perform thesteps to format the cell.
- 13. Activity 1.3.8 Performthe following steps: Step 1: Open the data file Perso_Detail.xls . Step 2: Enter your name, date of birth (dd/mm/yyyy) and birth time in the corresponding columns. Step 3: Change the format of the F14 such that DOB will be displayed as <dd>-<month in words>-<yy> by choosing Format ï Cells ï Date ï 14-Mar-01 . Example: 19/10/1986 ï 19-oct-86
- 14. Activity 1.3.8 Step4: Change the format of the F15 such that time of birth will be displayed in 24hrs clock by choosing Format ï Cells ï Time ï 13:30 . Example: 1:30 pm ï 13:30 Step 5: Save the file and identify the changes in the code.
- 15. Lab Exercise Openthe data file Drinks.xls and perform the following: In the Total column, calculate Cost / Item * Total Item . Calculate the total cost and store it in the column J21 . Apply the formatting and change the columns F and J such that the cost will be displayed as R <cost>. Key: Use Format ï Cells . Identify the changes in the code.
- 16. Creating Charts Chartsare the graphical representation of the data.
- 17. Hands-On! Perform thesteps to create a chart.
- 18. Lab Exercise Openthe data file Form4_ Results.xls . Create bar chart for the Maths marks.
- 19. Multiple Excel SheetsWhen you have data in two excel sheets in a workbook, you can perform calculation using the data present in both the sheets. This can be achieved by using the format sheetname!cellname .
- 20. Hands-On! In awork book, sheet1 stored the marks scored in test1 and sheet2 stores the marks scored in test2. Perform the steps to compare the marks obtained by each student in the English tests and store the maximum mark in the third sheet.
- 21. Activity 1.3.9 Performthe above steps for the Form5_ Results_Multiple.xls .
- 22. Creating Hyperlink AcrossWorksheets It is possible to create hyperlink across worksheets with a workbook.
- 23. Hands-On! Perform thesteps to create hyperlink across worksheets in a work book.
- 24. Multiple Workbooks Youcan create hyperlinks across workbooks.
- 25. Hands-On! Perform thesteps to create hyperlink across workbooks.
- 26. Publishing the Workbookas Web Page You can convert the workbook into HTML format and publish the document on web.
- 27. Hands-On! Perform thesteps to publish the workbook as web page.
- 28. Summary In thispresentation, you learnt the following: Data information layout helps in creating spreadsheets. Workbook is a collection of worksheets. A worksheet consists of number of rows and columns present in it. The intersection of a row and a column is defined as a cell. Alphabets and numbers help in identifying the corresponding cell is termed as label.
- 29. Assignment Describe thefollowing functions: SUM MAX COUNT