COMP1000 Notices

Special consideration request for COMP 1000 final exam

Posted by Aarthi Natarajan Wednesday 27 June 2018, 11:10:54 AM.

Dear students,

If you had been unable to attend the final exam for COMP 1000 on the 25th of June due to illness or unavoidable circumstances , please fill out a special consideration request. Details on how to apply are provided at: https://student.unsw.edu.au/special-consideration

This form must be lodged within 3 working days of the assessment (Wednesday, 27th of June)

Students who are granted a special consideration will be allowed to sit the supplementary exam. Date of this exam will be advised later.

Note: The supplementary exam is not available to students who sat for the final exam and failed, but only to students who have officially requested special consideration and who did not sit the final exam.

MyExperience

Posted by Isaac Carr Thursday 07 June 2018, 06:35:28 PM.

Hi all,

MyExperience closes tonight. We would love to hear all of your feedback. Link here .

Thanks for the great sem.

Isaac.

Seating Allocation Final Exam

Posted by Isaac Carr Monday 28 May 2018, 09:34:16 PM.

Hi All,

Please check your seating allocation for the final exam: https://cgi.cse.unsw.edu.au/~cs1000/18s1/seating/final/register.cgi/allocations

Isaac.

Lab this week

Posted by Isaac Carr Monday 28 May 2018, 09:30:20 PM.

Hi all,

Just a reminder that in your lab this week, we will give you 1hr to complete the practice paper uploaded under labs, and in the second hour, we will go through the solution. It is also a good opportunity to clarify anything issues you may have.

Another gentle reminder that MyExperience is open. Please take the time to fill it out - we love to hear about your thoughts on the course - what you liked, what you didn't, and what we could do to better in the future.

Isaac.

MyExperience

Posted by Isaac Carr Saturday 26 May 2018, 12:50:48 PM.

Hi all,

It would be greatly appreciated to hear your feedback of COMP1000 for this semester. We are always looking at ways of improving the course - in terms of teaching methods and content.

Head to MyExperience (https://myexperience.unsw.edu.au/) to review us.

Thank you for an awesome semester!

Isaac.

Midsemester Exam Marks

Posted by Isaac Carr Sunday 06 May 2018, 02:52:44 PM.

Hi all,

You should be able to see your midsemester exam marks now. Let me know if you have any problems.

If you did not pass the exam, you can still pass by performing satisfactorily in the final exam.

Isaac.

Consultations for MS Access

Posted by Ali Darejeh Sunday 29 April 2018, 01:23:59 AM.

Dear All,

The consultations for MS Access will be held on Mondays from 2-3 in K17, ground floor, room G02.

See you.

MS Office pro free download

Posted by Ali Darejeh Thursday 26 April 2018, 11:18:49 PM.

Hi All,

In order to do MS Access exercises at home, please download MS Office pro from UNSW website.

https://student.unsw.edu.au/notices/office

If you missed the exam yesterday...

Posted by Isaac Carr Wednesday 25 April 2018, 11:34:31 AM.

If you missed the exam yesterday, you must apply for special considerations through myUNSW. You must apply within 3 working days of yesterday.

Isaac.

Good luck!

Posted by Isaac Carr Tuesday 24 April 2018, 09:07:55 AM.

Good luck for today everyone. I have faith in you al!

I will be wearing a bright yellow shirt if you have any questions - feel free to stop and ask me if you see me walking around. I will be outside of the exam rooms from roughly 3.45pm.

Isaac.

Midsemester Exam details

Posted by Isaac Carr Sunday 22 April 2018, 08:27:31 PM.

Hi all,

Here is somewhat of an FAQ and update on the midsemester exam.

• Please check your seating allocation and ensure you arrive at 4pm on Tuesday out the front of your allocated lab: http://www.cse.unsw.edu.au/~cs1000/18s1/seating/midterm.html
• You will be using the lab computers, so please make sure you are familiar with using that environment. You will be using Notepad to edit your HTML document - there is no predictive text or colour coding.
• There is a consultation tomorrow from 1-2pm at K17 G01
• There will be a HTML/CSS reference sheet - check it out here: https://webcms3.cse.unsw.edu.au/COMP1000/18s1/reso...

My tips:

• Watch the week 7 lecture as I go over the exam content
• Be comfortable with all labs and lecture content

The exam itself:

• 1hr30mins exam with 10min reading time
• Mark break down:
• 15 marks - 15 multiple choice questions (both Excel and Web)

• 20 marks - practical Excel: there will be 3 sections to answer

• 15 marks - practical Web: you will have to construct a functional webpage

Good luck everyone!

Consultation Week 8

Posted by Isaac Carr Sunday 22 April 2018, 06:00:47 PM.

Hi all,

I will be having the last consultation before the Midsemester Exam tomorrow at 1-2pm at K17 G01. Please come along if you have any questions. I will send out a notice clarifying a few details about the exam.

Isaac.

Lecture after the Mid semester exam

Posted by Ali Darejeh Sunday 22 April 2018, 03:27:44 AM.

Dear All,

We will have a one-hour lecture after the mid semester exam on Tuesday 24/4/2017 at 6 pm. Please try to attend the lecture as we want to finalise the topic of database tables which is related to the next lab exercise.

Good luck with your midterm exam.

Midsemester Exam Seating Allocation

Posted by Isaac Carr Wednesday 18 April 2018, 10:40:43 PM.

Hi all,

This is your seating allocation for the midsemester exam: http://www.cse.unsw.edu.au/~cs1000/18s1/seating/midterm.html

Please arrive and wait outside the lab at 4pm next Tuesday.

Isaac.

MS Access Lectures

Posted by Ali Darejeh Monday 16 April 2018, 11:27:46 PM, last modified Wednesday 18 April 2018, 10:13:36 PM.

Dear All,

My name is Ali the lecturer of the database part using MS Access. We will have 6 lectures as described below:

• Week 7 (2 hours): 1 hour mid-term exam review + introducing database management systems and database tables.
• Week 8 (1 hour): 1:30 hours Mid-term exam + tables relationship and import & export data.
• Week 9 (3 hour): Creating queries to get desirable data from tables.
• Week 10 (3 hour): Queries advanced topics & Creating forms to make professional input/output interface for the tables.
• Week 11 (3 hour): forms advanced topics & Creating reports to make the printable version of tables’ data.
• Week 12 (1 hour): MS Access Review + 2 hours final exam review and hints.

See you in the lecture.

Week 7 Consultation & Lab06

Posted by Isaac Carr Friday 13 April 2018, 11:14:14 PM.

Hi all,

I have released lab06 a day early and will be due in Week 8. It shouln't take you a long time but JavaScript may be slightly tricky. Please let me know if you have any questions.

Also, the consultation for next week will be Thursday 10-11am in G01 K17.

Isaac.

Week 6 Consultation

Posted by Isaac Carr Tuesday 10 April 2018, 08:55:59 PM.

Hi all,

This week's consultation will be tomorrow from 10-11am in K17 G01.

Isaac.

lab05 released

Posted by Isaac Carr Sunday 08 April 2018, 07:38:38 PM.

Hi all,

Lab05 is released. It is due during your week 7 lab time.

Send me an email if you have any problems/concerns.

Alternative Week 4 Lecture

Posted by Isaac Carr Saturday 07 April 2018, 10:13:54 PM, last modified Saturday 07 April 2018, 10:15:51 PM.

Hi all,

We are all aware that the Week 4 lecture green-screened. As a result, I went through the same content in Week 5. However, if you feel that is not enough, I have also gone through similar content for another course. This is it:

https://youtu.be/0s37dnZQ9A4

Isaac.

Today's Lecture

Posted by Isaac Carr Tuesday 27 March 2018, 09:26:58 PM.

Hi all,

This week's lecture was successfully recorded and recapped everything we went through last week. Please try and watch it ASAP and email me if you have any questions. Don't forget consultation is tomorrow at 10-11am at G01 in K17.

Isaac.

Week 5 Consultation

Posted by Isaac Carr Thursday 22 March 2018, 09:04:48 PM.

Hi,

Last notification for the evening (I hope).

The week 5 consultation will be on Wednesday at 10-11am at G01 of the K17 building.

Isaac.

General HTML Updates: Template.html, Safari & TextEdit for Mac

Posted by Isaac Carr Thursday 22 March 2018, 09:03:52 PM.

Hi all,

1. Template.html

There is no problem with template.html for lab04. You need to right click on the page and select "view page source" to see the code you need to copy and paste.

2. Safari

It has been brought to my attention that Safari does not come with the "view page source" immediately. Follow these instructions to get it to work: http://www.socialmeteor.com/2013/03/04/how-to-view-html-source-in-safari-web-browser/

3. TextEdit for Mac

There has been some problems that if you write a HTML page in TextEdit on Mac, it will display the code rather than render the web page. If you follow these instructions, you can fix that: https://www.w3schools.com/html/html_editors.asp

Let me know if you have any other concerns.

Lecture Recording Malfunction

Posted by Isaac Carr Thursday 22 March 2018, 08:56:20 PM.

Hi all,

This week's lecture got recorded as a green screen because apparently the Mac OS doesn't like you recording the screen via HDMI. Next week it will definitely work.

At this stage, I am trying to work out a solution for those of you that missed the lecture. I did film a one-hour version of what I went through for another course which definitely worked, so I'm trying to get access to that.

For the moment, I have the lecture slides and examples uploaded. I understand this is frustrating because you have no experience with HTML/CSS. I am trying to get something happening. I will come get something up.

Do the exercises using the windows version of MS Office

Posted by Ali Darejeh Monday 19 March 2018, 12:10:06 AM.

Dear All,

Since for your Mid-term and final exams you need to work with the windows version of MS Office, we strongly suggest you to do the exercises using the windows version of Excel and Access as the software layout is a bit different in the Mac version. For example in this week exercise drawing pivot chart is different in the mac version in comparison with the windows version of Excel.

Good luck.

lab04 released ** PLEASE READ **

Posted by Isaac Carr Sunday 18 March 2018, 09:05:49 PM, last modified Sunday 18 March 2018, 10:24:27 PM.

Hi all,

I have released lab04. It is your first lab for the web component of the course.

It is worth 20 marks and will be due in your allocated lab time in Week 6 . You are encouraged to attend your week 5 lab and get any help you may need with it.

As Friday, 30th of March is a public holiday, those in my Friday labs are allowed to another lab time during the week.

Let me know if you have any questions.

Isaac.

Week 4 Consultation

Posted by Isaac Carr Saturday 17 March 2018, 10:03:33 PM.

Hi all,

This week's consultation will be on Monday at 1-2pm in K17 G01 .

Excel in the News

Posted by Isaac Carr Thursday 15 March 2018, 09:28:01 AM.

Let's enter next year: https://nypost.com/2017/08/07/theres-a-world-championship-for-excel-spreadsheets/

lab03 released

Posted by Isaac Carr Sunday 11 March 2018, 07:03:33 PM.

Due during your week 4 lab. Send me an email or post on the forum if you have any concerns. See you Tuesday!

Lecture Demonstration Spreadsheets

Posted by Isaac Carr Saturday 10 March 2018, 08:28:10 AM.

Hi all,

I've uploaded the spreadsheets that I went through in the lecture - both the empty and filled in versions.

Isaac.

Consultation Week 3

Posted by Isaac Carr Friday 09 March 2018, 06:56:53 PM.

Hi all,

Consultation will be at 10-11am on Wednesday at K17 G01.

Isaac.

Lab01 Operating System Clarification

Posted by Isaac Carr Sunday 04 March 2018, 09:11:38 PM.

Hi all,

Some of you have expressed concerns about downloading and using Linux operating system. You do NOT need to download or use Linux in any way, shape or form in this course. When you follow the

<u>Pre-task 1, 2</u> and <u>Task 1</u> of Lab01 only apply if you use the CSE lab computer in the lab. The instructions allow you to log into the COMP1000 environment, which is Windows 10. You do not need to touch Linux.

• <u>Pre-task 1</u> shows you step-by-step how to log into the COMP1000 Windows 10 environment in the lab
• <u>Pre-task 2</u> shows you how to save your work if you wish to use the lab and not lose your work. You may also wish to save your work to a USB, a cloud service (such as Dropbox or iCloud) or email it to yourself.
• <u>Task 1</u> is a suggested method of saving your work.

If you are using your own laptop, you only need to download Office 2016 from the uni. You can save your work however you like on your laptop. The aforementioned instructions are only if you are using the lab computer.<u></u>

Please email me (i.carr@unsw.edu.au) if this doesn't make sense.

Isaac.

Lab02 Now Released

Posted by Isaac Carr Sunday 04 March 2018, 08:50:27 PM.

Hi All,

Lab02 is now released. It will be due in your Week 3 lab.

A reminder that labs start this week, and you need to have lab01 marked off by the end of your allocated lab time.

Good luck!

Isaac.

Week 2 Consultation

Posted by Isaac Carr Friday 02 March 2018, 09:29:49 AM.

Hi all,

Next's week consultation will again be on Wednesday (March 7), in G01 on the ground floor of K17 (CSE Building).

Isaac.

Lab clarification

Posted by Isaac Carr Wednesday 28 February 2018, 11:17:12 PM.

To clarify some questions about the lab work.

You are expected to, at least, start the lab work each week before entering your allocated lab time. If you start the work at the beginning of the lab, you are likely to not finish, and hence lose marks for that week.

You can either (a) start on your own computer (if your laptop has Excel 2016) or (b) the lab computer. You are welcome to welcome to use any CSE lab computer (http://taggi.cse.unsw.edu.au/FAQ/CSE_lab_map/) so long as there isn't another lab going on when in that specific lab at any time. You can save it to your student drive (Z:) and then continue working on it later. You can also do the work on your own laptop.You can also demonstrate your work to tutor on (a) your laptop or (b) the lab computer. If the work is correct and you are using Excel 2016, you will get the marks.

But Isaac, why make us use the lab computers?

You will be doing your mid-semester and final exams on the lab computer. This has two consequences:

1. The lab computer may or may not support a way you're used to doing a specific task, so you need to be familiar Excel version on the lab computer. The differences in versions is minimal for Office 2016 compared to previous versions of Office, however, you still need to be careful.

2. Unlike writing an essay under time, computing exams can be stressful because you might only be missing a single comma, but you might have the complete wrong results, and then as soon as you add that comma, you get everything perfect. Computing exams can be hard to judge time, and hence cause stress. So if you're familiar with using lab computer, it's one less thing you have to worry about before exams.

Let me know if you have any questions.

Moodle & Lecture Recordings

Posted by Isaac Carr Wednesday 28 February 2018, 01:14:28 PM.

Hi all,

I believe the Moodle page is now up and running. The lecture recordings should now be available. Please let me know if this is not the case.

Isaac.

PS - sorry for the spam with notices. First week is always a mission from an admin perspective.

Consultation, Week 1 Review & Updates

Posted by Isaac Carr Tuesday 27 February 2018, 10:53:48 PM.

Consultation: This is a reminder that there will be a consultation tomorrow at 10-11am at G01 on the ground level of K17 (Computer Science building). Feel free to come by if you have any questions.

Lecture 1 Review:

- Reminder that this is the WebCMS3 (this site) will be the place where everything is stored/shared/accessed.

- Moodle will have the lecture recordings, but is not currently set up. I hope to have this done by the end of the week.

- Labs start next week . Please start lab01 prior to entering the lab. You need to be finished and marked off by your demonstrator in your week 2 lab.

- Lecture notes are now up.

Welcome to COMP1000!

Posted by Isaac Carr Monday 26 February 2018, 04:31:43 PM, last modified Tuesday 27 February 2018, 11:48:12 AM.

Hi students,

My name is Isaac and I will be your lecturer for the first 7 weeks of the course. I would like to extend a warm welcome to COMP1000 18s1!

This course runs is three parts: Microsoft Excel, WWW, and Microsoft Access. It aims to give you an introduction to computing, and the three powerful tools that will empower you for your future studies and careers.

WebCMS3 is the platform used to administer the course. If you have any questions about anything, feel free to post it on the course forum . Prior to our lecture tomorrow in Columbo C Lecture Theatre, I recommend checking out the course outline . Also check out the class timetable .

This week, the consultation will run Wednesday 10-11am in K17 Ground Floor, Room G01 Consultation Room.

While labs don't start until next week, lab01 has been released and is due in your week 2 lab. Make sure you start on it before your allocated lab time.

See you tomorrow!

Isaac.