Stephotec | Computers

Training

System Repair

The computer repair course is used to introduce and develop the computer skills required by the student to complete class work in co mputer repair. This introduction will give the student the basis knowledge to use multiple operating systems, identify the parts of a computer, and use logical steps in solving hardware and software problems. The aim of the curriculum is to develop basis comput er hardware and software knowledge through computer related repair problems. The developed curriculum is the first step in becoming a competent computer repair technician.

Rationale
Computer repair is a demanding occupation that one can reap excellent benefits from. If one is willing to become A+ certified and continues to enhance one's skills he or she can enjoy a rewarding and self-fulfilling occupation. There are presently many jobs waiting to be filled and opportunities for employment are increasing yearly.

Content Source
The common body of knowledge is computer repair. Computer repair involves identifying computer parts, learning safety procedures, and learning the logical steps in troubleshooting a computer. Within this topic are included identifying computer terms,learning the different components of the computer, disassembling and reassembling a computer, learning safety precautions, removal and replacement of parts and logical steps in troubleshooting computer problems.

The content of this course will be derived from:
A technician's perspective
An instructor's perspective
A student's perspective
A user's perspective

Program Aim
The aim of the computer repair curriculum is to give students the basic computer skills needed to troubleshoot computer hardware and software problems.

Program Goals
This curriculum will help students to:

Develop a working knowledge of computer hardware and software

Use the logical steps in troubleshooting a computer

Locate documentation for computer components

Communicate with consumers

Determine the causes of computer problems

Formulate a solution to solve computer problems

Web Development

What is Web Design?
A web design incorporates design and graphics that complement the content written for web pages of a site. The design may complement a content that has been prepared for business or Individual purpose. The design of a web page is mainly based on creativity and technologies such as use of HTML, CSS, JS, ASP, SSL, PHP, XML, .NET, RUBY and others. A website design is a collective work incorporating all the web pages of a site.

Web designing incorporates the processes from conceptualization to execution of the web project content with help of technologies via Internet. The technologies adapted to design a website should be suitable for the display by a web browser. The design of a site is primarily dependent on the type of content prepared for the website. The design should be consistent in regard to the topics that the contents deal with. But while designing website,

another important factor is kept in mind: - the target audience. They should be pleased with the designing and page layout. The visitors to the site looking for particular piece of information should be retained with a pleasing and appealing web design.

Things to remember while designing a website:

It should be consistent with the web content

It should attract visitors

It should be catchy enough to retain visitors

It should be easily navigable

A good website design is that, which fulfills all the goals or purposes of launching the website. Web design consists of web applications along with web content or texts. Images and graphics can also be included in a web page design.

Category of Web Page Design
Web pages are generally categorized as three types. The Web designs for these web pages are conceptualized accordingly. At Stephotec, You will learn the Following category of web page design:

Static Pages: only a human user or the Web master of the site can update this kind of web pages. The content or the layout of this type of web pages does not change by a request from the end user.

Dynamic Pages: this type of web pages is dependent on the input or requests made by the end users.

Representation State Transfer (a.k.a RESTful): This is a web design structure that supports and aid exchange of information between web applications. The file transfer can be in any of the following formats e.g. JSON, XML and so on.

While designing a website, the design should be relevant with the page content. The web design should be such so that it becomes user friendly. The appearance of a website depends a great deal on the web designing. Multiple disciplines of information systems, communication designs and information technology are combined together in a website design.

Video Production/Editing

Video Production required proper planning and execution and attention to details. Video production is divided into three phases, namely:

Pre-production

Production

Post-production

Pre-production: Sixty percent of your time should be spent planning. Depending on the complexity of the project, another 20-25 percent will be spent filming, and the other 10-15 percent will be spent editing and making revisions. Pre-production includes:

Visualization of the finished product. Think about large conceptual ideas; who will be viewing this, and why? What is the message? Why video? How and where will the video be shown? Will this be a companion piece to other educational materials? If so, are they meant to be used together, in sequence, or should the video stand alone?

Writing the script: This is the detailed flow of what you'd like to see in the finished product. Once you have written the script you will have a much better idea about the main points, if this is better viewed as part of a series of videos, as well as how long the video presentation might be.

Creating the storyboard: With the draft script written that identifies the video content, you can now move on to identifying visual elements that support and enhance the message and facilitate understanding for your audience. Drawing these visual concepts is called storyboarding.

Creating the shot list: Organize your shot list on a separate document. You might need to organize your shots in a way that will minimize set-up time during filming, such as by the types of shots (long, medium or close-up) or by content (one person, two person, group shot, or indoor/outdoor). This will help maximize talent and location time as well as minimize the amount of camera and

lighting adjustments. The end result will also have continuity. This type of shooting schedule can be confusing to your collaborators, but explaining your process will help. Unless your production requires documenting a demonstration from start to finish, it's the final product that will be created through editing that is being filmed.

Production:Be on the lookout for things in the background that will be distracting to viewers and remove it as soon as you see it, or reframe the shot. Encourage the people involved to also be on the lookout for things that need to be corrected. Be assertive and ready to adapt.

Post-production involves:

Logging and transcribing

Editing

Draft Review

Revise

Final Review

Distribution

Programming

A computer is a programmable machine. This means it can execute a programmed list of instructions and respond to new instructions that it is given. Computer Programming is the process of developing and implementing various sets of instructions to enable a computer to do a certain task. Programs are written to solve problems or perform tasks on a computer … " Özgür ZEYDAN"

Programmers:- translate the solutions or tasks into a language the computer can understand. As we write programs, we must keep in mind that the computer will only do what we instruct it to do. Because of this, we must be very careful and thorough with our instructions.

Algorithm:- An algorithm is a list of instructions, procedures, or formulas used to solve a problem. The word derives from the name of the mathematician, Mohammed ibn-Musa al- Khwarizmi (El-Harezmî).

Pseudocode:- is a computer programming language that resembles plain English that cannot be compiled or executed, but explains a resolution to a problem.

Source Code:- consists of the programming statements that are created by a programmer with a text editor or a visual programming tool and then saved in a file. For example, a programmer using the C language types in a desired sequence of C language statements using a text editor and then saves them as a named file. This file is said to contain the source code.

Flowchart:- is a formalized graphic representation of a logic sequence, work or manufacturing process, organization chart, or similar formalized structure. The purpose of a flow chart is to provide people with a common language or reference point when dealing with a project or process. Flowcharts use simple geometric symbols and arrows to define relationships.

Programming Languages:-
Computer programming is almost always done by means of Programming Language. There exists more than 2500 programming languages in the world. Some of them are known by only their developers! For further information: List of programming languages

Stephotec expertise in real life Software Development gives our students edge over their counterpart in Programming world. Our Instructors are experienced in the field. We prepare our students for programming challenges by teaching them different programming languages in other to fit in to any platform and any programming environments they find themselves.

Desktop Publishing

(DTP) simply means using your desktop computer to produce printed pieces of work. With the advent of the personal computer, anyone with access to the necessary hardware and software can create desktop published pieces of work, often by combining text and graphics. You can use the following pieces of software to create DTP documents: Microsoft Word, AppleWorks, KidPix, Microsoft Publisher.

Adding and formatting text

Inserting and moving graphics

Manipulating page layouts

How Our Training Works
Option 1: One-On-One Training :
First, we will review your current needs, processes, and goals. Then, we share best practices, tips, tricks, and secrets that will get you your desired results. Next, we will apply what you learned to real-world business IT situations. This way, you can get

immediate answers to your questions. We will tailor the training to meet your needs. If you identify a specific step or challenge as a hurdle, we will focus on that.

Option 2: Group Training :
This class uses real-world challenges to educate you and your colleagues on how to conceptualize clear, communicative, compelling ideas. First, we will review your company's current needs, processes, and goals. We will tailor the training to share best practices, tips, tricks, and secrets that solve you and your group's challenges and achieve the company's goals.

Who?
All training is performed by either our experienced and eloquent trainers. They are professional trainers and public speakers. Stephotec's expert instructors have provided reliability education to thousands of audience in Schools, Offices, Organizations, Groups, and we have consistently received

praise for the outstanding quality and value of the seminars delivered. Trust Stephotec for any Computer related topics that you want to acquire more knowledge and understanding. Either individually or as a group. We use latest technology in our presentaions. We are specialist in both indoor and outdoor seminar presentaion. join us today and benefit from our years of experience and well of knowledge in Information and Communication Technology.

Database Management

Database is a collection of related data and data is a collection of facts and figures that can be processed to produce information. Mostly data represents recordable facts. Data aids in production information, which is based on facts. A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.

Database Management System or DBMS in short refers to the technology of storing and retrieving users' data with utmost efficiency along with appropriate security measures. DBMS allows its users to create their own databases as per their requirement. These databases are highly configurable and offer a bunch of options. The training will explains the basics of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational database design, and storage and file structure. In addition, it covers advanced topics such as indexing and hashing, transaction and concurrency, and backup and recovery and so on.

Audience This training is meant for those who are starting a new career in Database Management and those that are willing to improve their skill; it will especially help computer science graduates in understanding the basic -to- advanced concepts related to Database Management Systems.

Characteristics
Traditionally, data was organized in file formats. DBMS was a new concept then, and all the research was done to make it overcome the deficiencies in traditional style of data Management. A modern DBMS has the following characteristics:

Real-world entity: A modern DBMS is more realistic and uses real – world entities to design its architecture. It uses the behavior and attributes too. For example, a school database may use student s as an entity and their age as an attribute.

Relation-based tables: DBMS allows entities and relations among them to form tables. A user can understand the architecture of a database just by looking at the table names.

Isolation of data and application: A database system is entirely different than its data. A database is an active entity, whereas data is said to be passive, on which the database works and organizes. DBMS also stores metadata, which is data about data, to ease its own process.

Less redundancy: DBMS follows the rules of normalization, which splits a relation when any of its attributes is having redundancy in values. Normalization is a mathematically rich and scientific process that reduces data redundancy.

Consistency: Consistency is a state where every relation in a database remains consistent. There exist methods and techniques, which can detect attempt of leaving database in inconsistent state. A DBMS can provide greater consistency as compared to earlier forms of data storing applications like file - processing systems.

Query Language: DBMS is equipped with query language, which makes it more efficient to retrieve and manipulate data. A user can apply as many and as different filtering options as required to retrieve a set of data.