Download Syllabus in MIS and more Study notes Computers and Information technologies in PDF only on Docsity!
Republic of the Philippines PANGASINAN STATE UNIVERSITY San Carlos City Campus San Carlos City, Pangasinan 2420
Syllabus in HRDM ELECT 101 (Management Information System)
Course Code No.: HRDM ELECT 101 Title of the Subject: Management Information System
Time Frame: 54 hours (2nd^ Sem.)^ Course Credit:^ 3 units
I. VISION, MISSION, GOALS AND OBJECTIVES
- PSU Vision A dynamic, self-reliant, and productivity-driven institution of higher learning recognized as a center of excellence in professional studies and technical training with distinctive competence and leadership in research and community service.
- PSU Mission The Pangasinan State University shall provide professional and technical training in the arts, sciences, humanities, and technology, conduct scientific research and technological studies, and community services.
- Campus Mission The Pangasinan State University-San Carlos Campus will implement quality programs that include a full range of agriculture, education and information technology degrees. It will provide better opportunities for the acquisition of theoretical knowledge and practical skills that will bring about sustainable agricultural development, and economically as well as socially progressive community development.
- Campus Goals and Objectives Within the context of national development particularly at the grassroot level, the College envisions to initiate rapid enhancement of science and technology particularly those that affect technical agriculture, education and business technology.
Specifically, the College aims to:
- Provide adequate foundation for the students and other clienteles on general education and the necessary agriculture, business and technological knowledge and skills to prepare them to become effective and competitive in a rapidly changing global economy;
- Prepare and produce quality graduates in education, technical agriculture and information technology, who are equipped with sufficient skills and effective training which promote and maximize their competencies and capabilities for productive endeavors;
- Initiate, develop and expand research programs and activities that will generate technologies to sustain agricultural development, support education as well as information technology and promote entrepreneurial endeavors that can respond to local and national needs;
- Conduct skills training and technology seminars for extension clientele to promote effective technology transfer and functional community-based intervention programs and projects which encourage self-reliance and cooperative entrepreneurship;
- Strengthen and supplement the College’s financial and technical resources through the establishment of extensive and functional networking programs and support systems; and
- Promote and enhance excellence, efficiency and ethics in the attainment of the College’s objectives and in the performance of its operations.
The Information and Communications Technology Program of PSU-San Carlos Campus aims to: •.1. produce ICT graduates equipped with theoretical knowledge and technological skills needed to become effective, productive, responsible individuals, and competitive citizens of the country and the global community; •.2. to provide the students with relevant functional learning experiences and developing their skills in information and communications technology; •.3. help the students achieve their academic career and goals in life through ICT;
II. Course Description
This course deals with an overview of management information system and the broad system of MIS.
III. Course Objectives
A. General Objectives: To impart to the students the basic knowledge about how computers came about, computer components, uses of computers and career opportunities in computers
B. Specific Objectives: At the end of the course, the students are expected to: B.1. know the significance of information management, B.2. understand the basic fundamental principles of MIS, B.3. know the computer as problem solving tool using MIS B.4. know the computer-based as information system and database management
IV. Course Outline
I. Part One. Information Management Chapter 1 Introduction to Information Management I.1. Importance of Information Management I.2. The Modern Manager I.3. Management Skills I.4. The Manager and System I.5. The Information Services Organization I.6. The Need for a Complete of Information System I.7. The Computer as an Element in an Information System
II. Part Two. Fundamental Principles Chapter 2 Theory of Management and Organizations I.8. Theory I.9. Management Theory II.a. Importance of Management Theory to Information Management I.10.Organization Theory I.11.Importance of Organization Theory to Information Management I.12.System Theory I.13.System Theory of Management and Organization Chapter 3 The General System Model of the Firm I.14.Models I.15.The General System Model I.16.Use of the General System Model I.17.The Emerging Emphasis on Resource Flows in Organization Chapter 4 The System Approach
Chapter 10 Decision Support Systems I.67.Decision Making I.68.DSS Objectives I.69.What is DSS? I.70.A DSS Model I.71.Simulation I.72.Fourth – Generation Languages I.73.Group Decision Support Systems Chapter 11 Office Automation I.74.Automation in the Factory I.75.Office Automation I.76.The Role of Office Automation in Problem Solving Chapter 12 Expert System I.77.Artificial Intelligence I.78.The Appeal of Expert System I.79.Parts of an Expert System I.80.The User Interface I.81.Evaluating Expert Systems in Business I.82.The Steps beyond Expert Systems
V. Part Five Organizational Information Systems V.i.Functional Information Systems V.ii. The Executive Information Systems Chapter 13 The Executive Information Systems I.83.Who are the Executives? I.84.What do Executives do? I.85.How do Executives thinks? I.86.Unique Information Needs of Executives I.87.Suggestions for Improving Executive Information I.88.Computer - Based Executive Information Systems I.89.EIS Implementation Decisions Chapter 14 Marketing Information Systems I.90.Functional Organization Structure I.91.Functional Organization Systems I.92.Marketing Principles I.93.Evolution of the Marketing Information System I.94.A Marketing Information System Model Chapter 15 Manufacturing Information Systems I.95.The Computer in Manufacturing I.96.The Computer as an Part of the Physical System I.97.The Computer as an Information System I.98.A Model of a Manufacturing Information System I.99.Data Processing Subsystem I.100. Industrial Engineering Subsystem I.101. (^) Manufacturing Intelligence Subsystem I.102. Production Subsystem I.103. Inventory Subsystem I.104. Quality Subsystem I.105. Cost Subsystem I.106. How Managers use the manufacturing Information System Chapter 16 Financial Information Systems I.107. Model of Financial Information Systems I.108. Data Processing Subsystem I.109. Internal Audit Subsystem I.110. (^) Financial Intelligence Subsystem I.111. Forecasting Subsystem I.112. Funds Management Subsystem I.113. Control Subsystem
VI. Part 6 Information Systems Management Chapter 17 The System Life Cycle I.114. The System Life Cycle I.115. The Planning Phase I.116. (^) The Analysis and Design Phase I.117. The Implementation Phase I.118. The Operation Phase
Chapter 18 Information Resources Management I.119. The Different Views of IRM I.120. Information as a Strategic Resource I.121. Strategic Planning for Information Resources I.122. The Chief Information Officer I.123. The Management of End-User Computing
V. Teaching/Learning Strategies
- Individual Reporting
- Lecture with Actual Demonstration
- Active participation during discussion
VI. Bases for Evaluation
- Participation 70% (Mid-term/Final Exams, quizzes)
- Projects (system evaluation and prototyping) 30%
VII. Instructional Materials
- Handouts/book
- Computer Equipment
VI. References Mcleod, Raymond, Jr., Management Information System, Fourth Edition 1993
Prepared by: Noted:
CHRISTOPHER A. RODRIGUEZ EVELYN B. LOMBOY
Instructor Chairman, Arts & Sciences
MARLYN P. AMBANLOC
Associate Dean
DR. VIRGILIO C. BARONGAN
Campus Executive Director
Republic of the Philippines PANGASINAN STATE UNIVERSITY San Carlos City Campus San Carlos City, Pangasinan 2420
Syllabus in ICT 127
•.5. to provide the students with relevant functional learning experiences and developing their skills in information and communications technology; •.6. help the students achieve their academic career and goals in life through ICT;
II. Course Description This course deals with an overview of database design and implementation using MS-Access.
III. Course Objectives
C. General Objectives: To impart to the students the basic knowledge about how computers came about, computer components, uses of computers and career opportunities in computers
D. Specific Objectives: At the end of the course, the students are expected to: B.5. Know the purpose of database systems, B.6. Create database design B.7. Understand data definition language B.8. Understand Database Administrator B.9. Start MS-Access B.10. Create table B.11. simple database program
IV. Course Outline
- Create an Access database 1.a.Create a database using database wizard 1.b. Create a database using template 1.c.Create a database without using database wizard
- Working with access file 1.d. Open an Access database 1.e.Open a file
- Working with Data 1.f. Adding modifying data 1.g. (^) Cut and copying data 1.h. Finding and sorting data and grouping data
- Expressions 1.i. Creating expressions 1.j. Example of expressions 1.k. Functions
- Database Replication 1.l. Understanding replication 1.m. Replicating a database 1.n. Replica visibility
- (^) Security and Privacy 1.o. Security 1.p. Privacy
- Programmability 1.q. Actions 1.r. Events 1.s.Macros 1.t. Basic Programming Concept 1.u. Registry Settings
- Microsoft Access Visual Basic reference 1.v.Programming concepts 1.w. Collections 1.x. Objects 1.y.Method 1.z.Properties
1.aa. Events 1.bb. Functions 1.cc. Enumerations
V. Teaching/Learning Strategies
- Discussion/tutorials
- Lecture with Actual Demonstration
- Active participation during discussion
VI. Bases for Evaluation
- Participation 70% (Mid-term/Final Exams, quizzes)
- Projects (database development) 30%
- Laboratory exercise
VII. Instructional Materials
- Handouts/book
- Computer Equipment
VI. References Tañedo, Roel T., Applications Programming 1,2 and3., CAL Holdings Phil. Inc. Phil. Copyright 2004
Prepared by: Noted:
CHRISTOPHER A. RODRIGUEZ DR. CARMELITA L. GONZALES
Instructor Chairman, Arts & Sciences
MARLYN P. AMBANLOC
Associate Dean
DR. VIRGILIO C. BARONGAN
Campus Dean
Republic of the Philippines PANGASINAN STATE UNIVERSITY San Carlos City Campus San Carlos City, Pangasinan 2420
Syllabus in ICT 120 ( File Organization )
Course Code No.: ICT 120 Title of the Subject: File Organization Time Frame: 54 hours (2nd^ Sem.)^ Course Credit:^ 3 units with laboratory
I. VISION, MISSION, GOALS AND OBJECTIVES
III. Course Objectives
This course deals with an overview of file organization and processing using MS- Access.
IV. Course Outline
- Introduction to MS-Access 1.a.Define some key Access terminology 1.b. Illustration of fields, records and a table 1.c.Use the task pane to open a database 1.d. Open an Access database table
- Creating And Maintaining A Database 1.e.Learn the guidelines for designing databases 1.f. Determining database fields 1.g. (^) Group the fields into tables 1.h. Choose a primary key 1.i. Create a new table
- Querying a Database 1.j. The Query Design view window 1.k. Selecting, displaying and sorting fields 1.l. A sample query datasheet 1.m. A one-to-many relationship 1.n. Selecting the tables for a relationship
- Creating Forms and Reports 1.o. (^) Use Form Wizard to choose a form layout 1.p. Use Form Wizard to select a style for the form 1.q. Completed Form 1.r. Change a form's AutoFormat 1.s.A completed form created with the Form Wizard 1.t. The AutoFormat dialog box 1.u. Find data using a form 1.v.Setting up a Find operation
- Enhancing a Table’s Design and Creating Advanced Queries 1.w. Display related table records in a subdatasheet 1.x. (^) Create an input mask for a table field 1.y.A design grid with a pattern match field 1.z.Use a list of values to expand the selection possibilities 1.aa. Use both the And Or logical operators in the same query 1.bb. Sample design grid with And Or conditions in the same query
- Creating Custom Forms 1.cc. Design and create a custom form 1.dd. Plan your custom form first 1.ee. Printing Relationships using the Documenter 1.ff. Object Definition Window 1.gg. (^) Add, select, move, resize, delete, and rename controls 1.hh. Form Design View
- Creating Custom Reports 1.ii. Design and create a custom report 1.jj. Report sections and their contents 1.kk. Design a report before creating it 1.ll. Assign a conditional value to a calculated field 1.mm. An If statement example
- Automating Tasks With Macros 1.nn. Design a switchboard and dialog box for a graphical user interface 1.oo. (^) What is a switchboard? 1.pp. An example of a switchboard 1.qq. Use the Macro window to add actions 1.rr. The Macro window 1.ss. Single-Stepping a macro
- Using and Writing Visual Basic for Applications Code 1.tt. Learn about VBA 1.uu. Function procedures, Sub procedures, and modules 1.vv. The structure of a VBA module 1.ww. Learning VBA takes time and effort 1.xx. Use assignment statements 1.yy. Event properties for a form 1.zz. The Visual Basic Code window 1.aaa. Recognize VBA statements
V. Teaching/Learning Strategies
- Individual Reporting
- Lecture with Actual Demonstration
- Active participation during discussion
VI. Bases for Evaluation
- Participation 70% (Mid-term/Final Exams, quizzes)
- Projects (system evaluation and prototyping) 30%
VII. Instructional Materials
- Handouts/book
- Computer Equipment
VI. Reference
Tañedo, Roel T., Applications Programming 1,2 and3., CAL Holdings Phil. Inc. Phil. Copyright 2004
Prepared by: Noted:
CHRISTOPHER A. RODRIGUEZ DR. CARMELITA L. GONZALES
Instructor Chairman, Arts & Sciences
MARLYN P. AMBANLOC
Associate Dean
DR. VIRGILIO C. BARONGAN
Campus Dean Republic of the Philippines PANGASINAN STATE UNIVERSITY San Carlos City Campus San Carlos City, Pangasinan 2420
Syllabus in ICT 115 (Management Information System)
Course Code No.: ICT 115 Title of the Subject: Int. Application Software and
Productivity Tool Time Frame: 54 hours (2nd^ Sem.) Course Credit: 3 units with laboratory
I. VISION, MISSION, GOALS AND OBJECTIVES
A. PSU Vision
III. Course Objectives
A. General Objectives To impart to the students basic knowledge of computer operation
B. Specific Objectives At the end of the course, the students will be able to:
- learn the basic components of the computer system,
- learn the basic operation of computers,
- know how to organize data items and come out with outputs using the software MS-Word for word processing, and MS-PowerPoint for presentations,
- (^) gain expertise in typing using the correct positioning of fingers in the key board
IV. Course Content
- An Overview of Computers 12 hours Basic Components of the Computer System
- Word Processing (MS Word) 21 hours Creating a File Saving Data File Naming a File Editing a File Formatting a File Creating a Table in the Document Saving and Resaving Data Files Closing a File Opening a File Erasing or Deleting Files Inserting a File Inserting Object or Pictures Viewing the Document Exiting from the Application
- MS PowerPoint Application 21 hours Creating Presentations Blank Presentation Presentation based on Design Template Presentation based on Suggested Content Saving and Closing Presentations Quit or Exit Powerpoint Powerpoint Views Normal View Outline Pane Slide Pane Notes Pane Slide Sorter View Ways to Organize Content in an Outline Demote an Outline Point Promote an Outline Point Working with Slides Create a new slide Delete a Slide Change a slide background color Adding and Formatting Text Adding Clip Art (pictures)
Animate Text and Objects
V. Teaching/Learning Strategies
- Lecture with Actual Demonstration
- Actual application of theories learned during laboratory periods
VI. Bases for Evaluation
- Participation (Mid-term/Final Exams) 70%
- Projects (Outputs from MS Word and MS Powerpoint) 30%
VII. Instructional Materials
- Handouts
- Computer Equipment
- Modules
VI. References Leon, Alexis and Mathews Leon. 1999. Introduction to Computers. Vikas Publishing House Pvt. Ltd., New Delhi, India. Cadongonan, Manuel Jr. G. 2003. ppt Tutorial Module. Cadongonan, Manuel Jr. G. 2003. MS Word Tutorial Module. Kellely, Al and Ira Pohl. A Book on C., Publishing Co., Inc. Yu, John W. and Catherine Demers. 1989. Dynamics of Excel. Richard D. Irwin, Inc.,
Prepared by: Noted:
CHRISTOPHER A. RODRIGUEZ DR. CARMELITA L. GONZALES
Instructor Chairman, Arts & Sciences
MARLYN P. AMBANLOC
Associate Dean
DR. VIRGILIO C. BARONGAN
Campus Dean
