Fundamentals of Ict detailed Syllabus for Travel & Tourism (TR), K – scheme has been taken from the MSBTE official website and presented for the diploma students. For Subject Code, Subject Name, Lectures, Tutorial, Practical/Drawing, Credits, Theory (Max & Min) Marks, Practical (Max & Min) Marks, Total Marks, and other information, do visit full semester subjects post given below.
For all other MSBTE 1st Sem Syllabus K – Scheme Travel & Tourism, do visit MSBTE 1st Sem Syllabus K – Scheme Travel & Tourism Subjects. The detailed Syllabus for fundamentals of ict is as follows.
Rationale
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
Course Outcomes:
Students will be able to achieve & demonstrate the following COs on completion of course based learning
- Use computer system and its peripherals for given purpose
- Prepare Business document using Word Processing Tool
- Analyze Data and represent it graphically using Spreadsheet
- Prepare professional Slide Show presentations
- Use different types of Web Browsers and Apps
- Explain concept and applications of Emerging Technologies
Unit I
Introduction to Computer System 1.1 Basics of Computer System: Overview of Hardware and Software: block diagram of Computer System, Input/Output unit CPU, Control Unit, Arithmetic logic Unit (ALU), Memory Unit 1.2 Internal components: processor, motherboards, random access memory (RAM), read-only memory (ROM), video cards, sound cards and internal hard disk drives) 1.3 External Devices: Types of input/output devices, types of monitors, keyboards, mouse, printers: Dot matrix, Inkjet and LaserJet, plotter and scanner, external storage devices CD/DVD, Hard disk and pen drive 1.4 Application Software: word processing, spreadsheet, database management systems, control software, measuring software, photo-editing software, video-editing software, graphics manipulation software System Software compilers, linkers, device drivers, oper 1.5 Network environments: network interface cards, hubs, switches, routers and modems, concept of LAN, MAN, WAN, WLAN, Wi-Fi and Bluetooth 1.6 Working with Operating Systems: Create and manage file and folders, Copy a file, renaming and deleting of files and folders, Searching files and folders, application installation, creating shortcut of application on the desktop.
Suggested Learning Pedagogy
Hands-on Demonstration Presentations
Unit II
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
Unit III
Spreadsheets 3.1 Working with Spreadsheets: Overview of workbook and worksheet, Create Worksheet Entering sample data, Save, Copy Worksheet, Delete Worksheet, Close and open Workbook. 3.2 Editing Worksheet: Insert and select data, adjust row height and column width, delete, move data, insert rows and columns, Copy and Paste, Find and Replace, Spell Check, Zoom In-Out, Special Symbols, Insert Comments, Add Text Box, Undo Changes, – Freeze 3.3 Formatting Cells and sheet: Setting Cell Type, Setting Fonts, Text options, Rotate Cells, Setting Colors, Text Alignments, Merge and Wrap, apply Borders and Shades, Sheet Options, Adjust Margins, Page Orientation, Header and Footer, Insert Page Breaks, S 3.4 Working with Formula: Creating Formulas, Copying Formulas, Common spreadsheet Functions such as sum, average, min, max, date, In, And, or, mathematical functions such as sqrt, power, applying conditions using IF. 3.5 Working with Charts: Introduction to charts, overview of different types of charts, Bar, Pie, Line charts, creating and editing charts. Using chart options: chart title, axis title, legend, data labels, Axes, grid lines, moving chart in a separate sheet. 3.6 Advanced Operations: Conditional Formatting, Data Filtering, Data Sorting, Using Ranges, Data Validation, Adding Graphics, Printing Worksheets, print area, margins, header, footer and other page setup options.
Suggested Learning Pedagogy
Hands-on Demonstration Presentations
Unit IV
Presentation Tool 4.1 Creating a Presentation: Outline of an effective presentation, Identify the elements of the User Interface, Starting a New Presentation Files, Creating a Basic Presentation, Working with textboxes, Apply Character Formats, Format Paragraphs, View a Prese 4.2 Inserting Media elements: Adding and Modifying Graphical Objects to a Presentation – Insert Images into a Presentation, insert audio clips, video/animation, Add Shapes, Add Visual Styles to Text in a Presentation, Edit Graphical Objects on a Slide, Format 4.3 Working with Tables: Insert a Table in a Slide, Format Tables, and Import Tables from Other Office Applications. 4.4 Working with Charts: Insert Charts in a Slide, Modify a Chart, Import Charts from Other Office Applications.
Suggested Learning Pedagogy
Hands-on Demonstration Presentations
Unit V
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
Practical / Tutorial Experiences
- Work with document files:
- Work with Images and Shapes in Word Processing.
- Work with tables in Word Processing.
- Working with layout and printing
- Create, open and edit Worksheet.
- Formulas and functions in Worksheet.
- Sort, Filter and validate data in Spreadsheet.
- Charts for Visual Presentation in Spreadsheet.
- Worksheet Printing.
- Make Slide Show Presentation.
- Use Tables and Charts in Slide
- Working with Browsers.
- Prepare Web Forms for Survey.
- Prepare Web Forms for Quiz
a) Work with Computer System, Input/output devices, and peripherals.
b) Work with files and folders
a) Create, edit and save document in Word Processing.
b) Text, lines and paragraph level formatting
a) Document page layout, Themes, and printing.
b) Use of mail merge with options.
a) Insert Animation effects to Text and Slides.
b) Insert Audio and Video files in presentation
a) Internet connection configuration
b) Use Internet and Web Services.
Suggested Micro Project / Self Learning
Self Learning
- Following are some suggestive self-learning topics:
- Use ChatGPT/any other AI tool to explore information.
- Use Calendar to Schedule and edit activities.
- Use Translate app to translate the given content from one language to another.
- Use cloud based storage drive to store and share your files.
Micro project
- The microproject has to be industry application based, internet-based, workshop-based, laboratory-based or fieldbased as suggested by Teacher.
- Perform a survey on various input and output devices available in market and make its report.
- Prepare Time Table, Prepare Notes on Technical Topics, Reports, Biodata with covering letter (Subject teacher shall assign a document to be prepared by each students)
- Prepare slides with all Presentation features such as: classroom presentation, presentation about department, presentation of Technical Topics. (Subject teacher shall assign a presentation to be prepared by each student).
- Student Marksheet, Prepare Pay bills, tax statement, student’s assessment record using spreadsheet. (Teacher shall assign a spreadsheet to be prepared by each student).
- Carry-out Survey on different web browsers.
- Generate resume for different job profile, survey report of any industry using ChatGPT/any other AI tool.
Laboratory Equipment/Software Required
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
Suggested Learning Materials
- Goel, Anita Computer Fundamentals Pearson Education, New Delhi, 2014, ISBN-13: 978-8131733097
- Miller, Michael Computer Basics Absolute Beginner’s Guide, Windows 10 QUE Publishing; 8th edition August 2015, ISBN: 978-0789754516
- Alvaro, Felix Linux: Easy Linux for Beginners CreatevSpace Independent Publishing Platform- 2016, ISBN-13: 978-1533683731
- Johnson, Steve Microsoft Office 2010: On Demand Pearson Education, New Delhi India, 2010. ISBN :9788131770641
- Schwartz, Steve Microsoft Office 2010 for Windows: Visual Quick Start Pearson Education, New Delhi India, 2012, ISBN : 9788131766613
- Leete, Gurdy, Finkelstein Ellen, Mary Leete OpenOffice.org for Dummies Wiley Publishing, New Delhi, 2003 ISBN : 978-0764542220
Learning Websites & Portals
- https://www.microsoft.com/en-in/learning/office-training.asp x Office
- http://www.tutorialsforopenoffice.org/ Open Office
- https://s3-ap-southeast-1.amazonaws.com/r4ltue295xy0d/ Special_Edition_Using_StarOffice_6_0.pdf Open Office
- https://ashishmodi.weebly.com/uploads/1/8/9/7/18970467/compu ter_fundamental.pdf Computer Fundamental
- http://www.tutorialsforopenoffice.org/ Open Office
- https://www.tutorialspoint.com/computer_fundamentals/index.h tm Computer Fundamental
- https://www.tutorialspoint.com/word/ Word Processing
- https://www.javatpoint.com/ms-word-tutorial Word Processing
- https://support.microsoft.com/en-au/office/word-for-windows-training-7bcd85e6-2c3d-4c3c-a2a5-5ed8847 Word Processing
- https://www.javatpoint.com/excel-tutorial Spreadsheet
- https://support.microsoft.com/en-au/office/excel-video-train ing-9bc05390-e94c-46af-a5b3-d7c22f6990bb Spreadsheet
- https://www.javatpoint.com/powerpoint-tutorial Powerpoint Presentation
- https://support.microsoft.com/en-au/office/powerpoint-for-wi ndows-training-40e8c930-cb0b-40d8-82c4-b Powerpoint Presentation
- https://www.geeksforgeeks.org/ms-dos-operating-system/ Operating System
- https://www.javatpoint.com/windows Windows Operating System
- https://www.javatpoint.com/what-is-linux Linux Operating System
- https://www.techtarget.com/iotagenda/definition/Internet-of-Things-IoT IoT
- https://www.geeksforgeeks.org/introduction-to-internet-of-th ings-iot-set-1/ IoT
- https://www.javatpoint.com/machine-learning AI & Machine Learning
- https://www.skillrary.com/blogs/read/introduction-to-drone-t echnology Drone Technology
- https://www.cnet.com/tech/computing/what-is-3d-printing/ 3D Printing
- https://support.google.com/a/users/answer/9389764?hl=en Apps
For detail Syllabus of all other subjects of Travel & Tourism, K – scheme do visit Travel & Tourism 1st Sem Syllabus for K – scheme.
For all Travel & Tourism results, visit MSBTE Travel & Tourism all semester results direct links.