Cairo Modern School Computer for Grade 5 2013-2012
Word Processing • Word Processing is writing words and sentences on the computer. • It is easy to change or move text in a word document. • People use word processing to write letters. • You can key your name or words on a computer.
Microsoft Office Provides a gallery of pictures. • This gallery is called Clip Art and it contains different categories for pictures. • To add Clip Art, Use Insert Menu.
A dialog box will be opened, write the word you want to search for, then press Go. 2. All related pictures to that word will appear, choose the picture you want by clicking.
Student Assessment(Practice on Computer) Apply the following:- (1). Insert Clip Art about your favorite food. (2). Use different shapes of WordArt to label your picture. Cake
To move a Clip Art follow these steps: Click on the clip art. Picture toolbar will be opened automatically. Click on Wrap Text. Choose Square. Drag and Drop the clip art at the desired place and leave it.
To create a new presentation, open file, choose new, BlankPresentation and choose create.
Lesson 2-Format a slide text • To format a text means to change it’s color or size. • First step is to highlight the text then use formatting icons in the home tab.
3- Font color: School School 4- Use Bold, Italic, and Underline : School School School School School School
Student Assessment(Practice on Computer) Apply the following:- (1). Create a bulleted slide and format this slide. *Title: Font size (18) – Font color (red) – Bold *The bulleted list: Font size (14) - Italic
Put (T) if the sentence is correct and (F) if the sentence is wrong : 1- Power point program is used to create presentations. ( ) 2- This Icon is called New Slide. ( ) 3- To create a title slide, open slide layout menu. ( ) 4- The page in the power point program is called document. ( ) 5-To Format a text, open Home menu. ( ) 6-To make another copy of a sentence, use Cut and paste. ( )
Slide Transition: • It is the amount of time between slides in a presentation. • Open transition tab in the menu bar. • Click on the desired transition. • To specify a certain duration, use Duration Icon and set the time.
Unit 6: Spreadsheet
What is a spreadsheet? • A spreadsheet helps you work easily with numbers. • Spreadsheet is used to organize data. • It looks like a chart or a table. • The school office uses spreadsheets to count the number of students in your class. • In this unit you will learn how to use spreadsheets. • You will learn about a cell, a row and a column. • Spreadsheet is created using Excel Program.
How to open the Excel Program? StartAllprogramsMicrosoftofficeExcelProgram
Row 9 Column E Cell E9 • The Excel Book contains three sheets. • The spreadsheet looks like a table. • It consists of COLUMNS (go from up to down) and ROWS (go from left to right). • The columns are named by letters. • The rows are named by numbers. • The column and the row meet in a cell. • The cell address: shows where the Cell is. • Column + Row = Cell address • Letter + number = cell address • E + 9 = E9
Lesson 2: Enter Data • Words and numbers in the spreadsheet are called data. • Follow these steps to enter date in a spreadsheet: • Open the excel program. • Use sheet 1 to enter data. • Use the cursor or the four arrows to move between cells. • Go to cell A1 and click to write. Click and write
Student Assessment Put (T) if the sentence is correct and (F) if the sentence is wrong : 1- We use the spreadsheet to draw pictures. ( ) 2- Cell address = Number +Letter ( ) 3- Columns and rows meet in a table. ( ) 4- We can use the four arrows to move around the spreadsheet. ( ) 5- The Excel program is used to create a document. ( ) 6- Columns are called by letters and rows are named by numbers.( )
Lesson 3: Add Columns and Rows • To insert another column or row, follow these steps: • Open Home menu in the menu bar. • Click on Insert icon. • Choose Insert Sheet Rows or Insert Sheet Columns.
Lesson 4:Wrap Text • Wrap text makes all content visible within a cell. • To make a text appear through multiple lines in a cell, format the cell so that the text wraps automatically. To Wrap text automatically: In a worksheet, select the cells that you want to format by clicking. On the Home tab, in the Alignment group, Click Wrap Text. If all wrapped text is not visible, it may be because the row is set to a specific height.
Lesson 5:Spreadsheet Calculations • Use the AutoSum icon to add two or more numbers easily. • It displays the sum of the selected cells directly after the selected cells. • To use AutoSum Function, follow these steps: • Click on the cell you want the total to appear in. • Press on the AUTOSUM button. • Press on the ENTERKEY. Note: If you change any number, the total will be changed automatically.
Lesson 6:Additional Formulas • To insert function is useful in adding or subtracting numbers quickly. • To insert function for adding numbers, follow these steps: • Open Formulas tab in the Menu bar. • Choose insert Function.
3. Insert Function box will be opened. 4. Choose Sum. 5. Insert the First number by clicking on its cell. 6. Insert the second number by clicking on its cell. 7. Click on the cell of the total. 8. Press Ok.
Lesson 7:Work with Graphics • Graph: is another way to represent our data in a clear way. • It makes the data easy to be read. • Microsoft Excel supports many types of charts to help you display data in ways that are meaningful. • Examples: Column chart, Bar chart and Line chart. **In order to create a chart from a spreadsheet, follow these steps: (1)- Enter data (When a cell has a frame around it, data can be added)
(2)- Highlight data (don’t highlight empty cells). (3)- Open Insert, and choose chart. (4)- Choose the type you want.
1- Bar Chart • Data that is arranged in columns or rows on a worksheet can be plotted in a bar chart(goes from left to right). • Bar charts illustrate comparisons among individual items.
1- Column Chart • Data that is arranged in columns or rows on a worksheet can be plotted in a column chart(goes from down to up).
1- Line Chart • Data that is arranged in columns or rows on a worksheet can be plotted in a line chart. Line charts can display continuous data over time