Skip navigation.

CSI1201

No public posts in this group. You must register or login and become a subscriber in order to post messages, and view any private posts.

CSI 1201: Applications on Micro-Computers

Introduction
This course is designed to introduce students to the most commonly used software packages and the concepts around software usage. It is also intended to teach students to build web pages and to write simple computer programs.

Objectives
By the end of the course students will be able to:

1. Use Microsoft Office Software to create documents, spreadsheets, PowerPoint Presentations and databases.
2. Design a web page using HTML.
3. Write computer programs using JavaScript.

Credits: 4
Pre-requisites: None

Lecturers:

- Fannita DeJesus-Barakat
- Penelope DeFreitas
- Aurel Liddell
- Lenandlar Singh

Assessment:
* Course Work - 40%
* Final Exam 60%

Lecturers: Penelope DeFreitas, Girendra Persaud, Aurel Liddel, Fannita DeJesus-Barakat

Contents

Introduction
1. Characteristics of hardware components of a computer
2. GUIs versus the console
3. File and directory management

Word Processing
4. Creating, editing, saving, retrieving and printing documents
5. Formatting and enhancing texts
6. Using the speller and thesaurus
7. Working with blocks of text
8. Text columns and tables
9. Integrating text with graphics and line drawings
10. Mail Merge

Assessment 1

Spreadsheets
11. Creating a simple spreadsheet
12. Moving and copying data, inserting and deleting rows and columns
13. Creating graphs
14. Sorting, querying and extracting data from a spreadsheet
15. Working with formulas
16. Using objects

PowerPoint and Presentations
17. Creating a simple PowerPoint presentation using slides
18. Formatting slides and using templates
19. Integrating different media into PowerPoint presentations
20. Importing data into PowerPoint slides from external sources (MS Excel)

Database Management Systems (DBMS)
21. Database Management System concepts and relational DBMS
22. Database design principles
23. Tables, relationships, primary and foreign keys
24. Creating a database and entering data using forms
25. Queries
26. Creating and printing reports

Assessment 2

Webpage Design and Development
27. Introduction to the Internet and the World Wide Web (WWW)
28. Introduction to HTML syntax: elements, attributes and entities
29. Block elements and inline elements
30. Hyperlinks, images, tables
31. Frames
32. XML

Assessment 3

Programming
33. Introduction to programming and programming languages using JavaScript
34. Programming language basics: declarations, data types: numbers, strings, booleans
35. Expressions and assignment statements
36. Data input and event-based programming
37. Conditional operators and loops
38.Functions

Assessment 4

Recommended Text
Beekman, George. Computer Confluence: Exploring Tomorrow's Technology. Upper Saddle River, New Jersey: Prentice-Hall, 2003. (Companion website: www.prenhall.com/beekman)

Suggested Reading
1.Du Preez, Angela and Vaughan Van Dyk. Computer Hardware and Software. Pearson Education, South Africa.
2008.
2. Kalicharan, Noel. An Introduction to Computer Studies. Cambridge University Press, 1988.
3. Snyder, Lawrence. Fluency with Information Technology. Addison Wesley, 2004. ISBN 0-201-75491-6. (Companion
website: wps.aw.com/aw_snyder_fluency_1)
4. PC Magazine
5. PC Novice
6. Any Beginners book on HTML, XHTML & JavaScript

Websites:
- http://www.w3.org
- http://www.w3schools.com
- http://www.google.com can be used to search for related resources.

Syndicate content