Hi all,
Well the results are in for the Spreadsheet Usability challenge - and here they are. So as usual the winner will receive a Perky Prize and congratulations to Klanec for tackling the Google Spreadsheet limitations and coming out on top!
| 56 Cornelius |
| 70 Twiggy |
| 75 Klanec |
| 66 SkySteel |
So a reminder of things happening over the next few weeks :-
- Deadline today - for the Paper 2 iPAD article and assignment. As always should be a GDOC shared with me - no excuses Cornelius.
- Discussion of which To Do App - you have decided to use. Write a blog post about initial two weeks of using the iPAD - looking at positives and negatives.
- On Thursday for 30 minutes after school from 3:20 - you the "ACS Egham Genius Bar Crew" will be helping with the teachers iPAD Workshop session - will chat more in class about things we will be covering.
- Finally it looks as if we will be going ahead with the initial iPAD intros to the rest of Grade 11's with one 40 minute session in Thursdays TOK, and then two sessions for the other two groups in Fridays TOK. Note these will be similar to our initial sessions - where we will be getting students to change passcode, join or show how to join to iTunes, setup Google account and shared calendar... and some chat from me. So be prepared for Thursday and Friday during TOK - note the students will not be taking them yet very similar to you until they have the basic training.
- Read through Chapter 6 - Graphics and Multimedia and make notes that you share with me - either through Notability, Google Docs or other format of your choosing.
- Next class we will be discussing Authenticity related to Graphics and Chapter 6 - and then their will be two small assignments related to the Graphics content. More to follow...
AND FINALLY the week after next we will introduce the MAIN PROJECT...
I will be bringing together quarter and semester grades next week. For the Quarter grade you will need to make sure the following work below is finished by the revised deadlines. The Semester grade will be a combination of the first two quarters and your exam grade.
WORK TO BE COMPLETED
1) SPREADSHEET Assignment - Tuesday 10th Jan
Remember - your spreadsheet assignment will be graded using the following criteria - UsabilitySpreadsheets. Also you must 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:-
- Vlookup
- If Statement / Countif Statement
- Dynamic / Static Cell Referencing
- Charts
- Advanced Filters
- Basic Mathematical Formulas - Aveage, Sum, Max, Min,
- Macros (you'll be pleased to know they are back and working with Office 2011 OSX - https://www.macworld.com/article/154785/2010/10/welcomebackvisualbasic.html )
- Conditional Formatting
- Spinners
- Date/Time Functions
- Formatting, Titles and Buttons
- Validation/Verification
- Password Protection
Simply email me the spreadsheet completed or the link to the Google Spreadsheet you have completed - and we will view these in class and discuss the issues and problems associated with the Web 2.0 New "Skool" and the Old "Skool" Excel Spreadsheets. Note there should be instructions on how to use the spreadsheet on the spreadsheet itself so anybody coming to this sheet for the first time could use it. Make sure to format the presentation and colouring of the spreadsheet as well.
2) OPEN BOOK TEST CHAPTER 4/5 ON GDOC - Wednesday 11th January
Only two of you have started this test on a GDOC? - MiniTestITGSChapter4+5 Combo 2011. You will have some classtime to complete these two assignments - and all of Wednesdays' class as I will not be in school on that day.
iPAD INTRODUCTION
On Monday and Tuesday next week we will begin investigating the use of the iPAD in class. Setting each of your iPAD's up for use and trialing a variety of elements. For this you will need an active iTUNES user account. This first week we will be just using and setting them up in class and you will not be taking them home. BY the following week once student expectations and parental communications have been organised then we will begin the first phase of the 1-to-1 program.
Alzheimers
Ancient Greece
Antikythera Mechanism
apocalypse
ArtificialIntelligence
brain
cells
Chrome
collider
Copyright
digital
electrodes
Expert system
Fats Million
Firefox
Google
GST
hadron
http://www.popularmechanics.com/technology/industry/4217348.html
http://www.youtube.com/watch?v=rKgU6ubBgJA
http://www.youtube.com/watch?v=rP5y7yp06n0
immigrant
large
Lawrence
Lawrence Lessig
Lessig
LHC
marc
native
networks
of
prensky
Quiz
rat
Remix
robot
scientist
Security
Social network
Spreadsheet
tweets
twitter
warcraft
world
wow Artificial Intelligence (19)
Arts Nd Entertainment (9)
Assignment (49)
Authenticity (6)
Blogroll (3)
Business/Employment (12)
Case Study (5)
Control (13)
Database (6)
Deadlines (3)
Delicious Links (140)
Education (22)
Equality (6)
Examinations (4)
Globalisation (9)
Health (10)
Integrity (6)
Intellectual Property (10)
IT Systems (25)
ITGS (493)
Just for Fun (36)
People and Machines (37)
Policues and Standards (13)
Politics and Government (13)
Portfolios (5)
Privacy (24)
Quiz (1)
Reliability (24)
Science Nd Environment (8)
Security (22)
Surveillance (2)
video (3)
Web 2.0 (9)
Wiki (2)
WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.
Authors
- ace (15)
- bob_saget (8)
- captainron (11)
- chocodreams (15)
- coolness16 (15)
- cornelius (4)
- draco (12)
- drtech (466)
- Fats Million (14)
- joeblogs (4)
- klanec (7)
- lal (11)
- Moosykinns (2)
- nabsuh (13)
- odo (18)
- pass (6)
- peeps812 (5)
- perriwinkle (10)
- rdubb (3)
- shakeandbake (19)
- sillibilliboi (11)
- skysteel (6)
- swamp (12)
- twiggy (6)
- youngtroopz (10)
- zout (2)
Recent Comments
- Plans for the Last Few Weeks +Video Results are In...
- Cory Doctorow's Little Brother
- Unilever stalks its customers with GPS trackers secretly placed in laundry detergent boxes
- Can Technology Identify Looters?
- Facebook facial recognition software violates privacy laws, says Germany
- ITGS Triangle: China Defends Internet Censorship
- China defends internet censorship « mikeottman: [...] China Defends Internet Censorship Share this:TwitterFacebookLike this:LikeBe the first to like this post. [...]
- The Megahertz Myth
- Digital Natives, Digital Immigrants.
- DIGITAL NATIVES, DIGITAL IMMIGRANTS
- Digital Natives, Digital Immigrants by Mark Prensky Review
Subscribe here…
ITGS-Online Links
Go OGG
Check Your Carbon Footprint
YacaPaca…
Visit Our ITGS Wiki
Welcome…
Disclaimer: if there are any problems related to copyright or fair-use please contact me immediately and I will remove the offending content from the blog. All content created by Dr Tech is under the Creative Commons License
Help Feed the World!
Net Neutrality – Help Save It!
Categories
Open Rights Group
Archives
Recent Comments
- skysteel on Plans for the Last Few Weeks +Video Results are In…
- drtech on Cory Doctorow’s Little Brother
- drtech on Unilever stalks its customers with GPS trackers secretly placed in laundry detergent boxes
- drtech on Can Technology Identify Looters?
- drtech on Facebook facial recognition software violates privacy laws, says Germany
Translate
