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.

 

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, Headers/Footers, Print Preview
  • Margins, Ruler, Line spacing, Font Style and Size

 

Intermediate

  • Toolbars: Formatting and Standard Features
  • Tabs and Indentation
  • Find and Replace

 

Advanced

  • Mail Merge
  • Advanced Mail Merge (with query options)
  • Mailing Labels
  • Wizards: Resume, Fax Cover, Letter
  • Tables and Graphics

 

 

SPREADSHEETS

Instruction focuses on creating and manipulating worksheet assignments designed to introduce the basics of spreadsheets 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

 

Intermediate 

  • Absolute Formulas/Advanced Formatting
  • Sorting Data
  • Advanced Functions

 

Advanced

  • Filtering
  • Multiple Worksheets/Financial Reports/Payroll
  • Organizing Worksheets/Grouping, Subtotals
  • Printing
  • Charts and Graphs
  • Pivot Tables


DATABASE

Students are given alphanumeric data entry assignments to create a database. These assignments improve speed and accuracy. Data entry assignments are completed in Lotus and Excel as well as Access.

 

Microsoft Access

Basic

  • Basic Alpha and numeric input
  • Use of forms and reports
  • Sort and search for data
  • Use the toolbars

 

Intermediate

  • Create data tables and forms
  • Merge data with Word mail merge


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.

 

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 at L.E.N. Institute. A student produced PowerPoint presentation is the culmination of the class.

 

Computerized Accounting Program

Students that have completed the manual bookkeeping class are taught to use QuickBooks Pro automated system. Entry of transactions in debit/credit format, processing checks, recording receipts, general banking and journal entry procedures are taught. Income statements and balance sheets are prepared.

 

Internet

Students are given an overview of how to use search engines to navigate within the World Wide Web. We are on-line throughout the day and students are encouraged to browse the Internet and practice their newly learned skills. Job search using the Internet is emphasized. Students also have the opportunity to develop and edit website materials.

 

Electronic Mail - Students are taught how to read, create, delete and send Electronic Mail (e-mail).

 

Keyboarding - Individuals are taught keyboarding skills on both the computer and on the IBM electronic typewriter. Students are encouraged to achieve minimum speeds of 45 words per minute with high accuracy. Instruction is also provided in machine operation.

 

Calculator - Individuals are taught to operate the 10-key calculator by touch. Instruction is provided in machine operation and the multiple functions of the calculator. Students are encouraged to achieve minimum speeds of 200 strokes per minute with high accuracy.

 

Filing - Instruction is provided in organizing materials alphabetically, numerically, geographically, and by subject. Employment screening tests are administered upon completion of the filing course.

 

Business Math - Basic mathematics instruction is provided. Class material covers arithmetic, decimals, averages, percentages and fractions.

 

Bookkeeping - Basic instruction in manual bookkeeping techniques is provided. This instruction covers identification of assets, liabilities and owner's equity, basic bookkeeping formulas, double-entry transactions, posting of journal and ledger entries, and completing balance sheets. This course is optional.

 

Telephone Etiquette - Students are provided with instruction relating to appropriate answering of telephone calls, telephone call routing and message taking. Students are provided with the opportunity to practice these skills on a regular basis.

 

Medical Front Office – Students are provided with instruction in basic medical terminology, billing, patient scheduling, insurance coding (ICD-9), medical filing and record keeping. This course is optional.

 

Computerized Medical Office

Students are taught to use Lytec Medical automated system. The students are taught patient registration, billing procedures and coding procedures commonly used in a medical practice. They are also given bookwork on patient relations and interaction within the medical community.

 

Career Development - Students are provided with instruction in preparation of resumes, cover letters and follow-up letters, completion of job applications, interviewing techniques, identifying job leads, and job search tactics. Students are shown how to identify goals, plan and schedule activities on a daily and weekly basis, and track jobs contacts and follow-up.

 

Internship - Students who demonstrate acceptable skills and behavior may be offered the opportunity to participate in an internship. Positions within the San Francisco Bay Area business community are identified. Students may have the opportunity to attend work 1/2 day and attend school 1/2 day. To date, participating institutions include: the University of California in San Francisco, Chinatown Community Development Center, San Francisco Bay Conservation and Development Commission, Mission Neighborhood Health Center, San Francisco Housing Rights Committee,  Mercy Housing Corporation Improvworks.

 

Business Correspondence Course - Advanced English students and native English speakers have the opportunity to participate in the Business Correspondence Course. Students learn content organization and proper language and phrasing used in business letters and memos. Students also practice formatting revising and editing their letters and memos on the computer.

 

English as a Second Language - Four different ESL classes are offered. Students are typically enrolled in 2 such classes daily. Grammar classes are offered at 2 different levels. There are grammar and vocabulary classes at a beginning-intermediate level (ESL levels 200 - 400) and intermediate-advanced level (ESL levels 400 - 600). Depending upon language level, students are also enrolled in either a conversation class or business English class. The conversation class focuses on incorporating new ideas into daily speech. The focus in the conversation class is on vocational ESL including job interviews, telephone conduct and appropriate work behaviors. Business English focuses on advanced grammar and sentence structure. Advanced reading comprehension and writing skills are also taught.

 

Special Classes - Students are provided with assignments designed to improve writing and spelling skills.

 

Materials are available to assist individuals in preparing for the Graduate Equivalency Diploma (GED).