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

IPO Table

Exercise 3

Create a solution which prompts the user to enter the length and breadth of a rectangle and output the area.

Hint:

Input	Processing	Output
length, breadth	area<– length* breadth	area

Videos: Data Validation And Verification

November 5, 2020November 5, 2020 vkungeLeave a comment

differentiate between validation and verification of data;	Difference between validation and verification.	https://www.youtube.com/watch?v=wNMAtc_PzuI
14. identify appropriate validation and verification checks given a particular scenario; and,	Methods of validation: range check, reasonableness checks, data type checks, consistency checks, presence, format and length. Methods of verification: double entry and proofreading (to identify and correct typographical and transpositional errors).	https://www.youtube.com/watch?v=OeHe61pT9CI More Detailed: https://www.youtube.com/watch?v=iS9tqYuVQ08

Flowchart Practise – Finding the average of 3 numbers.

November 2, 2020November 2, 2020 vkunge1 Comment

Task

Create a flowchart algorithm which prompts the user to enter 3 numbers and outputs the average of the numbers.

Guided Solution

First, let us use an IPO Table:

Input	Processing	Output
Three Numbers num1, num2, num3	average=(num1+num2+num3)/3	average

After considering what needs to be done, we see that we need 4 variables

Solution in flowgorithm:

Download the solution here

Island Class

Learning in the Caribbean

Category: CSEC IT