Introduction To Databases

January 7, 2021January 8, 2021 vkunge1 Comment

Video from today’s class (Thurs 7th Jan 2021)

The file produced from the video above can be found here:

https://drive.google.com/file/d/1fLPNIhxWgoFnlqIop7elm9Ph9jY-CH1s/view?usp=sharing

Introduction

Definition: A database is a collection of related data stored in separate data structures, usually table structures. Data stored in databases contain a minimal amount of duplication.
Alternative Definition: A database is as store of data organized into related tables.

A database purpose is to store and manage information; and to be easily searchable to produce filtered information on the data by querying the database.

Facilities querying the database are provided by the Database Management System (DBMS).

For example, a school’s database can store all information about the school in different tables – Teacher information in a teacher table , Student information in a student table, subject information in a subject table.

Because the tables are related to each other , we can perform queries on the database to find:

The list of subjects for a particular student,

The number of students assigned to a subject,

The list of student assigned to a teacher,

…..etc.

Required reading

Information technology for CSEC , 3rd Edition, Howard Campbell , pages 222 to 225

Fillable forms – (Microsoft Word) – Live Class

January 7, 2021January 7, 2021 vkungeLeave a comment

Hello Students, this post contains a live capture of our class on fillable forms.

Please note:

Not all form controls were demonstrated, the list box and checkbox controls were deliberately left out of the demonstration for your research and learning during homework.
Homework: Information Technology for CSEC 3rd Edition , Howard Campbell – complete the tutorial found from pages 154-157 (this includes all controls that were omitted in class from part 1 above)
Optional exercise – Use google forms to produce a form which captures the information from the tutorial from part 2 above.

CSEC SBA Question

December 10, 2020December 10, 2020 vkungeLeave a comment

You can get the information on the SBA via this link: CSEC SBA

A pivot table’s intended use.

November 22, 2020November 22, 2020 vkungeLeave a comment

This video was captured in class to demonstrate how we manipulate pivot tables to find trends.

Here , we take a “behind the scenes approach” to understand our data , even though pivot tables are used for creating summary tables and determining trends in unfamiliar data.

This is the excel tutorial file used in the demonstration:

https://drive.google.com/file/d/1M4bU4XB8Dz0ygcDv5P8P7PnT0ARWpaUk/view?usp=sharing

Mail Merge Class Demonstration And Revision

November 22, 2020 vkungeLeave a comment

In this class, we reviewed how to accomplish a mail merge , an automatically generated table of contents and how to password protect our document.

See the video below:

Reopening/Editing the existing data source.

A question arose from how we can return to the data source after its creation and use. How can we reopen it and add new records?

See the Gif below:

Selection Statements: Practise Exercise(s)

November 10, 2020November 20, 2020 vkungeLeave a comment

For these flowchart solutions, you may opt to:

Draw the solution in your notebook OR
Draw the solution in a word processing document OR
Draw the solution in an online tool OR
Create a solution using flowgorithm.

Exercise 1

Create a flowchart solution which prompts the user to enter a student’s math mark and outputs “You have passed” if the mark is 50 and/or greater or “You have failed” if the mark is less than 50.

Exercise 2

Create a flowchart solution which prompts the user to enter two numbers, A and B, and outputs the larger number.

Videos: Search/Replace, Tables, Columns

November 10, 2020November 10, 2020 vkungeLeave a comment

These video(s) were chosen for each topic because they cover the subject matter in a relevant context. They definitely were not created specifically for the CSEC Syllabus, however , they do address the fundamental concepts in real world scenarios and classroom context.

3. use appropriate editing features to structure and organize a document;

Drag and drop editing: perform block operations on selected areas of text within a document.

Use search and replace functions appropriately to edit a document.

Use of tables, table styles, shading, borders, row and column insertion, split cells, split tables, text direction and cell margins, cell size.

Use of columns (one, two, three, left and right columns, column breaks).

https://www.youtube.com/watch?v=8ZSlu4DWJ5k

https://www.youtube.com/watch?v=XNBrCEgzddw

https://www.youtube.com/watch?v=X1n2VG1yxFs

Serial, Sequential, Direct (Random) Access

November 7, 2020October 22, 2025 vkungeLeave a comment

In this class we seek to understand the concept of logical storage for computer files stored on a physical medium.

Even though all data is stored as a sequence of zeros and ones not this binary data; we learned that this data can have some logical organization on the physical access medium.

Serial access is where data can only be accessed in the order that it was written. This is usually because of the inherent nature of the storage medium for example a magnetic tape.

Sequential access is a form of Serial access, when we organize our data in some order before storing the Data on the storage medium.

Direct access is where the location of the data on the storage medium is known beforehand, thus accessing a logical file on a direct access medium does not require accessing any other data but that specific file.

below is a video which demonstrates an analogy for data storage for direct access serial access and sequential access:

Closure on Sequence with flow charts

November 7, 2020November 10, 2020 vkungeLeave a comment

Exercise 1 :

Modify previous example to find the average of four numbers. The previous example can be found below:

https://islandclass.wordpress.com/2020/11/02/flowchart-practise-finding-the-average-of-3-numbers/

Exercise 2:

Create a program which Prompts the user to enter a the radius of a circle and outputs the circumference and diameter.

Hint:

IPO Table

Input	Processing	Output
radius	Circumference <– 2* Pi * radius Area <– Pi * r * r	Circumference Diameter