Transcript Assessment Guidelines

Preparation for Entry into .NET Bridging
Program (Databases)
In order to be successful in this program, it is important for you to have some
theoretical knowledge of many concepts in software development.
You should have an idea of what a database is and how it stores data. You
should also be able to write a simple SQL statement to retrieve data from a
table.
Know about the relational aspect of a Database, how we can join tables and
the difference between the Foreign and Primary keys.
Be able to Create, Update and Delete records in a Database.
Preparation for Entry into .NET Bridging
Program (Programming)
For the C# programming part of the course it is important for you to
understand the fundamental concepts (in any programming language):
Variables and assignment
Operators like +-*/% as well as AND/OR/NOT etc.
Control structures like decisions, iteration and looping
Arrays-initialization, elements, indexing etc.
Methods (functions)-parameters, return values etc.
It is also important for you to know the Microsoft Windows
environment and be comfortable with files, folders, copying, moving
and very basic knowledge of the Office products.
Preparation for Entry into .NET Bridging
Program (Web)
You should be familiar with the Internet, using the Internet, searching,
finding information knowing the difference between good information
and bad information.
Be able to write a simple web page using Notepad, so you should have
knowledge of the HTML tags like Paragraphs, Ordered Lists, Body, Table
and Div, all the major ones.
It would be helpful if you have used JavaScript in some way, perhaps to
check the value inside of a textfield, or to cause a popup message.
Object Oriented Programming using C#
If you are a complete beginner to the OOP world, please review this
entire slide presentation from slide number 6 onwards. You will need to
run the presentation in full-screen mode (F5) in order to hear the
audio. After the presentation you may follow the links given on slide #5
to view the two videos on the official Microsoft website.
For those with some exposure to OOP or to C# itself, please proceed to
the videos, you may skip the slides in this presentation.
Microsoft Produced Videos
Please go to this url address:
http://www.microsoftvirtualacademy.com/training-courses/c-fundamentalsfor-absolute-beginners
Start with this video (towards the middle of the page):
15 | Understanding and Creating Classes
Then watch this video:
16 | More About Classes and Methods
Of course you may watch as many as you like, but we will be testing
specifically on 15 and 16.
Prehistoric Humans & Communication
Natural World
First Words?
Grrrrrr
Ugghh
Brrrrrr
Arrrrrghh
Language Starts
Something
Thing
This
That
One Word
Object
Object
Object
Object
Different Words
Bird
Fruit
Plant
Rock
Fish
Fire
Nouns
Bird
Fruit
Plant
Rock
Fish
Fire
Adjectives
Size
Colour
Height
Texture
Weight
Temperature
Verbs
Fly, eat, walk, sing
Be eaten
Germinate, grow, die
Exert force on the earth, broken,
provides shade for insects
Swim, eat, sleep
Provide heat, burn, start
Put out
Full Sentences
Bird (Eagle)
Fruit (Banana)
Colour –
Yellow
Action beaten ( )
Size –
Small,
Medium, Large
Actions Fly ( ), Eat ( ),
Walk ( )
Objects with Properties and Methods
Thing -> Object -> Noun -> Banana
Adjective (e.g. colour)=Property=Yellow
Verbs = Action = functionality (e.g. beEaten ( ))
Closer to Programming
Object
Functions, methods, procedures
Properties, fields, variables, data
Representation
A Student Object
00010100101010111011011100
Student kim = new Student ( ) ;
A Student
Representation of a Student
A Student Object
Properties1, Properties2,
Properties3
Function1, Function2,
Function3
A Student
Representation using a Class
class Student {
string Name
date DoB
float GPA
Register ( )
AddCourse ( )
DropCourse ( )
Graduate ( )
A Student
}
Representation in General
class Student {
string Name
date DoB
float GPA
A Student
}
Register ( )
AddCourse ( )
DropCourse ( )
Graduate ( )
Representation of a Student
class Student {
Name
DoB
GPA
Register ( )
AddCourse ( )
DropCourse ( )
Graduate ( )
A Student
}
Class becomes Object
Bob
class Student {
Name
Age
GPA
Register ( )
AddCourse ( )
DropCourse ( )
Graduate ( )
}
Jane
new
Lin
John
Many Objects
class Student {
}
class Course {
class Classroom {
Name
Age
GPA
int CourseID
string Name
string Professor
string RoomName
int RoomNum
Register ( )
AddCourse ( )
DropCourse ( )
Graduate ( )
assignToCurriculum ( )
removeFromCurriculum ( )
assignToRoom ( )
}
addCourseTaught ( )
removeCourseTaught ( )
}
Relationships among Objects
Course object
History
Student object
Bob
Room object
K144