ITGS Online

‘hanging out the dirty linen’ to delve into the ethics of IT’s role in society.

Powered by Twitter Tools

Posted from Diigo. The rest of ITGSonline group favorite links are here.

Posted from Diigo. The rest of ITGSonline group favorite links are here.

Posted from Diigo. The rest of ITGSonline group favorite links are here.

Logo used by Wikileaks
Image via Wikipedia

Well Grade 12's as you are wading through those past papers - here is some light relief for you to get your teeth into and discuss...

A big story at the moment is that of Wikileaks closing down due to lack of funds when it is now being hailed as the only way forward for serious investigative journalism in the world! A serious statement but a very serious site. Have a read of the following articles and then comment and discuss on the issues, the technologies and whether you agree this is an important way forward or if it should remain closed or even be made illegal. If you do think it is important - why so and why now?

Looking forward to your comments and thoughts...(note Grade 11's you can join in as well!)

Image representing Prezi as depicted in CrunchBase
Image via CrunchBase

This is a much longer term assignment than the other one you are undertaking at the moment - and involves reading a book. Yes you did not here me incorrectly yes you will need to read a book - Yikes. During the coming lesson I will present you with a choice of books that all have ITGS related content and discussion but are in much more depth than anything you have read before. You will need to choose one (will tell you how that will work) and then over a period of weeks read it regularly. You will then need to publish a blog post every two weeks summarising the content and what the author is discussing and your points of view of the issues and IT systems described. The post should be specific especially in terms of describing IT systems involved.

The end game of the assignment- will involve a final presentation.

Here is the basics of what you will need to do for the final presentation What do you need to show? Well read on below for full information:-

  1. The final presentation will give everyone an overview in detail of the book you have read - with main chapter summaries, a review of the IT systems involved and the social and ethical issues.
  2. The presentation should stand alone to review the book - giving both the authors points of view and specific examples of their discussions.
  3. The presentation should conclude from a variety of stakeholders points of view the issues, and link this with your own thoughts.
  4. If your ideas and thoughts have changed during reading the book then please explain this transition.
  5. The presentations will be due on the Thursday 19th February - e.g. the Thursday after half term.
  6. The presentations must be able to be viewed upon the web (note it is not a video presentation but a slide based presentation) - example tools you might use are:- Slideshare (good for adding vocal overtop?), Empressr, Prezi (this one is supercool), authorstream, Zoho, Google Docs, Voicethread and many more. It is your choice to choose the best Web 2.0 tool to present your work. The work should be embedded on a weblog post, with a short explanation.
  7. You will also present this in front of the class - a rubric of assessment will be available from the preceeding week but will look at many areas including: quality of presentation, quality of arguments, quality of reviews, use of tool, understanding of issues, understanding and explanation of IT systems involved, simplicity of explanation, use of specific relevant examples...

BOOK Decisions - after much deliberation and cogitation here are the decisions based or maybe not based on your choices for book to read. Note Dr Tech's decision is final and is based on a rigorous and thoughtful process of skills based analysis linked with your choice/interest: -

Microsoft Excel on a floppy
Image by VoxPelli via Flickr

Using the skills that you will garner during the next week or so with creating tutorial/example based Excel Spreadsheets (yes for once we will use a normal application rather than some Web 2.0 based shenanigins), you must then choose a realistic project from one of your other subjects to design and create a spreadsheet for. Subjects that would probably be very sensible to choose might be Mathematics, Economics, Sciences, Design Technology, Drama etc... What productive function the spreadsheet does is up to you? It might create a test, it might plot a specific experiment and show results, it might be a booking sheet for a theatre or it might be a break even chart analysis? YOU decide.

You must however use a minimum of ten of  the following skills (that you will practice this next week or so) within your spreadsheet to make the design and so its workings as efficient and automatic as possible. You must also be able to discuss what each of these functions does and why you would use it:-

  1. Vlookup
  2. If Statement / Countif Statement
  3. Dynamic / Static Cell Referencing
  4. Charts
  5. Advanced Filters
  6. Basic Mathematical Formulas - Aveage, Sum, Max, Min,
  7. Macros (you will need to use Office 2004 on the Mac - Why?)
  8. Conditional Formatting
  9. Spinners
  10. Date/Time Functions
  11. Formatting, Titles and Buttons
  12. Validation/Verification
  13. Password Protection

Along with this, the spreadsheet should be well designed and user friendly with suitable instructions for a new user to be able to follow and understand what they are doing when it comes to inputting data and processing an output. The spreadsheet should have multiple sheets, and include a title page. Dr Tech will show you some examples of existing spreadsheets that fulfill the above purpose.

Make sure you test your spreadsheet models, as the assessment will be based on an unknown user/client attempting to use your spreadsheet without instruction from yourself.

To help you learn, I will provide a series of spreadsheet worksheets - but also you can find your own if you would like or use something like Atomic Learning - see around the room for login details. Deadline for your spreadsheet is on the Monday after the mid winter break so you do not have long - so use your time well this week to learn any new skills.

Related articles by Zemanta

Posted from Diigo. The rest of ITGSonline group favorite links are here.

Powered by Twitter Tools

Posted from Diigo. The rest of ITGSonline group favorite links are here.

Posted from Diigo. The rest of ITGSonline group favorite links are here.

Click here link to Wall

Posted from Diigo. The rest of ITGSonline group favorite links are here.

Well the demonstration was a funny and peaceful way to bring forward the issues - but what do you think watch the following videos and read up on the issue and then using sources comment on your position and ways forward - make sure to go the main webpage of the group as well.

 
icon for podpress  YouTube: Play Now | Play in Popup | Download

 
icon for podpress  YouTube: Play Now | Play in Popup | Download
« Previous Entries  Next Page »

Podcast Feeds

  • View in iTunes
  • Any Podcatcher
  • Any Feed Reader

Translate