GUJARAT TECHNOLOGICAL UNIVERSITY Program Name: Diploma in Engineering Level: Diploma Branch: Information & Communication Technology / Electronics & Communication Engineering / Renewable Energy / Electrical Engineering Course / Subject Code: DI01000091 Course / Subject Name: Fundamentals of Information and Communication Technology (FICT) ___________________________________________________________________________ w. e. f. Academic Year: 2024-25 Semester: 1st Category of the Course: ESC Prerequisite: Basic knowledge of computer Rationale: Nowadays, Information and Communication Technology (ICT) is used in all walks of life. The potential of ICT is widely used in science, business, industry, and education. This course envisages the development of basic skills in the use of information and communication technologies. It will provide students with hands-on experience with different office automation applications to create business documents and to develop programming skills from scratch to improve daily problem-solving skills. Course Outcome: After Completion of the Course, Student will able to: No Course Outcomes RBT Level Classify computer systems and their peripherals and create forms using Google R, U, A 01 applications. 02 Prepare professional documents, analyze data, and create presentations. U, A 03 Use Scratch to solve simple problems. R, U, A 04 Understand the use of different blocks in Scratch. R, U, A 05 Apply decision, loop, and list concepts in Scratch. U, A *Revised Bloom’s Taxonomy (RBT) Teaching and Examination Scheme: Total Teaching Scheme Credits Assessment Pattern and Marks (in Hours) L+T+ (PR/2) Total Marks Theory Tutorial / Practical L T PR C ESE PA / CA PA/CA (I) ESE (V) (E) (M) 0 1 4 3 0 0 20 30 50 w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page 1 of 8 GUJARAT TECHNOLOGICAL UNIVERSITY Program Name: Diploma in Engineering Level: Diploma Branch: Information & Communication Technology / Electronics & Communication Engineering / Renewable Energy / Electrical Engineering Course / Subject Code: DI01000091 Course / Subject Name: Fundamentals of Information and Communication Technology (FICT) ___________________________________________________________________________ Course Content: Unit No. of % of Content No. Hours Weightage COMPUTER SYSTEMS FUNDAMENTALS AND GOOGLE APPLICATIONS 1.1. Computer system block diagram, Concept of Hardware, and Software 1.2. CPU, Control Unit, Arithmetic logic unit (ALU), Memory Unit, Power Unit, and Interfacing Ports. 1.3. Input-Output unit: Monitor, keyboard, External Hard disk, Mouse, Printers, Scanner, Projectors, etc. 1.4. Operating system concepts, purpose, functions, and 1. characteristics. 8 14% 1.5. Operations of Windows Linux Installation on PC and Basic Terminal Commands 1.6. Installation of various Application Software. 1.7. Gmail: Create an account; Adding Contacts; Composing an Email; Creating and Managing Labels, Filters, and Signature. 1.8. Drive: Create a folder, Upload and Download Files/folders, and Sharing Files/Folders. 1.9. Forms: Create a Form; Validate a Form; Share a Form, Managing Response. DOCUMENTATION AND PRESENTATION TOOLS MS Word: 2.1 Basics of text formatting: font type, size, color, effects, typography, Paragraph tool, WordArt, and Drop Cap, Symbol, and Equations. 2.2 Insert Table, Pictures, Shapes Smart Art and Chart options, Inserting rows or columns, merging and splitting cells, Arithmetic 2. 18 32% Calculations in a Table. 2.3 Page settings and margins including header and footer in the word document. 2.4 Spelling and Grammatical checks (use: Grammarly Software) 2.5 Use of Mail merge tool 2.6 Google Docs sheet: creating and sharing w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page 2 of 8 GUJARAT TECHNOLOGICAL UNIVERSITY Program Name: Diploma in Engineering Level: Diploma Branch: Information & Communication Technology / Electronics & Communication Engineering / Renewable Energy / Electrical Engineering Course / Subject Code: DI01000091 Course / Subject Name: Fundamentals of Information and Communication Technology (FICT) ___________________________________________________________________________ MS Excel: 2.7 Introduction to data, Cell address, Excel Data Types, formatting 2.8 Understanding formulas, Operators, Common spreadsheet functions and Types of 2D charts. 2.9 Concept of print area, margins, header, footer, and other page setup options 2.10 Overview of Google Spreadsheets and how to create Spreadsheets MS PowerPoint: 2.11 Creating new Slides, Working with text boxes, fonts, tables, Layouts, themes, effects, background, and Colors 2.12 Selecting, deleting, moving, copying, resizing and arranging objects. 2.13 Working with drawing tools, Applying shape or picture styles, Applying object borders, object fill, object effects, clip art collection, and modifying clip art 2.14 Configuring a sound playback, Assigning sound to an object, Adding a digital music soundtrack, Transition effects and timings INTRODUCTION TO SCRATCH 3.1 Scratch: A graphical programing language 3.2 Scratch Programming Environment: The stage, Sprite, Backdrop, Sprite list, Blocks tab, Scripts area, Costumes tab, Sounds tab, Sprite info, Scratch toolbar 3.3 Paint Editor: Create/edit costumes and backdrop, Setting center 3. 8 14% of a costume. 3.4 Arithmetic Operators and Functions: Arithmetic operators, Mathematical Functions, Random Numbers. 3.5 Data types in Scratch: Boolean, Number, String. 3.6 Variables: What is a variable? Creating a variable, scope of a variable, and use of a variable. DIFFERENT BLOCKS IN SCRATCH 4.1 Scratch blocks: Command blocks, Function blocks, Trigger blocks, and Control blocks. 4. 12 22% 4.2 Motion blocks: go to, glide to, set x to, set y to, point in the direction, point towards, move, turn, change x by, change y by, set rotation style. w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page 3 of 8 GUJARAT TECHNOLOGICAL UNIVERSITY Program Name: Diploma in Engineering Level: Diploma Branch: Information & Communication Technology / Electronics & Communication Engineering / Renewable Energy / Electrical Engineering Course / Subject Code: DI01000091 Course / Subject Name: Fundamentals of Information and Communication Technology (FICT) ___________________________________________________________________________ 4.3 Pen blocks: stamp, pen down, set pen color to, set pen size to, and erase all. 4.4 Looks blocks: say, think, switch costume to, next costume, switch backdrop to, next backdrop, change the size by, set size to, change different effects, set different effects, clear graphic effects, show, hide. 4.5 Sound blocks: play sound until done, start sound, stop sound, change pitch effect by, set pitch effect to, clear sound effect, change volume by, set volume to. PROCEDURES, DECISION MAKING, LOOPING AND CONCEPT OF LISTS IN SCRATCH 5.1 Concept of structured programming: Procedures, Custom blocks, passing parameters to custom blocks, recursive procedure. 5.2 Event Blocks: when the key is pressed, when this sprite is clicked, broadcast, broadcast, and wait when I receive. 5. 10 18% 5.3 Comparison operators: less than, greater than, equal to. 5.4 Logical operators: and, or, not 5.5 Control blocks: wait, repeat, forever, if, if-else, wait until, repeat until stop. 5.6 Lists: Creating lists, List commands (Add, Delete, Insert, and Replace), Accessing list elements, and the Contains block. Total 100 Suggested Specification Table with Marks (Theory): Distribution of Theory Marks (in %) R Level U Level A Level N Level E Level C Level NA Where R: Remember; U: Understanding; A: Application, N: Analyze and E: Evaluate C: Create (as per Revised Bloom’s Taxonomy) References/Suggested Learning Resources: (a) Books: 1. Fundamentals of Computers by Rajaraman V, Adabala N (Sixth Edition) 2. MS-Office for Dummies by Wallace Wang 3. Learn to program with Scratch: A Visual Introduction to Programming with Games, Art, Science and Math by Majed Marji 4. Scratch Programming for Teens by Jerry Lee Ford, Jr. w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page 4 of 8 GUJARAT TECHNOLOGICAL UNIVERSITY Program Name: Diploma in Engineering Level: Diploma Branch: Information & Communication Technology / Electronics & Communication Engineering / Renewable Energy / Electrical Engineering Course / Subject Code: DI01000091 Course / Subject Name: Fundamentals of Information and Communication Technology (FICT) ___________________________________________________________________________ (b) Open source software and website: 1. https://support.microsoft.com/en-us/training 2. https://www.coursera.org/search?query=MS%20office& 3. https://www.udemy.com/courses/search/?src=ukw&q=MS+office 4. https://scratch.mit.edu 5. https://en.scratch-wiki.info 6. https://nptel.ac.in/courses/106106182 (contents of Week 1) Suggested Course Practical List: Sr. Unit Approx. No. Practical Outcomes (PrOs) No. Hrs. Required. 1 Identify parts of computer systems and peripherals. I 02 2 Learn about various operating systems (OS) and install I 04 Windows/Linux operating systems. 3 Use the various tools/utilities provided in the Windows/Linux I 04 operating system accessories. 4 Install printer, scanner, and projector with the computer system I 02 5 Create, share and Manage Files and Folders in Google Drive I 02 6 Create and design admissions/inquiries google form for students I 02 7 Create text documents with different formatting features, insert II 04 shapes, SmartArt, images, tables, set page layout and background according to the given examples. 8 Use the mail merge feature for sending invitation letters for an II 02 expert lecture to 10 industries. 9 Create spreadsheets, analyze data using formulas and functions, II 04 and present them in charts. 10 Create Pay bills/ Pay slips/ Electricity bills/student mark sheets II 04 using a spreadsheet and take a printout. 11 Create professional presentations with various formatting ii 04 features, insert tables and charts, use drawing tools, apply shape and picture styles, apply object borders, the object fills, and object effects. 12 Explore Scratch’s project editor interface. III 02 w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page 5 of 8 GUJARAT TECHNOLOGICAL UNIVERSITY Program Name: Diploma in Engineering Level: Diploma Branch: Information & Communication Technology / Electronics & Communication Engineering / Renewable Energy / Electrical Engineering Course / Subject Code: DI01000091 Course / Subject Name: Fundamentals of Information and Communication Technology (FICT) ___________________________________________________________________________ 13 Write a script to perform basic arithmetic operations. III 02 14 Write a script to simulate dice. III 02 15 According to Ohm’s law, When a current I flows through a III 02 resistance R, voltage across R is given by V=IR. Write a script that reads I and R and calculates V. 16 Write a script to find the value of V using the expression III 02 𝑉 = 𝐴 sin 𝜃 for a given value of A, ϴ (take the value of ϴ in degree). 17 Write a script that asks the user to enter a temperature in degrees III 02 Celsius. The script will convert the temperature to degrees Fahrenheit and display the result to the user with an appropriate message. (Hint: F° = (1.8 × C°) + 32.) 18 Write a script to draw a rectangle of given width and height. IV 02 19 Write a script to connect each of the following sets of points in IV 02 order to reveal the final shape: (20,-40), (-160,-40), (20,160), (140,-40), (20,-40), (20,-60), (- 120,-60),(-80,-100), (80,-100), (120,-60), (20,-60). 20 Write a script for pattern draw application with the following IV, V 02 instruction. a) Move the sprite 10 step forward when ‘Up Arrow Key’ is pressed b) Move the sprite 10 step backward when ‘Down Arrow Key’ is pressed c) Turn the sprite clockwise when ‘Right Arrow Key’ is pressed d) Turn the sprite anticlockwise when ‘Left Arrow Key’ is pressed 21 Write a script to draw a polygon for a given number of sides and IV, V 02 side length. 22 Write a script that asks the user to enter three numbers. The V 02 script will then determine and print the largest of the three numbers. 23 Write a script that calculates and displays the sum of all odd V 02 integers between 1 and 20. 24 Write a script to check whether the given number is prime or not V 02 and display an appropriate message. 25 Write a script to display the Fibonacci Series of 0 to N numbers. V 02 w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page 6 of 8 GUJARAT TECHNOLOGICAL UNIVERSITY Program Name: Diploma in Engineering Level: Diploma Branch: Information & Communication Technology / Electronics & Communication Engineering / Renewable Energy / Electrical Engineering Course / Subject Code: DI01000091 Course / Subject Name: Fundamentals of Information and Communication Technology (FICT) ___________________________________________________________________________ 26 Write a script to find the factorial of a given number. V 02 27 Write a script to count the number of vowels in a given string. V 02 28 Write a script to check whether the given number/string is V 02 palindrome or not and display an appropriate message. 29 Write a script to display days of a week using a list. V 02 30 Write a script to check whether a given string/number is in a list V 02 or not and display an appropriate message. 31 Write a script to find the maximum number in a list of numbers. V 02 32 Write a script to find the average value of a list of numbers. V 03 33 Write a script to perform a linear search in a list of strings. V 03 34 Write a script to count how many times an item appears in a list. V 03 35 Write a script to perform bubble sort in a list. V 03 Total 60 Hours List of Laboratory/Learning Resources Required: Sr. No. Equipment Name with Broad Specifications PrO. No. 1 Computer with basic configuration and Internet Facility All 2 Window/ Linux as operating system All 3 Word, Excel, and PowerPoint Software 7-11 4 Scratch Software (open source) 12-35 Suggested Project List: A suggestive list of micro-projects is given here. This has to match the competency and the COs. Similar micro-projects could be added by the concerned course teacher: 1. Use the Google app to prepare any feedback form on any topic given by the subject teacher, covering all the main features of Google Forms. 2. Prepare an MS word document on any subject given by the subject teacher, covering all the main features of MS word. 3. Use spreadsheets to prepare salary statements, tax statements, student assessment records, student expense systems, company income, and expense statements to determine profit and loss, covering all major features of MS Excel. 4. Prepare 15-20 slide presentations with department and institute information covering key features of MS PowerPoint. 5. Develop a small story and animation in scratch. w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page 7 of 8 GUJARAT TECHNOLOGICAL UNIVERSITY Program Name: Diploma in Engineering Level: Diploma Branch: Information & Communication Technology / Electronics & Communication Engineering / Renewable Energy / Electrical Engineering Course / Subject Code: DI01000091 Course / Subject Name: Fundamentals of Information and Communication Technology (FICT) ___________________________________________________________________________ 6. Develop a small game, simulation in scratch. Suggested Activities for Students: If any Other than the classroom and laboratory learning, the following are the suggested student-related co- curricular activities that can be undertaken to accelerate the attainment of the various outcomes in this course: Students should perform the following activities in group and prepare reports of about 5 pages for each activity. They should also collect/record physical evidence for their (student’s) portfolio which may be useful for their placement interviews: a) Undertake micro-projects in team/individually. b) Encourage Students for creating and designing forms related to Departmental work. c) Encourage students to participate in the Microsoft Office Specialist World Championship. d) Students are encouraged to register themselves in various MOOCs such as Swayam, edx, Coursera, Udemy, etc. to further enhance their learning. e) Undertake a survey of different graphical programming languages used to develop animations, mobile apps, games etc. ******* w.e.f. 2024-25 http://syllabus.gtu.ac.in/ Page 8 of 8