Filetype Excel XLS | Posted on 09 Aug 2022 | 3 years ago
Authentication
digital resources
226x Filetype XLS File size 0.07 MB Source: rathinamcollege.ac.in
Sheet 1: Sheet1
| Name of the Course : BUSINESS RESEARCH METHODS | Name of the Faculty Handling the Course : N.INDHUMATHI | |||||||||||
| To be Filled before the Commence of the Semester | After the Completion of the Class | |||||||||||
| Unit No. | Topic | Reference | Learning Outcome | Blooms Level | Course Outcome | Evaluation Pattern | Proposed Date & Hour (DD-MM-YYYY & Hour) |
Prerequisite Required | Content Delivery Activity Performed During Session | Evaluation Questionnaries | Actual Date & Hour (DD-MM-YYYY & Hour) |
Reason for the Delay |
| I | BRM introduction | https://www.youtube.com/watch?v=-18Py3sX5sM | Knowledge about MIS | Understanding | CO1 | Quiz | 13.12.2021 -V | MIS basic | Class room Lecture | 1. What is MIS? 2. What is the defferen between MIS and ? 3. who issues MIS ? 4. What is mean by MIS And FIS? 5.What is the purpose of an MIS? |
||
| I | BRM concepts | https://www.youtube.com/watch?v=n3A23RCjvpo | Knowledge about Sysytem | Understanding | CO1 | Quiz | 14.12.2021-III | MIS levels of basic | Class room Lecture | 1. What are the different types of MIS? 2. What is the core principle of MIS? 3. What are the levels of information requirements in an MIS? 4. What are the levels of decision making in MIS? 5. What are the elements of decision making in MIS? |
||
| I | BRM ADV / DISADV | https://www.youtube.com/watch?v=MzkC_mAxcPY | Knowledge about resources data | Understanding | CO1 | Quiz | 17.12.2021-II | apply mgmt in infroamations system | Class room Lecture | 1.W hat are the advantages of MIS in a business? 2. What are the different approaches used in designing an MIS? 3. What strategies do you follow to successfully apply management information systems to a business? 4. How can you protect your worksheet from anyone editing the data? 5.How to create a drop-down list so that users cannot enter unwanted data? |
||
| I | MIS Structure - Managerial View of IS – Functions of Management | https://www.youtube.com/watch?v=6e4s_AmOl_khttps://www.youtube.com/watch?v=6e4s_AmOl_k | Understading of IS Funtions | Understanding | CO1 | Assignment | 21.12.2021-III | VLOOKUP Functions | Class room Lecture | 1. Is it possible to make a pivot table using data from multiple sources? 2. How do you freeze rows and columns simultaneously? 3. What is the constraint of a VLOOKUP function? 4. How many report formats are available in MS Excel? 5. What logical condition will you use when there are two different criteria? |
||
| I | Management Role - Levels of Management. | https://www.youtube.com/watch?v=iB334D7-Joy | Understading of Levels of mgmt | Understanding | CO1 | Quiz | 23.12.2021 -I | INDEX MATCH in excel | Class room Lecture | 1. How do you prepare an MIS report in Excel? 2. What do you know about VLOOKUP? 3. What is the need of INDEX & MATCH in Excel? 4. How to format an open MIS Report (.csv to .xlsx)Excel? 5. Explain 2 advanced Pivot Table techniques on Excel. |
||
| II | Foundation of Information Systems: | https://www.youtube.com/watch?v=9SB6JRAECGk%20youtube%20youtube | Able to apply infromations tools in techiques | Applying | CO2 | Quiz | 27.12.2021-V | DIM SET | Class room Lecture | 1. What is a condition and why does it matter? 2. What is the difference between relative and absolute cell referencing? 3. What is the difference between DIM and SET? 4. Write a VBA program to copy data from a worksheet to another? 5. What is Option Explicit and Option Base? |
||
| II | Fundamentals of Information Systems | https://www.youtube.com/watch?v=Jwm_oyleuhY | Able to apply infromations sysytem | Applying | CO2 | Assignment | 30.12.2021-I | arguments to VBA functions | Class room Lecture | 1. What is the difference between ActiveWorkbook and ThisWorkbook? 2. How can you stop VBScript when it goes into the infinite loop? 3. How can you pass arguments to VBA functions? 4. Which are some of the different types of error handling techniques? 5. Give the shortcuts for the following Excel VBA: |
||
| II | BRM concepts | https://www.youtube.com/watch?v=nmIkTm09BGc | Able to sloving business problems | Applying | CO2 | Quiz | 03.01.2022-V | ADO, ODBC and OLEDB CONTROLS | Class room Lecture | 1. How do you count a string in excel? 2. Highlight the main differences among VB6, VBA, VBScript and VB.Net. 3. Name some of the categories of two data types? 4. Can you elaborate on ADO, ODBC and OLEDB? 5. How do you pass arguments to VBA functions other than ByVal and ByRef? |
||
| II | Criteria in Information System | https://www.youtube.com/watch?v=CMyQlyORpPQ | Able to apply infroamtions system criteria | Applying | CO2 | Quiz | 06.01.2022-I | Primary Key | Class room Lecture | 1. What are the three main types of statements in SQL? 2. What is a Primary Key? 3. What are the different types of JOINs? 4. How do ensure that your subquery is working fine? 5. What do mean by XML Datatype? |
||
| II | Frame Work For IS - Sequence of Development of IS. | https://www.youtube.com/watch?v=19krzA_TQPw | Able to apply frame work and tools | Applying | CO2 | Assignment | 10.01.2022-V | @@SPID in SQL | Class room Lecture | 1. What is @@SPID in SQL? 2.What is @@Version? 3. What are the Triggers? 4. What should you do when a data disk gets overloaded? 5. What is your understanding of DBMS? |
||
| III | Concept of Organizational Planning | https://www.youtube.com/watch?v=alJXQ6dci20 | Able to prepare organizational planning | Applying | CO3 | Quiz | 18.01.2022-III | boss wants you to find a certain transaction AND analysing tools | Class room Lecture | 1. Briefly explain the 3 types of index in SQL. 2. What do you understand by ACID property in a database? 3. What Are the Roles of an MIS Executive? 4. TWhat Are the Qualities that an MIS Executive Should Possess to be Effective? 5. Your boss wants you to find a certain transaction. Which report do you go to? |
||
| III | Planning Process - Computational Support for Planning | https://www.youtube.com/watch?v=BtbG1fYjeyY | Able to prepare planning process support | Applying | CO3 | Seminar | 20.01.2022-I | out of place of business functions | Class room Lecture | 1. What is the definition of MIS? 2. A summary report that comes out daily is a what? 3. When a report is produced periodically, it is called what? 4. Something is out of place in a business. What report is made? 5. What is amortization expenses? |
||
| III | Characteristics of Control Process | https://www.youtube.com/watch?v=TodpUUTvJ6U | Able to prepare Finanical Statements | Applying | CO3 | Quiz | 24.01.2022-V | MIS ADV / DISADV | Class room Lecture | 1. when you request a report, what is that called? 2. Who wrote the song on MIS? 3. Inputs of MIS are typically what? 4. Problem solving includes and goes beyond decision making. 5. Why its necessary to compares plus MIS? |
||
| III | Determination of Information Requirements | https://www.youtube.com/watch?v=nKWQh7mp5GI | Applying | CO3 | Quiz | 27.01.2022-I | various elements of MIS | Class room Lecture | 1. What are the 5 main types of management information systems MIS? 2. What are the 4 types of information systems? 3. Is SAP an MIS system? 4. What are the various elements of MIS? 5.What are the 3 key elements of MIS? |
|||
| III | Business Systems Planning - End Means Analysis - Organizing the Plan. | https://www.youtube.com/watch?v=ln4SoUdxur0 | Able to prepare Finanical Statements | Applying | CO3 | Quiz | 31.01.2022-V | DSS in an enterprise system | Class room Lecture | 1. Which one is an internal source of information for MIS? 2. What is main objective of MIS? 3. What are the 4 components of information system 4. How do you develop a MIS system? 5. What is the function of DSS in an enterprise system? |
||
| III | Characteristics of Control Process | https://www.youtube.com/watch?v=TodpUUTvJ6U | Able to prepare Finanical Statements | Applying | CO3 | Assignment | 01.02.2022-III | limitation of MIS | Class room Lecture | 1.Which type of system interacts with its environment? 2. Where does MIS get input? 3. What are the limitation of MIS? 4. What are the environmental influences that affect open system? 5. How important is the informal information system in system analysis? |
||
| IV | Internet & Electronic Commerce | https://www.youtube.com/watch?v=nxSDHBdsWqA | understanding the electronc commerce | Evaluating | CO4 | Quiz | 04.02.2022-II | core principle of MIS | Class room Lecture | 1. What does MIS stand for? 2. Why MIS is important in an organization? 3. Why MIS is required for an Organisation? 4. What is the core principle of MIS? 5. What are MIS reporting tools? |
||
| IV | – Intranet - Extranet & Enterprise Solutions | https://www.youtube.com/watch?v=cOQlqtF3GA4 | Able to evaluate the intranet and extranet | Evaluating | CO4 | Seminar | 10.02.2022-I | 3 types of information systems | Class room Lecture | 1. What is VLOOKUP formula? 2. What is VLOOKUP and Hlookup? 3. What is Pivot in Excel? 4. What are the 3 types of information systems? 5. What are the four parts of an information management system? |
||
| IV | Information System for Business Operations | https://www.youtube.com/watch?v=114DipNd1n8 | Able to evaluate the Valuation of goodwill and shares | Understanding | CO4 | Assignment | 14.02.2022-V | uper-Profit Method | Class room Lecture | 1. Where MIS is used in business? 2. What resources do we need for MIS? 3. what are the 5 main components of an information system? 4. What do you mean bySuper-Profit Method? 5. What do you mean byCapitalisation Method? |
||
| IV | java adv / and disadvantanges | https://www.youtube.com/watch?v=n3A23RCjvpo | Able to evaluate the infroamtions system | Understanding | CO4 | Quiz | 15.02.2022-III | limitation of MIS | Class room Lecture | 1. What are the 6 components of information system? 2. What are the 3 management levels? 3. What type of information are expected by 3 management levels? 4. What is an example of a management information system? 5. What are the limitation of MIS? |
||
| IV | Information System for Strategic Advantage. | https://www.youtube.com/watch?v=sv9oybx4NeQ | Able to strategic mgmt | Applying | CO5 | Quiz | 21.02.2022-V | motivate your team AND employees | Class room Lecture | 1. How do you motivate your employees? 2. How will you manage a team under pressure? 3. How do you motivate your team? 4. Why do we need to manage time? 5. What is scalar chain? |
||
| V | Enterprise Resource Planning | https://www.youtube.com/watch?v=c9HfNg4a_Og | Knowledge about ERP | Applying | CO5 | Quiz | 24.02.2022-I | managing IT infrastructure | Class room Lecture | 1. How do you handle upper management? 2. How do you prioritize time management? 3. How do you reduce workload? 4. What are the challenges of managing IT infrastructure? 5.What are the 5 principles of management? |
||
| V | BRM VALUE | https://www.youtube.com/watch?v=SEImedrfUWA | Knowledge about Supply chain mgmt | Applying | CO5 | Quiz | 25.02.2022-II | manage multiple priorities | Class room Lecture | 1. How do you distribute work equally? 2. How projects are prioritized and selected? 3. How projects are prioritized and selected? 4.WHow do you manage multiple priorities? 5. How do you manage multiple priorities? |
||
| V | System Development Life Cycle | https://www.youtube.com/watch?v=shNOYFlmBOU | Knowledge about system development cycle | Applying | CO5 | Quiz | 28.02.2022-V | distribute work equally techicques | Class room Lecture | 1. How do you speak at a higher level? 2. What are the benefits of workload management? 3. How do you handle too many tasks at work? 4.How do you distribute work equally? 5. How do you talk with purpose? |
||
| V | Management and Procurement Management | https://www.youtube.com/watch?v=aZRouISq-WM | Knowledge about MPM | Applying | CO5 | Quiz | 01.03.2022-III | INDEX & MATCH in Excel | Class room Lecture | 1. How do you prepare an MIS report in Excel? 2. What do you know about VLOOKUP? 3. What is the need of INDEX & MATCH in Excel? 4. How to format an open MIS Report (.csv to .xlsx)Excel? 5. Explain 2 advanced Pivot Table techniques on Excel. |
||
| V | BRM COMMON ETHICS | https://www.youtube.com/watch?v=XkPUFcZYfMU | Knowledge about COST benefits | Applying | CO5 | Quiz | 04.02.2022-II | First rule of management? | Class room Lecture | 1.What are the 4 functions of management? 2.What is the first rule of management? 3. What is the first rule of management? 4. What is scalar chain? 5.What is infrastructure planning? |
||
| V | Project Management - | https://www.youtube.com/watch?v=uWPIsaYpY7U | Able to give accounting treatment for Liquidation of Companies | Applying | CO5 | Quiz | 07.02.2022-V | Explain Ark system | Class room Lecture | What is called MIS? Define its importance? 2. How do management decisions can be taken? 3. Discuss Systems Approach and Information? 4. Explain Ark system? 5. What Information System Architecture?1 |
||
| V | Design - Implementation. | https://www.youtube.com/watch?v=aFAVPOVGK3c | Able to understant the Sdesign implementaions | Understanding | CO5 | Quiz | 10.02.2022-I | DIM and SET? | Class room Lecture | 1. What is a condition and why does it matter? 2. What is the difference between relative and absolute cell referencing? 3. What is the difference between DIM and SET? 4. Write a VBA program to copy data from a worksheet to another? 5. What is Option Explicit and Option Base? |
||
| V | BRM VALUE | https://www.youtube.com/watch?v=_1bOaNSy5XY | Able to understant the S Prototyping | Understanding | CO5 | Quiz | 14.03.2022-V | ADO, ODBC and OLEDB? | Class room Lecture | 1. How do you count a string in excel? 2. Highlight the main differences among VB6, VBA, VBScript and VB.Net. 3. Name some of the categories of two data types? 4. Can you elaborate on ADO, ODBC and OLEDB? 5. How do you pass arguments to VBA functions other than ByVal and ByRef? |
||
| Hour - 1st / 2st / 3st / 5st | ||||||||||||
no reviews yet
Please Login to review.
