(CREDIT DISTRIBUTION, ELIGIBILITY AND PRE-REQUISITES OF THE COURSE Course | Crea | Credit aktribaion of the course | EIGIONNT | Prevequisve site Lecture Tutorial] Practical | ¥etterin | ofthe course actice (tay) a Pr Code. jase TT 2) oe |e 2 | 2 Pas | NIL ool Learai Objectives The Learning Objectives ofthis course aes follows + To enable sudents develop IT skills hat area pre-requisite in today's work ‘+ To equip them with basic computing sil that wil enhance their employability in general ‘+ To enblethe student to analyse and presen infomation ina meaning manne, “The Lemming Outcomes ofthis course ae as follows ‘+ By studying this couse, students willbe able to use word: rocessor to generate document wth appropriate formating, layout, review and reference ‘+ By studying this course, students willbe able to manage data in worksheet and workbooks and analyze i using speeadshet functions and inbuilt formulas. ‘By studying this course, stents will be able to draw analysis on data wing spreadsheets o make decisions + By studying this couse, students will be able to make meaningful representations of atin the form of charts nd pivot ables ‘+ Bystudying this course, students will beable to manage dain database tables and se the same for generating queries, forms and reports,SYLLABUS, Course Contents Unit 1: Introduction to Spreadsheets 4 Weets) Spreadsheets: Concept of worksheets and workbooks, creating, opening, closing and saving workbooks, moving, copying, inserting, deleting and renaming worksheets, working with rile worksheets and mulkile workbooks, ontoling worksheet views, naming cols using name box, name create and name define; Exchanging data using clipboard, abject inking and embedding; Printing and Protecting worksheets; Adjusting margins, creating headers and footers, sting page breaks, changing orientation, creating portable documents and pining data and formulae; Implementing fle level security and protecting data within the worksheet; Understanding absolute, relative and mixed referencing in formulas, referencing cells in other worksheet and workbooks, corecting common formula eors, working with inbuilt funtion categories like mathematical, statistical, text, lookup, information, logis, database, date and time and basi financial functions, Unit 2 Data Analysis in Spreadsheets (4 Weeks) Consolidating worksheets and workbooks using formulae and data consliate command Choosing chart ype, understanding data points and data series, editing and formating char clements, and cresting spackline graphics, Analysing data using pivot tables: Creating, Tormating and modifying a pivot table, sorting, trig and grouping itens, ccating calculated field and calculated item, creating pivot table chars, producing a reprt with pivot tbls Inivodutiono recording and execution of macros. Unit 3: Word Processing @ Weeks) Introduction: Creating and saving your document, displaying different views, working with styles and character formating, working with paragraph formatting techniques using inden, ‘abs, alignment, spacing, bullets and numbering and erating borders Page Setup and sections Setting page margins, orientation, headers and footers, end notes and fot noes, crating section breaks and page borders Working with wbles: Creating tables, modifing table layout and design, sorting, inserting graphics ina table, table math, converting text totale and vce versa; Create newspaper columns, indexes and table of contents, Spell check your document using inbuilt and custom dictionaries, checking grammar and style, using thesturus and findingand replacing text; Create bookmarks, eaptions and cross referencing, arg hyperlinks, adding sources and compiling and bibliography; Mail merge: Creating and editing your mun document and data souree, sorting and fering merged documents and using merge instructions like ask, Flin and if-then-else; Linking and embedding to kee things together. N¢Unit 4 Databases (4 Weets) Tnoduetion to Database Development: Datsbese Terminology, Objecs, Creating. Tables, working with fields, understanding Data types, Changing table design, Assigning Field Propetes, Sting Primary Keys using field validation and record validation rules, Indexing, working with muliple tables, Relationships & Integrity Rules, Join Propesies, Record manipulation, Soring & Firing; Select data with queries: Creating Query by dsien & by wizard (Select, Make Table, Append, Delete, Cross Teb, Update, Paramsterized Query, Find Duplicate and Find Unmatched), Creating mult table queries, creating & working with table Joins. Using operators & expressions: Creating simple & advance criteria; Working with forms: Creating Basi forms, working with bound, unbound and calculated consol, understanding property sheet, Working with Data on Forms: Changing Layout, creating Sub Forms, creating lst box, combo box and option group; Working with Reports: Creating Basic Reports, Creating Header & Footer, Placing Controls on report, sorting & grouping Creating Sub repors. EssentiaVrecommended readings ‘+ Swinford ., Dodge, M, Couch, A. Melion, B.A. (2013). Microsoft Office Professional 2013. United States: O'Reilly Media. ‘+ Wang, W. 2018). Office 2019 For Dummies. United States: Wiley. Microsoft Lambe, J 2019). Microsoft Word 2019 Step by Step, United Stats: Parson Education Suggestive readings + Jolen, B.2013).Exset 2013 Charts and Graphs. United Kinglom: Que, ‘Alexander, M, Jelen, B. (2013), Excel 203 Pivot Table Data Crunching, United Kingdom: Pestson Education. ‘+ Alexander, M, Kusleka,R. 2018), Access 2019 Bibl, United Kingdom: Wiley Examination scheme and mode: “Total Marks: 100 Teena Assessment: 28 Marks Practial Exam (lntemal): 25 Masks Ed Semester University Exam: $0 Marks ‘The Internal Assessment forthe course may include Class participation, Assignments, lasts, Projets, Field Work, Peseniatons, amongst others as decided by the acu Note: Examination scheme and mode shall be as prescribed by the Examination Branch, University of Delhi, from ti