《Basic_course_shortcut》由会员分享,可在线阅读,更多相关《Basic_course_shortcut(11页珍藏版)》请在金锄头文库上搜索。
1、Hand Book of computer -1-COPPADES BCICT ProjectBasic Computer Training Course (Designed for the school teachers of BCICT Programme implemented Schools)This book covers the following courses: Introduction to computer Computer History Windows OS MS-Word 2000/XP MS-Excel 2000/XP MS-Power Point 2000/XP
2、MS-Access 2000/XP Adobe PageMaker 6.5/7.0 Q-Basic Multimedia Overview E-mail Save, Save As; Page Setup, Print Preview, Print.EditUndo, Redo, Cut, Copy, Paste, Find, Replace, Go to.View:Normal, Web Layout, Print Layout; Toolbar, Ruler, Document Map, Header and Footer, Footnote, Zoom.InsertBreaking pa
3、ge /column, Inserting page number, Inserting date/ time, Creating auto text, Inserting auto text, Inserting symbol, Inserting footnote /endnote, Inserting clip art picture, Inserting picture from file, Inserting auto shapes, Inserting Word art, Inserting chart, Wrapping text around the picture, Inse
4、rting text box FormatFont, Paragraph, Bullet and Numbering, Boarder and Shading; Column, Tab, Drop Cap, Text Direction, Change Case, Style.ToolsSpelling and gummer, Language, Word Count, Auto Correct, Protect Document, Mail Merge, Macro, Customize, OptionTableDraw Table, Insert, Delete, Select, Merg
5、ing cell, Splitting Cell, Splitting Table, Table Auto Format, Auto Fit, Heading Row Repeat, Convert, Sort, Formula, Table Property.WindowNew Window, Arrange All, Split, Change File.HelpMicrosoft Word Help, Whats This.=THE END= Microsoft Excel 10 hours Entering Excel Some useful terms*Multiplication
6、/ Division+ Addition- Subtract Greater than = Greater than equal to= Less than equal toHand Book of computer -5-COPPADES BCICT ProjectEntering Date Create a new Workbook. Saving, Opening, Closing, RE-saving, Page Setting, Previewing the documents Copying, Moving, finding, replacing the data: Creatin
7、g serial number Deleting Data Deleting the worksheet Moving data from one book to another book or form one sheet to another sheet Adding header/footer Inserting cells, rows, columns or worksheet Inserting chart: Breaking page: Using function Inserting picture Changing number format Arranging data Ch
8、anging font, fonts style and fonts sizeAdding border and shading Changing width and height of rows and columns Note: Hiding or displaying rows or columns or sheet Changing sheet name Inserting background picture Apply auto format to worksheet Displaying or hiding gridlines Sorting data in ascending
9、or descending order Filtering data From Subtotals Converting text into column How to do page set up How to print preview: How to view formula bar: Splitting windows Freezing windows=THE END=MS POWERPOINT 6 hours Duplicating Slide Deleting Slide Slide Show Inserting new slide Slide Number Movies and
10、Sound: Slide Layout Slide color Scheme Adding Background Apply Design Template Color and line View Show Rehearse and Timing Present animation Custom Animation Slide sorter Slide notes Slides miniature Slide master Change case Slide transition= The End =Access 2000/XP 6 hours-Introduction of Access -
11、Introduction of Database -Types of Database -DBMS -RDBMS -Data Types -Rules to Declare Data types -Creating Tables -Design View -Wizard ViewHand Book of computer -6-COPPADES BCICT Project-Entering data view -Creating Form -Design View -Wizard View -Creating Report -Design View -Wizard viewCreating P
12、ages of database for web-Design View -Wizard View -Existing ViewCreating Queries -Design View -Wizard View Module Description Creating Functions -user defined -Built In functions Macros Descriptions Creating Relationship -One to One Relationship -Many to many relationship -One to Many RelationshipSe
13、curity for Database-Creating user -Set Database Password -User & user Permit ion -Deleting user and Database PasswordQBasic Programming 10 hours -Introduction of QBasic Programming -Basic terms used in QBasic -Basic Statement and CommandsVariables-Declaring variable -Types of variablesOperators-Arit
14、hmetic Operators -Conditional OperatorsHand Book of computer -7-COPPADES BCICT Project-Logical Operators Basic Programs -INPUT -PRINTLooping for Programs-For Loops -While loops -Inner loops -Outer loopsFunctions-Built in Functions -User Defined functionsArray-Singular Array -Double Array -Multidimen
15、sional ArrayAdobe PageMaker 6.5 6 hours Introduction To start PageMaker To work with PageMaker Changing the PageMakers view Revert: Document setup Print Preference Paste multiple Edit story Go to page Insert pages Remove pages Sort pages Go Back / Forward Column guides To change font To change font
16、size To change line spacing leading To change type style To change export tracking Horizontal scaleCharacter Paragraph Fill Stroke Fill & stroke Arrange Text wrap Group Ungroup Lock / unlock position Mask Unmask Polygon settings Hiding or displaying rulers Setting zero lock on or off Locking or unlocking guides Applying bullets and numbering Changing case Adding drop cap Setting