CSE 1301 Consumer Computer Applications

The course is designed to make the students able to efficiently use MS Word, MS Excel and MS Access. It covers all the fundamentals of word processing. At the end students will know how to format the document, how to use styles, how to build tables of content and tables of figures, how to add foot notes and so on. The course will cover the fact of dealing with huge documents. The second part gives students a clear view of what Excel can do. It covers from basics to advanced concepts. At the end, students will be able to build an Excel document from its analysis to the implementation, to analyse data and to perform simulations using MS Excel. The third part introduces the notion of Relational database. It goes from the Entity-Relationship model to the physical implementation using MS Access. Students will learn how to design, implement, maintain and query a database. Starting with the notion of table we?ll go through queries, forms and reports. The goal is to be able to implement the database and then to be able to easily feed it with information. Finally we?ll see how to extract and process the information using light weight client such as Excel.