Course Title: Operate a personal computer
Part B: Course Detail
Teaching Period: Term1 2010
Course Code: COSC5379C
Course Title: Operate a personal computer
School: 155T Life & Physical Sciences
Campus: City Campus
Program: C3209 - Certificate III in Science
Course Contact : Geoff Moss
Course Contact Phone: +61 3 9925 4852
Course Contact Email:email@example.com
Name and Contact Details of All Other Relevant Staff
Nominal Hours: 20
Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.
Pre-requisites and Co-requisites
The use of a range of functions with a variety of software applications will enable students to become more competent in their use of the computer. While this course defines the competency required to start up, identify and select icons, correctly navigate and organise the desktop environment and use a range of functions, it is used to support other courses within the Certificate 111 Science program. Students will develop PowerPoint presentations and Excel spreadsheets in relation to other courses while developing the necessary skills for their personal use.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title:
ICAU1128A Operate a personal computer
Students will develop competency in the basic operation of a computer and the maintenance of directories and sub-directories.
They will also learn how to use, and develop skills in using, the software packages: MS Word, MS Excel and MS PowerPoint to produce documents and reports.
The use of a range of functions with a variety of software applications will enable students to become more competent in their use of the computer.
Students will develop PowerPoint presentations and Excel spreadsheets in relation to other courses while developing the necessary skills for their personal use.
Details of Learning Activities
Activities in this course is aimed at enhancing student skills in the use of their personal computer to meet the needs of their program in Certificate III in Science. Depending on the initial skills of the students, activities will be varied to meet the skills of students and the requirements in other courses.
Students will learn the basic functions of operating a personal computer, including saving files; copying files; management of their files and folders; management of the desktop and the creation of desktop shortcuts; etc.
Students will learn how to crop images (and/or text) and wrap text around images to improve their presentation of reports and assignments in other units within the Cert. III in Science course.
Students will produce a PowerPoint presentation for their Cell Biology course which will be assessed in both this course and Cell Biology. The task will involve Internet research on a topic assigned in the Cell Biology class and the preparation of a PowerPoint presentation in this course. The student will be expected to deliver a talk (of approx. 5 minutes duration) with the presentation. They will be required to produce notes within their presentation.
Students will learn the basic arithmetic operators in Excel as well as drag and fill functions, relative and absolute cell referencing. As students progress they will also learn IF and nested IF functions, Lookup functions and produce charts for the visual presentation of results produced in their Excel spreadsheets. A range of problem-solving tasks will be presented to test the student’s understanding of Excel and its basic functions.
The teaching of this course and the course titled: Information Using a Web Browser and Email (COSC5380C) will be taught and assessed throughout the semester, rather than being a term-long unit. The teaching schedule is for both courses as they are taught conjointly throughout the semester.
The teaching schedule is a guide only and will be amended as needed by the student group and the requirements of related courses within the Cert III in Science program.
|1||Introduction. Basic operation of computer; file and folder management||Windows Explorer||As per class handout||Practicals|
|2||Internet search; search engines. Copying and cropping images. Text wrap; layout of documents for reports||Browser; search engines; MS Paint; MS Word||As per class handout||Assignment 1|
|3||Introduction to PowerPoint||MS PowerPoint; search engine|
|4||Inserting YouTube videos into PowerPoint presentations||Google search engine; YouTube; MS PowerPoint||As per class handout||Practical|
|5||PowerPoint presentation development||YouTube; MS PowerPoint||Practical|
|6||PowerPoint presentations||MS PowerPoint||Assignment 2|
|7||PowerPoint presentations||MS PowerPoint|
|8||Internet Research; Copyright; Privacy; Security||Browser; search engines|
|9||Communication on the Internet research||Browser; search engines||As per class handout|
|10||Communication on the Internet PowerPoint presentation||Browser; search engines; MS PowerPoint|
|11||Excel basic functions||MS Excel||As per class handout; S:Drive Excel folder||Assignment 3|
|12||Excel: If and Lookup functions; Charts; dynmaic linksto MS Word||MS Excel; MS Word||As per class handout; S:Drive Excel folder||Excel Practicals|
|13||Excel: Problem-solving exercises||MS Excel||As per class handout; S:Drive Excel folder|
|14||Excel Assignment||MS Excel||Excel Assignment|
Varied resources will be available on the student share drive (S: Drive) and the Learning Hub as the semester progresses.
Various classroom handouts.
PowerPoint presentations presented in class.
Overview of Assessment
Assessment will consist of the following:
- PowerPoint presentations and talk
- Practical tasks
- Problem-solving activities
- Assignment 1: Search Engine – Print Screen, Crop, Image placement
- Assignment 2: Cell Biology PowerPoint presentation and talk.
- Assignment 3: Communication on the Internet PowerPoint presentation
- Excel practical tasks
- Excel assignment
|Element||Assignment||Practical Tasks||Observation||Class Testing||Individual/Group Discussion|
For information on late submission of work or absence on the day of assessment, please go to the Program site on the Learning Hub for C3209 Certificate III in Science or contact the Program Co-ordinator, Judi Mc Cann.
Course Overview: Access Course Overview