Course Outline

Contents

• Course Details
• Course Summary
• Assumed Knowledge
• Student Learning Outcomes
• Teaching Strategies
• Teaching Rationale
• Student Conduct
• Assessment
• Course Schedule
• Resources for Students
• Course Evaluation and Development

Course Details

Course Code	COMP1000
Course Title	Web, Spreadsheets and Databases
Convenor / Admin	Ali Darejah
Lecturer	Ali Darejah
Contact for the Course	ali.darejeh@unsw.edu.au
Classes	Timetable for all classes
Consultations	TBD
Units of Credit	6
Course Website	https://moodle.telt.unsw.edu.au/course/view.php?id=51309
Handbook Entry	http://www.handbook.unsw.edu.au/undergraduate/courses/current/COMP1000.html

Course Summary

This course will explore fundamental concepts of spreadsheets, databases, and web development using HTML5 and content management system. This course attempts to provide students with practical skills one needs to have when using Microsoft Excel (as a powerful spreadsheet software), Microsoft Access (as a commonly used database software), and HTML5 and CSS3 as the base languages for web development and their application in content management system

Besides lectures, weekly exercises will help you to put into practice the knowledge acquired from lectures; ultimately leading to the outcome that you will be able to develop web, spreadsheet and database applications.

Assumed Knowledge

COMP1000 is intended for students with no prior tertiary study of computer science. Many, perhaps most, students who take COMP1000 do so in part to meet the UNSW General Education requirement.

Student Learning Outcomes

After completing COMP1000, students should:

• Understand the computational concepts underlying modern spreadsheet and database applications.
• Be able to design and implement sophisticated spreadsheet and database applications.
• Have an informal and yet technically sound knowledge of the fundamentals of HTML 5, CSS 3 and World Press content management system, understand how they work and be able to build your own simple web sites.

Teaching Strategies

1. Lectures will provide a detailed description of content along with examples and videos related to the key learning areas, namely spreadsheets, web design and databases. There are two 2-hour lectures each week from 1 to 10.
2. Laboratory exercises provide an opportunity to practice the skills learned in lectures using a step-by-step instruction. These weekly lab exercises should be submitted online and your submissions will be marked by your tutor. You will also be given a chance to ask any questions you might have about these exercises and get feedback from your tutors before submission.
3. Textbooks and reference books provide supplementary material, and/or a slightly different point of view on the technical material.
4. Consultation sessions give students an opportunity to ask the lecturers, one-on-one, specific questions about any of the course material that they might be uncertain about;
5. Assignments are designed to enable students to put to practice the concepts they learn in this course in practical projects related to the 3 course content areas.

Teaching Rationale

The lectures and labs together are structured to present and reinforce concepts and techniques required for developing applications involving web design and building of databases and spreadsheets.

Student Conduct

The Student Code of Conduct ( Information , Policy ) sets out what the University expects from students as members of the UNSW community. As well as the learning, teaching and research environment, the University aims to provide an environment that enables students to achieve their full potential and to provide an experience consistent with the University’s values and guiding principles. A condition of enrollment is that students inform themselves of the University’s rules and policies affecting them, and conduct themselves accordingly.

In particular, students have the responsibility to observe standards of equity and respect in dealing with every member of the University community. This applies to all activities on UNSW premises and all external activities related to study and research. This includes behavior in person as well as behavior on social media, for example Facebook groups set up for the purpose of discussing UNSW courses or course work. Behavior that is considered in breach of the Student Code Policy as discriminatory, sexually inappropriate, bullying, harassing, invading another’s privacy or causing any person to fear for their personal safety is serious misconduct and can lead to severe penalties, including suspension or exclusion from UNSW.

If you have any concerns, you may raise them with your lecturer, or approach the School Ethics Officer , Grievance Officer , or one of the student representatives .

Plagiarism is defined as using the words or ideas of others and presenting them as your own. UNSW and CSE treat plagiarism as academic misconduct, which means that it carries penalties as severe as being excluded from further study at UNSW. There are several on-line sources to help you understand what plagiarism is and how it is dealt with at UNSW:

• Plagiarism and Academic Integrity
• UNSW Plagiarism Procedure

Make sure that you read and understand these. Ignorance is not accepted as an excuse for plagiarism. In particular, you are also responsible that your assignment files are not accessible by anyone but you by setting the correct permissions in your CSE directory and code repository, if using. Note also that plagiarism includes paying or asking another person to do a piece of work for you and then submitting it as your own work.

UNSW has an ongoing commitment to fostering a culture of learning informed by academic integrity. All UNSW staff and students have a responsibility to adhere to this principle of academic integrity. Plagiarism undermines academic integrity and is not tolerated at UNSW. Plagiarism at UNSW is defined as using the words or ideas of others and passing them off as your own.

If you haven't done so yet, please take the time to read the full text of

• UNSW's policy regarding academic honesty and plagiarism

The pages below describe the policies and procedures in more detail:

• Student Code Policy
• Student Misconduct Procedure
• Plagiarism Policy Statement
• Plagiarism Procedure

Assessment

The key assessment criteria are outlined below in the table below. A satisfactory performance is required in all the three components in order to satisfactorily pass the course

Assessment	Topics	Due	Marks
Labs	All topics	Due every week (from Week 2 to Week 11)	10%
Excel assignment	Topics on Weeks 1-4	Friday Week 5 @23:59	30%
Access assignment	Topics on Weeks 5,7,8	Friday Week 9 @23:59	15%
Web assignment	Topics on Weeks 9-10	Friday Week 11 @23:59	15%
Final exam	All topics	Exam Period	30%

Final Mark

Your final mark for this course will be computed using the above assessments as follows:

Mark for the lab	out of 10
Mark for Excel assignment	out of 25
Mark for Access assignment	out of 15
Mark for Web assignment	out of 15
Final Exam	out of 30
Course_Work_Mark + Excel_assignment_Mark+Access_assignment_Mark+ Web_assignment_mark	out of 100
FL, if FinalMark < 50/100 PS, if 50/100 ≤ FinalMark < 65/100 CR, if 65/100 ≤ FinalMark < 75/100 DN, if 75/100 ≤ FinalMark < 85/100 HD, if FinalMark ≥ 85/100	Final-Grade

Lab exercises

Each lab exercise is designed to develop practical skills related to the topics covered in the lecture. Labs will commence in Week two. The lab specification for each week:

• will outline the criteria by which lab marks will be assigned
• will be uploaded in the week prior to submission due date

Each lab exercise is due on Friday of the week after it is released e.g., exercise released in Week 1 is due on Friday Week 2. All lab work will be marked by the tutors. Please use the lab time to seek any help you might need with the issues with your exercise.

Late submission of labs is not permitted.

Special Consideration

If your work in this course is affected by unforeseen adverse circumstances, you should apply for Special Consideration through MyUNSW, including documentation on how you have been affected. If your request is reasonable and your work has clearly been impacted, then

• for a practical lab session, you may be granted an extension
• for the final exam, you may be offered a Supplementary Exam

Note the use of the word "may". None of the above is guaranteed. It depends on you making a convincing case that the circumstances have clearly impacted your ability to work.

If you are registered with Disability Services, please forward your documentation to Ali Darejah within the first two weeks of semester.

Course Schedule

Week	Lecture	No Labs
1	Spreadsheets: Introduction to Excel 2019, spreadsheet basics, formulas and functions	-
2	Spreadsheets: Charts, Tables and Filtering data	Lab 1
3	Spreadsheets: Pivot tables, pivot charts	Lab 2
4	Spreadsheets: What-if analysis	Lab 3
5	Databases: Managing database tables to store data in Access 2019	Lab 4
6	Break (No lecture), Just submit your lab work online.	Lab 5
7	Databases: Advanced queries and creating forms to make professional input/output interface for the tables	Lab 6
8	Databases: Creating reports to make printable version of table's data	Lab 7
9	Web: Introduction to HTML 5 / CSS	Lab 8
10	Web: Content management system using World Press	Lab 9
11	Submit the lab exercise + submit the web assignment	Lab 10

Resources for Students

Details are below for many of these - follow the links:

• The reference textbooks provide detailed reference material on functionality available Access and Excel.
• The reference books provide further detail.
• Lecture Notes can be accessed, as they become available The lectures provide a guide to, and exposition of, the course material. The lecture notes provide a fairly comprehensive summary of what is said in the lectures, additional comments may be made in lectures that are not covered in the lecture notes, and you are responsible for finding out about anything extra that was said in lectures, if you happen to miss the lecture.
• Laboratory Classes . A theoretical understanding of the material is not enough: to get a firm hold on the course material, you need hands-on experience. The lab classes provide this.
• Your fellow students - get to know them and talk to them - because they, like you, are committed to learning about web, spreadsheets and databases, they can help you to learn, and, by doing so, they will help clarify concepts for themselves. Just remember to stay on the right side of the plagiarism rules , when discussing assignments.
• The Message Board (forum)- which potentially has contributions from both staff and students is accessible via the course web page (Moodle).
• Consultation sessions with the lectuerer.

Recommended Reference Books

Recommended books for the course include:

• Excel 2019 Bible - by Michael Alexander, Richard Kusleika, John Walkenbach
• Access 2019 Bible - by Michael Alexander, Richard Kusleika
• A Smarter Way to Learn HTML & CSS: Learn it faster. Remember it longer - by Mark Myers

Course Evaluation and Development

The survey responses of the course offering in T2 2019 indicated the highest level of satisfaction in the School of computer Science. We are committed to implement the same teaching strategy but we have used student feedback to improve on the assessment pieces. We have replaced the mid-course which were based on two components of the course, with an assignment after each component. Also, the final exam mark is decreased from 75% to 30% to have more focus on the assignment and to work on projects that are practical with real-world outcomes.

This course will be evaluated at the end of the session using the myExperience system. Closer to the end of the semester, students will receive an email inviting them to provide feedback on the course offering. It is important that students complete the survey to ensure continuous, ongoing improvement of the course.