Download to read offline
Uploaded byIntan Jameel
Introduction to Programming
This document provides an introduction to office tools and their basic functions. It discusses menu bars, toolbars, common file operations like opening, saving and closing files. It also covers editing tools, formatting text, and different file formats and extensions. Hands-on activities are included to practice these functions in Word, Excel and PowerPoint.
More Related Content
Similar to Introduction to Programming
Introduction to Programming
- 1. Introduction to Programming Unit 1.1 - Overview of Office Tools Presentation 2
- 2. Objectives At theend of this presentation, you will be able to: List the various menu options Identify the various toolbar options Perform basic file operations Identify various file formats
- 3. Menu Bar Isa horizontal bar that appears at the top of the active window, which is associated with pull-down menus.
- 4. Activity 1.1.1 OpenWord, Excel and PowerPoint applications. Notice the difference in menu names between Word, Excel and PowerPoint.
- 5. Toolbar Is acollection of icons that provides easy access to commonly used menu commands.
- 6. File Menu Helpsin performing file related operations such as opening, saving and closing a file.
- 7. File Menu Savesthe active file with a different name in a different location. Save As Saves the active file. Save Closes the active file. Close Opens an existing file. Open Creates a new blank file. New Description Menu Option
- 8. Hands-On! Perform thesteps to create a new file and save it with the file name File1.doc .
- 9. Hands-On! Perform thesteps to open the existing file File1.doc .
- 10. Hands-On! Perform thesteps to save the existing file File1.doc as File2.doc .
- 11. In the figure,label the icons and state its main function in the box given: Activity 1.1.2 (a)
- 12. Activity 1.1.2 (b)Perform the following steps: Step 1 : Open Excel application. Step 2: Type the number 123 . Step 3: Save the file with the name Ex1.xls . Step 4: Close the file. Step 5: Open the file Ex1.xls . Step 6: Save the file with the name Ex2.xls . Step 7: Close the file. Step 8: Close the application.
- 13. Lab Exercise Opena blank document and type the following: " I had lunch with a chess champion the other day. I knew he was a chess champion because it took him 20 minutes to pass the salt. " Save the document with the name Quote1.doc .
- 14. Lab Exercise Openthe document Quote1.doc and add the following quote: " When humour goes, there goes civilization." Save the document with the name Quote2.doc .
- 15. Edit Menu Isused for editing the content of the file using commands such as cut, copy and paste.
- 16. Edit Menu Searchesfor and replaces the specified text. Replace Searches for the specified text. Find Inserts the item at the cursor position. Paste Copies the selected item and places it in the Clipboard. Copy Removes the selected item and places it in the Clipboard. Cut Description Menu Option
- 17. Hands-On! Perform thesteps to duplicate a paragraph.
- 18. Hands-On! Perform thesteps to cut and paste a line in a document.
- 19. Hands-On! Perform thesteps to find and replace a text in a document.
- 20. In the figure,label the icons and state its main function in the box given: Activity 1.1.3 (a)
- 21. Activity 1.1.3 (b)The weekly sales report of the company JPS SPORTS Sdn. Bhd is generated every month. The item code, name and quantity of each item appear in the report. Company decides to change the item code of football is from I001 to I003. Make the necessary changes in the report by following the given steps: Step 1: Open the data file Report1.xls .
- 22. Activity 1.1.3 (b)Step 2: To change the item code of football, choose Edit Replace . Step 3: On the Find what textbox, type the text I 001 and on the Replace with textbox, type the text I003 . Step 4: Click on Replace All button.
- 23. Lab Exercise Opena blank workbook and type the following: 1841 Japanese invaded Malaya 1857 Federation of Malaya gained independence 1863 Malaysia founded 1865 Singapore withdrew from Malaysia As the years are wrongly typed, replace all 18 with 19 . Save the workbook with the name Years1.xls .
- 24. Lab Exercise Opena blank workbook. Copy the years from Years1.xls and paste it in a new workbook. Save the workbook with the name Years2.xls .
- 25. View Menu Willaffect what the user views in the window.
- 26. View Menu Addstext that appears at the top and bottom of every page or presentation. Header and Footer Displays or hides toolbars. Toolbars Description Menu Option
- 27. Hands-On! Perform thesteps to hide and then display the standard and formatting toolbars.
- 28. Hands-On! Perform thesteps to add header and footer to a document.
- 29. Lab Exercise Openthe document Quote2.doc . Add the text Quotes in the header and date in the footer. Save the document.
- 30. Format Menu Willaffect the way the document or presentation appears.
- 31. Hands-On! Perform thesteps to format the given document.
- 32. Activity 1.1.4 Performthe following steps: Step 1: Open the Continents.ppt data file. Step 2: On the first slide, change the colour of the text to Blue . Step 3: On the rest of the slides, change the font size of the title to 40 .
- 33. Activity 1.1.4 Step4: Apply Italics to all the numbers such as 30065000, 13209000 etc. in the slides. Step 5: Save the file as Continents1.ppt .
- 34. File Formats Wheneveryou save a file, the file is saved along with its extension. The extension describes the type of file and helps an application to recognize the file.
- 35. File Formats WebPage .HTML Excel .XLS PowerPoint .PPT Word .DOC File Type File Extension
- 36. Lab Exercise Openthe workbook Years1.xls . Change the font to Book Antiqua and size to 14 . Save the workbook.
- 37. Summary In thispresentation, you learnt the following: Menu bar is a horizontal bar that appears at the top of the active window, which is associated with pull-down menus. Toolbar is a collection of icons that provides easy access to commonly used menu commands. Menu bar contains list of commands that are used for creating and editing documents and presentations.
- 38. Summary In thispresentation, you learnt the following: File menu helps in performing file related operations such as opening, saving and closing a file. Edit menu is used for editing the content of the file using commands such as cut, copy and paste. View menu will affect what the user views in the window.
- 39. Summary In thispresentation, you learnt the following: Format menu will affect the way the document or presentation appears. File extension describes the type of file and helps an application to recognize the file.
- 40. Assignment List theoptions available in menu bar. What is the need for toolbar?