Question:- Explain how you can create an ERD in Visio 2013?
Answer:- To create an ERD in Visio 2013, • You have to select software and database from the list of template categories • After that select Database Model Diagram and then select Software and Database from the list of templates • Now drag-n-drop an entity from the Shapes panel into the drawing grid. Change the generic name for the physical name and conceptual name • Inside the Database Properties panel, switch to the column category. Now, type the name of an column (an attribute). Type FNAME, and then click the Edit button to change the default size of 10 characters. • Now choose the Data Type tab and change the field length to 12 and switch from “fixed length” to “variable length” . After that enter the column names • Once one entity is prepared, likewise you can create another column • Now to create a relationship between different entities, click on the relations icon in the shape panel, and drag and drop Relationship into the table you want to build a relation with. You can do same for other entities as well
Question:- Explain what are the roles of Connectors in Visio?
Answer:- Connectors in Visio are referred to those lines that connect shapes. They are one-dimensional shapes that are used most frequently to connect two-dimensional shapes. One-dimensional shapes will display endpoints whereas two-dimensional shapes will display a selection frame with rotation handles and green sizing.
Question:- Explain how to create PowerPoint Slides from a Visio drawing?
Answer:- To create a PowerPoint slides from a Visio drawing, you have to access macro in Visio as it creates slides from the active Visio drawing. To open the set of slides from a Visio drawing, you have to • Open the Visio drawing containing the macro • Open the Visio drawing that you want to save as PowerPoint • Choose Tools>Macro>Create PPT fromVisio>ThisDocument>CreatePowerPointFromVisio • Now you will have PowerPoint slides with your drawing pages • Macro forms a title slide and inserts the name of the Visio document from which slides were made
Question:- Explain what is Containers, Lists and Callouts?
Answer:- • Containers: It provides a visual boundary around a set of objects, but it also build a logical relationship between the objects and containers within it. Containers know which shape they consist, and shapes know when they are members of a container • Lists: It is a type of container that maintains an ordered relationship among its members. Each object in the list are aware of its ordinal position, new objects are merely not added to a list but are added to a specific position in a list • Callouts: A callout is merely a shape that glued to one another to add a comment. A visio 2013 provides the provision to add an annotation to a shape, but the callout knows the shape to which it is attached and the shape can recognize any attached callouts.
Question:- Explain how you can share diagram using the Cloud?
Answer:- In order to share a file using Cloud, you have to • Go to the File option, and then go down to Share option • When you choose option Share, you will further notice two options, Invite People and Second option is to send a link • If you choose the first option, it will save your file on SkyDrive • After that, you will be enabled to share a document, if you are choosing e-mail as a sending option, you can share a copy of your diagram • The other option is sending out a link to the file and then you will be having everybody working on the same file
Question:- Explain what is link task in MS project used for?
Answer:- As the name suggests, link task in MS project is used for linking any two tasks in a project.
Question:- Mention where is “summary task” in MS project?
Answer:- Summary task is helpful in estimating the task period and the length in project, and organizing the task in order. You can find “summary task” under main menu -> Insert -> Summary
Question:- List out the categories of tasks used in MS project?
Answer:- • Summary tasks: It consists of subtasks and their related properties • Subtasks: It is a smaller task that are part of a summary task • Recurring tasks: These are the tasks that falls at regular intervals • Milestones: These are the prime priority task that are adjusted to zero duration and are like short-term goals in the project
Question:- Mention what are the new features available in MS project 2013?
Answer:- • Improved reporting tools: MS project 2013 offers advanced reporting tools and easy accountability for organizations • Office 365 Integration: Easy integration of office 365 to the MS project data • New Project Templates: The new MS project provides project templates that can be compliance to your requirement like marketing, construction, business, software development plan, etc. • Better Presentation Tools: The timeline view gives better view of the progress of your project and helps to schedule your project accordingly • Task Path: This feature can be handy for a project manager handling large and complex schedules. It allows the user to see the path for a specific task including Successors, Driven successors, Predecessors and Driving Predecessors.
Question:- Explain what is a constraint in MS project? What are the types of constraint available in MS project 2013?
Answer:- In MS project, constraint is used for scheduling the task and setting a due date for the task. The types of constraint available in MS project are • As soon as possible • As late as possible • Must start on • Must finish on • Finish no later than • Start no later than • Start no earlier than • Finish no earlier than
Question:- Mention how to set a deadline in MS project?
Answer:- To set a deadline in MS project • Double-click a task -> it will open a task information dialog box • Now, click on the advanced tab • Then click on the arrow in the deadline field to show the calendar and then choose a date • Now save this by clicking on the save button
Question:- Explain how you can move tasks in project 2013?
Answer:- You can move tasks in MS project 2013 by two techniques • Move the task with drag and drop method • Move the task with the cut and paste method
Question:- Explain how you can remove resource from your project?
Answer:- To remove the resource from your project, first filter the task list to view only the tasks to which the resource is allocated, and then you can edit or change each task to replace that resource. • Choose a task-oriented view like Gantt chart and hide the summary tasks, this list will show only work tasks and milestones • Under View tab’s data section, click on the filter drop-down list and then select “Using Resource.” • In the “show tasks using” drop-down list, select the resource and delete it that you don’t want and then click ok • To replace the resource, select “Assign Resources” under resource tab’s assignment section. Select the task from the table you want to re-assign, and then, in the Assign resource dialog box, choose the resource you want to replace and click replace • Click the format tab, and turn the checkbox back on for “Show Summary Tasks.” • Click resource sheet in the view tab’s resource view section and now you can delete the resource
Question:- Mention what is the characteristics of Gantt Chart Basics?
Answer:- • In Gantt chart, each task is displayed by one row • Dates are displayed in incremental order like days, weeks or months as per the total length of the project • For each task expected, time is displayed by a horizontal bar whose left end indicates the estimated beginning of the task and right end indicates the estimated completion date • Task may run parallel, sequentially or overlapping • The chart is represented in the bar formation to a length proportional to the fraction of the work that has been completed • On the left of the line, you will see the completed tasks • Future tasks line lies to the right of the line • Current task are cross the line and are behind schedule when filled in section is on the left of the line and ahead of schedule when it is right of the line
