Introductory VB.NET work

Create a Splash Screen

1. Design your screen in terms of a suitable image and a heading, using a picturebox and a label.
2. Add a progress bar to your form from the toolbox.
3. Double-click on the form (not the progress bar).  This code will run when the form is first opened.
4. Set the value of the progress bar to 0.  [pbrProgress.Value = 0].
5. Add a timer to your form.
6. Make sure you rename all your objects (screen elements) using appropriate naming conventions (prefixes).
7. Set the timer interval property – remember an Interval of 1000 is approximately 1 second. 
8. Set the timer enabled property to TRUE.
9. Double-click on the timer.  This code will run repeatedly every interval.
10. Increment the progress bar. [pbrProgress.Value = pbrProgress.Value + 10].  Note the value you increment by (here I’ve used 10), will be how much it increases by at once.

Once you have created the Splash screen you may move on to the theory work (some of which MUST be completed for homework); or you may attempt a task from the VB.NET tasks available.  Some of you may have completed some of these tasks in Year 10.  If so, you may skip tasks you’ve already done.

Visual Basic.NET Tasks

These tasks are intended for students learning to use Visual Basic.NET for the first time.  They require the student to add objects to a form and use functions to create simple programs.

Task sheet 1:  http://www.scribd.com/doc/3198747/VisualBasicTasks1

Task sheet 2:  http://www.scribd.com/doc/3198759/VisualBasicTasks2

Year 11 2009 – Assessments

11SDD

SDD Assignment 1 - End User

SDD Assignment 2 – RAD

Note: the assessment deadline has been confirmed as Monday Week 10.

11IPT

Introduction to Information Systems Assessment

IPT Assignment 2 – Personal Project

Please note: if you have trouble viewing assignments in Scribd, you may need to download the documents.

Welcome to 2009

I use this blog for providing information and instructions to students.  This blog contains links to resources students will need during the year.  All students are expected to make a note of this blog address and access it when required.  If I am away from class for any reason, students should always check this blog for instructions regarding work.  Students who are absent should check the blog for information regarding class tasks / homework.  Students may comment on entries in order to demonstrate understanding or ask questions. 

In 2009, each class will be expected to maintain a communal blog in addition to students’ personal blogs.

11 SDD Communal Blog

11 IPT Communal Blog

In addition, each class will maintain a class wiki with notes:

11 SDD Wiki

11 IPT Wiki

Individual students will take responsibility for composing individual topics / pages; but the whole class will be responsible for checking accuracy and maintaining quality content.  These notes will be maintained for students to reflect on and revise from.

Please note: posts with a highlighted title are sticky posts.  This means they remain at the top of the blog.  Always check below the sticky posts for new posts.

My email address for questions / submitting information required by email is: susanna.edmondsbrown@gmail.com

Algorithm Information Sheets

Link to the deskcheck sheets:

http://www.scribd.com/doc/2682731/Desk-checking?ga_uploads=1

Link to programming control structures sheet:

http://www.scribd.com/doc/2859350/Programming-Structures

Link to slideshow on flowcharting:

http://www.slideshare.net/sebrown/basic-flowcharting

Basic Algorithm Representation

The following sheet covers basic algorithm description methods: pseudocode key words and flowchart symbols.  Note:  the usage column is repeated for easy reading.

http://www.scribd.com/doc/2951551/Basic-Algorithm-Description

 

Visual Basic Syntax Guide Sheets

The following links provide access to a series of sheets I have created to provide support when learning to code in Visual Basic.NET. 

 Input and Output

Reading and writing:  http://www.scribd.com/doc/3198674/ReadingAndWriting

Accepting input from objects:  http://www.scribd.com/doc/3198704/VBSyntax-UserInputFromSetOptions

Reading and writing to spreadsheets in VBA:   http://www.scribd.com/doc/13686961/Visual-Basic-for-Applications

 Basic Terminology and Syntax

Terminology:  http://www.scribd.com/doc/3198575/Basic-Visual-Basic-Definitions

Naming conventions:  http://www.scribd.com/doc/3198600/ControlNamingConventions

Variables:  http://www.scribd.com/doc/3198710/VBSyntax-Variables

Selection structure:  http://www.scribd.com/doc/3198693/VBSyntax-Selection

Repetition structure:  http://www.scribd.com/doc/3198681/VBSyntax-Repetition

Properties, functions and methods:  http://www.scribd.com/doc/3198655/PropertiesAndMethods

Timer:  http://www.scribd.com/doc/3198699/VBSyntax-Timer

Forms:  http://www.scribd.com/doc/3198646/FormManipulation

Events:  http://www.scribd.com/doc/3198644/Events

Adding objects at run time: http://www.scribd.com/doc/3223292/VBSyntax-AddingAtRuntime

Drawing to a form:  http://www.scribd.com/doc/3324007/VBSyntax-FormDrawing

Using Datebases

Accessing data from a datebase:  http://www.scribd.com/doc/3198614/DatabaseManipulation

Saving back to a database:  http://www.scribd.com/doc/3198638/DatabaseSave

With statement:  http://www.scribd.com/doc/3198715/VBSyntax-WithStatement

EXAMPLE – Creating a database at runtime:  http://www.scribd.com/doc/3410004/EXAMPLE-CreatingaDatabaseProgrammatically

Specific Code Examples

Collision testing:  http://www.scribd.com/doc/3198589/CollisionTesting

12SDD Assessments

12SDD Assessment 1 - Web Site SEI Assignement

12SDD Project Assessment Sheet Part 1

IPT Spreadsheet Exercise

Homework

Students are required to complete the text editor task (if they have not already done so) as well as the spreadsheet task (below).

 

1. Create a copy of your .CSV file (the one you created in Notepad).
2. Open the copy in Excel.
3. On your data perform the following calculations:
   • Total of a column of numbers
   • Average of a column of numbers
   • Minimum of a column of numbers (MIN function)
   • Maximum of a column of numbers
4. Use the IF function to put in a column that varies the content based on another column.
5. Perform some conditional formatting.
6. Create 2 graphs on your data.
7. Blog on what you have done and categorise each action as Organising or Analysing.

Text Editor Exercise

 

1. Gather statistics (data – numeric and text) on a sport. [You may use RAW SPREADSHEET provided by me.]
2. Put the statistics into Notepad, using only its text functionality.
3. Save this document as a .TXT file.
4. Create a new document in Notepad and format your statistics using HTML tags to create a webpage.
5. Save this document as an .HTML file.
6. Create a new document in Notepad and format the data using commas.
7. Save this document as a .CSV file.
8. Blog on the various uses of a text editor for organising.  Make sure you demonstrate awareness of advantages / disadvantages of using a text editor.

11IPT – 3 Processes Task: Collection, Organising, Analysing

Collect data on each of your class mates on how they spend their time (ie: how much time is spent on sleep, paid work, study, sport and downtime):

• Make sure you think about and plan your method of collection (eg: interview / survey / online form).
• If you want to use an online form of collection, the easiest is probably to create a ZOHO form in ZOHO Creator.
• The timeframe for your data is up to you (ie: whether you’re looking at how much time is spent at each activity daily or weekly).

Organise the data: 

• Choose a suitable software package.
• Enter the data into the software package.
• Organise the data.

Analyse the data:

• Either using the software package chosen for organising or using a package that interfaces with that package, analyse the data.
• This may involve sorting the data in certain ways, identifying highs and lows, or creating charts / graphs etc…

Blog:

• Do a print screen or find some other method of displaying your organised and analysed information in your blog.
• Explain each process:
  1. Collecting – What collection method did you use?  Why did you select your chosen collection method?  Was it effective?  Were there any issues / advantages to your method?
  2. Organising – Why did you select your chosen software package?  What did you do with your data?  Was it effective?
  3. Analysis – What analysis did you do on your data?  How effective was your analysis?

11IPT – Hardware Collecting Task

1. In groups students research different collecting hardware
   • For each data type (text, numerical, graphics, audio, video/animation)
   • Actually demonstrate use of the hardware (if possible)
   • Each student in the group is to be allocated to a specific data type and has to write a blog in the communal blog exploring advantages / disadvantages of different methods of collection.
2. Each group is to take responsibility for one collecting hardware device and collate notes and links on the wiki.  (Student allocation determined by first in on the admin wiki page).

HSC Project Suggestions

• ► Calculator
• ► Student diary
• ► Study program system
• ► Appointment system
• ► Hotel bookings
• ► Video store management system
• ► Subject choice/report system
• ► Payroll system
• ► Stock control
• ► Olympic ticketing
• ► Library system
• ► Connect four
• ► Mastermind
• ► Snakes and Ladders
• ► Hangman
• ► Memory
• ► Battleship
• ► Search a Word
• ► Monopoly
• ► Bingo
• ► Cluedo
• ► Crossword generator
• ► Quizzes
• ► Cash register
• ► Tenpin bowling scoring
• ► Calculation of sport averages
• ► Wedding planner
• ► Tetris

12SDD – Work set for Friday, 28th November 2008

Students have TWO lessons plus homework to complete the following:

• Students are to read Chapter 2 of their HSC text books.
• Students are to complete all MULTIPLE CHOICE exercises (2A – 2R) in exercise books / on paper.
• All students are to post the following on Commongate -

@     An extended response to ONE of the other questions from the chapter exercises (2A – 2R).  Each student must pick a different question.  To determine questions you may use choose to create a thread on Commongate or use the NING forum (first post gets the question).  Alternatively, you may simply agree amongst yourselves.

@     A reflection on how approaches to software development are changing and why.

@     A reflection on your understanding of implementation methods, and how they compare / contrast.

@     A comment on at least one other student’s post.  This is should be reflective and constructive.