Center for Regional Programs
Center for
Regional Programs
Learn how to start word, use the menu system, and toolbars. Students will learn how to display help information, exit from word, reset the working folder, and enter text into the Document window. Learn how to Save, Print, Close, and reopen a document. Learn how to move the insertion point within a document, insert and delete text, and reverse an edit operation. Learn how to move, copy, and delete a block of text. Learn how to work with paragraphs by indenting the right and/or left side of the paragraph, change margins for the document; reset the spacing in a document or paragraph. Students will learn this along with many shortcuts and other features.
Learn intermediate editing and formatting techniques such as: finding specific text in a document, find and replace text in a document, apply underline and effect options to text, adjust character spacing, and insert symbols. Learn how to set up a table: create a table, insert and delete rows and columns, use formulas in a table, and merge cells in a table. Set up multiple-column documents: create parallel columns in a document, create newspaper columns in a document, use styles, produce a report, add header/footers to a document, and page numbers. Students will learn these features and much more.
Prerequisites: Word 2000, Introduction or equivalent experience.
Learn advanced editing and formatting techniques such as: finding formatting and special characters, controlling page breaks, sorting paragraphs in a list, balancing the length in a newspaper column, creating and applying a new style to text. Learn advanced table techniques: create a table by linking or embedding a Microsoft Excel worksheet. Learn advanced report techniques: adding borders and shading to a document, creating a table of contents, creating an index, and creating footnotes and endnotes. Learn about working with charts and pictures by inserting and modifying a chart in Microsoft Word. Learn how to perform mail merge features and Word forms. Students will learn these features and much more.
Prerequisites: Word 2000, Intermediate or equivalent experience.
Learn the basics of using Excel’s integrated spreadsheet, chart, and database program. Learn how to create, edit, format, and print charts and reports. In the process, learn how to use Excel’s numerous timesaving features, including AutoSelect, AutoCorrect, AutoFill, AutoComplete, AutoSum, Animate Insertion and Deletion, Drag-and-Drop, ScreenTips, Office Assistant, Shortcut menus, and Excel’s customizable toolbars. Learn how to enter formulas, modify formulas, and timesaving techniques on entering formulas in multiple cells at the same time. Learn how to use Excel functions for Sum, Average, Max and Min. using the paste function button.
Learn the basics of using Excel’s integrated spreadsheet, chart, and database program. Learn how to create, edit, format, and print charts and reports. In the process, learn how to use Excel’s numerous timesaving features, including AutoSelect, AutoCorrect, AutoFill, AutoComplete, AutoSum, Animate Insertion and Deletion, Drag-and-Drop, ScreenTips, Office Assistant, Shortcut menus, and Excel’s customizable toolbars. Learn how to enter formulas, modify formulas, and timesaving techniques on entering formulas in multiple cells at the same time. Learn how to use Excel functions for Sum, Average, Max and Min. using the paste function button.
Learn how to use Excel’s intermediate spreadsheet features effectively. Find a specific entry in a worksheet. Create and apply a new style to a worksheet. Use a workbook template to create a new workbook. Use alignment options in the Format Cells dialog box. Enter an absolute column and absolute row cell reference into a formula. Use the PMT and FV function and set up a financial analysis table (using the PMT and FV functions). Use the IF and Nest IF functions; Date and Now functions. Modify and enhance a basic chart. Learn how to copy data from one worksheet to another worksheet in the same workbook and into a different workbook. Freeze and hide rows and columns. Learn all this and more.
Prerequisites: Excel 2000, Beginning or equivalent experience.
Learn how to use Excel’s advanced spreadsheet features effectively. Learn data entry and formatting techniques, which include: restricting cell entries to specific numbers, dates or times. Learn how to define a range name, and use range names in formulas. Learn to use the lookup functions using the Vlookup and the Hlookup functions. Students will learn to how to link multiple workbooks. Learn about working with a database. Students will learn about analyzing data using pivottable reports, solver, and outlining a worksheet. Learn how to import and export from other applications into Excel. Learn all the features and much more.
Prerequisites: Excel 2000, Intermediate or equivalent experience.
Lean how to create professionally designed overhead transparencies, 35mm slides, and computer-based presentations quickly and easily. Students will learn how to create a title slide, bulleted list slide, and how to edit text, switch between outline view, slide view and slide sorter view. Learn how to import graphics; use the drawing tools; create, edit, and format bulleted text slides; and apply and modify various templates. Then learn how to check the spelling; print Speaker’s Notes and Audience Handouts; add transition and animation effects; and give a Slide Show. Learn how to use design template, use the clip gallery, and many more features into a worksheet and copy a formula. Students will learn the basics about PowerPoint, which will include: creating a title slide, bulleted list slide and adding autoshapes. Students will also learn about Microsoft Access and Internet Explorer and much more.
Lean how to create professionally designed overhead transparencies, 35mm slides, and computer-based presentations quickly and easily. Students will learn how to create a title slide, bulleted list slide, and how to edit text, switch between outline view, slide view and slide sorter view. Learn how to import graphics; use the drawing tools; create, edit, and format bulleted text slides; and apply and modify various templates. Then learn how to check the spelling; print Speaker’s Notes and Audience Handouts; add transition and animation effects; and give a Slide Show. Learn how to use design template, use the clip gallery, and many more features into a worksheet and copy a formula. Students will learn the basics about PowerPoint, which will include: creating a title slide, bulleted list slide and adding autoshapes. Students will also learn about Microsoft Access and Internet Explorer and much more.
Students will learn how to share data with Microsoft Excel with object linking and embedding, embedding Microsoft Excel worksheet entries in a PowerPoint Presentation. Enhance Microsoft Excel worksheet entries on a PowerPoint slide. Learn to share data with Microsoft Word, add special effects to text by creating an artistic text block or using the formatting toolbar to enhance text Then learn how to integrate data from other programs, including WordArt, Microsoft Organization Chart, Microsoft Graph, Microsoft Excel, and Microsoft Word. Also learn how to modify the color scheme and use various Slide Show techniques including transitions, builds, animation, drill downs, and hidden slides.
Prerequisites: PowerPoint 2000, Introduction or equivalent experience.
Students will learn how to use the advanced formatting techniques such as copying a design template from one presentation to another, reset paragraph indentation on a slide, set and clear tab stops on a slide, adjust an autoshape to fit text/adjust text to fit within an autoshape. Use data from other applications, create and setup an organizational chart. Learn how to include sounds and video in a presentation by inserting a sound clip or video clip into a slide. Learn to play a sound or video clip in slide show. Students will learn advanced slide show techniques like how to exclude a slide from a slide show, crate a hyperlink branch to a specific slide or another presentation, and use automatic slide timings. Students will learn additional advanced PowerPoint features that include creating a summary slide, custom slide how, save a presentation for use on another computer, and more timesaving techniques.
Prerequisites: PowerPoint 2000, Intermediate or equivalent experience.
Students will learn how to open the different database objects. Design and create data tables, Modify existing data tables and manipulate existing data for editing purposes. Select specific records and fields from tables by using Access queries. Learn how to reopen a database/reopen a table, navigate through records in form/datasheet view. Students will learn how to display selected record by creating and applying a filter or by creating and running a query. Create calculated fields and view data from more than one table. Create data forms for viewing and inputting data. Present data from your tables by creating reports that summarize and grouping information the way you need to. Student manual provided.
Students will learn how to open the different database objects. Design and create data tables, Modify existing data tables and manipulate existing data for editing purposes. Select specific records and fields from tables by using Access queries. Learn how to reopen a database/reopen a table, navigate through records in form/datasheet view. Students will learn how to display selected record by creating and applying a filter or by creating and running a query. Create calculated fields and view data from more than one table. Create data forms for viewing and inputting data. Present data from your tables by creating reports that summarize and grouping information the way you need to. Student manual provided.
Students will learn how to modify the design of a table, specify a required field/define a default field value, set up a primary key, add a memo field, and addition table design topics. Students will learn about working with multiple tables by displaying multiple tables, resizing, and repositioning the table window. Learn about creating a relationship between two tables. Learn to about working with a custome form which indluces designing a custom form, adding a header and footer to a form, and how to add a calculated control to a form. Students will learn intermediate query and report techniques such as: extracting information from multiple tables, creating a report from multiple tables, and adding a calculated control to a report. Students will learn additional intermediate Access features, which include: using a database wizard, compacting and repairing a database, and backup and restore a database.
Prerequisites: Access 2000, Introduction or equivalent experience.
Students will learn how to use advanced table design features that include validating field entries and creating a lookup field and additional table functional features. Learn how to use the advanced form techniques by creating a master-detail form, add a picture to a form, and display a form. Learn about including multiple conditions in a query, create a parameter query, and create a query that will generate summary information. Students will learn how to create an action query, change the join type in a query, and modify query properties. Students will learn advanced report techniques by creating a master-detail report, modify the report properties, and add a picture to a report. Further techniques include transferring data between other applications, working with macros, and additional features.
Prerequisites: Access 2000, Intermediate or equivalent experience.
Learn how to send and receive messages; how to display and respond to a mail message, print a mail message, attach an external file to a mail message, display the contents of a file attachment and how to forward a mail message. Learn about setting up scheduled events on your calendar and how to setup recurring events. Students will learn to about navigating through the calendar, scheduling, and printing the calendar. Learn about creating, adding, and changing a contacts list. Learn to create a tasks list, maintain a journal, and how to use the notes folder.
Students will have an introduction on understanding the Internet, the World Wide Web and Intranets. Students will learn what FrontPage is and learn to use the application window, menus, displaying help information, and how to enter and exit FrontPage. Students will also learn about building a web site; how to work with tables (creating, inserting and deleting rows/columns, resizing table rows/columns, merging cells, and resetting table and cell properties); how to work with pictures and hyperlinks, and dynamic html effects and FrontPage components. Students will also learn how to manage a FrontPage Web, work in tasks view, and additional features of FrontPage, which include templates, wizards, navigation view, and more.
Students will learn intermediate table operations such as: importing existing web pages into FrontPage, using a table for page layout purposes, and adding a custom background color or background picture to a table. Students will learn about customizing individual web pages by applying a theme to a single page, creating a custom theme, removing a theme from a single page, adding a background color/background picture to a single page, and inserting a timestamp on a page. Students will learn about working with shared borders, page banners and navigation bars including editing the contents of a shared border and overriding shared border settings on a page. As well as adding a page banner and navigation bar to a page.
Students will learn creating a frames page and web forms. Also included are instructions on publishing a complete web site including database information along with additional Intermediate FrontPage features.
Prerequisites: FrontPage, Introduction or equivalent experience.
Students will learn about creating a letterhead in publisher, how to examine options in the Publisher catalog, user the letterhead wizard, and save the application. Learn how to create a flyer using the quick publication wizard, insert a personal information component into a publication, add a border to a frame, and insert a text frame. Learn to create a newsletter, examine options in the Publisher design gallery, insert a masthead, setup columns, create a drop cap, and work with shapes. Learn about setting up a table and use WordArt. Learn to create and format a table and insert and delete rows and columns in a table. Learn addition publisher features such as creating and applying a new style to text.
Learn how to create and use personal macros. Students will
learn how to record and run a personal macro as well as display macro
instructions.
Learn how to edit a macro. Students will learn how to use absolute and relative
cell references in macros. Students will learn how to create and use workbook
macros, record and run a workbook macro.
Other items students will learn is how to add a macro button to a worksheet, use Visual Basic to write macros, open a new module in the Visual Basic Editor, Display a data prompt during macro execution; how to use a conditional statement in a macro; how to use a control loop in a macro. Learn additional control statements. Learn how to place controls, combo box and a check box on a worksheet. Learn how to link a control to worksheet data. Create a macros toolbar. Add a button to a toolbar/assign a macro to a toolbar button. Create a macros menu. Use the Visual Basic help system.
Prerequisites: Excel, Advanced or equivalent experience.
Students will learn about the basic hardware components, additional hardware components, and computer software. Students will learn about hard disks, floppy disks, compact disks and additional storage media. Learn the basics about Microsoft windows: creating a new folder, copy and delete a file, and mouse techniques. Learn the basics for Microsoft Word, enter and save text in a document, open an existing document, revise and print a document. Learn the basics for Microsoft Excel such as: entering labels and values into a worksheet, enter a formula into a worksheet and copy a formula. Students will learn the basics about PowerPoint, which will include: creating a title slide, bulleted list slide and adding autoshapes. Students will also learn about Microsoft Access and Internet Explorer and much more.
For questions or comments contact
webmaster@cvnj.astate.edu.