[Spreadsheets][Database][Word Processing]
[Computer ] [ESL][Job Development]
[Internship][Clerical]
Instruction provided on IBM compatible computers.
SYSTEMS
A general introduction to the systems used for various business applications. The program is designed to allow the students to develop ease working in the following systems:
WINDOWS
- Introduction to the Operating System,
Mouse Instruction
- File Management and Data Security
- Introduction to Graphic Tools
- Running concurrent applications
WORD PROCESSING
Instruction focuses on word processing assignments designed to increase familiarity with the practical uses of the computer as well as to improve typing speed and accuracy. Standard business formats used in an office environment are taught and reviewed, including proofreading and editing symbols. In addition, students are given regular assignments which require word processing on the computer. These assignments are completed and edited under teacher guidance.
MICROSOFT WORD
Basic
- Menu Access: Save/Open/Close, Status Bar, Scroll, Open documents, Cut and Copy
- Intro to Toolbars (view, display, tool tips)
- Features: Spelling, Header/Footers, Print preview,
Margins, Ruler, Line spacing, Font Style and Size
- Toolbars: Formatting and Standard Features, Tabs and Indentation, Find and Replace
Intermediate
- Mail Merge,
Advanced Mail Merge (with query options),
Mailing Labels
- Insert Graphics in a document
Advanced
- Import Styles: Autoformat feature
SPREADSHEETS
Instruction focuses on creating and manipulating worksheet assignments designed to introduce the basics of spreadsheet on the computer. These assignments also help the student improve data entry speed and accuracy. Standard formats used in an office environment are taught and reviewed, including the practical use of formulas, functions, and formats.
MICROSOFT EXCEL
Basic
- Menu Access/Basic formatting
- Toolbars
- Formulas/Copy and Paste Procedures/Worksheet Layout
- Absolute Formulas/ Advanced Formatting
- Sorting Data
- Advanced Functions
Intermediate
- Multiple Page Workbooks
- Organizing Workbooks
- Printing
- Charts
- Query and Extracting Data
Advanced
- Graphics
- Pivot Tables
- Macros
DATABASE
Students are given alpha-numeric data entry assignments to create a database. These assignments improve speed and accuracy. Data entry assignments are completed in Excel as well as Access.
ACCESS
- Database Basics
- Open Database
- Alpha-numeric Input
- Use Forms and Reports
- Sort and Search for Data
- Use the Standard Toolbar
- Export Data to Word and Excel
- Link Data for Mail Merge in Word
MICROSOFT OFFICE
In addition to individual program instruction, lessons are provided in the Microsoft Office Suite. These lessons promote an understanding of the interaction possibilities of Excel, Word, Access and the presentation powers of Microsoft PowerPoint and Publisher.
NONPROFIT PROJECTS
L.E.N. works hand-in-hand with Bay Area nonprofit agencies by volunteering to perform clerical projects on the school premises at no charge. These projects offer students real work experience in data entry, database creation and update, word processing, record checking and editing. This forum allows students to practice their clerical skills while performing a valuable community service. They have an opportunity to learn about community agencies and to form connections with these agencies.
COMPUTER THEORY
Instruction is provided in computer theory. Class material covers both hardware and software. Emphasis is placed on vocabulary and enabling the students to successfully discuss their computer skills in an interview. Hardware covers peripheral devices, processing and storage. Software covers operating systems software and applications software with an emphasis on the Microsoft Office Suite used in most Bay Area offices. Students are required to do projects with the Internet, PowerPoint, and Microsoft Publisher as the culmination of the class.
