Alphatech School

Office information system (OIS)

OFFICE INFORMATION SYSTEM              680 clock hours
     18 hours/week  – 38 weeks
OBJECTIVES: The office information system is designed for the mature student whose aspirations extend beyond secretarial proficiency to the opportunities available in office administrative management.  This program provides the opportunity for students to improve their MS Windows and Microsoft Office software applications literacy and job skills.  Software application courses help students through hands-on experience to advance their professional careers. Manage their personal affairs, and improve performance in other business courses.

CAREER OPPORTUNITIES:  Graduates who have completed office information system program already hold excellent positions in industry and in the professions but acknowledge the need for further education and professional growth.  Students who complete the program will be prepared to obtain employment as an entry level administrative assistant, administrative or executive secretaries; software specialists, word processing supervisors and trainers; and data entry clerks in various business, industrial, governmental, and professional offices.

Keyboarding/Typing:       
OIS 101        Lab            40 clock hours
This course is designed to instruct the beginning student in the use of proper techniques to master the microcomputer keyboard.  Students learn the proper techniques of alphanumeric keyboarding and the ten-key numeric keypad.  Minimum speed requirement is 20 net words per minute on three timed writings with a three errors limit. 

COMPUTER FUNDAMENTALS      
CIS 102        Lec            40 clock hours
This course develops a student’s understanding of information systems.  Students learn the basic principles, concepts and terminology of computers and computer information systems.  Students develop knowledge regarding computer systems and related equipment.  Information about computer careers such as operations, programming and system design is discussed along with future trends in the computer industry.  Students will also introduced to Microsoft Windows and Internet access.
Prerequisite: None

Windows Family        CIS 103                40 clock hours
This class is designed to provide the updated development of Windows family.  It includes using explorer, hardware, software, peripherals, customizing the desktop, and customizing taskbar.  Student will be able to work with file and storage management, creating and using shortcuts, and design computer display.  Student will be able also to view all the functions of Windows family, such as transferring data between applications and mouse tips.  Prerequisites:  Computer Fundamentals
   
INTRO/INTER. DOS          
CIS 106      Lec                  30 clock hours
This class is designed for the student to start knowing the Microsoft’s command-line operating system.  Student will learn about DOS objectives, directing data, translating information, carrying out commands, booting from the hard and floppy disks, DOS prompt, screen commands and more.  In this class student will continue how to use DOS, and to work with files and the directory command, working with files using DOS.  Prerequisites:  None

INTRODUCTION TO MS WORD   
OIS 107    Lec                30 clock hours
This class is an introduction to Microsoft Word 2000 to learn the essentials of this popular word processing program that is part of Microsoft Office 2000.  The student will learn about the techniques of windows, keyboarding and mouse commands, toolbar capabilities, editing and moving text, formatting, saving, and other skills.   Prerequisites:  Windows Family & Computer Fundamentals

INTERMEDIATE MS WORD     
OIS 108    Lec                30 clock hours
This class is a comprehensive approach to master Microsoft Word for windows.   Students will follow step-by-step through the features in Word such as the ability to create impressive documents, and graphics.
Prerequisite: Introduction MS Word

ADVANCED MS WORD    
OIS 109    Lec                    30 clock hours
This class is designed to enable the student to work with styles, macros, auto text, forms, tables, multiple column formats, mail merge, envelopes and labels.
Prerequisite: Intermediate MS Word  

INTRODUCTION TO MS EXCEL    
OIS 110        Lec                30 clock hours
This class is designed to put hands-on introduction to Microsoft Excel 2000 from worksheet creation to final printout focusing on the basic spreadsheet techniques. The student will be able to know how to use the mouse; creating, revising and formatting a workbook; formula and function basics; linking of worksheets; and printer setup options. 
Prerequisite: Windows Family & Computer Fundamentals

INTERMEDIATE MS EXCEL    
OIS 111    Lec                30 clock hours
This class is designed for the students who are familiar with the topics covered in the MS Excel intermediate class and would like to enhance their skills.  The concepts covered in this class will be the creating, modifying and summarizing scenarios; Pivot Tables, cell auditing, table filtering, data validation and consolidation.  Prerequisite:  Introduction MS Excel 



ADVANCED MS EXCEL    
OIS 112    Lec                30 clock hours
This class is designed to enable the students to be work with the worksheet and cross-workbook calculations, workspace, named ranges, subtotals, charts, macro overview, built-in functions, graphic and objects. 
Prerequisite: Intermediate MS Excel

INTROTO MS ACCESS        
OIS 113    Lec                40 clock hours
This class is an introduction to and basic understanding of data base concepts using Microsoft Access.  It helps students to learn about objects, data base tables and how to use it.  Prerequisite: Windows Family & Computer Fundamentals

INTERMEDIATE MS ACCESS
OIS 114    Lec                40 clock hours
This class was designed for the students who are familiar with the introduction of MS Access.  Student in this course will be able to work with data entry and editing, sorting and indexing, quick find and replacement of data, selection query design capabilities, using operators and multimedia criteria, and begin basic reporting.  Prerequisite:  Introduction MS ACCESS 

ADVANCED MS ACCESS    
OIS 115    Lec                40 clock hours
This class was designed to enhance MS Access skills and cover topics including customizing and controlling, wizards, designing report, working with external tables, merging using external tables with graphics, troubleshooting, and designing advance queries including calculations.  In addition, will be covered designing custom forms, and creating macros. 
Prerequisite: Intermediate MS ACCESS

INTRO/ INTER POWERPOINT    
OIS 116        Lec                30 clock hours
This class is designed to prepare the student for a powerful presentation system that is part of the MS Office 2000.  Students will able to know the techniques for working with handouts, drawing tools, as well as creating graphs and organization charts.  Prerequisite: Windows Family & Computer Fundamentals

ADVANCED MS POWERPOINT    
OIS 117    Lec                30 clock hours
This class is a continuation for the introduction MS PowerPoint.  Additional techniques are covered to make the more proficient with this software.  Prerequisite:  Introduction MS PowerPoint 





Introduction to MS Outlook
            OIS 119    Lec                30 Clock hours
This class is designed to introduce students to Course objectives, moving around software, using mouse, keyboard, using office assistant, choosing and customizing the assistant, new features, screen components, working with email, using the Inbox, composing messages, flagging messages, using send options, reading and viewing messages, using additional mail features, and advanced email features.  Prerequisites:  Windows Family & Computer Fundamentals

Intermediate MS Outlook
            OIS 120    Lec                 30 Clock hours
This class is designed to able students working with using the calendar, customizing calendar, scheduling appointments and events, planning meetings, managing items, printing, working with contacts, finding contacts, printing, working with activities, and using tasks and notes.  Prerequisites:  Intro to MS Outlook

Advanced MS Outlook
            OIS 120    Lec                 30 Clock hours
This class is the continuation to manage tasks, sending status report printing tasks, looking at notes, organizing and viewing notes, customizing notes, printing notes, bringing it all together, navigating with Outlook, customizing Outlook, organizing information, integrating Outlook items, using office documents and using the office clipboard.  Prerequisites:  Interm MS Outlook

MS Front Page
            OIS 124    Lec                40 Clock hours
This course was designed to enable students working with Front Page functions and techniques.  Exploring Front Page Windows, open web page, using view, navigation, sorting, creating new tasks, creating web pages from templates, using page elements, transition effects, understanding hyperlinks, applying themes, format painter, spell checking, building webs with pages, adding multimedia elements and more.
Prerequisites: Windows Family & Computer Fundamentals

QuickBooks Pro
            OIS 125    Lec                40 Clock hours
This class was designed to enable students working with accounting software in the office.  Students will be able to work opening files, balance sheet, comparative balance sheet, creating and modifying income statement, cash flow, inventory, and some other major functions in office accounting.  Prerequisites:  Computer Fundamentals & Windows Family